 |
$440 | 1 Day Group discounts available |
|
 |
Times | 9:00am - 4:30pm | |
 |
Reference | Hosted manual included or Purchase printed book |
|
 |
Certificate | Attendance or Completion upon assessment |
|
 |
Classroom | Upon request | |
 |
Live Online |
Hands-on, Live Instructor Dedicated VILT Platform |
|
 |
On Site | Get a Quote |
Excel Tables & PivotTables
4.75 (1505 reviews)
$440
Brochure
Tables allow you to manage and analyse data in Excel quickly and easily.
Link tables to external data so that your data is always up to date
A pivot table allows you to analyse large, detailed data sets.
Discover how to perform a variety of calculations with Pivot Table Data.
Create PivotCharts based on Pivot able Data.
Analyse data from multiple tables using a Data Model and PowerPivot.
Course Details
Audience:
Users needing to manipulate and analyse data stored in Excel lists using pivot tables.
Prerequisites:
Participants must have an intermediate level knowledge and experience with Microsoft Excel.
Course Content
Tables and Pivot tables are two of Excel's most powerful features. This course is designed to develop experience and confidence in using the Excel Tables and PivotTables to analyse data and produce sophisticated management reports.
PivotTable Fundamentals
- What is a PivotTable?
- Why should I use a Pivot Table?
- What are the advantages?
- PivotTable Terminology
- Preparing your data for use in a PivotTable
- Creating a PivotTable
- Selecting the Data Source
- PivotTable Fields List
- Filterering data with Page Fields
- Adding Fields
- Removing Fields
- Understanding the Field icons
Presenting Data in PivotTables
- PivotTable Ribbon
- Hiding and Unhiding Items
- Sorting Data in a PivotTable
- Using AutoSort
- Advanced AutoSort
- Refreshing a PivotTable Report
- Inserting Data into the Data Source
- Formatting Numerical Data
- Selecting Parts of a PivotTable
- PivotTable Formats
- PivotTable Options
- Change the Summary Function
- Adding Multiple Data Fields
- Changing Calculations
- Hiding and Showing Row/Column Details
- Displaying Data Details
Grouping Data
- Grouping Data
- Group by Dates
- Group by Number
- Ungrouping Data
Calculations in PivotTables
- Changing custom calculations
- Creating Calculated Fields
- Calculated Items
- GetPivotData() to extract information
- Using Other Sources of Data
- Selecting data from another Excel workbook
- Connecting to an Database
- Using a Saved Query as the data source
- Using a csv text file as the source of a PivotTable
Using PivotCharts
- PivotChart terms
- Modifying the Chart
- Caution - Loss of Formatting in PivotCharts
Publishing PivotTables to the Web
- Saving a PivotTable as a web page
- Creating Interactive PivotCharts - Web
- Adding Fields to a PivotChart - Browser
Re-using PivotTables
- Requerying data
- Using Saved queries
- Automating PivotTable Updates
- Saving a PivotTable Template
Creating a Data Model
A Data Model allows you to integrate data from multiple tables, effectively building a relational data source inside an Excel workbook.
- Create a data model with multiple tables
- Create a relationship between the tables
- Use the data model to create a PivotTable and PivotChart
- Adding data to the data model