Course Outline

Power Pivot for Microsoft Excel Course

This course is designed to be hands-on. You will learn skills that you can apply to your own work. Bring your own projects, files and questions to the training, or use our free support anytime after training.

We specialise in on-site and online customised training, which means we can schedule the course at a date that suits you and tailor the content to address your requirements.

Customised Power Pivot for Microsoft Excel Course training
on site and online for your team

i

Tailored to your needs



Results for your business

w

Free Support

Unleash Excel Business Intelligence! This course includes:

Power Pivot workbooks
Excel Data Model
Create table relationships
Import & query data
Power PivotTable and Charts



Course Duration

One day or two half-days

\

Course Objectives

After completing this course you will be able to describe the main ways to import and query data using Power Pivots workbooks in Excel, to generate PivotTable and PivotChart reports and to create relationships between Power Pivot tables.



Course Prerequisites

Previous knowledge of Excel PivotTable features is useful but not essential. Basic understanding of relational data is useful but not essential.



Who is this Course for

Professionals who want to use Power Pivot full capabilities in Excel 2010 and who recognise the need for Business Intelligence.

Power Pivot for Microsoft Excel Course Topics

h

Getting started

Why use PowerPivots
PowerPivot Workbooks
Data Model
The PowerPivot tab
Data sources
Relationships

h

Relationships

Understanding relationships
Review existing relationships
Create new relationships
Diagram View

h

Get and transform data

Using the Table Import Wizard
Import and Filter from Databases
Run SQL Query
Get Data from Files
Copy and Paste Data
Create Linked Tables

h

Data Tables

Formatting Numbers
Handling Technical and Useless Columns
Understanding Calculated Columns
Using Lookup Tables
Understanding Measures
Handling Many Tables
Refreshing Data

h

Slicers

Adding slicers to PivotTables and Charts
Resizing Slicers
Slicer options

h

PowerPivot Reports and Charts

Difference between PivotTables in Excel and PowerPivot
Refreshing the table
Changing the table structure
Formatting
Creating a PivotChart
PivotChart Layouts
Changing the Chart type
Formatting the Chart

h

DAX Measures and Formulas

Formula basics
DAX Data Types
DAX Operators
Calculated Columns Examples
DAX Measure Examples
RELATED, CALCULATE functions

Get a quote