Power Pivot
Call: 0330 32 100 58

Power Pivot

Excel Power Pivot Course Content


To understand and use:
Concepts & Terms
Import Raw Data
Connect to Data
Shape & Transform
Create Relationships
Data Analysis Expressions


1: Who is the Course for?
This course is ideal experienced users who are responsible for analysing data from many sources and have a good understanding of Excel functions and formulas. 

2: The Course
Courses delivered by InIT Learning are tutor led. The tutor will use demonstration and discussion along with hands-on practical tasks and assignments to ensure each user has gained an understanding of each topic. Questions are encouraged throughout the session. During each task and assignment the tutor will give one to one support as required.

3: Certificates
Each delegate will receive a manual and a certificate of attendance

Excel Power Pivot

Course Content:
Introduction to Excel Power Business Intelligence
Enable Power Pivot
Power Query
Power Query Editor
Query Editor Tools
Loading Data
Pivoting and Unpivoting
Merging Queries
Appending Queries
Data Model Views
Database Normalisation
Data and Lookup Tables
Power Pivot
DAX Measures
Data Analysis Expressions (DAX)
Basic Measures
Date and Time Functions (Basic)
Excel 1Excel 2Excel 3Excel 4Word 1Word 2PowerPointOutlook

Software Training

Enquire about software training computer courses at your office. IT Courses @ Yours
InIT Learning deliver courses all around Buckinghamshire and surrounding counties wherever your offices are located.

Suite 163
Milton Keynes Business Centre
Foxhunter Drive
Linford Wood
Milton Keynes
MK14 6GD

Tel: 0330 32 100 58
(Calls may be recorded for quality purposes) 

One-day computer Courses
On Course for Success with InIT Learning
Copyright © InIT Learning
usersscreenlist linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.