No products in the cart.
Microsoft Excel Training class – Advanced
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
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 Training class – Advanced
Contact
We'll get back to you within one business day.
Description
Excel
Excel
Level: Advanced
Microsoft
DURATION:
1 day
REQUIRED LEVEL:
Basic knowledge of Excel’s functions.
OBJECTIVES :
– Be able to build advanced formulas and perform complex calculations.
– Create and use a pivot table.
– Perform VLOOKUP
PROGRAM:
FUNCTIONS
Statistical
- Review on simple formulas
- Absolute and relative references
- Statistics: Average, COUNT, COUNTA, MAX,
- MIN, COUNTIF, AVERAGEIF
Math and trigonometry
- SUMIF
- INT (age calculation)
- ROUND, ROUNDDOWN, ROUNDUP
Text
- UPPER, LOWER, PROPER
- CONCATENATE
- LEFT, RIGHT
- LEN
Date
- TODAY, NOW
- YEAR, MONTH, DAY, NETWORKDAYS
Logic
- Simple logic IF
- Complex logic: IF with several logics, AND, OR
Search and reference
- VLOOKUP
Other functions
- PV, NPER, VPMT
- ISBLANK
Formula audit
- Identify dependents and precedents
VALIDATION
- Create validation
- Create an error message
NAME MANAGER
- Set a name
- Change or delete a name
CLIPBOARD OPTIONS
- Paste, paste with link
- Paste formula, value, etc.
DATA PROTECTION
- Protect the workbook
- Allow some users to change ranges
PIVOT TABLES
List of fields
- Line Labels
- Filter of the report
- Labels
- Values
- Pivot table options
Group selection
- By date, number, text
Creation tab
Options (Analysis)
- Change the source
- Update the data
- Show percentage values
- Segment and displays
CREATE A MODEL
Duration
6 hours
Level
Advanced
Prerequisites
Basic knowledge of Excel’s functions.
Goals
Be able to build advanced formulas and perform complex calculations.
– Create and use a pivot table.
– Perform VLOOKUP
Syllabus
FUNCTIONS
Statistical
- Review on simple formulas
- Absolute and relative references
- Statistics: Average, COUNT, COUNTA, MAX,
- MIN, COUNTIF, AVERAGEIF
Math and trigonometry
- SUMIF
- INT (age calculation)
- ROUND, ROUNDDOWN, ROUNDUP
Text
- UPPER, LOWER, PROPER
- CONCATENATE
- LEFT, RIGHT
- LEN
Date
- TODAY, NOW
- YEAR, MONTH, DAY, NETWORKDAYS
Logic
- Simple logic IF
- Complex logic: IF with several logics, AND, OR
Search and reference
- VLOOKUP
Other functions
- PV, NPER, VPMT
- ISBLANK
Formula audit
- Identify dependents and precedents
VALIDATION
- Create validation
- Create an error message
NAME MANAGER
- Set a name
- Change or delete a name
CLIPBOARD OPTIONS
- Paste, paste with link
- Paste formula, value, etc.
DATA PROTECTION
- Protect the workbook
- Allow some users to change ranges
PIVOT TABLES
List of fields
- Line Labels
- Filter of the report
- Labels
- Values
- Pivot table options
Group selection
- By date, number, text
Creation tab
Options (Analysis)
- Change the source
- Update the data
- Show percentage values
- Segment and displays
CREATE A MODEL
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
- Attestation
Emploi Québec
approved
approved
from:999.00$ /pers.
Included with this course:
- 1 year Support
- Attestation
Emploi Québec
approved
approved
from:From: 999.00$ /pers.
Included with this course:
- 1 year Support
- Attestation
Emploi Québec
approved
approved
from:From: 999.00$ /pers.