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
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
- 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
- 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
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:$199.99 /pers.
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.