Excel Training
Try this course with a Free Trial
Excel Training
Learn to:
- Build & edit spreadsheets
- Calculate with formulas
- Add eye-catching formatting
- Organize and manage workbooks
Features:
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|
Excel Training Outline
|
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 | |