Introduction
Analyze data with maximum efficiency in Excel
(00:55)
Understanding Office versions
(01:29)
1. Work with Excel Files
Navigate Excel and the Ribbon
(04:12)
Create, open, and save a file
(02:37)
Enter text in a workbook
(03:34)
2. Work with Cells and Text
Format text in Excel
(02:54)
Autofill and edit text
(04:35)
Copying and deleting cell data
(04:23)
Change borders and background colors
(04:42)
Merge cells
(01:18)
Find and replace text and values
(04:21)
Work with cell data types
(03:46)
3. Work with Sheets
Rename, insert, and delete a sheet
(02:23)
Move and group sheets
(02:53)
4. Work with Rows and Columns
Adjust column and row height and width
(05:04)
Delete and hide rows and columns
(03:36)
Insert multiple rows and columns
(02:15)
Move and rearrange rows and columns
(03:07)
Freeze columns and rows
(03:54)
5. Work with Formulas and Functions
Build a formula and reference cells
(03:52)
Copy formulas and use AutoSum
(03:29)
Create a formula with XLOOKUP
(04:18)
Split text into two columns
(03:06)
6. Sort and Filter Data
Sort data in Excel
(04:38)
Filter data with a drop-down list
(03:41)
Create a PivotTable to group and summarize data
(05:27)
Use conditional formatting to see trends
(03:45)
Create and work with charts
(05:12)
7. Collaborate and Share
Print a workbook or sheet
(05:28)
Share a workbook or sheet
(02:01)
Protect your file from unwanted changes
(03:56)
Conclusion
Take Excel further
(00:33)
Ex_Files_Excel_2021_EssT_upd.zip
(1.7 MB)