Spellmann & Associates - Slideshow

innovative business solutions & creative ideas

Archive for the ‘Microsoft Excel’ Category

Microsoft Excel Tip: Cool Undocumented Function

Tuesday, August 17th, 2010

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.

Microsoft Excel: Use a Highlighter

Monday, August 2nd, 2010

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!

Microsoft Excel Tip: Increasing the MRU

Monday, July 26th, 2010

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!

Microsoft Excel Tip: Switch Quickly

Monday, July 19th, 2010

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