Excel Basic Course Outline

Microsoft®

Excel 2021 Basic

Learn the Excel 2021 basics: Create and format professional-looking spreadsheets; calculate totals, build simple formulas; and more.

excel-2021-basic-courseware

Understand the Excel Screen
Create Workbooks
Navigate Worksheets
Open Workbooks
Save Workbooks
AutoRecover
Quick Access Toolbar
Print
Help
Close & Exit

Select Cells and Ranges
Edit Cell Data
Cut, Copy, and Paste
Undo, Redo, and Repeat
More Paste Options
Insert and Move Cells
Delete Cells
Check Spelling
Find and Replace Text
Hide Columns and Rows
Document Properties

Formula Basics
AutoFill
Sums and Averages
MIN and MAX
COUNT

Format Text
Align and Merge Cells
Format Numbers and Dates
Borders and Background Colours
Copy Formatting
Row Heights and Column Widths

Images
Shapes
Hyperlinks
Object Properties and Alt Text

View Worksheets
Multiple Windows
Move and Copy Worksheets
Insert, Rename and Delete Worksheets
Freeze Rows and Columns
Hide Worksheets and Gridlines

Download
EBQR
Free Cheat Sheet
Handy "cheat sheets" with commonly used shortcuts, tips and tricks.