Advanced Excel: Data Analysis with Power Query, PivotTables & Inquire
Excel
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.
Updated on
The Advanced Excel course at a glance
- Length
- 2 days
- Schedule
- 9:00 a.m. to 4:30 p.m.
- Format
- Live virtual class or in person in Montreal and Quebec City
- Audience
- Tous
- Price
- $901 per participant, or $765 for public bodies and non-profits (plus taxes)
- Language
- English
Doussou Formation and Advanced Excel: key facts
- Since 2016Doussou Formation has been delivering professional training in Quebec
- 300+specialized courses in our catalogue
- 97 %satisfaction according to client evaluations
- RAP · CPMTAccredited supplier and recognized training organization
Upcoming Advanced Excel sessions
Advanced Excel course outline
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
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
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
Prices and practical information
Preferred rate
$765 / participant
Public bodies and non-profits · plus taxes
Standard price
$901 / participant
Businesses and individuals · plus taxes
Practical information
- Length: 2 days
- Schedule: 9:00 a.m. to 4:30 p.m.
- Format: Live virtual class or in person in Montreal and Quebec City
- Payment: online (PayPal or card) when registering, or by invoice for organizations
Corporate Advanced Excel training
Train your whole team as a private group, on your own documents, at your premises or in a virtual class, on the dates that suit you.
Participant reviews
97% satisfaction (end-of-course evaluations, 120 evaluations) · Read all testimonials
Why take this Advanced Excel course
Objectives: what you will be able to do
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.
Prerequisites
Have basic knowledge of Excel or have completed the Beginner Excel training
What is included
- Course materials and exercise files for each participant
- Certificate of attendance
- Optional personalized coaching after the course
- In public in-person sessions:
- Tea and coffee
- Lunch at a nearby restaurant
- Parking (in some cities)
- Wi-Fi access