This cheat sheet gets you up to speed on the features ... If you want to summarize your spreadsheet data using a PivotTable, for example, type in something like summarize with pivot table.

In Excel 2007, more is truly better. Microsoft has increased the number of columns per spreadsheet (and per PivotTable ... But armed with our cheat sheet and a little elbow grease, you’ll ...

Pivot Tables are one of Excel’s most useful-and misunderstood-features. Here’s a quick lesson: Click within a chunk of data, click Insert, and select “Pivot Table.” Excel should ...

For example, there are several ways to enter formulas and calculate numbers in Excel. Use the Insert Function ... of blank cells beneath (or on another sheet) that’s the same size as the ...

SEE: How to add a drop down list to an Excel cell (TechRepublic) This article assumes you know how to build a basic pivot table, but also provides instructions for building the example pivot table.

How to combine Excel ... or PivotTable but being familiar with these features will be helpful. SEE: Choosing your Windows 7 exit strategy: Four options (Tech Pro Research) The simple sheet shown ...