The Start Screen

Microsoft Excel 2021 - Beginner Course

Section 1: Introduction

Section 2: Getting Started in Excel 2021

Launching Excel (3:38)
The Start Screen (10:12)
Exploring the Interface (11:39)
Understanding Ribbons, Tabs and Menus (8:29)
The Backstage Area (4:40)
Customizing the Quick Access Toolbar (9:44)
Useful Keyboard Shortcuts (9:41)
Getting Help (6:36)
Exercise 01 (2:19)

Section 3: Creating You First Excel Spreadsheet

Working with Excel Templates (9:02)
Working with Workbooks and Worksheets (7:34)
Saving Workbooks and Worksheets (8:44)
Entering and Editing Data (9:53)
Navigating and Selecting Cells, Rows and Columns (7:21)
Exercise 02 (5:19)

Section 4: Introduction to Excel Formulas and Functions

Formulas and Functions Explained (11:42)
Performing Calculations with the SUM function (7:38)
Counting Values and Blanks (7:26)
Finding the Average with the AVERAGE function (4:18)
Working with the MIN and MAX functions (2:24)
Handling Errors in Formulas (8:40)
Absolute vs Relative Referencing (6:56)
Autosum and AutoFill (9:41)
Flash Fill (5:02)
Exercise 03 (5:12)

Section 5: Using Named Ranges

What are Named Ranges? (4:41)
Creating Named Ranges (4:25)
Managing Named Ranges (3:49)
Using Named Ranges in Calculations (5:19)
Exercise 04 (4:17)

Section 6: Formatting Numbers and Cells

Applying Number Formats (10:02)
Applying Date and Time Formats (5:39)
Formatting Cells, Rows and Columns (8:38)
Using Format Painter (4:39)
Exercise 05 (4:06)

Section 7: Formatting Worksheets

Working with Rows and Columns (8:25)
Deleting and Clearing Cells (6:25)
Aligning Text and Numbers (11:13)
Applying Themes and Styles (7:41)
Exercise 06 (5:22)

Section 8: Working with Excel Lists

How to Structure a List (4:37)
Sorting a List (Single-Level Sort) (5:06)
Sorting a List (Multi-Level Sort) (5:06)
Sorting Using a Custom List (Custom Sort) (8:12)
Using Autofilter to Filter a List (6:45)
Format as a Table (10:18)
Creating Subtotals in a List (7:34)
Exercise 07 (4:37)

Section 9: Moving and Linking to Data

Using Cut and Copy (4:56)
Paste Options (7:45)
Pasting from the Clipboard (4:31)
Linking to Other Worksheets and Workbooks (6:26)
3D Referencing (5:54)
Inserting Hyperlinks to Worksheets (9:39)
Exercise 08 (4:41)

Section 10: An Introduction to Intermediate Formulas

Looking up Information with VLOOKUP (10:02)
VLOOKUP Approximate Match (5:08)
Error Handling Functions (7:10)
Basic Logical Functions (IF, AND, OR) (12:24)
Making Decisions with IF Statements (4:33)
Cleaning Data using Text Functions (12:09)
Working with Time and Date Functions (11:17)
Exercise 09 (10:19)

Section 11: Analyzing Data with Charts

Section 12: Conditional Formatting

Highlighting Cell Values (7:13)
Data Bars (5:32)
Color Scales (4:55)
Icon Sets (7:49)
Exercise 11 (5:43)

Section 13: Inserting Items into a Spreadsheet

Inserting Pictures (10:53)
Inserting Shapes and Text Boxes (9:04)
Inserting Icons and 3D Models (6:00)
Creating Diagrams Using SmartArt (10:41)
Inserting Screenshots (4:27)
Inserting Comments (5:13)
Exercise 12 (9:15)

Section 14: Working with Views and Zoom

Workbook Views (6:21)
Using Zoom in a Worksheet (2:56)
Arranging Workbooks and Worksheets (5:01)
Freezing Panes (4:00)
Exercise 13 (3:26)

Section 15: Page Layout and Print Options

Setting Margins and Orientation (5:05)
Setting and Clearing the Print Area (2:52)
Inserting Page Breaks (4:32)
Setting Print Titles and a Background (4:29)
Inserting Headers and Footers (5:42)
Printing a Workbook (6:00)
Exercise 14 (3:06)

Section 16: Finalizing the Spreadsheet

Protecting Workbooks and Worksheets (9:02)
Spell Checking (3:45)
Inspecting the Workbook (7:21)
Saving the Workbook in Different Formats (4:21)
Sharing a Workbook (5:35)
Exercise 15 (3:28)

Section 17: Course Close

Your session expired. Please sign in again to continue.

Login