Microsoft Office 365 Excel Essentials Training

By the end of this training course, participants will:
Open and close spreadsheets
Understand the Office 365 web interface, including the home page, the team site, and the shared documents list
Understand the Excel 365 browser interface
Upload a spreadsheet to the Shared Documents library
Differentiate between worksheets, workbooks, rows, columns, and cells
Download and reload workbooks
Use the Find Command
Save a Copy
Open in Editing View
Open the spreadsheet in the Excel desktop application for more advanced features
Understand saving and collaborating
Create a new file
Enter labels and values
Edit data
Use the Wrap Command
Use cut, copy, and paste
Use Undo and redo
Add rows and columns
Delete cells
Understand shortcuts
Build, copy and edit formulas
Use absolute referencing appropriately
Understand the difference between Formulas and Functions
Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN
Understand Autocomplete
Sort and filter data
Collaborate with others on a spreadsheet
Refresh and recalculate data
Format text and numbers
Use alignment options
Apply borders and fill color
Insert and work with Tables
Insert and work with Charts
Insert links