This 2‑day course enables participants to master Excel and Power Query to analyze data effectively. It covers automating data cleaning, transformation, and consolidation, as well as creating reports and visualizations to support decision‑making.
Objectives
The objective of this course is to enable participants to analyze and prepare data in Excel, automate transformations with Power Query, create effective analytical models and reports, and present insights clearly and concisely.
Is it for you ?
Business analysts, data analysts, accountants, BI managers, and anyone wishing to improve their skills in data manipulation and analysis in Excel and Power Query
Prerequisite
Basic knowledge of Excel, fundamental skills in table manipulation and formulas, access to a recent Excel environment with Power Query enabled
Your benefits
Content
Data preparation and transformation
- Introduction to Power Query and basic concepts
- Importing and consolidating data from different sources
- Data cleaning and transformation
- Creating calculated columns and advanced transformations
- Handling missing data and complex filters
- Introduction to advanced functions and queries
Hands‑on exercise
Importing and cleaning a complex dataset using Power Query. Deliverable: Excel file with prepared queries and data ready for analysis.
Key points & takeaways
- Mastery of basic and advanced Power Query features
- Ability to automate data transformations
- Efficient preparation of datasets for analysis
See more + / -
Analysis and reporting
- Data analysis and aggregation with Power Query
- Creating analytical models and pivot tables
- Introduction to automated visualizations and reports
- Workflow optimization and automatic data refresh
- Best practices for reports and dashboards
- Sharing and communicating insights to stakeholders
Hands‑on exercise
Creation of a complete automated report using Power Query and pivot tables. Deliverable: Final Excel file with analyses and visualizations.
Key points & takeaways
- Ability to create automated and reproducible workflows
- Mastery of advanced analysis techniques in Excel
- Skill in producing clear and concise reports
💡 Useful information
Our training sessions are offered in Montreal or Quebec City, in person or in virtual format. Dates and locations are provided when you select your session below. If you have any questions regarding registration, schedules, the language of instruction, or cancellation policies, please consult our FAQ .
Trainers
Private or personalized training
Do you have several employees interested in the same training course? Whether in person at your offices or remotely in virtual mode, we offer private training courses tailored to your team's needs. Group rates are available. Contact us for more details or request a quote online.
Request a quote