innovative business solutions & creative ideas

One of the coolest functions is also undocumented anywhere in Excel: the DateDif function. It is the MOST accurate way to compute the amount of time between two dates. Don’t search your Excel help files. You wont’ find it. Click here for an explanation.

Use the “Fill Color” button (paint bucket) to quickly focus your reader’s attention on important numbers in your worksheet. In a sea of numbers, this trick quickly makes your point!

By default, Excel only shows the last four “most recently used” workbooks under the “File” menu. Increase that to nine by pulling down the “Tools” menu, choosing “Options,” hitting the “General” tab, and then increasing the value. Big time-saver!

Do you work with more than one workbook at a time. Use Ctrl-F6 to quickly jump between them!