Microsoft Excel Online Essentials

This course has been superseded

We suggest the following instead:
Microsoft Excel 365 Intermediate

Course Description

This course is intended to help users get up to speed quickly with Excel Online, part of Microsoft's Office 365.
1 Day
Contact us for pricing
 

Prerequisites

Familiarity with Windows, Files & Folders.

Getting Started with Excel Online

Logging into Office 365
Getting to Know Excel
Managing Workbooks
Getting Help in Excel Online
Using Tell Me

Working with Data

A Closer Look at Formulas
Using Formulas and Functions
Working with Data
Working with Rows and Columns
Sorting and Filtering Data

Formatting a Worksheet

Formatting Text
Formatting Cells
Aligning Cell Content
Using Find & Select Tools
Applying Conditional Formatting

Adding Pictures and Shapes

Inserting Pictures
Inserting Shapes
Inserting Shapes
Formatting Shapes

Organizing Worksheet Data with Tables and Charts

Inserting Tables
Inserting Charts
Modifying Charts

Using Pivot Tables

Inserting Pivot Tables
Working with Pivot Table Data
Sorting and Filtering Pivot Table Data

Finalizing Workbooks

Using Comments
Viewing Worksheets
Inserting, Deleting & Duplicating Worksheets
Worksheet References in Formulas
Hiding and Unhiding Worksheets
Reordering Worksheets
Renaming Worksheet Tabs
Changing View Options
MS OfficeMicrosoft OfficeOffice 365ExcelExcel OnlineMicrosoft ExcelExcel 2021Microsoft Excel 2021