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

0. Introduction

01 - Getting started with Excel for Microsoft 365
02 - The future of Excel

1. Getting Started with Excel

03 - What is Excel used for
04 - The Ribbon menu and the Quick Access Toolbar
05 - Shortcut menus and the Mini toolbar
06 - Understanding workbooks and worksheets
07 - Use Excel Help

2. Entering Data

08 - Exploring data entry, editing, and AutoFill
09 - Working with dates and times
10 - Using Undo and Redo
11 - Use Save or Save As

3. Formulas and Functions

12 - Using simple formulas
13 - Copying a formula into adjacent cells
14 - Using SUM and AVERAGE
15 - XLOOKUP and lookup functions

4. Formatting

16 - Exploring font styles, borders, and color backgrounds
17 - Applying numeric formats
18 - Adjusting row heights and column widths
19 - Applying numeric formats

5. Adjusting Worksheet Layout and Data

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

6. Adjusting Page Layout and Printing

23 - Page Layout view and commands
24 - Using Page Break Preview and print setup options

7. Charts

25 - Creating charts
26 - Exploring chart types

8. Adjusting Worksheet Views

27 - Freezing and unfreezing panes
28 - Splitting screens horizontally and vertically

9. Multiple Worksheets and Workbooks

29 - Renaming, inserting, and deleting sheets
30 - Moving, copying, and grouping sheets
31 - Opening, closing, and saving workbooks

10. Data Management Features

32 - Sorting data
33 - Using filters
34 - Creating PivotTables

11. Security and Sharing

35 - Protecting worksheets and workbooks
36 - Sharing workbooks and tracking changes

Conclusion

37 - Continuing your Excel journey