This advanced Excel training focuses on importing, cleaning, analyzing, and reporting from large and complex datasets. It is structured into three key modules covering Power Query, Inquire, and Power Pivot. With Power Query, participants will learn how to import and prepare data from various sources for analysis. The Inquire module focuses on analyzing and comparing Excel files to ensure their integrity and optimize performance. Finally, the Power Pivot module enables participants to consolidate data from multiple sources, build data models, and produce dynamic reports. This training provides Excel users with the essential skills to handle complex data and generate precise, interactive analytical insights.

Course details

Module 1: Power Query – Importing and Cleaning Data

Introduction to Power Query

Understanding the interface and main features of Power Query
Exploring compatible data sources (CSV, Excel, Web, etc.)
Importing data into Power Query

Importing Data

Importing CSV files, Excel workbooks, and data from websites
Importing an entire folder to consolidate multiple similar files into a single source

Cleaning and Transforming Data

Removing null values, duplicates, and filtering rows
Splitting columns, changing data types, replacing values
Detecting and correcting errors to ensure data quality

Saving and Loading Cleaned Data

Saving transformations and loading the cleaned data into Excel for analysis

Module 2: Inquire – Analyzing and Comparing Excel Files

Introduction to Inquire

Overview of the tool and its main functionalities
Accessing Inquire in the Excel ribbon and configuring comparison options

Comparing Two Workbooks

Performing a detailed comparison of two workbooks to identify differences
Generating comparison reports to document changes and differing values

Optimizing Excel Files

Cleaning excessive formatting to reduce file size
Removing unnecessary formatting to improve performance
Managing passwords to secure files

Module 3: Power Pivot – Building Reports and Linking Data

Introduction to Power Pivot

Understanding the interface and the benefits of Power Pivot for advanced analysis
Enabling Power Pivot in Excel and adding data sources

Creating Data Models and Relationships

Importing and consolidating multiple tables from different sources
Creating and managing relationships between tables to interconnect data

Calculated Columns and Measures

Creating calculated columns with custom formulas to enrich the dataset
Using measures for dynamic calculations within PivotTables

Building PivotTables and PivotCharts

Creating interactive reports with PivotTables and PivotCharts
Using slicers for quick and targeted data analysis

Exporting and Sharing Reports

Preparing reports for export and sharing with stakeholders
Refreshing Power Pivot data to keep reports up to date

Other course(s) in this category

→ Advanced Excel: Data Analysis with Power Query, PivotTables & Inquire

Benefits:

A course material for each participant.
Coaching available after the training.
We offer you in public session:
- Tea, coffee
- Dinner at a nearby restaurant
- Wireless internet connection

Prerequisites:

Have basic knowledge of Excel or have completed the Beginner Excel training

Objectives:

By the end of the Advanced Excel training, you will be able to:

Master Power Query to import data from different sources, clean and transform raw data into actionable insights.
Use Inquire to analyze, compare, and optimize Excel workbooks, identifying differences and improving file performance.
Learn Power Pivot to create interactive visual reports, establish relationships between tables, and use calculated columns and measures for enhanced analysis.
Produce dynamic reports with PivotTables and PivotCharts, refreshable based on source data, for shared and collaborative analysis.

- 09/02/2026
- 10/02/2026
- 23/02/2026
- 24/02/2026
- 23/03/2026
- 24/03/2026
- 07/04/2026
- 08/04/2026
- 04/05/2026
- 05/05/2026
- 20/05/2026
- 21/05/2026
- 17/06/2026
- 18/06/2026
- 06/07/2026
- 07/07/2026
- 03/08/2026
- 04/08/2026
- 17/08/2026
- 18/08/2026
- 14/09/2026
- 15/09/2026

- 09/03/2026
- 10/03/2026
- 03/06/2026
- 04/06/2026
- 31/08/2026
- 01/09/2026

- 26/01/2026
- 27/01/2026
- 20/04/2026
- 21/04/2026
- 20/07/2026
- 21/07/2026

Pricing

Preferential rate

765

$ / participant

Public orgs, NPOs

Public price

901 $ / participant

Practical information

Duration: 2 day(s)
Schedule: 9:00 a.m. to 4:30 p.m. (2 coffee breaks + 1-hour lunch)
Format: - Online (live virtual classroom)
- Or in person, depending on availability

📄 Download course outline (PDF)

Registration details

Interested in this training?

Free quote with no obligation

Check if you are: You work for a government organization or a non-profit (NPO)

Select location and date

Name *

Email *

Company (optional)

Number of participants

I have read the terms and conditions

Enter the code

Registration with credit card payment

Check if you are: You work for a government organization or a non-profit (NPO)

Select location and date

Name *

Email *

Company (optional)

Number of participants

I have read the terms and conditions

Enter the code

Mark Plouffe, Government of Canada

« Je tiens à vous remercier tous les deux d’avoir offert à mes ressources une excellente formation COBOL au cours des trois derniers jours. Mamadou, merci d’avoir été si accommodant malgré le court préavis et d’avoir envoyé votre formateur à Gatineau pour ce cours personnalisé. Nous avons hâte de poursuivre notre collaboration pour de futurs besoins de formation. »
(Traduit de l’anglais)

“I want to thank you both for providing my resources with excellent COBOL training over the past 3 days. Mamadou, thank you for being so accommodating on such short notice and for sending your facilitator to Gatineau for this customized and personalized training course. We look forward to continuing our partnership for future training needs.”

René-Claude Bouchard | Chargé de projets | STM

« Mamadou est venu nous aider à réorganiser notre panneau d’arrêt via un outil de rapport, Crystal Reports. Mamadou a réussi avec succès le travail de précision, au pixel près, puisque nous voulions un rapport similaire au design graphique original. Il nous a aidés à découper le projet par cycle et à intégrer le rapport à notre logiciel corporatif. La qualité que nous avons appréciée était le souci du détail et la constance. Mamadou a été très professionnel et connaît plusieurs autres technologies. Merci. »

“Mamadou helped us reorganize our stop panel using a reporting tool, Crystal Reports. He successfully delivered precise, pixel-perfect work, as we needed a report that matched the original graphic design. He helped us break the project down into cycles and integrate the report into our corporate software. What we appreciated most was his attention to detail and consistency. Mamadou was very professional and is knowledgeable in many other technologies. Thank you.”
(Translated from French)

Martin Côté – Analyste Assurance Qualité – Travailleur autonome – Montréal

« Ce fut un plaisir de faire affaires avec Doussou Formation. Ce qui fait LA différence est le service personnalisé totalement à l'écoute des participants ainsi que l'adaptation aux besoins de formation. Flexibilité / Adaptabilité / Professionnalisme / Courtoisie. Merci ! »

“It was a pleasure doing business with Doussou Formation. What truly makes THE difference is the personalized service, fully attentive to participants, as well as the ability to adapt the training to their needs. Flexibility / Adaptability / Professionalism / Courtesy. Thank you!”
(Translated from French)

Advanced Excel: Data Analysis with Power Query, PivotTables & Inquire