Excel 2021 Essential Training (Office 2021/LTSC)

Course details

Excel, the popular spreadsheet program from Microsoft, is an essential tool for many professional roles. In this course, Jess Stratton shows you the ins and outs of the 2021 release. Jess begins with how to navigate Excel and how to create, open, and save a file. Next, she shows you how to enter, format, autofill, and edit text, as well as how to copy and delete cell data, merge cells, and more. Jess explains how to work with sheets, then dives into the myriad adjustments and customizations you can apply to rows and columns. Formulas are at the heart of Excel’s ability to perform text or number calculations, so Jess concludes by walking you through formulas and functions, including AutoSum and the very useful XLOOKUP.

Concepts

0. Introduction

01 - Analyze data with maximum efficiency in Excel
02 - Understanding Office versions

1. Work with Excel Files

03 - Navigate Excel and the Ribbon
04 - Create, open, and save a file
05 - Enter text in a workbook

2. Work with Cells and Text

06 - Format text in Excel
07 - Autofill and edit text
08 - Copying and deleting cell data
09 - Change borders and background colors
10 - Merge cells
11 - Find and replace text and values
12 - Work with cell data types

3. Work with Sheets

13 - Rename, insert, and delete a sheet
14 - Move and group sheets

4. Work with Rows and Columns

15 - Adjust column and row height and width
16 - Delete and hide rows and columns
17 - Insert multiple rows and columns
18 - Move and rearrange rows and columns
19 - Freeze columns and rows

5. Work with Formulas and Functions

20 - Build a formula and reference cells
21 - Copy formulas and use AutoSum
22 - Create a formula with XLOOKUP
23 - Split text into two columns

6. Sort and Filter Data

24 - Sort data in Excel
25 - Filter data with a drop-down list
26 - Create a PivotTable to group and summarize data
27 - Use conditional formatting to see trends
28 - Create and work with charts

7. Collaborate and Share

29 - Print a workbook or sheet
30 - Share a workbook or sheet
31 - Protect your file from unwanted changes

Conclusion

32 - Take Excel further