Autodesk Courses
Autocad
Revit
Microsoft Courses
Copilot Pro
Excel
OneDrive
Outlook
Planner
Power Automate
PowerPoint
Project
SharePoint
Teams
To do
Visio
Word
Microsoft 365 Courses
AI Artificial IntelligenceNo products in the cart.
Microsoft Excel Expert
Predict, analyze and protect data.
Create formulas and groupings in a PivotTable.
Create links between sheets, workbooks and files with or without a Link.
Training options
Videos
Online and On-Demand
at your rythm
- Instant Access 24/7
Unlimided viewings for 1 year - Flexible: follow every course at your own rythm and schedule
- Training manual and exercice files provided
- Official Attestation given after course completion
Remotely
Public Classes
with Live Teacher
- Online classes with live teacher
- max 10 participants
- Training manual and exercice 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
- In online classes or at your office
- 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.
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:$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.