Levi, Ray & Shoup, Inc.
  • Courses
  • Site Content

APPIV10 - Microsoft Excel 2010: PivotTables

You will create and analyze PivotTable data.

Click here to print this page »

Prerequisites


Before starting this course, students are recommended to take the following courses or have equivalent knowledge: Microsoft® Office Excel® 2010: Level 1 and Microsoft® Office Excel® 2010: Level 2

Detailed Class Syllabus


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