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.
  • Trainings and Courses
    • Microsoft 365 (Office) Courses
    • Microsoft Outlook
    • Microsoft Excel
    • Microsoft PowerPoint
  • Subsidies
  • About
    • Formation CAD Advantage
  • Contact
  • 0
    • No products in the cart.
  • Free assessment
  • Menu
Accueil » Courses and Trainings » Microsoft 365 (Office) Courses » Microsoft Excel
Filter

Accueil » Courses and Trainings » Microsoft 365 (Office) Courses » Microsoft Excel

Microsoft Excel Training class - Advanced

Microsoft Excel Training class – Advanced

Private Course
Microsoft Excel Training class - Advanced

Emploi Québec

Microsoft Excel Training class - Advanced

from:From: 999.00$ /pers.

Advanced

6 hours

97.7% statisfaction rate

Choose a training option

Training options

Videos

Online and On-Demand
at your rythm

starting at:

from:199.99$ /pers.

$
/pers.
Instant Access 24/7
Buy the Video Course
  • 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

starting at:

999$ /day/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 exercice files provided
  • Official Attestation given after course completion

Microsoft Excel Training class – Advanced

No public classes scheduled :

Ask for a private class
Start:
/ /
End:
/ /

Day(s)

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 Training class – Advanced

from:From: 999.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.
Description

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

 

Downloadable PDF Syllabus

Excel Advanced - Syllabus

Download

Need to assess your level?

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

Free Assessment
Microsoft Excel Training class - Advanced
Microsoft Excel Training class - Advanced

Related courses

Formations apparentées

Microsoft Excel Training class - Expert
Microsoft Excel

Microsoft Excel Training class – Expert

Expert

3.5 hours
Video
Online Classes
Private
Included with this course:
  • 1 year Support
  • Attestation
Emploi Québec
approved
from:999.00$ /pers.
Microsoft Excel Training class - Beginner 2
Microsoft Excel

Microsoft Excel Training class – Beginner 2

Beginner

6 hours
Video
Online Classes
Private
Included with this course:
  • 1 year Support
  • Attestation
Emploi Québec
approved
from:From: 999.00$ /pers.
Microsoft Excel Training class - Beginner 1
Microsoft Excel

Microsoft Excel Training class – Beginner 1

Beginner

6 hours
Video
Online Classes
Private
Included with this course:
  • 1 year Support
  • Attestation
Emploi Québec
approved
from:From: 999.00$ /pers.
Formation CAD
Autocad, Autodesk, and Microsoft Office 365 courses. Online classes with live, accredited teachers.
Training center in Laval and Montreal. Tailor-made courses for companies and administrations everywhere in Québec.
Tools
  • Online classroom connection information
  • Microsoft Office Assessment – Get the right training for you
  • Terms and Conditions Formation CAD
Online Courses
  • In-Office Training
  • Microsoft 365 (Office) Courses
    • Microsoft Excel
    • Microsoft Outlook
    • Microsoft PowerPoint
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 2023 © Formation CAD
  • Trainings and Courses
    • Microsoft 365 (Office) Courses
    • Microsoft Outlook
    • Microsoft Excel
    • Microsoft PowerPoint
  • Subsidies
  • About
    • Formation CAD Advantage
  • Contact
  • Login
  • Free assessment
    • Français

Login

Lost your password?