Excel Training
Features:
-
Interactive bite-sized lessons
-
Get Certified
-
Accurate skill assessments
-
Customizable, LMS-ready content
Excel Training
Account Required:
Try this course with a
Free Trial
|
Verified Learning |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Excel Fundamentals | ||||
Understand the Excel Screen
Understand the Excel Screen |
Account Req | Not Started | Account Req | |
Create Workbooks
How to create blank & template-based workbooks in Excel |
Account Req | Not Started | Account Req | |
Navigate Worksheets
How to Navigate Worksheets in Excel |
Account Req | Not Started | Account Req | |
Open Workbooks
How to Open Workbooks in Excel |
Account Req | Not Started | Account Req | |
Save Workbooks
How to Save Workbooks in Excel |
Account Req | Not Started | Account Req | |
AutoRecover
How to AutoRecover Excel Files |
Account Req | Not Started | Account Req | |
The Quick Access Toolbar
How to Use The Quick Access Toolbar in Excel |
Account Req | Not Started | Account Req | |
Print
How to Print in Excel |
Account Req | Not Started | Account Req | |
Help
How to Get Help in Excel |
Account Req | Not Started | Account Req | |
Close and Exit
How to Close and Exit from Excel |
Account Req | Not Started | Account Req |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Edit a Workbook | ||||
Select Cells and Ranges
How to Select Cells and Ranges in Excel |
Account Req | Not Started | Account Req | |
Edit Cell Data
How to Edit Cell Data in Excel |
Account Req | Not Started | Account Req | |
Cut, Copy, and Paste
How to Cut, Copy, and Paste in Excel |
Account Req | Not Started | Account Req | |
Undo, Redo, Repeat
How to Use Undo, Redo, Repeat Commands in Excel |
Account Req | Not Started | Account Req | |
More Pasting Options
How to Use Special Paste Options in Excel |
Account Req | Not Started | Account Req | |
Insert and Move Cells
How to Insert and Move Cells in Excel |
Account Req | Not Started | Account Req | |
Delete Cells
How to Delete Cells in Excel |
Account Req | Not Started | Account Req | |
Check Spelling
How to Spell Check in Excel & avoid errors |
Account Req | Not Started | Account Req | |
Find and Replace Text
How to Use Find and Replace in Excel |
Account Req | Not Started | Account Req | |
Hide Columns and Rows
How to Hide Columns and Rows in Excel |
Account Req | Not Started | Account Req | |
Document Properties
How to View and Edit Document Properties in Excel |
Account Req | Not Started | Account Req |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Basic Formulas | ||||
Formula Basics
How to Create Basic Formulas in Excel |
Account Req | Not Started | Account Req | |
AutoFill
How to Use AutoFill in Excel |
Account Req | Not Started | Account Req | |
Sums and Averages
How to Use Sum and Average Formulas in Excel |
Account Req | Not Started | Account Req | |
MIN and MAX
How to Use MIN and MAX Functions in Microsoft Excel |
Account Req | Not Started | Account Req | |
COUNT
How to Use the COUNT Function in Excel |
Account Req | Not Started | Account Req |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Basic Formatting | ||||
Format Text
How to Apply Formatting to Text in Excel |
Account Req | Not Started | Account Req | |
Align and Merge Cells
How to align and merge cells in Excel |
Account Req | Not Started | Account Req | |
Format Numbers and Dates
How to Format Numbers and Dates in Excel |
Account Req | Not Started | Account Req | |
Borders and Background Colors
How to Add Cell Borders and Background Colors in Excel |
Account Req | Not Started | Account Req | |
Copy Formatting
How to Copy Formatting in Excel |
Account Req | Not Started | Account Req | |
Row Heights and Column Widths
How to Adjust Row Heights and Column Widths in Excel |
Account Req | Not Started | Account Req |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Insert Objects | ||||
Images
How to Insert Images in Excel |
Account Req | Not Started | Account Req | |
Shapes
How to Insert and Format Shapes in Excel |
Account Req | Not Started | Account Req | |
Hyperlinks
How to Insert Hyperlinks in Excel |
Account Req | Not Started | Account Req | |
Object Properties and Alt Text
How to Adjust Object Properties and Alt Text in Excel |
Account Req | Not Started | Account Req |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Manage Worksheets | ||||
View Worksheets
How to Change Worksheet Views in Excel |
Account Req | Not Started | Account Req | |
Multiple Windows
How to Work with Multiple Windows in Excel |
Account Req | Not Started | Account Req | |
Move and Copy Worksheets
How to Move and Copy Worksheets in Excel |
Account Req | Not Started | Account Req | |
Insert, Rename, and Delete Worksheets
How to Insert, Rename, and Delete Worksheets in Excel |
Account Req | Not Started | Account Req | |
Freeze Rows and Columns
How to Freeze and Unfreeze Rows and Columns in Excel |
Account Req | Not Started | Account Req | |
Hide Worksheets and Gridlines
How to Hide Worksheets and Gridlines in Excel |
Account Req | Not Started | Account Req |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Charts | ||||
Create Charts
How to Create Charts in Excel |
Account Req | Not Started | Account Req | |
Move and Resize
How to Move and Resize a Chart in Excel |
Account Req | Not Started | Account Req | |
Chart Types
How to Change Chart Types in Excel |
Account Req | Not Started | Account Req | |
Layout and Style
How to Apply Chart Layouts and Styles in Excel |
Account Req | Not Started | Account Req | |
Titles and Legends
How to Customize Chart Titles and Legends in Excel |
Account Req | Not Started | Account Req | |
Gridlines, Labels, and Data Tables
How to Display Chart Gridlines, Labels, and Data Tables in Excel |
Account Req | Not Started | Account Req | |
Chart Elements
How to Format Chart Data in Excel |
Account Req | Not Started | Account Req | |
Modify Chart Data
How to Modify Chart Data in Excel |
Account Req | Not Started | Account Req | |
Filter Charts
How to Filter Charts in Excel |
Account Req | Not Started | Account Req | |
Trendlines
How to Add Trendlines in Excel |
Account Req | Not Started | Account Req | |
Dual-Axis Charts
How to Create Dual-Axis Charts in Excel |
Account Req | Not Started | Account Req | |
Chart Templates
How to Create Chart Templates in Excel |
Account Req | Not Started | Account Req | |
Sparklines
How to Add Sparklines in Excel |
Account Req | Not Started | Account Req |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Print and Distribute | ||||
Page Size and Scale
How to Adjust Page Size and Scale in Excel |
Account Req | Not Started | Account Req | |
Print Area and Page Breaks
How to Set Print Area and Page Breaks in Excel |
Account Req | Not Started | Account Req | |
Print Titles, Gridlines, and Headings
How to Print Titles, Gridlines, and Headings in Excel |
Account Req | Not Started | Account Req | |
Headers and Footers
How to Add Headers and Footers in Excel |
Account Req | Not Started | Account Req | |
Margins and Orientation
How to Adjust Margins and Orientation in Excel |
Account Req | Not Started | Account Req | |
Inspect for Issues
How to Inspect for Issues in Excel |
Account Req | Not Started | Account Req |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Intermediate Formulas | ||||
Reference External Worksheets
How to Reference External Worksheets in Excel |
Account Req | Not Started | Account Req | |
Absolute and Relative References
How to use Absolute and Relative Cell References in Excel |
Account Req | Not Started | Account Req | |
Order of Operations
Order of Operations in Excel |
Account Req | Not Started | Account Req | |
Cell and Range Names
How to Add Cell and Range Names in Excel |
Account Req | Not Started | Account Req | |
Insert Functions
How to Insert Functions in Excel |
Account Req | Not Started | Account Req | |
CONCAT Function
How to use the Concatenate Text Function in Excel |
Account Req | Not Started | Account Req | |
PMT and NPER Functions
How to Use the PMT Function in Excel |
Account Req | Not Started | Account Req | |
Display Formulas
How to Display Formulas in Excel |
Account Req | Not Started | Account Req | |
Date Formulas
How to Use Date Formulas in Excel |
Account Req | Not Started | Account Req |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Manage Data | ||||
Quick Analysis
What is the quick analysis tool in Excel |
Account Req | Not Started | Account Req | |
Outline and Subtotal
How to Use the Outline and Subtotal Features in Excel |
Account Req | Not Started | Account Req | |
Data Validation
How to Use Data Validation Rules in Excel |
Account Req | Not Started | Account Req | |
Flash Fill
How to Use Flash Fill in Excel |
Account Req | Not Started | Account Req | |
Import and Export Data
How to Import and Export Excel Data |
Account Req | Not Started | Account Req |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Tables | ||||
Insert a Table
How to Insert a Table in Excel |
Account Req | Not Started | Account Req | |
Sort Data
How to Sort Data in Excel |
Account Req | Not Started | Account Req | |
Filter Data
How to Filter Data in Excel |
Account Req | Not Started | Account Req | |
Add Rows and Columns
How to Add Rows and Columns to Excel Tables |
Account Req | Not Started | Account Req | |
Table Styles
How to Apply Table Styles in Excel |
Account Req | Not Started | Account Req | |
Remove Duplicates
How to Remove Duplicates in Excel |
Account Req | Not Started | Account Req | |
Slicers
How to Use Slicers in Excel |
Account Req | Not Started | Account Req | |
Structured References
How to Use Structured References in Excel |
Account Req | Not Started | Account Req |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Intermediate Formatting | ||||
Apply Conditional Formatting
How to Apply Conditional Formatting in Excel |
Account Req | Not Started | Account Req | |
Apply and Remove Cell Styles
How to Apply and Remove Cell Styles in Excel |
Account Req | Not Started | Account Req | |
Create and Modify Cell Styles
How to Create and Modify Cell Styles in Excel |
Account Req | Not Started | Account Req | |
Find and Replace Formatting
How to Find and Replace Formatting in Excel |
Account Req | Not Started | Account Req | |
Apply a Theme
How to Apply a Theme in Excel |
Account Req | Not Started | Account Req |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Collaboration | ||||
Cell Comments
How to Add, Edit, and Delete Cell Comments in Excel |
Account Req | Not Started | Account Req | |
Share Workbooks
How to Share Workbooks in Excel |
Account Req | Not Started | Account Req | |
Co-author Workbooks
How to Co-author Workbooks in Excel |
Account Req | Not Started | Account Req | |
Version History
How to Use Version History in Excel |
Account Req | Not Started | Account Req | |
Protect a Worksheet
How to Protect a Worksheet in Excel |
Account Req | Not Started | Account Req | |
Protect Workbook Structure
How to Protect a Workbook's Structure in Excel |
Account Req | Not Started | Account Req | |
Password Protection
How to Add Password Protection in Excel |
Account Req | Not Started | Account Req |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
PivotTables | ||||
Create PivotTables
How to Create PivotTables in Excel |
Account Req | Not Started | Account Req | |
Add Multiple PivotTable Fields
How to Add Multiple PivotTable Fields to a PivotTable in Excel |
Account Req | Not Started | Account Req | |
Change a PivotTable's Calculation
How to Change a PivotTable's Calculation in Excel |
Account Req | Not Started | Account Req | |
Add Calculated Fields
How to Add and Remove Calculated Fields in Excel PivotTables |
Account Req | Not Started | Account Req | |
The GETPIVOTDATA Function
How to Use the GETPIVOTDATA Function in Excel |
Account Req | Not Started | Account Req | |
Filter PivotTables
How to Filter PivotTables in Excel |
Account Req | Not Started | Account Req | |
Timelines
How to Add a Timeline in Excel |
Account Req | Not Started | Account Req | |
PivotTable Layout
Adjust a PivotTable's Layout in Excel |
Account Req | Not Started | Account Req | |
Group Values
How to Group Values in Excel |
Account Req | Not Started | Account Req | |
Refresh a PivotTable
How to Refresh a PivotTable in Excel |
Account Req | Not Started | Account Req | |
Format a PivotTable
How to Format a PivotTable in Excel |
Account Req | Not Started | Account Req |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
PivotCharts | ||||
Create PivotCharts
How to Create PivotCharts in Excel |
Account Req | Not Started | Account Req | |
PivotChart Options
PivotChart Options in Excel |
Account Req | Not Started | Account Req | |
PivotChart Styles
How to Apply PivotChart Styles in Excel |
Account Req | Not Started | Account Req | |
Drill-Down Data
How to Drill-Down Chart Data in Excel |
Account Req | Not Started | Account Req |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Troubleshoot Formulas | ||||
Formula Errors
How to Fix Formula Errors in Excel |
Account Req | Not Started | Account Req | |
The Watch Window
How to The Watch Window in Excel |
Account Req | Not Started | Account Req | |
Evaluate Formulas
How to Evaluate Formulas in Excel |
Account Req | Not Started | Account Req |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Advanced Formatting | ||||
Customize Conditional Formatting
How to Customize Conditional Formatting in Excel |
Account Req | Not Started | Account Req | |
Conditional Formatting with Formulas
How to Use Conditional Formatting with Formulas in Excel |
Account Req | Not Started | Account Req | |
Manage Conditional Formatting
How to Manage Conditional Formatting in Excel |
Account Req | Not Started | Account Req | |
International Currency and Formats
How to Use International Currency and Formats in Excel |
Account Req | Not Started | Account Req | |
Body and Heading Options
How to Apply Body and Heading Font Options in Excel |
Account Req | Not Started | Account Req | |
Color Formats
How to Create and Apply Color Schemes in Excel |
Account Req | Not Started | Account Req | |
Custom Themes
How to Create and Apply Custom Themes in Excel |
Account Req | Not Started | Account Req | |
Form Controls
How to Form Controls in Excel |
Account Req | Not Started | Account Req | |
Save Form Templates
How to Save a Form as a Template in Excel |
Account Req | Not Started | Account Req |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Advanced Formulas | ||||
IF Function
How to Use the IF Function in Excel |
Account Req | Not Started | Account Req | |
Nested Functions
How to Insert Nested Functions in Excel |
Account Req | Not Started | Account Req | |
AND, OR, and NOT Functions
How to use AND, OR, and NOT Functions in Excel |
Account Req | Not Started | Account Req | |
SUMIF, AVERAGEIF, and COUNTIF Functions
How to Use SUMIF, AVERAGEIF, and COUNTIF Functions in Excel |
Account Req | Not Started | Account Req | |
VLOOKUP
How to Use the VLOOKUP Function in Excel |
Account Req | Not Started | Account Req | |
HLOOKUP
How to Use HLOOKUP in Excel |
Account Req | Not Started | Account Req | |
INDEX and MATCH
How to Use the INDEX and MATCH Functions in Excel |
Account Req | Not Started | Account Req | |
UPPER, LOWER, and PROPER
How to Use UPPER, LOWER, and PROPER Functions in Excel |
Account Req | Not Started | Account Req | |
RIGHT, LEFT, and MID
How to Use RIGHT, LEFT, and MID Functions in Excel |
Account Req | Not Started | Account Req | |
Formula Calculation Options
How to Change Formula Calculation Options in Excel |
Account Req | Not Started | Account Req |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Analyze Data | ||||
Goal Seek
How to use Goal Seek feature in Excel |
Account Req | Not Started | Account Req | |
Scenario Manager
How Use to Scenario Manager in Excel |
Account Req | Not Started | Account Req | |
Consolidate Data
How to Consolidate Data in Excel |
Account Req | Not Started | Account Req |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Macros | ||||
Enable Macros
How to Enable Macros in Excel |
Account Req | Not Started | Account Req | |
Create Macros
How to Create Macros in Excel |
Account Req | Not Started | Account Req | |
Modify Macros
How to Modify Macros in Excel |
Account Req | Not Started | Account Req | |
Copy Macros
How to Copy Macros in Excel |
Account Req | Not Started | Account Req |