Excel 2021 Essential Training

(Office 2021 - LTSC)

Video Lessons

Was: $35

Deal Price: $15

You Save: $20

About this Course

Excel, the popular spreadsheet program from Microsoft, is an essential tool for many professional roles. In this course, expert shows you the ins and outs of the 2021 release. Expert begins with how to navigate Excel and how to create, open, and save a file, and shows you how to enter, format, autofill, and edit text, as well as how to copy and delete cell data, merge cells, and more.

Expert 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 instructor concludes by walking you through formulas and functions, including AutoSum and the very useful XLOOKUP.

 

Contents

 

Introduction
Analyze data with maximum efficiency in Excel
55s
Understanding Office versions
1m 29s


1. Work with Excel Files
Navigate Excel and the Ribbon
4m 12s
Create, open, and save a file
2m 37s
Enter text in a workbook
3m 34s


2. Work with Cells and Text
Format text in Excel
2m 54s
Autofill and edit text
4m 35s
Copying and deleting cell data
4m 23s
Change borders and background colors
4m 42s
Merge cells
1m 18s
Find and replace text and values
4m 21s
Work with cell data types
3m 46s


3. Work with Sheets
Rename, insert, and delete a sheet
2m 23s
Move and group sheets
2m 53s


4. Work with Rows and Columns
Adjust column and row height and width
5m 4s
Delete and hide rows and columns
3m 36s
Insert multiple rows and columns
2m 15s
Move and rearrange rows and columns
3m 7s
Freeze columns and rows
3m 54s


5. Work with Formulas and Functions
Build a formula and reference cells
3m 52s
Copy formulas and use AutoSum
3m 29s
Create a formula with XLOOKUP
4m 18s
Split text into two columns
3m 6s


6. Sort and Filter Data
Sort data in Excel
4m 38s
Filter data with a drop-down list
3m 41s
Create a PivotTable to group and summarize data
5m 27s
Use conditional formatting to see trends
3m 45s
Create and work with charts
5m 12s


7. Collaborate and Share
Print a workbook or sheet
5m 28s
Share a workbook or sheet
2m 1s
Protect your file from unwanted changes
3m 56s

1. Language: English. 

2. Secure download. 

    Video file format: MP4.

3. Learn anywhere. Switch between

    your computer, tablet, or TV.  

4. Practice while you learn

    with exercise files.  

5. Secure payment by PayPal.

6. 30 days refund.

7. No subscription needed.

8. Lifetime access.

9. This course without a sponsored ads.

 

Watch. Listen. Practice. Learn.