Beginning PivotTables in Excel 2007 will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.

Categories

Archives

Learn how to create Excel dashboards.

Compare Budgets With Excel Scenarios

Should you spend extravagantly this Christmas, or go cheap, or spend somewhere in the middle?
In Excel, you can use Scenarios to store several versions of a budget, and compare the results. Let’s set up a worksheet where we can compare three scenarios for holiday spending.
Set Up the Worksheet
The first step is to set up the [...]