Microsoft Excel Training

Free Excel Training and Excel Cheat Sheet

Free Microsoft Excel Training resources to use and share with our compliments!

Interactive eLearning
Learn by doing—not watching—with interactive simulations that give students hands-on experience of using real software!
Step-by-step Courseware
Fully illustrated, simple to follow lessons.
Free Quick References
Free to download and distribute with our compliments!
Spanish Versions
Click here to view this course in Spanish.

Share with staff, students, parents—anyone who wants to learn Excel!

What you'll learn:

Master Microsoft Excel basic, intermediate, and advanced skills
Format cells and cell ranges to create professional-looking spreadsheets
Build formulas to calculate SUM, COUNT, AVERAGE, MIN, and MAX
Design beautiful bar charts, pie charts, graphs, and reports
Use PivotTables & PivotCharts to summarize large amounts of data
Understand SUMIF, VLOOKUP, HLOOKUP, MATCH, and INDEX functions
Add conditional formatting to highlight data that meets your criteria
Record macros and use VBA to automate repetitive tasks

Microsoft Excel Training	Copy these free tutorials to use in your own lesson plans:
Excel Fundamentals
Understand the Excel Screen Understand the Excel Screen		Copy Link
Create Workbooks How to create blank & template-based workbooks in Excel		Copy Link
Navigate Worksheets How to Navigate Worksheets in Excel		Copy Link
Open Workbooks How to Open Workbooks in Excel		Copy Link
Save Workbooks How to Save Workbooks in Excel		Copy Link
AutoRecover How to AutoRecover Excel Files		Copy Link
The Quick Access Toolbar How to Use The Quick Access Toolbar in Excel		Copy Link
Print How to Print in Excel		Copy Link
Edit a Workbook
Select Cells and Ranges How to Select Cells and Ranges in Excel		Copy Link
Cut, Copy, and Paste How to Cut, Copy, and Paste in Excel		Copy Link
Undo, Redo, Repeat How to Use Undo, Redo, Repeat Commands in Excel		Copy Link
More Pasting Options How to Use Special Paste Options in Excel		Copy Link
Insert and Move Cells How to Insert and Move Cells in Excel		Copy Link
Delete Cells How to Delete Cells in Excel		Copy Link
Check Spelling Learn how you use Excel's spell check to proof your worksheets for spelling errors.		Copy Link
Find and Replace Text How to Use Find and Replace in Excel		Copy Link
Hide Columns and Rows How to Hide Columns and Rows in Excel		Copy Link
Basic Formulas
Formula Basics How to Create Basic Formulas in Excel		Copy Link
AutoFill How to Use AutoFill in Excel		Copy Link
Sums and Averages How to Use Sum and Average Formulas in Excel		Copy Link
MIN and MAX How to Use MIN and MAX Functions in Microsoft Excel		Copy Link
COUNT How to Use the COUNT Function in Excel		Copy Link
Basic Formatting
Format Text How to Apply Formatting to Text in Excel		Copy Link
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.		Copy Link
Format Numbers and Dates How to Format Numbers and Dates in Excel		Copy Link
Borders and Background Colors How to Add Cell Borders and Background Colors in Excel		Copy Link
Copy Formatting How to Copy Formatting in Excel		Copy Link
Row Heights and Column Widths How to Adjust Row Heights and Column Widths in Excel		Copy Link
Insert Objects
Images How to Insert Images in Excel		Copy Link
Hyperlinks How to Insert Hyperlinks in Excel		Copy Link
Manage Worksheets
View Worksheets How to Change Worksheet Views in Excel		Copy Link
Move and Copy Worksheets How to Move and Copy Worksheets in Excel		Copy Link
Insert, Rename, and Delete Worksheets How to Insert, Rename, and Delete Worksheets in Excel		Copy Link
Freeze Rows and Columns How to Freeze and Unfreeze Rows and Columns in Excel		Copy Link
Hide Worksheets and Gridlines How to Hide Worksheets and Gridlines in Excel		Copy Link
Charts
Move and Resize How to Move and Resize a Chart in Excel		Copy Link
Chart Types How to Change Chart Types in Excel		Copy Link
Layout and Style How to Apply Chart Layouts and Styles in Excel		Copy Link
Titles and Legends How to Customize Chart Titles and Legends in Excel		Copy Link
Gridlines, Labels, and Data Tables How to Display Chart Gridlines, Labels, and Data Tables in Excel		Copy Link
Chart Elements How to Format Chart Data in Excel		Copy Link
Modify Chart Data How to Modify Chart Data in Excel		Copy Link
Trendlines How to Add Trendlines in Excel		Copy Link
Dual-Axis Charts How to Create Dual-Axis Charts in Excel		Copy Link
Chart Templates How to Create Chart Templates in Excel		Copy Link
Sparklines How to Add Sparklines in Excel		Copy Link
Print and Distribute
Page Size and Scale How to Adjust Page Size and Scale in Excel		Copy Link
Print Area and Page Breaks How to Set Print Area and Page Breaks in Excel		Copy Link
Print Titles, Gridlines, and Headings How to Print Titles, Gridlines, and Headings in Excel		Copy Link
Headers and Footers How to Add Headers and Footers in Excel		Copy Link
Intermediate Formulas
Reference External Worksheets How to Reference External Worksheets in Excel		Copy Link
Absolute and Relative References How to use Absolute and Relative Cell References in Excel		Copy Link
Order of Operations Order of Operations in Excel		Copy Link
Cell and Range Names How to Add Cell and Range Names in Excel		Copy Link
Insert Functions How to Insert Functions in Excel		Copy Link
CONCAT Function How to use the Concatenate Text Function in Excel		Copy Link
PMT and NPER Functions How to Use the PMT Function in Excel		Copy Link
Display Formulas How to Display Formulas in Excel		Copy Link
Date Formulas How to Use Date Formulas in Excel		Copy Link
Manage Data
Quick Analysis The Quick Analysis tool helps you quickly format your data into a chart, table, or sparkline.		Copy Link
Outline and Subtotal How to Use the Outline and Subtotal Features in Excel		Copy Link
Data Validation How to Use Data Validation Rules in Excel		Copy Link
Flash Fill How to Use Flash Fill in Excel		Copy Link
Import and Export Data How to Import and Export Excel Data		Copy Link
Tables
Insert a Table How to Insert a Table in Excel		Copy Link
Sort Data How to Sort Data in Excel		Copy Link
Filter Data How to Filter Data in Excel		Copy Link
Remove Duplicates How to Remove Duplicates in Excel		Copy Link
Slicers How to Use Slicers in Excel		Copy Link
Structured References How to Use Structured References in Excel		Copy Link
Intermediate Formatting
Apply Conditional Formatting How to Apply Conditional Formatting in Excel		Copy Link
Collaboration
Cell Comments How to Add, Edit, and Delete Cell Comments in Excel		Copy Link
Share Workbooks How to Share Workbooks in Excel		Copy Link
Version History How to Use Version History in Excel		Copy Link
Protect a Worksheet How to Protect a Worksheet in Excel		Copy Link
Protect Workbook Structure How to Protect a Workbook's Structure in Excel		Copy Link
Password Protection How to Add Password Protection in Excel		Copy Link
PivotTables
Create PivotTables How to Create PivotTables in Excel		Copy Link
Add Multiple PivotTable Fields How to Add Multiple PivotTable Fields to a PivotTable in Excel		Copy Link
Add Calculated Fields How to Add and Remove Calculated Fields in Excel PivotTables		Copy Link
The GETPIVOTDATA Function How to Use the GETPIVOTDATA Function in Excel		Copy Link
Filter PivotTables How to Filter PivotTables in Excel		Copy Link
Group Values How to Group Values in Excel		Copy Link
Refresh a PivotTable How to Refresh a PivotTable in Excel		Copy Link
Format a PivotTable How to Format a PivotTable in Excel		Copy Link
PivotCharts
Create PivotCharts How to Create PivotCharts in Excel		Copy Link
Troubleshoot Formulas
Formula Errors How to Fix Formula Errors in Excel		Copy Link
The Watch Window How to The Watch Window in Excel		Copy Link
Evaluate Formulas How to Evaluate Formulas in Excel		Copy Link
Advanced Formatting
Customize Conditional Formatting How to Customize Conditional Formatting in Excel		Copy Link
Conditional Formatting with Formulas How to Use Conditional Formatting with Formulas in Excel		Copy Link
International Currency and Formats How to Use International Currency and Formats in Excel		Copy Link
Color Formats How to Create and Apply Color Schemes in Excel		Copy Link
Custom Themes How to Create and Apply Custom Themes in Excel		Copy Link
Form Controls How to Form Controls in Excel		Copy Link
Advanced Formulas
IF Function How to Use the IF Function in Excel		Copy Link
Nested Functions How to Insert Nested Functions in Excel		Copy Link
AND, OR, and NOT Functions How to use AND, OR, and NOT Functions in Excel		Copy Link
SUMIF, AVERAGEIF, and COUNTIF Functions How to Use SUMIF, AVERAGEIF, and COUNTIF Functions in Excel		Copy Link
VLOOKUP How to Use the VLOOKUP Function in Excel		Copy Link
HLOOKUP How to Use HLOOKUP in Excel		Copy Link
INDEX and MATCH How to Use the INDEX and MATCH Functions in Excel		Copy Link
UPPER, LOWER, and PROPER How to Use UPPER, LOWER, and PROPER Functions in Excel		Copy Link
RIGHT, LEFT, and MID How to Use RIGHT, LEFT, and MID Functions in Excel		Copy Link
Formula Calculation Options How to Change Formula Calculation Options in Excel		Copy Link
Analyze Data
Goal Seek How to use Goal Seek feature in Excel		Copy Link
Scenario Manager How Use to Scenario Manager in Excel		Copy Link
Consolidate Data How to Consolidate Data in Excel		Copy Link
Macros
Enable Macros How to Enable Macros in Excel		Copy Link
Create Macros How to Create Macros in Excel		Copy Link
Modify Macros How to Modify Macros in Excel		Copy Link