Microsoft Excel Training class – Beginner 2
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 – Beginner 2
Microsoft Excel Training class – Beginner 2
from:From: 999.00$ /pers.
Demander une formation privée
Contact
We'll get back to you within one business day.
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)
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:799.99$ 599.99$ /pers.
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.