Excel Power Pivot Courses

On Course for Success in Milton Keynes

Excel Masterclass

Course Objectives

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

About

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
C
ourses 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

Introduction
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
SWITCH and SWITCH(TRUE) Functions
Date and Time Functions (Basic)
Dates & Book
Excel Power Pivot Courses are delivered by InIT Learning, Milton Keynes
Privacy PolicyDisclaimer
Excel Power Pivot Courses
Milton Keynes Chamber Member
desktopmagic-wanddatabase

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.

Close