Processing your application. Please be patient while we make sure we receive every piece of it.
Office 2010 Applications
Excel 2010: PivotTables
1/2 Day
Guaranteed To Run
Wednesday
Oct 25
Toronto
  $295
Thursday
Oct 26
Toronto
  $295
Thursday
Nov 02
Toronto
  $295
Tuesday
Nov 14
Toronto
  $295
Wednesday
Nov 15
Toronto
  $295
Wednesday
Nov 29
Toronto
  $295
Thursday
Nov 30
Toronto
  $295
Wednesday
Dec 06
Toronto
  $295
Thursday
Dec 07
Toronto
  $295
Tuesday
Dec 19
Toronto
  $295
Wednesday
Dec 20
Toronto
  $295
REQUEST
PRIVATE SESSION
COURSE DESCRIPTION
OVER
VIEW
+
OBJEC
TIVES
+
AUD
IENCE
+
PRERE
QUISI
TES
+
OUT
LINE
+
You will create and analyze Pivot Table data.
Upon successful completion of this course, students will be able to:
  • build a PivotTable.
  • analyze data using PivotTables.
  • present PivotTable data visually.
This course is meant for people with a sound working knowledge of Microsoft Excel and general computer proficiency.
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
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
SITE MAP