Our training options
Public
Public Online Classes
with Live Teacher
- Online classes with live teacher
- Class size limited to a maximum of 10 participants per course to encourage interaction with the trainer
- Training manual and exercice files provided
- Live Q&As during classes and coaching during practice sessions.
- Official Attestation given after course completion
Popular
Videos
Online, on demand
and at your own pace
- Instant Access 24/7
- Unlimited viewing for 1 year
(▶ See a demo of the training interface) - Flexible: follow every course at your own rythm and schedule
- Training manual and exercice files provided
- Official Attestation given after course completion
Private
Remotely or at your office,
to suit your schedule
made-to-measure :
price per team
Chloé Bessette
Training Manager
- In online classes or at your office
- For a group/team from your company/organization
- Standard or custom-made syllabus
- Live, private Teacher
- Training manual and exercice files provided
- Official Attestation given after course completion
Microsoft Excel Expert
Contact
We'll get back to you within one business day.
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).
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
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
Need to assess your level?
Select the right course for you using the Formation CAD Auto-Assessment tool
Related courses
Formations apparentées
Included with this course:
- 1 year Support
- Official Certificate
Emploi Québec
approved
approved
from: Original price was: $899.99.$599.99Current price is: $599.99. /pers.
Included with this course:
- 1 year Support
- Official Certificate
Emploi Québec
approved
approved
from:$199.99 /pers.
Included with this course:
- 1 year Support
- Official Certificate
Emploi Québec
approved
approved
from:$199.99 /pers.