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 - Intermediate

Microsoft Excel Training class – Intermediate

Private Course
Microsoft Excel Training class - Intermediate

Emploi Québec

Microsoft Excel Training class - Intermediate

from:From: 999.00$ /pers.

Intermediate

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 – Intermediate

No public classes scheduled :

Ask for a private class
/ /

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 – Intermediate

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: Intermediate

Microsoft

REQUIRED LEVEL:

Basic knowledge of Excel’s functions.

DURATION:

1 day

OBJECTIVES:

– Easily manage databases.
– Work with multiple sheets or workbooks.
– Sort and create complex filters.
– Add conditional formatting, drop-down lists and graphics.

PROGRAM:

REVIEW OF THE BEGINNER COURSE

  • Review on simple formulas: (Statistics: Average, COUNT, COUNTA, MAX, MIN)
  • Freeze the panes and titles for printing
  • Absolute and relative references
  • Copy a formula effectively

CHART

  • Create a chart
  • Modify data
  • Arrangement and formatting of a chart
  • Sparkline chart

CONDITIONAL FORMATTING

  • Create a simple formatting
  • Icon set, color scheme
  • Manage conditions

MULTI-SHEET

  • Group and dissociate sheets
  • Multi-sheet operations
  • Operation from one sheet to another with link
  • Identical formatting for some or all sheets
  • View multiple sheets of the same workbook
  • Hide, un-hide a sheet
  • Change the color of a sheet
  • Consolidation
  • Protect a sheet

MANAGING A DATABASE

SORT AND FILTER

  • Personalized sorting
  • Sort by font color, filling and icon sets
  • Simple filter
  • Custom filter
  • Advanced filter

SUBTOTALS

  • With one or more functions
  • On one or more columns

CUSTOM DISPLAYS

  • Set a view (Repetitive)

REMOVING DUPLICATES
CONVERTING DATA

DATA VALIDATION

  • Create validation
  • Error message

NAME MANAGER

  • Set a name
  • Change or delete a name

 

Formation CAD

Tél. : (514) 316-6824

Courriel : [email protected]

Web : www.formation-cad.com

Duration
6 hours
Level

Intermediate

Prerequisites

Basic knowledge of Excel’s functions.

Goals

Easily manage databases.
– Work with multiple sheets or workbooks.
– Sort and create complex filters.
– Add conditional formatting, drop-down lists and graphics.

Syllabus

REVIEW OF THE BEGINNER COURSE

  • Review on simple formulas: (Statistics: Average, COUNT, COUNTA, MAX, MIN)
  • Freeze the panes and titles for printing
  • Absolute and relative references
  • Copy a formula effectively

CHART

  • Create a chart
  • Modify data
  • Arrangement and formatting of a chart
  • Sparkline chart

CONDITIONAL FORMATTING

  • Create a simple formatting
  • Icon set, color scheme
  • Manage conditions

MULTI-SHEET

  • Group and dissociate sheets
  • Multi-sheet operations
  • Operation from one sheet to another with link
  • Identical formatting for some or all sheets
  • View multiple sheets of the same workbook
  • Hide, un-hide a sheet
  • Change the color of a sheet
  • Consolidation
  • Protect a sheet

MANAGING A DATABASE

SORT AND FILTER

  • Personalized sorting
  • Sort by font color, filling and icon sets
  • Simple filter
  • Custom filter
  • Advanced filter

SUBTOTALS

  • With one or more functions
  • On one or more columns

CUSTOM DISPLAYS

  • Set a view (Repetitive)

REMOVING DUPLICATES
CONVERTING DATA

DATA VALIDATION

  • Create validation
  • Error message

NAME MANAGER

  • Set a name
  • Change or delete a name

 

Downloadable PDF Syllabus

Excel Intermediate - 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 - Intermediate
Microsoft Excel Training class - Intermediate

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?