Power Query and Power Pivot for Excel Training

Training Summary

Certificate: No Certification

Duration: 2 Days

Course Delivery: Classroom / Virtual

Language: English

Credits: 16

Training Highlights

  • High quality training from Certified & Industry Experts
  • Earn 16 PDUs and 16 SEU’s
  • Course Completion Certificates
  • Reimbursement guaranteed if the training is not satisfied
  • Extensive documentation provided

Our approach is both practical and inspirational.Our training is carefully designed and tested to develop the key skills and confidence needed while being highly participatory and fun

Course Overview

Power BI (including Power Query & Power Pivot) are the biggest Excel news items in the last 10 years. They give Excel users the power to draw information out of multiple sources, link it together then perform calculations on it that can then be sliced & diced any way you want.

Course Description See Below

Course Description:

Power BI (including Power Query & Power Pivot) are the biggest Excel news items in the last 10 years. They give Excel users the power to draw information out of multiple sources, link it together then perform calculations on it that can then be sliced & diced any way you want.
This hands-on course is focused on real-world techniques utilising the amazing capabilities of Power Query, Power Pivot and Power BI.
The course covers the core elements needed to get an understanding of what Power BI, Power Pivot and Power Query can do. You will use Power Query to extract and shape data and then load it into Power Pivot. You will build a complex Power Pivot Model from scratch, write DAX formulas and set up interactive reports.
The second day delves deeper into all of the topic areas demonstrating how to get the most from these amazing tools. You will learn extra advanced Power BI features and get a more in-depth understanding of Power Query and Power Pivot reporting techniques

Course Outline:

Power BI & PowerPivot Introduction

● Creating your first Power Pivot Model
● Mapping tables
● Joining multiple tables together and understanding relationships
● Creating a Calendar Table
● Utilising a Calendar Table
● Advanced PivotTable Design
● Pivot Charts
● PowerMap
In-depth Power BI & Power Pivot Models

● Creating more complex Power Pivot models
● Calculated Columns
● Introducing DAX formulas and Measures (Calculated Fields)
● Filters and Slicers
● Improve the user experience through Hiding and Hierarchies
● Pitfalls to avoid
● How to build in checks to detect new data or imbalances
● Creating useful time-based measures with more advanced DAX formulas
● CALCULATE explained
● CUBE formula
● KPIs

● Exploring the User Interface
● PowerQuery techniques
● How to “un-pivot” data
● How to merge multiple queries into one table
In-Depth Power Query

● Using variables for query parameters
● Introduction to the Advanced Editor and M language
● Creating re-usable custom functions
● Calendar Creator
Power BI Desktop & POWERBI.com

● Power BI Desktop
● A comparison with Power Pivot and Power Query
● An overview of the graphical interface
● Custom Visualizations
● PowerBI.com
● Publishing and Sharing your Dashboards
What you get from this course

● Understand how Power BI builds on the functionality of Excel’s native tools, such as PivotTables, slicers and key analytical functions
● Be able to import data from a variety of electronic sources and relate them quickly to deliver key information in minutes not weeks
● Utilise best practice database design, realising the power of the Data Model by using LOOKUP lists and efficient database design
● Provides an introduction to Power BI’s Data Analysis Expressions (DAX) language

●     This is an intermediate course and users should already be comfortable with Excel to get the most from this course.
●     Participants should be familiar with functions & concepts such as VLOOKUP and SUMIFS.
●     The focus of the course on Power BI in Excel 2013/2016 and is also applicable to Power BI Desktop.
Who should attend?

●     Excel users & analysts that focus on extracting, re-organizing and analysing data
●     Excel users & analysts involved in creating visualisations & data modelling
●     Anyone interested in saving huge amounts of time in automating the work involved in creating recurring reports and dashboards
Once after the training you receive course completion certificate from Mangates
What are the hours of the Training?

The Training hours are 9:00 am to 5:00 pm

What time shall I arrive at the venue

Please arrive 15 minutes early for the training

What are PDU’s and SEU’s?

A PDU stands for a Professional Development Unit, A way to measure ongoing professional development. SEUs are Scrum Educational Units, issued by the Scrum Alliance.

What Does Mangates provide me on the day of the course?

We provide Course Materials, Course Completion Certificate and Refreshements

Do you provide Placements?

Placements are not guaranteed, however you can ask our trainer for the help as our trainer has contacts with corporate.

Do you provide a group discount for classroom training programs?

We do Provide Group Discounts such as 10% for group of 3, 15% for group of 5 and 20% for the group of 10 people.

If I cancel my Enrollment, how can I claim my Refund?

You can request a refund by sending an email to info@mangates.com and within 7 working days you get your money back.


We have most experienced trainers in the Industry. Our Trainers are highly skilled in their subject areas and are uniquely positioned to provide participants with deep industry experience. They are motivated to transfer knowledge through practical support post and pre-training to provide participants with additional support outside the classroom.

Samir Chibber CST

Ashesh SPC4

Armen Pashkam SPC4

Abrar SPC4


All of our instructors are recognized experts in their fields with hands-on experience on the topics they teach. We combine proven adult educational training methods with leading-edge industry expertise to provide you an exceptional training experience. Every instructor must meet rigorous standards with the proven background in their given field of expertise. It is the difference that our customers covet and participant appreciates at the completion of the course.


Students will receive a course manual with presentation slides and reference materials.

ALL of our instructors, share with you over Real experience, case studies, stories, and examples.

We provide Continuing Support beyond the class with Free Coaching and Mentoring

Training Platforms

Flexibility is what we provide in order to take your career to the next level. Lets you get out and take the training on your convenient place and on your convenient time. Any of our Classroom courses can be delivered on-site at your workplace or a place of you choose.

Classroom Training

Social Interaction

Audio, Visual and Beyond

Instructor vs. Learner Focused

Virtual Training


Flexible Learning

Practical and Proven

Corporate Training

Save Valuable Time and Money

Customized Course Content

On Your Preferred Date & Time

Good Focus on Knowledge Areas
Best Support Team and Best Instructor, Great Learning
Excellent Teaching, Real world Examples

Our Popular Courses

We know that picking what course to study next is sometimes rather difficult. Therefore to help narrow down your choices, we have taken the step to look through hundreds of courses on offer and pulled together a list of our most popular courses. This way you can see what is currently trending in the World! If you need help enrolling into any of these courses, call us to speak with one of our Training Consultants.

DevOps Fundamentals
Duration: 5 Days
Microsoft Power BI
Duration: 2 Days
Fundamentals of SDLC
Duration: 3 Days
Cyber Security
Duration: 2 Days
Advanced Java and Web Application Security
Duration: 3 Days
DevOps Practitioner
Duration: 1 Day

Our Clients

Just some of the leading brands that trust Mangates

ga('send', 'pageview');