No products in the cart.
Microsoft Excel Training class – Beginner 1
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
Remotely
Public Classes
with Live Teacher
- Online classes with live teacher
- max 10 participants
- Training manual and exercice files provided
- Live Q&As during classes and coaching during practice sessions.
- 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 1
Contact
We'll get back to you within one business day.
Description
Duration:
One day
Prerequisites:
- Knowledge of the Windows environment.
- 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.
- Be able to create spreadsheets using the main tools.
- Use simple formulas.
PROGRAMME
EXCEL ENVIRONMENT
- Know and understand the usefulness of an Excel table
- Create and modify data
- Use a custom list
- Create a series of numbers or dates or texts
- Personalize the Quick Access toolbar and add more commands
- customize the status bar
SELECTION
- Selection effectively: rows, columns, sheets
- Use touch keyboard: CTRL, SHIFT, ALT
CELLS
- Insert: rows, columns, sheets
- Delete: rows, columns, sheets
- Cell size: row height and column width
- Rename sheet
- Move or copy a sheet
DATE STYLE AND FORMATTING
- Font, alignment, number, cell
- Border and data filling
- Format painter
- Cell styles
FORMULAS
- Simple formula: addition, subtraction, multiplication, and division
- Function SUM
- Copy a formula
VIEW
- Workbook views
- Sheet options: Formula bar, gridlines, headings
LAYOUT
- Print preview
- Page setup
Duration
6 hours
Level
Beginner
Prerequisites
- Knowledge of the Windows environment.
- Have access to a computer and to Microsoft Excel (2013, 2016 or OFFICE 365 versions).
Goals
- Master the basics of the Excel environment.
- Be able to create spreadsheets using the main tools.
- Use simple formulas.
Syllabus
EXCEL ENVIRONMENT
- Know and understand the usefulness of an Excel table
- Create and modify data
- Use a custom list
- Create a series of numbers or dates or texts
- Personalize the Quick Access toolbar and add more commands
- customize the status bar
SELECTION
- Selection effectively: rows, columns, sheets
- Use touch keyboard: CTRL, SHIFT, ALT
CELLS
- Insert: rows, columns, sheets
- Delete: rows, columns, sheets
- Cell size: row height and column width
- Rename sheet
- Move or copy a sheet
DATE STYLE AND FORMATTING
- Font, alignment, number, cell
- Border and data filling
- Format painter
- Cell styles
FORMULAS
- Simple formula: addition, subtraction, multiplication, and division
- Function SUM
- Copy a formula
VIEW
- Workbook views
- Sheet options: Formula bar, gridlines, headings
LAYOUT
- Print preview
- Page setup
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: 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.