Tuesday, December 30, 2008

Use Conditional Formatting to Highlight Above-Average Values

Highlighting exeptional values can be a useful (and simply-done) analysis tool. Here is an easy way to highlight the Above-Average values in a range:

  1. At the bottom of your range, enter the formula for Average: =Average(range)
  2. Select the values in the range (not including the Average formula)

  3. On the Home tab in Excel 2007, choose Conditional Formatting from the Styles menu

  4. Select Highlight Cells Rules / Greater Than

  5. Choose the dialogue box and click on the cell in which you have the Average Formula

  6. Choose the Formatting you wish to apply

  7. Click Enter and Presto! Values that are Above-Average are highlighted!

Use this simple method to highlight Above-Average values (You will be Above-Average Yourself!)

Tuesday, December 16, 2008

Right-click Tab Scrolling Buttons

Large Excel workbooks will commonly contain a great many worksheets that can be cumbersome to scroll through to find a particular item.

A quick and easy shortcut to the worksheet of your choice is to right-click the tab scrolling buttons in the lower-left corner of your workbook. A menu will appear showing the tab names. You can then choose your location and navigate to it directly.

Bamm! You can go right to your worksheet and skip by the rest!