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
![]() |
Copy these free tutorials to use in your own lesson plans: | |
Excel Fundamentals | ||
Understand the Excel Screen |
Copy Link | |
Create Workbooks |
Copy Link | |
Navigate Worksheets |
Copy Link | |
Open Workbooks |
Copy Link | |
Save Workbooks |
Copy Link | |
AutoRecover |
Copy Link | |
The Quick Access Toolbar |
Copy Link | |
Print |
Copy Link | |
Help |
Copy Link | |
Close and Exit |
Copy Link | |
Edit a Workbook | ||
Select Cells and Ranges |
Copy Link | |
Edit Cell Data |
Copy Link | |
Cut, Copy, and Paste |
Copy Link | |
Undo, Redo, Repeat |
Copy Link | |
More Pasting Options |
Copy Link | |
Insert and Move Cells |
Copy Link | |
Delete Cells |
Copy Link | |
Check Spelling |
Copy Link | |
Find and Replace Text |
Copy Link | |
Hide Columns and Rows |
Copy Link | |
Document Properties |
Copy Link | |
Basic Formulas | ||
Formula Basics |
Copy Link | |
AutoFill |
Copy Link | |
Sums and Averages |
Copy Link | |
MIN and MAX |
Copy Link | |
COUNT |
Copy Link | |
Basic Formatting | ||
Format Text |
Copy Link | |
Align and Merge Cells |
Copy Link | |
Format Numbers and Dates |
Copy Link | |
Borders and Background Colors |
Copy Link | |
Copy Formatting |
Copy Link | |
Row Heights and Column Widths |
Copy Link | |
Insert Objects | ||
Images |
Copy Link | |
Shapes |
Copy Link | |
Hyperlinks |
Copy Link | |
Object Properties and Alt Text |
Copy Link | |
Manage Worksheets | ||
View Worksheets |
Copy Link | |
Multiple Windows |
Copy Link | |
Move and Copy Worksheets |
Copy Link | |
Insert, Rename, and Delete Worksheets |
Copy Link | |
Freeze Rows and Columns |
Copy Link | |
Hide Worksheets and Gridlines |
Copy Link | |
Charts | ||
Create Charts |
Copy Link | |
Move and Resize |
Copy Link | |
Chart Types |
Copy Link | |
Layout and Style |
Copy Link | |
Titles and Legends |
Copy Link | |
Gridlines, Labels, and Data Tables |
Copy Link | |
Chart Elements |
Copy Link | |
Modify Chart Data |
Copy Link | |
Filter Charts |
Copy Link | |
Trendlines |
Copy Link | |
Dual-Axis Charts |
Copy Link | |
Chart Templates |
Copy Link | |
Sparklines |
Copy Link | |
Print and Distribute | ||
Page Size and Scale |
Copy Link | |
Print Area and Page Breaks |
Copy Link | |
Print Titles, Gridlines, and Headings |
Copy Link | |
Headers and Footers |
Copy Link | |
Margins and Orientation |
Copy Link | |
Inspect for Issues |
Copy Link | |
Intermediate Formulas | ||
Reference External Worksheets |
Copy Link | |
Absolute and Relative References |
Copy Link | |
Order of Operations |
Copy Link | |
Cell and Range Names |
Copy Link | |
Insert Functions |
Copy Link | |
CONCAT Function |
Copy Link | |
PMT and NPER Functions |
Copy Link | |
Display Formulas |
Copy Link | |
Date Formulas |
Copy Link | |
Manage Data | ||
Quick Analysis |
Copy Link | |
Outline and Subtotal |
Copy Link | |
Data Validation |
Copy Link | |
Flash Fill |
Copy Link | |
Import and Export Data |
Copy Link | |
Tables | ||
Insert a Table |
Copy Link | |
Sort Data |
Copy Link | |
Filter Data |
Copy Link | |
Add Rows and Columns |
Copy Link | |
Table Styles |
Copy Link | |
Remove Duplicates |
Copy Link | |
Slicers |
Copy Link | |
Structured References |
Copy Link | |
Intermediate Formatting | ||
Apply Conditional Formatting |
Copy Link | |
Apply and Remove Cell Styles |
Copy Link | |
Create and Modify Cell Styles |
Copy Link | |
Find and Replace Formatting |
Copy Link | |
Apply a Theme |
Copy Link | |
Collaboration | ||
Cell Comments |
Copy Link | |
Share Workbooks |
Copy Link | |
Co-author Workbooks |
Copy Link | |
Version History |
Copy Link | |
Protect a Worksheet |
Copy Link | |
Protect Workbook Structure |
Copy Link | |
Password Protection |
Copy Link | |
PivotTables | ||
Create PivotTables |
Copy Link | |
Add Multiple PivotTable Fields |
Copy Link | |
Change a PivotTable's Calculation |
Copy Link | |
Add Calculated Fields |
Copy Link | |
The GETPIVOTDATA Function |
Copy Link | |
Filter PivotTables |
Copy Link | |
Timelines |
Copy Link | |
PivotTable Layout |
Copy Link | |
Group Values |
Copy Link | |
Refresh a PivotTable |
Copy Link | |
Format a PivotTable |
Copy Link | |
PivotCharts | ||
Create PivotCharts |
Copy Link | |
PivotChart Options |
Copy Link | |
PivotChart Styles |
Copy Link | |
Drill-Down Data |
Copy Link | |
Troubleshoot Formulas | ||
Formula Errors |
Copy Link | |
The Watch Window |
Copy Link | |
Evaluate Formulas |
Copy Link | |
Advanced Formatting | ||
Customize Conditional Formatting |
Copy Link | |
Conditional Formatting with Formulas |
Copy Link | |
Manage Conditional Formatting |
Copy Link | |
International Currency and Formats |
Copy Link | |
Body and Heading Options |
Copy Link | |
Color Formats |
Copy Link | |
Custom Themes |
Copy Link | |
Form Controls |
Copy Link | |
Save Form Templates |
Copy Link | |
Advanced Formulas | ||
IF Function |
Copy Link | |
Nested Functions |
Copy Link | |
AND, OR, and NOT Functions |
Copy Link | |
SUMIF, AVERAGEIF, and COUNTIF Functions |
Copy Link | |
VLOOKUP |
Copy Link | |
HLOOKUP |
Copy Link | |
INDEX and MATCH |
Copy Link | |
UPPER, LOWER, and PROPER |
Copy Link | |
RIGHT, LEFT, and MID |
Copy Link | |
Formula Calculation Options |
Copy Link | |
Analyze Data | ||
Goal Seek |
Copy Link | |
Scenario Manager |
Copy Link | |
Consolidate Data |
Copy Link | |
Macros | ||
Enable Macros |
Copy Link | |
Create Macros |
Copy Link | |
Modify Macros |
Copy Link | |
Copy Macros |
Copy Link |