Excel Digest

To install and load the Analysis Toolpak in Excel 2007 follow these steps:

Click the Office button.
Click Excel Options, the Excel Options window will open.

In the left pane of Excel Options click Add-Ins, The right pane will show a list of Active and Inactive  Add-ins.
At the bottom of the right pane there is a combo [...]

To hide rows based on cell value in Excel 2007 follow these steps:

Prepare your data including a header row.
In the Home tab, Editing group, click Sort and Filter then select Filter from the menu.
Your data will now look like this:

In this example we want to hide rows where the sales are greater than or equal [...]