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 - Beginner 2

Microsoft Excel Training class – Beginner 2

Private Course
Microsoft Excel Training class - Beginner 2

Emploi Québec

Microsoft Excel Training class - Beginner 2

from:From: 999.00$ /pers.

Beginner

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 – Beginner 2

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 – Beginner 2

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

Duration:

One day

Prerequisites:

  • Knowledge of the Windows environment.
  • Have completed the Beginner 1 course or have equivalent knowledge.
  • Have access to a computer and to Microsoft Excel (2013, 2016 or OFFICE 365 versions).

Certificate:

Yes

Educational resources:

  • Online training
  • Demonstration
  • Training support included

Skills acquired at the end of the training:

  • Master the basics of the Excel environment.

PROGRAMME

EXCEL ENVIRONMENT

  • Create PDF
  • Share a workbook and/or a sheet

SEARCH FOR DATA

  • Search in a sheet, workbook and formulas
  • Find and replace

DATE STYLE AND FORMATTING

  • Open cell format cells box for more functions: Font, alignment and number settings
  • Format as table
  • Cell styles

FORMULA

  • Simple statistics: average, minimum, maximum and count
  • Absolute and relative references
  • Date: today, now

NOTES

  • Insert, edit, modify and delete a note
  • Print a note

PAGE LAYOUT

  • Set up printing of a large table
  • Print area and page break
  • Print titles

VIEW

  • Freeze panes
  • Normal view, formatting and preview of page breaks
  • Hide/Show rows, columns or a sheet

EXPORTING DATA

  • Create a table or chart and copy them into a WORD document with or without a link

MANAGING A DATA LIST

  • Sorting data
  • Simple data extraction: (Numerical, chronological and textual filters)

 

Duration
6 hours
Level

Beginner

Prerequisites
  • Knowledge of the Windows environment.
  • Have completed the Beginner 1 course or have equivalent knowledge.
  • Have access to a computer and to Microsoft Excel (2013, 2016 or OFFICE 365 versions).

Goals
  • Master the basics of the Excel environment.
Syllabus

EXCEL ENVIRONMENT

  • Create PDF
  • Share a workbook and/or a sheet

SEARCH FOR DATA

  • Search in a sheet, workbook and formulas
  • Find and replace

DATE STYLE AND FORMATTING

  • Open cell format cells box for more functions: Font, alignment and number settings
  • Format as table
  • Cell styles

FORMULA

  • Simple statistics: average, minimum, maximum and count
  • Absolute and relative references
  • Date: today, now

NOTES

  • Insert, edit, modify and delete a note
  • Print a note

PAGE LAYOUT

  • Set up printing of a large table
  • Print area and page break
  • Print titles

VIEW

  • Freeze panes
  • Normal view, formatting and preview of page breaks
  • Hide/Show rows, columns or a sheet

EXPORTING DATA

  • Create a table or chart and copy them into a WORD document with or without a link

MANAGING A DATA LIST

  • Sorting data
  • Simple data extraction: (Numerical, chronological and textual filters)

 

Downloadable PDF Syllabus

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

Related courses

Formations apparentées

Microsoft Excel Training class - Complete
Microsoft Excel

Microsoft Excel Training class – Complete

Beginner to Advanced

24 hours
Video
Online Classes
Private
Included with this course:
  • 1 year Support
  • Attestation
Emploi Québec
approved
from:799.99$ 599.99$ /pers.
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 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?