Microsoft® Excel® 2010: PivotTables
Course Specifications
Course number: 084580
Course length: 0.5 day(s)
Course Description
Course Objective: You will create and analyze PivotTable data.
Target Student: This course is meant for people with a sound working knowledge of Microsoft Excel and general computer proficiency.
Prerequisites: Before starting this course, students are recommended to take the following Element K courses or have equivalent knowledge:
Microsoft® Office Excel® 2010: Level 1 and Microsoft® Office Excel® 2010: Level 2
Hardware Requirements
For this course, you will need one computer for each student and one for the instructor. Each computer will need the following
minimum hardware components:
- 1 GHz Pentium-class processor or faster.
- Minimum 256 MB of RAM. 512 MB of RAM is recommended.
- 10 GB hard disk or larger. You should have at least 1 GB of free hard disk space available for the Office installation.
- CD-ROM drive.
- Keyboard and mouse or other pointing device.
- 1024 x 768 resolution monitor is recommended.
- Network cards and cabling for local network access.
- Internet access (contact your local network administrator).
- Printer (optional) or an installed printer driver.
- Projection system to display the instructor’s computer screen.
Software Requirements
Each computer requires the following software:
- Microsoft® Office Professional Plus 2010 Edition
- Microsoft® Office Suite Service Pack 1
- Microsoft® Windows® XP Professional with Service Pack 2
Course Objectives
Upon successful completion of this course, students will be able to:
- build a PivotTable.
- analyze data using PivotTables.
- present PivotTable data visually.
Course Content
- Lesson 1: Building a PivotTable
- Topic 1A: Insert a PivotTable
- Topic 1B: Create a PivotTable Based on External Data
- Topic 1C: Categorize PivotTable Data
- Topic 1D: Customize a PivotTable
- Lesson 2: Analyzing Data Using PivotTables
- Topic 2A: Create Custom Calculations in a PivotTable
- Topic 2B: Restructure a PivotTable
- Lesson 3: Presenting PivotTable Data Visually
- Topic 3A: Format a PivotTable
- Topic 3B: Present a PivotTable in a PivotChart
- Topic 3C: Print PivotTables and PivotCharts
Appendix A: Solvers
Appendix B: Goal Seek
Appendix C: Troubleshooting PivotTables