Microsoft Excel 2010: PivotTables

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

SKU	084580IE
Weight	0.6400
Coming Soon	N/A
Days of Training	0.5
Audience	Instructor
Product Family	Select
Product Type	Print Courseware
Electronic	No
ISBN	1424617618
Language	English
Page Count	88
Curriculum Library	Excel
Year	2010
Manufacturer's Product Code	N/A

Current Revision	1.01
Revision Notes	No Revision Information Available
Original Publication Date	2011-04-15 00:00:00

datafile	084580IE Data File
overhead	084580IE Overhead File
rtf	084580IE RTF File
outline	084580IE Outline File