In this practice session you'll create a PivotTable report, change the layout of the report, and see what page fields can do. You'll also practice using commands to move fields onto the layout area instead of using the drag and drop method.
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.
- 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.