Page 14 of 16PREVNEXT

PivotTable I: What's so great about PivotTable reports?

Excel practice file and practice instructions

Download size: 74 KB (<1 min @ 56 Kbps)

Practice in Excel
Problems with the practice?
HelpTry our troubleshooting tips


In this practice session, you'll use the PivotTable and PivotChart Wizard to create a PivotTable report from the same sales figures used in the lesson. You can also try something new: viewing sales by country (by dragging a field into the Page drop area).

About the practice session

When you click Practice in Excel, a practice worksheet will download to your computer and open in Excel, and a separate window with practice instructions will appear alongside (see picture).

Note     You need to have Excel 2003 installed on your computer.

Tips

  • If the practice instructions aren't visible, or if they disappear when you click in Excel, click the Excel Help taskbar button and then click the Auto Tile button in the upper-left corner of the instructions.
  • If the practice instructions cover up Excel, click the Auto Tile button in the upper-left corner of the instructions.

Before you begin

Make sure to close Excel if it is already running.

Start the practice

Click the Practice in Excel button now.

Page 14 of 16PREVNEXT