Microsoft Office Productivity

If you have a spreadsheet containing a list of products and sales figures, or employees and their salaries, you may find the Subtotal function very useful.  This video also shows how to use the basic "Filter" function.  You will use the "Filter" function to sort your spreadsheet before using "Subtotal".
 

You may have headers/footers that you have used in one workbook and would like to use them in another workbook.  Instead of re-creating the headers/footers in the second workbook, you can simply copy them from an existing workbook.
 

There are several ways to view your contacts/emails in Outlook.  You can sort contacts/emails by multiple columns to organize information more concisely, and make it easier to locate important information.  This will work in Outlook 2003, Outlook 2007, Outlook 2010, and Outlook 2013.

Using the ‘Find & Select’ feature you can locate and select multiple cells at once.  This will allow you to make changes to the cells as a group. In this example we will find a group of cells with the same formatting and change the formatting all at once.  The images shown are from Excel 2010, the process is the same in Excel 2007.
 

Text to Columns can be very useful.  If you inherit a worksheet that contains two or more pieces of data that appear in one column, you can separate the data into individual columns.  This will work in Excel 2007 & Excel 2010.