Excel Training

Excel Training

Features:

  • Interactive bite-sized lessons

  • Get Certified

  • Accurate skill assessments

  • Customizable, LMS-ready content

Prices
Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

Excel Training
Excel Training Account Required: Try this course with a

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