Microsoft Excel 365 - Basic - Level 1

Overview

Delivery method

Virtual classroom

Duration

7 hours (2 half days)

Audience

All SSC employees at all levels

Description

Notice: SSC incurs expenses for the Microsoft sessions regardless of attendance. Please be mindful and committed to your registration. If your plans change, please cancel 12 business days prior to the course start date.

Introduction – Excel in the M365 environment

• The different ways of accessing Excel in the M365 ecosystem
• Via Teams
• Via SharePoint
• Teams vs browser vs desktop application
• Recommended best practices

 Chapter 1 - Identify interface elements

• Identify components of the environment
• Identify the specific elements of Excel
• Access commands
• Get help
• The File tab and Backstage view mode
• Start screen, templates, navigation, cloud

Chapter 2 - Open and manipulate a workbook

• Open a workbook
• Adapt the on-screen display as needed
• Navigate in a sheet
• Select cells
• Freeze titles

Chapter 3 - Create a workbook and enter data

• Create and save a workbook
• Recognize the types of data
• Enter data into a sheet
• Use the fill handle to enter a series of data
• Save a workbook
• Close a workbook and exit Excel
• Cancel or restore the last operations
• The cloud and models, choice of sharing, instant fill

Chapter 4 - Manipulate columns, rows or cells

• Modify the size of columns and rows
• Insert columns and rows
• Remove columns and rows
• Hide columns and rows

Chapter 5 – Performing calculations

• Identify formula features
• Enter a formula
• Add cells using the Sum button
• Use the function assistant
• Copy formulas
• Use relative, absolute, or mixed references

Chapter 6 - Manipulate and search data

• Copy and move data
• Search or replace data

Chapter 7 – Format data

• Apply formats
• Set the font
• Align, merge cells, and apply indents
• Set numeric formats
• Apply borders and fill colour
• Manipulate formats
• Quick analysis and conditional formatting

Chapter 8 – Layout and print workbook data

• Set display mode
• Set layout
• Insert page breaks
• Set a print area
• View page breaks and print areas
• Print descriptive titles
• Use scaling and printing options
• Print spreadsheets

Objectives

• Acquire essential knowledge to create simple tables with Excel
• Use basic formulas to execute simple calculations

Target Audience
SSC Employees who use Microsoft Excel

Prerequisite(s)
Windows - User or equivalent

Legacy course code: MS365-EB1-SSC