Microsoft Excel 2013 - Data Analysis with Pivot Tables

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
• Create implicit calculated fields (previously called ‘measures’)
• 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
• Create relationships between data from different sources,
• and between multiple tables in a PivotTable.

Creating a Pivot Table from a Database

• Databases you can access
• Refreshing the Data

Publishing an Excel Workbook

• When to Use Excel Services

Upon successful completion of this course, students will be able to understand, create, and format PivotTables.

Training on our Excel Level 2 course or equivalent knowledge and experience.

This course is intended for students who have experience working with Excel and would like to learn more about PivotTables.