Use complex functionalities of PIVOT TABLES AND analyse multiple
files using the Power PIVOT ADD-in.
THIS COURSE IS IDEAL FOR
This course has been developed for people wanting to use more complex
functionality of PivotTables within Microsoft Excel, including the
PowerPivot add-in which allows you to analyse multiple files.
WHAT YOU WILL LEARN
*
Create and modify existing PivotTables.
*
Work with calculated fields and summary tools.
*
Analyse multiple data sources with the PowerPivot add-in.
*
Create simple dashboards.
TOPICS COVERED IN THIS TRAINING COURSE
BASIC PIVOTTABLE REVIEW
*
What is a PivotTable?
*
Prepare your data
*
PivotChart revision
*
Filtering data
*
Formatting values
*
PivotTable value field properties
*
Produce multiple PivotTables
*
Grouping date data
*
PivotTable format and display
*
Classic view
*
Create PivotCharts
PIVOTTABLE PROPERTIES
*
Dynamic data ranges
*
Use tables as data sources
*
Dealing with zeros
*
Data drill down
*
Refresh PivotTable data
*
Change the data source
*
Move a PivotTable
PIVOTTABLE VIEWS
*
Manually sort data
*
Group fields
*
Work with Slicers
*
Work with timelines (2013)
*
Conditional Formatting
SUBTOTALS AND SUMMARISING
*
Manipulate display of totals
*
Advanced value field settings
PIVOTTABLE CALCULATIONS
*
Calculated fields
*
Problems with calculated fields
*
Calculated items
*
GETPIVOTDATA function
POWERPIVOT
*
Install PowerPivot (2010)
*
Activate PowerPivot
*
Understand PowerPivot
*
Import a text file into PowerPivot
*
Copy data into PowerPivot
*
Create relationships between data
*
Create a PivotTable in PowerPivot
CREATE A DASHBOARD WITH POWERPIVOT AND SLICERS
*
Collect and link data
*
Create PivotCharts
*
Create a Slicer connected to multiple sources
*
Link Slicer values to cells
sports
courses
514
Views
26/03/2019 Last update
Karstens Training Centre
Level 1, 111 Harrington Street , Sydney, 2000, NSW, Australia