Microsoft Excel 2007/2010 Pivot Table Workshop (Level 3 / Advanced)

This course will focus on Creating a Pivot Table ,Using the Report Filter, Formatting the Pivot Table Using Formulas Functions, Working with Multiple Data Ranges, Creating PivotCharts and Creating a Pivot Table from a Database

Course Outline

This course will focus on Creating a Pivot Table ,Using the Report Filter, Formatting the Pivot Table
Using Formulas Functions, Working with Multiple Data Ranges, Creating PivotCharts and  Creating a Pivot Table from a Database Course Outline Understanding Pivot Tables

• Types of Pivot Table reports
• Source data for Pivot Table reports
• Creating Worksheet Lists

Using Names

• Create A Name
• Using a Name in a Formula
• Creating Names for a Multiple Rows or Columns
• Creating Names for a Value or Formula

Creating a Pivot Table

• Pivot Table Field List
• Completing the Report
• Pivot Table Tools
• Rearranging the Pivot Table
• Changing the Report Field Titles
• Formatting Data Fields

Using the Report Filter

• Displaying Filtered Fields on Separate Worksheets

Formatting the Pivot Table

• Sorting Data
• Removing Data
• Refreshing Data

Using Formulas Functions

• Create a Calculated Field
• Add or remove subtotals in a Pivot Table report
• Display Or Hide Details

Working with Multiple Data Ranges

• Setting up the source data
• Using named ranges when source data is likely to expand

Creating PivotCharts

• Creating the Chart
• Moving the Chart to a New Worksheet
• Chart Tools
• Using Pivot Table Data Outside The Pivot Table Report

Creating a Pivot Table from a Database

• Databases you can access
• Refreshing the Data

Using Microsoft Query

• Creating the Data Source
• Creating Queries with Microsoft Query
• Microsoft Query Toolbar
• Returning Data to Excel

Publishing an Excel Workbook

• When to Use Excel Services

Additional Details

Pre-Requisites

Previous experience with Office 2007 and Intermediate Excel skills.

Certificates offered

Certificate of Completion

Cancellation Policy

There is no consequence if you cancel/reschedule this registration with a minimum of 10 business days notice prior to the first day of this course. Full payment is required if you cancel/reschedule this registration within the non-cancellation period of 10 business days prior to the first day of the course. Substitutions are welcome.

Map & Reviews

ctc TrainCanada
[ View Provider's Profile ]

Mississauga Office
201 City Center Drive
Suite 601
Mississauga, Ontario
Canada   L5B 2T4

Reviews

 

   

instructor lack knowledge on the subject matter.

Reviewed by Rashed S. 2011