CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

APPIV10 - Microsoft Excel 2010: PivotTables

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

You will create and analyze PivotTable data.

Click here for a printer-friendly version of this page

Upcoming classes

	Number	Class Date	Location	Length	Cost	Sign up
	APPIV10	Jun 28, 2012 - Jun 28, 2012	Springfield	0.5 days	$95.00	Register

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