Skip to content
  • Remote Classes and online courses for professionals and businesses. Official Attestations approved by Emploi Québec and professional associations

    • +1 (877) 260-6888
    • Français
    • +1 (877) 260-6888
    • Français
Formation CADFormation CAD
  • 0
    Cart
    No products in the cart.
    • Courses and Trainings
      • Autodesk
        • Autocad
        • Revit
      • Microsoft
        • Access
        • Copilot
        • Excel
        • OneDrive
        • OneNote
        • Outlook
        • Power Automate
        • Power BI
        • Planner
        • PowerPoint
        • Project
        • SharePoint
        • Teams
        • To do
        • Word
        • Microsoft 365
      • Microsoft Bundles
        • Microsoft 365 Complete CoursesCollaboration with Teams, Outlook, OneDrive, SharePoint, from beginner to advanced
        • Microsoft Office Complete CoursesExcel, Word, PowerPoint, Outlook from beginner to expert
        • Microsoft Office Basics CoursesExcel, Word, PowerPoint, Outlook, base levels
        • Excel Complete CoursesFrom Beginner to Expert
        • Word Complete CoursesFrom Beginner to Advanced
      • AI Artificial Intelligence
        • Copilot
      • Security
        • Cybersecurity
  • About
    • Formation CAD Advantage
  • Contact
  • 0
    • No products in the cart.
  • Free assessment
  • Menu
Home » Courses and Trainings » Microsoft Courses » Microsoft Excel
Filter

Home » Courses and Trainings » Microsoft Courses » Microsoft Excel

Microsoft Excel Expert

Microsoft Excel Expert

Courses in English

Predict, analyze and protect data.

Create formulas and groupings in a PivotTable.

Create links between sheets, workbooks and files with or without a Link.

Microsoft Excel Expert

Emploi Québec

Microsoft Excel Expert

from:$199.00 /pers.

Expert

3.5hrs (course+practice)

97.7% statisfaction rate

Choose a course

Training options

Videos

Online and On-Demand
at your rythm

from:$199.99 /pers.

Instant Access 24/7
Buy the Video Course
  • Instant Access 24/7
    Unlimited viewings for 1 year
  • Flexible: follow every course at your own rhythm and schedule
  • Training manual and exercise files provided
  • Official Attestation given after course completion

Remotely

Public Classes
with Live Teacher

from:$199.00 /pers.

Next classes schedule
View available dates
  • Online classes with live teacher
  • max 10 participants
  • Training manual and exercise files provided
  • Live Q&As during classes and coaching during practice sessions.
  • Official Attestation given after course completion

Private

Online or at your Office
tailored to your schedule

get a quote:

price per team

Reply and custom quote within a business day
Contact Us
  • In online classes or at your office
  • Standard or custom-made syllabus
  • Live, private Teacher
  • Training manual and exercise files provided
  • Official Attestation given after course completion

Microsoft Excel Expert

No public classes scheduled :

Ask for a private class
/ /

Want to watch again part of or the entire course you participated in?
Get a video recording (on-demand streaming) of the class you attended:

Microsoft Excel Expert

from:$199.00 /pers.

Acheter les vidéosVoir les dates disponibles
Demander une formation privée

Contact

We'll get back to you within one business day.

  • This field is for validation purposes and should be left unchanged.
Duration
3.5 hours (course+practice)
Level

Expert

Prerequisites
  • Knowledge of the Windows environment.
  • Having completed Microsoft Excel Advanced course or have equivalent knowledge.
  • Having access to a computer and Microsoft Excel (2013, 2016 or OFFICE 365).
Goals
  • Predict and analyze data.
  • Create formulas and groupings in a PivotTable.
  • Adequately protect data.
  • Create links between sheets, workbooks and files with or without a Link.
Syllabus

CONSOLIDATION

  • Consolidate by category

FORECAST

  • Scenario analysis
  • Target value
  • Table
  • Scenario Manager

CONDITIONAL FORMATTING

  • With formulas
  • Even and odd
  • WEEKDAY

LINK

  • To other sheets
  • To other files
  • Copy and paste to other files with LINK
  • Watch Window

ADVANCED FORMULAS

  • SI. ENS
  • Date
  • VLOOKUP, HLOOKUP (Value 1)

OUTLINE MODE

  • Group
  • Ungroup
  • Select visible cells under formulas only, and others…

DATA PROTECTION

  • Read-only
  • Password on opening
  • Protect formulas
  • Allow range modification to certain users
  • Protect the structure of a workbook

PIVOT TABLE

  • Group by text
  • Calculated field
  • Calculated item
Downloadable PDF Syllabus

Excel Expert Syllabus

Download

Need to assess your level?

Select the right course for you using the Formation CAD Auto-Assessment tool

Free Assessment
Microsoft Excel Expert
Microsoft Excel Expert

Related courses

Formations apparentées

Microsoft Excel Complete
Microsoft Excel

Microsoft Excel Complete

Beginner to Advanced

24 hours
Video
Online Classes
Private
Included with this course:
  • 1 year Support
  • Official Certificate
Emploi Québec
approved
from:$899.99 Original price was: $899.99.$599.99Current price is: $599.99. /pers.
Microsoft Excel Basics 2
Microsoft Excel

Microsoft Excel Basics 2

Beginner

6 hours
Video
Online Classes
Private
Included with this course:
  • 1 year Support
  • Official Certificate
Emploi Québec
approved
from:$199.99 /pers.
Microsoft Excel Basics 1
Microsoft Excel

Microsoft Excel Basics 1

Beginner

6 hours
Video
Online Classes
Private
Included with this course:
  • 1 year Support
  • Official Certificate
Emploi Québec
approved
from:$199.99 /pers.
Formation CAD
Autocad, Autodesk, and Microsoft Office 365 courses. Online classes with live, accredited teachers. Training center offering tailor-made courses for companies and administrations everywhere in Canada.
Tools
  • Online classroom connection information
  • Assess your level prior to choosing a course
    • Microsoft Office Assessment
    • Autodesk Assessment
  • Training Subsidies
    • Training Subsidies Discovery Tool
    • All available Training Subsidies
  • Terms and Conditions
Online Courses
  • AI Artificial Intelligence
  • Autodesk Courses
    • Autocad
    • Revit
  • In-Office Training
  • Microsoft Courses
    • Custom Courses and In-Office Training
    • Microsoft 365 (Office) Courses
    • Microsoft Copilot
    • Microsoft Courses Bundles
    • Microsoft Excel
    • Microsoft OneDrive
    • Microsoft OneNote
    • Microsoft Outlook
    • Microsoft Planner
    • Microsoft Power Automate
    • Microsoft PowerPoint
    • Microsoft Project
    • Microsoft SharePoint
    • Microsoft Teams
    • Microsoft To do
    • Microsoft Visio
    • Microsoft Windows
    • Microsoft Word
  • Security Courses
Newsletter

Get tools, advice and specials from Formation CAD directly in your inbox!

  • This field is for validation purposes and should be left unchanged.
Copyright 2025 © Formation CAD
  • Courses and Trainings
    • Autodesk
      • Autocad
      • Revit
    • Microsoft
      • Access
      • Copilot
      • Excel
      • OneDrive
      • OneNote
      • Outlook
      • Power Automate
      • Power BI
      • Planner
      • PowerPoint
      • Project
      • SharePoint
      • Teams
      • To do
      • Word
      • Microsoft 365
    • Microsoft Bundles
      • Microsoft 365 Complete Courses
      • Microsoft Office Complete Courses
      • Microsoft Office Basics Courses
      • Excel Complete Courses
      • Word Complete Courses
    • AI Artificial Intelligence
      • Copilot
    • Security
      • Cybersecurity
  • About
    • Formation CAD Advantage
  • Contact
  • Login / Register
  • Free assessment
    • Français

Login

Lost your password?