An introductory video (youtube) by bytebodger describing the use and creation of pivot tables in Excel 2007.

The REPT function repeats text a given number of times. For example, =REPT(”*”,10) repeats * 10 times in a cell.
You can use this function to create a simple bar for values in multiple cells.  Here is a short video on YouTube:

At work I use pivot tables nearly every day. My work does not involve analyzing business or financial data and still I find pivot tables very useful in manipulating data sets, performing on-the-fly calculations, and preparing final reports.
So, what is a pivot table?
A pivot table is a data summarization tool found in data visualization programs [...]

I wonder what the performance is like for the spreadsheet control that allows you to create a spreadsheet object with 262,144 Rows and 18,278 Columns.
Want more rows, more columns?
Think Excel is too small; Only 65,536 rows and 256 columns?
Try the Spreadsheet control; a Microsoft ActiveX control.
Source – Office Tips and Hints Blog

Along with Pivot Tables, AutoFilter is one the Excel features I find most useful. I have always found that it a little hard sometimes to see which columns I am filtering on. Many times I have turned off the AutoFilter and then turned it back on in order to start from scratch.
Summary: When [...]