You can quickly add pre-formatted headers to your worksheets in Excel using the 'Page-layout' tab. This tutorial is applicable to Excel 2007.
There are time you may want to hide an entire worksheet within a workbook. In Excel 2007 & Excel 2010 this can be easily accomplished with a few clicks of the mouse.
There are a couple different ways you can Increase/Decrease the font size in an entire worksheet, or just selected cells. This video works the same in Excel 2007 & Excel 2010.
One of the functions of the AutoSum button is 'Minimum' and 'Maximum. This can be used to find the smallest or largest number in a group of numbers in an Excel spreadsheet. This process works the same in Exel 2007 and Excel 2010.
One of the functions of the AutoSum button is 'Average'. This can be used to find the average of a group of numbers in an Excel spreadsheet. This process works the same in Exel 2007 and Excel 2010.