Microsoft Excel - Power Pivot Certification Training Course Overview

Enroll for our 2-day Microsoft Excel - Power Pivot from Koenig Solutions. In this course you will learn how to perform powerhouse data analysis and modeling to make intelligent business decisions through Microsoft PowerPivot. Microsoft PowerPivot is an add on for Excel that provides Business Intelligence functionality & reporting within the familiar environment of Excel.

The course is designed for Excel 2016, 2019 and Microsoft 365 (Office 365), so you can choose the version that works best for you.

Target Audience:

The training is Intended for data analysts, financial analysts, business analysts, managers, and anyone who wants to harness Excel's business intelligence capabilities.

Learning Objectives:

After completing this course, you will be able to:

  • How to get data and transform it into useful tables.
  • How to build a proper dimensional model in Excel, by linking multiple tables together in order to solve common real-world problems.
  • Write your own custom calculations for pivot tables using DAX (Data Analysis Expressions), Power Pivot’s formula language.
  • How to build amazing reports.

 

Microsoft Excel - Power Pivot (16 Hours) Download Course Contents

Live Virtual Classroom 950
Group Training
01 - 02 Nov GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 07 Dec GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Request More Information

Course Prerequisites
  •  A  good knowledge of Excel, including a working knowledge of PivotTables and an understanding of nested functions.