Description
The objectives of this course are to demonstrate the capability of Power Pivot in Excel; to import data into a Power Pivot and create relationships; to generate Power Pivot tables and charts and to customise the appearance of Power Pivot tables and charts.
Half Day Course Price: €600 per person
Click here to view the upcoming Virtual Live Training 1.5 hour session schedule.
To book onto a Virtual Live Training 1.5 hour session, or series of sessions, please click here.
Dates
- 17 May 2023 – 1/2 Day
- 10 October 2023 – 1/2 Day
- 05 December 2023 – 1/2 Day
TARGET AUDIENCE
Aimed at experienced Excel users who need to analyse and visualise large datasets from various sources.
PREREQUISITES
Participants should be existing users of Microsoft Excel who can create, edit, format and print a spreadsheet. They should also be able to create basic formulae and, ideally, should have completed the Excel Introduction training programme.
GOALS AND OBJECTIVES
Having completed this course, participants will be able to analyse and visualise large datasets from various sources using Power Pivot for Excel.
Introduction
Why use Power Pivot
Power Pivot Workbooks
The Power Pivot 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
Discussion and Question Time