Microsoft Excel 365 - Level 2

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 - Organize sheets in a workbook

• Navigate between the sheets of a workbook
• Rename a sheet
• Group spreadsheets
• Manipulate workbook sheets

Chapter 2 - Perform calculations between worksheets and workbooks

• Create formulas with references to other sheets in the workbook
• Set links between workbooks
• Manage links

Chapter 3 - Use functions

• Enter a function
• Edit a function
• Perform statistical calculations
• Calculate time-based data
• Use logical functions

Chapter 4 - Use reference names in formula

• Create reference names
• Reach a Named Item
• Use Name Manager
• Use a reference name in a formula

Chapter 5 - Create and manage a list of data

• Explore the structure of a list of data
• Create a list of data
• Manipulate the list of data using data table functions

Chapter 6 - Sort a data list

• Identify the items to sort
• Sort a list of data

Chapter 7 – Filter a data list

• Using automatic filters
• Use advanced filters

Objectives

• Create links between worksheet and workbook
• Use statistical, logical, date/time function
• Working properly with a data list

Target Audience
SSC Employees who use Microsoft Excel

Prerequisite(s)
Windows - User or equivalent

Legacy course code: MS365-EI2-SSC