Excel Training – The Most Comprehensive
The "Excel – The Most Comprehensive" training is designed to provide you with an in-depth and practical understanding of Microsoft Excel, one of the most powerful tools for data management and analysis.
This intensive two-day course is intended for beginners and intermediate users who wish to improve their efficiency and productivity with Excel. No prior experience is required, although a basic familiarity with spreadsheets is an asset.
Introduction to the Excel Training
Course Outline Presentation
- Description of the interface (Ribbon, Quick Access Toolbar, etc.)
Module 1 – Excel Basics Excel
- Structure of a file (workbooks, worksheets, and cells)
- Edit your data: Fill series and freeze panes
- Overview of key shortcuts and time-saving tips
- Customize the ribbon and Quick Access Toolbar
- Create and manage tabs
Module 2 – Using Named References
- Create named references
- Go to a named item
- Use the Name Manager
- Use a named reference in a formula
Module 3 – Tables and Page Layout
- Apply automatic table formatting
- Create a custom style and apply it to a table
- Conditional formatting
- Basic database functions: Filter and Sort
- Cell formatting and styling
- Print the table
Module 4 – Using Formulas in Excel
- Relative and absolute references
- Find and insert a function
- Use basic formulas: Sum, Average, Max, Date
- Use logical (IF), text, and date functions
- Use lookup functions: VLOOKUP, HLOOKUP, XLOOKUP
Module 5 – Creating Charts
- Select data for the chart
- Types of charts: column, line, pie (2D or 3D)
- Choose a chart type based on your needs
- Apply a style
Module 6 – Pivot Tables / Pivot Charts
- Understand the purpose of a pivot table (examples)
- Create a pivot table
- Format a pivot table
- Use slicers
- Update the pivot table after changing the data source
- Highlight desired statistics from your table
- Customize a pivot table
- Create a pivot chart
- Customize a pivot chart
Module 7 – Getting Started with Macros
- How macros work
- Record, write, and run macros
- Run a macro with shortcuts (from the ribbon, button, etc.)
- Manage macros
Advanced Macros Training
Other course(s) in this category
→ Excel Training – The Most Comprehensive
→ Excel Essentials Training – Master the Foundations for Professional Efficiency
Prerequisites:
- Basic knowledge of Windows (or macOS) and the Microsoft Office suite
Documents or Materials Provided for Excel Training
A course document including theory and practical exercises that we will complete together.Target Audience / Who Is This Training For?
This Excel training is designed for individuals who want to build a solid foundation in spreadsheet concepts and practice exercises to reinforce their new skills.Materials to Bring for the Excel Training
A computer with an Internet connection and the Excel software installed.Objectives:
At the end of the Excel training, you will be able to:
- Understand the Excel interface, file structure, and manage tabs
- Use named ranges effectively
- Format and layout tables professionally
- Optimize the use of Excel formulas
- Utilize graphical representations (charts)
- Understand, create, and interpret pivot tables and pivot charts
- Use basic macros to automate tasks
Excel Training Approach
Excel training is based on a personalized approach that takes into account your current knowledge, skills, learning goals, and professional objectives.Why Choose Excel Training at Doussou Formation? / Benefits of Excel Training at Doussou Formation
Experienced trainers who adapt to your needs, hands-on learning, up-to-date and interactive Excel content.Online
- 05/01/2026
- 06/01/2026
- 19/01/2026
- 20/01/2026
- 16/02/2026
- 17/02/2026
- 02/03/2026
- 03/03/2026
- 30/03/2026
- 31/03/2026
- 13/04/2026
- 14/04/2026
- 11/05/2026
- 12/05/2026
- 25/05/2026
- 26/05/2026
- 22/06/2026
- 23/06/2026
- 06/07/2026
- 07/07/2026
- 03/08/2026
- 04/08/2026
- 17/08/2026
- 18/08/2026
Montreal
- 16/03/2026
- 17/03/2026
- 08/06/2026
- 09/06/2026
- 31/08/2026
- 01/09/2026
Quebec City
- 02/02/2026
- 03/02/2026
- 27/04/2026
- 28/04/2026
- 20/07/2026
- 21/07/2026
Pricing
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 with instructor)
📄 Download course outline (PDF)
Registration detailsInterested in this training?
Free quote with no obligation
Registration with credit card payment
FR
« 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)
EN
“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.”
FR
« 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. »
EN
“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)
FR
« 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 ! »
EN
“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)