FR
Illustration: Excel Training course

Excel Training – The Most Comprehensive

Optimize your data analysis and automate your daily tasks.

In the digital age, mastering Excel is no longer just about aligning columns and applying basic formulas. This unique training program has been entirely redesigned to merge the traditional power of Microsoft Excel with the latest innovations in Artificial Intelligence (AI).

Whether you are a beginner or an intermediate user, this progressive curriculum will guide you from spreadsheet fundamentals to advanced automation techniques, including the strategic use of tools like ChatGPT and Microsoft 365 Copilot.

2 days 9:00 a.m. to 4:30 p.m. Online

Updated on

The Excel Training course at a glance

Length
2 days
Schedule
9:00 a.m. to 4:30 p.m.
Format
Live virtual class
Audience
Tous
Price
$391 per participant, or $332 for public bodies and non-profits (plus taxes)
Language
French or English

Doussou Formation and Excel Training: key facts

Upcoming Excel Training sessions

Online

  • Select
  • Select
  • Select
  • Select
  • Select
  • Select
  • Select

Excel Training course outline

Introduction to Excel & AI Training

  • Presentation of the syllabus and the impact of AI on productivity
  • Interface overview (Ribbon, Quick Access Toolbar, etc.)

Excel Fundamentals

  • File structure (workbooks, worksheets, and cells)
  • Modifying your data: Incrementing series, Smart Flash Fill, and Freezing panes
  • Overview of top shortcuts and time-saving tricks
  • Customizing the Ribbon and Quick Access Toolbar
  • Creating and managing worksheet tabs

Using Named References

  • Creating named references
  • Navigating to a named element
  • Using the Name Manager
  • Using a named reference inside a formula

Tables, Layout, and Smart Analysis

  • Automatic table formatting
  • Creating and applying custom table styles
  • Conditional formatting
  • Database functions: Filtering and Sorting
  • Cell formatting and layout
  • Printing tables and sheets
  • AI-guided exploration: Using the "Analyze Data" (Insights) feature to automatically generate visual suggestions

Leveraging Formulas and AI Formula Assistance

  • Relative and absolute references
  • Searching for and inserting functions
  • Using basic formulas: SUM, AVERAGE, MAX, DATE
  • Using logical (IF), text, and date functions
  • Using lookup functions: VLOOKUP, HLOOKUP, XLOOKUP
  • Introduction to connected data types : Stock and Geography data

Creating Data Visualizations

  • Selecting data to include in a chart
  • Chart types: Column, line, pie charts in 2D or 3D
  • Choosing the right chart type based on needs (Using Recommended Charts powered by Excel's algorithm)
  • Applying chart styles

Pivot Tables & Pivot Charts

  • Understanding the utility of a Pivot Table (use cases and examples)
  • Creating a Pivot Table (and utilizing Recommended Pivot Tables)
  • Formatting a Pivot Table
  • Using Slicers for interactive filtering
  • Modifying source data and refreshing tables
  • Extracting key metrics and statistics from your table
  • Customizing Pivot Tables
  • Creating a Pivot Chart
  • Customizing Pivot Charts

First Steps with Macros and Automation

  • Core principles of how a macro works
  • Recording, writing, and running macros
  • Executing macros via shortcuts (in the ribbon, buttons, etc.)
  • Managing macros
  • Introduction to modern automation: Differences between Macros (VBA) and cloud-optimized Office Scripts using AI

Using Microsoft Copilot in Excel

  • Overview of Copilot in Excel
  • Writing Clear Requests in Natural Language
  • Generating and Explaining Formulas with Copilot
  • Analyzing a Table and Identifying Key Trends
  • Creating a Summary from the Data
  • Reviewing AI-Generated Formulas and Results
  • Workshop: Analyzing a Dataset and Creating Formulas with Copilot

Advanced Training to Go Further

Your Excel Training trainer

Portrait of Danny

Danny

A graduate in Software Engineering from ÉTS, Danny has several years of experience in software development, web development, and technical training. As a full-stack developer, he works with a variety of technologies related to programming, databases, APIs, and web application…

View full profile

Prices and practical information

Preferred rate

$332 / participant

Public bodies and non-profits · plus taxes

Standard price

$391 / 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
  • Payment: online (PayPal or card) when registering, or by invoice for organizations
View dates and register Quote for my employer

Corporate Excel Training 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.

Request an offer

Participant reviews

97% satisfaction (end-of-course evaluations, 120 evaluations) · Read all testimonials

Why take this Excel Training course

Objectives: what you will be able to do

  • Master the Excel environment and manipulate data with ease using top productivity shortcuts.
  • Build robust and dynamic formulas (including XLOOKUP) and leverage AI-assisted formula writing.
  • Create impactful dashboards using Excel's smart features, recommended charts, and Pivot Tables (PT).
  • Collaborate with generative AI (ChatGPT, Copilot, Claude) to generate complex formulas, clean text-based datasets, and interpret results.
  • Take their first steps toward automation by designing macros (VBA) and discovering modern cloud-optimized Office Scripts enhanced by AI.

Prerequisites

  • Basic knowledge of Windows (or macOS) and the Microsoft Office suite

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

View all courses: Course to learn Microsoft Excel

Interested in the Excel Training course?

Quote for my employer Register now