Microsoft Office Productivity
You can attach a Comment to a cell in an Excel Worksheet to display important notes. The Comments are only visible when you hover your cursor over a cell with a Comment attached, or when you choose to display all Comments. This will work in Excel 2003, Excel 2007 & Excel 2010.
If the first few characters you type in a cell match an existing entry in that column, Excel automatically enters the remaining characters for you. Excel will only complete entries that contain text or text and numbers. This function will not work for entries that only contain numbers. You can turn Auto Complete OFF if makes entering data difficult. This will work in Excel 2010, Excel 2007 and Excel 2003.
You can change the font in an entire PowerPoint presentation at one time. If you use more than one font in your presentation you have the choice to change one or more fonts. *Note: when you change a font make sure to view every slide in your presentation. One font’s size 20 can be very different from another’s. This will work in PowerPoint 2007 & PowerPoint 2010.
Sorting data in Excel is a common task you may perform all the time. It is possible to sort a list and find out the data didn’t sort exactly how you thought it would. There are three common reasons as to why your data won’t sort properly. One of the reasons could be that the list is just too large and you don’t have enough memory on your computer to perform the sort. The other two reasons are shown in detail in this tutorial. This will work in Excel 2003, Excel 2007 and Excel 2010.
When you create a header or footer for your Excel worksheet you can add various elements, you can even include a picture (image). This process is shown using Excel 2010, but will work the same in Excel 2007.
