00 353 1 2790020sales@olas.ie Olas: Professional, Direct, Clever & Helpful

PowerPivots for Excel

 

Description

To demonstrate the capability of PowerPivots in Excel 2013; to import data in a PowerPivot and create relationships; to generate PowerPivot tables and charts; to customise PowerPivot table and chart appearance.

Price €450 per person

Dates

  • Book a place on this course and pay with your credit card.17 October 2017 , 1/2 Day
  • Book a place on this course and pay with your credit card.4 December 2017 , 1/2 Day

TARGET AUDIENCE

Aimed at experienced Excel users who need to analyse and visualise large datasets from various sources.

PREREQUISITES

None

GOALS AND OBJECTIVES

Course Outline
Click here to download course oultline

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

Importing 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

Creating Relationships
Understanding relationships
Review existing relationships
Create new relationships

Building DAX Formulas
Formula basics
Calculated fields and measures

PivotTables
Creating a PivotTable
Updating the table
Changing the table structure
Formatting the PivotTable

PivotCharts
Creating a PivotChart
PivotChart Layouts
Changing the Chart type
Formatting the Chart

Slicers
Adding slicers to PivotTables and Charts
Resizing Slicers
Slicer options

Course Summary and Review
Recap of Topics Covered
Question Time
Individual Project Work

Contact Us

Drop us a line, include your contact details and we will get back to you as soon as possible.