Excel Basic to Advanced Training Course

New to Excel? This course gives you a solid foundation in Excel and spreadsheet basics.

Learn to:

Create & edit spreadsheets
Write formulas
Apply formatting
Manage workbooks

Features:

Bite-sized lessons
Learn by doing simulations
Skill assessments
Covers Certiport certification

Skill	Pre-assess	Lesson	Post-assess	Learning mode

Excel Basic to Advanced Outline

Verified Learning

Skill	Pre-assess	Lesson	Post-assess
Excel Fundamentals
Understand the Excel Screen Understand the Excel Screen	Not Started	Not Started	Not Started
Create Workbooks How to create blank & template-based workbooks in Excel	Not Started	Not Started	Not Started
Navigate Worksheets How to Navigate Worksheets in Excel	Not Started	Not Started	Not Started
Open Workbooks How to Open Workbooks in Excel	Not Started	Not Started	Not Started
Save Workbooks How to Save Workbooks in Excel	Not Started	Not Started	Not Started
AutoRecover How to AutoRecover Excel Files	Not Started	Not Started	Not Started
The Quick Access Toolbar How to Use The Quick Access Toolbar in Excel	Not Started	Not Started	Not Started
Print How to Print in Excel	Not Started	Not Started	Not Started
Help How to Get Help in Excel	Not Started	Not Started	Not Started
Close and Exit How to Close and Exit from Excel	Not Started	Not Started	Not Started

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Edit a Workbook			Account Required
Select Cells and Ranges How to Select Cells and Ranges in Excel
Edit Cell Data How to Edit Cell Data in Excel
Cut, Copy, and Paste How to Cut, Copy, and Paste in Excel
Undo, Redo, Repeat How to Use Undo, Redo, Repeat Commands in Excel
More Pasting Options How to Use Special Paste Options in Excel
Insert and Move Cells How to Insert and Move Cells in Excel
Delete Cells How to Delete Cells in Excel
Check Spelling Learn how you use Excel's spell check to proof your worksheets for spelling errors.
Find and Replace Text How to Use Find and Replace in Excel
Hide Columns and Rows How to Hide Columns and Rows in Excel
Document Properties How to View and Edit Document Properties in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Basic Formulas			Account Required
Formula Basics How to Create Basic Formulas in Excel
AutoFill How to Use AutoFill in Excel
Sums and Averages How to Use Sum and Average Formulas in Excel
MIN and MAX How to Use MIN and MAX Functions in Microsoft Excel
COUNT How to Use the COUNT Function in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Basic Formatting			Account Required
Format Text How to Apply Formatting to Text in Excel
Align and Merge Cells To merge cells in Excel, select the cells you want to merge, click the Merge list arrow and select a merge option.
Format Numbers and Dates How to Format Numbers and Dates in Excel
Borders and Background Colors How to Add Cell Borders and Background Colors in Excel
Copy Formatting How to Copy Formatting in Excel
Row Heights and Column Widths How to Adjust Row Heights and Column Widths in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Insert Objects			Account Required
Images How to Insert Images in Excel
Shapes How to Insert and Format Shapes in Excel
Hyperlinks How to Insert Hyperlinks in Excel
Object Properties and Alt Text How to Adjust Object Properties and Alt Text in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Manage Worksheets			Account Required
View Worksheets How to Change Worksheet Views in Excel
Multiple Windows How to Work with Multiple Windows in Excel
Move and Copy Worksheets How to Move and Copy Worksheets in Excel
Insert, Rename, and Delete Worksheets How to Insert, Rename, and Delete Worksheets in Excel
Freeze Rows and Columns How to Freeze and Unfreeze Rows and Columns in Excel
Hide Worksheets and Gridlines How to Hide Worksheets and Gridlines in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Charts			Account Required
Create Charts How to Create Charts in Excel
Move and Resize How to Move and Resize a Chart in Excel
Chart Types How to Change Chart Types in Excel
Layout and Style How to Apply Chart Layouts and Styles in Excel
Titles and Legends How to Customize Chart Titles and Legends in Excel
Gridlines, Labels, and Data Tables How to Display Chart Gridlines, Labels, and Data Tables in Excel
Chart Elements How to Format Chart Data in Excel
Modify Chart Data How to Modify Chart Data in Excel
Filter Charts How to Filter Charts in Excel
Trendlines How to Add Trendlines in Excel
Dual-Axis Charts How to Create Dual-Axis Charts in Excel
Chart Templates How to Create Chart Templates in Excel
Sparklines How to Add Sparklines in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Print and Distribute			Account Required
Page Size and Scale How to Adjust Page Size and Scale in Excel
Print Area and Page Breaks How to Set Print Area and Page Breaks in Excel
Print Titles, Gridlines, and Headings How to Print Titles, Gridlines, and Headings in Excel
Headers and Footers How to Add Headers and Footers in Excel
Margins and Orientation How to Adjust Margins and Orientation in Excel
Inspect for Issues How to Inspect for Issues in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Intermediate Formulas			Account Required
Reference External Worksheets How to Reference External Worksheets in Excel
Absolute and Relative References How to use Absolute and Relative Cell References in Excel
Order of Operations Order of Operations in Excel
Cell and Range Names How to Add Cell and Range Names in Excel
Insert Functions How to Insert Functions in Excel
CONCAT Function How to use the Concatenate Text Function in Excel
PMT and NPER Functions How to Use the PMT Function in Excel
Display Formulas How to Display Formulas in Excel
Date Formulas How to Use Date Formulas in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Manage Data			Account Required
Quick Analysis The Quick Analysis tool helps you quickly format your data into a chart, table, or sparkline.
Data Validation How to Use Data Validation Rules in Excel
Outline and Subtotal How to Use the Outline and Subtotal Features in Excel
Flash Fill How to Use Flash Fill in Excel
Import and Export Data How to Import and Export Excel Data

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Tables			Account Required
Insert a Table How to Insert a Table in Excel
Sort Data How to Sort Data in Excel
Add Rows and Columns How to Add Rows and Columns to Excel Tables
Table Styles How to Apply Table Styles in Excel
Remove Duplicates How to Remove Duplicates in Excel
Slicers How to Use Slicers in Excel
Structured References How to Use Structured References in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Intermediate Formatting			Account Required
Apply Conditional Formatting How to Apply Conditional Formatting in Excel
Apply and Remove Cell Styles How to Apply and Remove Cell Styles in Excel
Create and Modify Cell Styles How to Create and Modify Cell Styles in Excel
Find and Replace Formatting How to Find and Replace Formatting in Excel
Apply a Theme How to Apply a Theme in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Collaboration			Account Required
Cell Comments How to Add, Edit, and Delete Cell Comments in Excel
Share Workbooks How to Share Workbooks in Excel
Co-author Workbooks How to Co-author Workbooks in Excel
Protect a Worksheet How to Protect a Worksheet in Excel
Protect Workbook Structure How to Protect a Workbook's Structure in Excel
Password Protection How to Add Password Protection in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
PivotTables			Account Required
Create PivotTables How to Create PivotTables in Excel
Add Multiple PivotTable Fields How to Add Multiple PivotTable Fields to a PivotTable in Excel
Change a PivotTable's Calculation How to Change a PivotTable's Calculation in Excel
Add Calculated Fields How to Add and Remove Calculated Fields in Excel PivotTables
The GETPIVOTDATA Function How to Use the GETPIVOTDATA Function in Excel
Filter PivotTables How to Filter PivotTables in Excel
Timelines How to Add a Timeline in Excel
PivotTable Layout Adjust a PivotTable's Layout in Excel
Group Values How to Group Values in Excel
Refresh a PivotTable How to Refresh a PivotTable in Excel
Format a PivotTable How to Format a PivotTable in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
PivotCharts			Account Required
Create PivotCharts How to Create PivotCharts in Excel
PivotChart Options PivotChart Options in Excel
PivotChart Styles How to Apply PivotChart Styles in Excel
Drill-Down Data How to Drill-Down Chart Data in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Troubleshoot Formulas			Account Required
Formula Errors How to Fix Formula Errors in Excel
The Watch Window How to The Watch Window in Excel
Evaluate Formulas How to Evaluate Formulas in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Advanced Formatting			Account Required
Customize Conditional Formatting How to Customize Conditional Formatting in Excel
Conditional Formatting with Formulas How to Use Conditional Formatting with Formulas in Excel
Manage Conditional Formatting How to Manage Conditional Formatting in Excel
International Currency and Formats How to Use International Currency and Formats in Excel
Body and Heading Options How to Apply Body and Heading Font Options in Excel
Color Formats How to Create and Apply Color Schemes in Excel
Custom Themes How to Create and Apply Custom Themes in Excel
Form Controls How to Form Controls in Excel
Save Form Templates How to Save a Form as a Template in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Advanced Formulas			Account Required
IF Function How to Use the IF Function in Excel
Nested Functions How to Insert Nested Functions in Excel
AND, OR, and NOT Functions How to use AND, OR, and NOT Functions in Excel
SUMIF, AVERAGEIF, and COUNTIF Functions How to Use SUMIF, AVERAGEIF, and COUNTIF Functions in Excel
VLOOKUP How to Use the VLOOKUP Function in Excel
HLOOKUP How to Use HLOOKUP in Excel
INDEX and MATCH How to Use the INDEX and MATCH Functions in Excel
UPPER, LOWER, and PROPER How to Use UPPER, LOWER, and PROPER Functions in Excel
RIGHT, LEFT, and MID How to Use RIGHT, LEFT, and MID Functions in Excel
Formula Calculation Options How to Change Formula Calculation Options in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Analyze Data			Account Required
Goal Seek How to use Goal Seek feature in Excel
Scenario Manager How Use to Scenario Manager in Excel
Consolidate Data How to Consolidate Data in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Macros			Account Required
Enable Macros How to Enable Macros in Excel
Create Macros How to Create Macros in Excel
Modify Macros How to Modify Macros in Excel
Copy Macros How to Copy Macros in Excel

Student Downloads

Get a Completion Certificate

Share your certificate with prospective employers and your professional network.

Certificate of Verified Skills

Your Name

For verified skills in: Excel Basic to Advanced

Issued on November 06, 2025

Excel Basic to Advanced

Try this Course with a Free Trial

Excel Basic to Advanced

Get a Completion Certificate

Certificate of Verified Skills

Master Excel Basic to Advanced Skills

Excel Basic to Advanced

Try this Course with a Free Trial

Excel Basic to Advanced

Get a Completion Certificate

Certificate of Verified Skills

Master Excel Basic to Advanced Skills

Free Evaluation