EX104 : Microsoft® Excel® 2010: PivotTables
  • Overview
  • Course Outline
  • What is included
  • Schedule
  • Testimonials
  • View Comments

You will create and analyze PivotTable data.

Audience

This course is meant for people with a sound working knowledge of Microsoft Excel and general computer proficiency.

Exams Covered

Upon successful completion of this course, students will be able to:

  • build a PivotTable.
  • analyze data using PivotTables.
  • present PivotTable data visually.

 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
Regular Price Feature List
  • Microsoft authorized courseware
All Incl. Price Feature List
  • Our Guarantee - Pass first time or free retake*
  • Books or study materials
LOCATION START END TIME ENROLL