Excel Essential Training (Microsoft 365) (2022)

Course details

Get up to speed with Microsoft Excel, the world's most popular spreadsheet program. Follow along with Excel expert Dennis Taylor as he demonstrates how to efficiently manage and analyze data with this powerful program. Learn how to enter and organize data, perform calculations with simple functions, and format the appearance of rows, columns, cells, and data. Other lessons cover how to work with multiple worksheets, build charts and PivotTables, sort and filter data, use the printing capabilities of Excel, and more.

Concepts

Introduction

Getting started with Excel for Microsoft 365
The future of Excel

Getting Started with Excel

What is Excel used for
The Ribbon menu and the Quick Access Toolbar
Shortcut menus and the Mini toolbar
Understanding workbooks and worksheets
Use Excel Help

Entering Data

Exploring data entry, editing, and AutoFill
Working with dates and times
Using Undo and Redo
Use Save or Save As

Formulas and Functions

Using simple formulas
Copying a formula into adjacent cells
Using SUM and AVERAGE
XLOOKUP and lookup functions

Formatting

Exploring font styles, borders, and color backgrounds
Applying numeric formats
Adjusting row heights and column widths
Applying numeric formats

Adjusting Worksheet Layout and Data

Rows and columns - Insert, delete, hide, and unhide
Moving, copying, and inserting data
Finding and replacing data

Adjusting Page Layout and Printing

Page Layout view and commands
Using Page Break Preview and print setup options

Charts

Creating charts
Exploring chart types

Adjusting Worksheet Views

Freezing and unfreezing panes
Splitting screens horizontally and vertically

Multiple Worksheets and Workbooks

Renaming, inserting, and deleting sheets
Moving, copying, and grouping sheets
Opening, closing, and saving workbooks

Data Management Features

Sorting data
Using filters
Creating PivotTables

Security and Sharing

Protecting worksheets and workbooks
Sharing workbooks and tracking changes

Conclusion

Continuing your Excel journey