Excel Essential Training (Microsoft 365) (2025)

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. Plus, learn about accessibility features, how to work with multiple worksheets, build charts and PivotTables, sort and filter data, print in Excel, use Microsoft Copilot with Excel, and more.

Learning objectives
Navigate Excel efficiently.
Create compelling data visualizations using charts.
Implement effective data organization through sorting.
Build and analyze data using PivotTables.

Concepts

Introduction

Getting started with Excel for Microsoft 365

Getting Started with Excel

Excel fundamentals - What can it do
Excel's ribbon menu and the Quick Access Toolbar
Shortcut menus and the mini toolbar
Understanding Excel workbooks and worksheets
Use Excel Help
Excel's accessibility features

Entering Data in Excel

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

Formulas and Functions in Excel

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

Formatting in Excel

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

Adjusting Excel Worksheet Layouts and Data

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

Adjusting Excel Page Layouts and Printing

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

Working with Charts in Excel

Creating charts
Exploring chart types

Adjusting Excel Worksheet Views

Freezing and unfreezing panes
Splitting screens horizontally and vertically

Working with Multiple Excel Worksheets and Workbooks

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

Excel Data Management Features

Sorting data
Using filters
Creating PivotTables

Security and Sharing in Excel

Protecting worksheets and workbooks
Sharing workbooks and tracking changes

Conclusion

Continue your Excel journey