Excel Course: Build Essential Beginner Spreadsheet Skills

Skill	Pre-assess	Lesson	Post-assess	Learning mode

Excel Basic Course Outline

Verified Learning

Skill	Pre-assess	Lesson	Post-assess
Excel Fundamentals
Understand the Excel Screen Find tools fast with the Excel ribbon	Not Started	Not Started	Not Started
Create Workbooks Start a blank workbook in Excel	Not Started	Not Started	Not Started
Navigate Worksheets Move between sheets in Excel quickly	Not Started	Not Started	Not Started
Open Workbooks Launch files from Recent or Browse in Excel	Not Started	Not Started	Not Started
Save Workbooks Quick steps to save your work in Excel	Not Started	Not Started	Not Started
AutoRecover Restore your in-progress spreadsheet easily	Not Started	Not Started	Not Started
The Quick Access Toolbar Add shortcuts with the Quick Access Toolbar	Not Started	Not Started	Not Started
Print Control what prints by setting print area	Not Started	Not Started	Not Started
Help Get quick Excel help when you need it	Not Started	Not Started	Not Started
Close and Exit Close workbooks fast and wrap up your session	Not Started	Not Started	Not Started

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Edit a Workbook			Account Required
Select Cells and Ranges Highlight multiple areas with shortcuts
Edit Cell Data Quick ways to edit cells in Excel
Cut, Copy, and Paste Master cut copy paste shortcuts in Excel
Undo, Redo, Repeat Fix mistakes fast with undo and redo
More Pasting Options Paste Special Excel values and formats
Insert and Move Cells Learn how to move cells in excel easily
Delete Cells Delete cells in Excel while keeping sheets tidy
Check Spelling Catch errors quickly with Excel spell check
Find and Replace Text Find and replace text in Excel quickly
Hide Columns and Rows Hide and reveal rows and columns in Excel
Document Properties Update Excel document properties to stay organized

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Basic Formulas			Account Required
Formula Basics Essential Excel formulas for beginners
AutoFill Copy Excel patterns or series instantly
Sums and Averages Apply Excel's SUM formula for fast totals
MIN and MAX Find smallest and largest in Excel
COUNT Count the values you need with a simple formula

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Basic Formatting			Account Required
Format Text Format text cleanly with excel text tools
Align and Merge Cells Excel center text and merge cells
Format Numbers and Dates Quickly apply date and number formats for clarity
Borders and Background Colors Make cells pop with crisp borders and fills
Copy Formatting Copy a cell’s look and apply it in one click
Row Heights and Column Widths Quickly resize rows and columns with AutoFit

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Insert Objects			Account Required
Images Learn how to insert a picture in Excel
Shapes Use shapes to enhance your worksheets
Hyperlinks Add hyperlinks in Excel for easy navigation
Object Properties and Alt Text Set Excel object properties and alt text

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Manage Worksheets			Account Required
View Worksheets Zoom in and out to view Excel sheets
Multiple Windows Work in two windows of the same workbook
Move and Copy Worksheets Quickly copy or move sheets in Excel
Insert, Rename, and Delete Worksheets Quickly add, rename, or delete Excel sheets
Freeze Rows and Columns Freeze Excel rows and columns to stay oriented
Hide Worksheets and Gridlines Remove gridlines and hide sheets in Excel

Student Downloads

Concise, easy-to-use guide for quick learning and reference.

Step-by-step illustrated reference guide.

Practice files for hands-on exercises.

Instructor Downloads

Lesson plans, instructions, and tips for delivering great classes.

Get a Completion Certificate

Share your certificate with prospective employers and your professional network.

Your Name

For verified skills in: Excel Basic

Issued on December 04, 2025