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.

Shifty Tricks in Excel

You probably know a few ways to use the Shift key in Excel, to extend the cells that you have selected. For example:

Click on a cell, then hold the Shift key, and click on another cell. All the cells in between are selected.
Hold the Shift key while you use the arrow keys, and cells will [...]