InIT Learning One day Computer Courses
Call: 0330 32 100 58

Power Pivot

Excel Power Pivot Course Content

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

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)

Software Training

Enquire about software training computer courses at your office. Courses @ Yours
LET'S GO!
We deliver courses all around Buckinghamshire and surrounding counties wherever your offices are located.

Harben House Hotel
Tickford Street
Newport Pagnell
MK16 9EY

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

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.

Close