InIT Learning One day Computer Courses
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)
On Course for Success with InIT Learning
On Course to Develop - On Course to Progress - On Course to Achieve
Copyright © InIT Learning
InIT Learning One day Computer Courses
Areas Covered - Milton Keynes, Buckinghamshire - Northampton, Northamptonshire - Rugby, Warwickshire - Oxford, Oxfordshire - Bedford, Bedfordshire - All surrounding towns and counties
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.