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

Other course(s) in this category

→ Training in Statistical Analysis and Data Preparation with R

→ The Most Comprehensive Power BI Training

→ Python and Data Science Training – Complete Tour

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:

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

Objectives:

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
- 14/05/2026
- 28/05/2026
- 25/06/2026
- 09/07/2026
- 06/08/2026
- 20/08/2026

- 19/03/2026
- 11/06/2026

- 23/07/2026

Pricing

Preferential rate

552

$ / participant

Public orgs, NPOs

Public 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, 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)

Excel Dashboard Training