1 day
Course Description
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.
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 Outline
Building a PivotTable
- Insert a PivotTable
- Create a PivotTable Based on External Data
- Categorize PivotTable Data
- Customize a PivotTable
Analyzing Data Using PivotTables
- Create Custom Calculations in a PivotTable
- Restructure a PivotTable
Presenting PivotTable Data Visually
- Format a PivotTable
- Present a PivotTable in a PivotChart
- Print PivotTables and PivotCharts
Microsoft Excel 2010 PivotTables was last modified: February 3rd, 2016 by