This Excel Pivot Table training will help you master the key features needed to build effective Pivot Tables.

Through numerous hands-on workshops, you will explore how to design Pivot Tables in Excel — from simple tables to more complex ones. This course offers a complete overview of Excel’s Pivot Table functionalities.

By the end of the training, you will have gained real experience in creating Pivot Tables. You won’t walk away with just theoretical knowledge — you’ll have mastered the essential concepts to confidently and efficiently work with Pivot Tables in Excel.

Registration Details

Course details

Course Modules:

Module 1: Introduction to Dashboards

Overview and objectives of dashboards
Examples of effective dashboards
Key components of a dashboard

Module 2: Data Collection and Preparation

Importing data into Excel
Cleaning and organizing data
Essential formulas for data preparation

Module 3: Data Visualization

Creating charts and diagrams
Using conditional formatting
Techniques to highlight data

Module 4: Dashboard Automation

Using macros to automate tasks
Advanced formulas for automatic updates
Integrating form controls for an interactive interface

Module 5: Data Analysis and Interpretation

Data analysis techniques
Interpreting visual results
Making data-driven decisions from the dashboard

Autre(s) cours dans cette catégorie

→ The Most Comprehensive Power BI Training

→ Excel Dashboard Training

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

Préalables :

Basic knowledge of Microsoft Excel (formulas, formatting, etc.)
Basic understanding of data management principles

Objectifs :

Understand the fundamentals of dashboards in Excel.
Learn how to efficiently collect and organize data.
Master data visualization techniques.
Automate data update processes.
Interpret and communicate key insights through the dashboard.

- 08/01/2026
- 22/01/2026
- 19/02/2026
- 05/03/2026
- 16/04/2026

- 01/12/2025
- 19/03/2026

Pricing

Preferential rate

552

$ / participant

Public orgs, NPOs or 2+ participants

Regular price

650 $ / participant

Practical information

Duration: 1 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, Gouvernement du Canada/ Government of Canada

“ I want to thank you both for providing my resources some excellent training(Cobol) 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 customised and personalised training course. We’ll look forward to continuing our partnership for future training needs. “

Maryse Duguay - Analyste fonctionnelle Base de donnée - Montréal

“J’ai grandement apprécié les méthodes d’enseignement du prof. Le fait que nous soyons un petit groupe a grandement facilité les apprentissages. Il s’adapte à son audience et les exercices sont formateurs. Je recommande fortement. “

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!“