Excel 2021 Intermediate

Learn by doing—not watching—with interactive simulations.

1,278 users

Course Includes

  • Custom-branding Certificate of Accreditation
  • Custom-branding 5.0 Credit Hours
  • Custom-branding Interactive Tutorials & Skills Assessments
  • Custom-branding Student manual, instructor guide, & practice files

What you'll learn:

  • How to create Bar, Column, Pie and Line Charts.
  • Build intermediate formulas using absolute & relative cell references.
  • Share & protect workbooks to collaborate with others.
  • Add conditional formatting to highlight data that meets your criteria.

Proven Learning Method

ALT_LEARNING_DIAGRAM
Skill Assess Learn Verify Improvement

Excel 2021 Intermediate

Complete Course to Display Score

Charts demo

Create Charts Click To Try Not Started Not Started Not Started
Move and Resize Not Started Not Started Not Started
Chart Types Not Started Not Started Not Started
Layout and Style Not Started Not Started Not Started
Titles and Legends Not Started Not Started Not Started
Gridlines, Labels, and Data Tables Not Started Not Started Not Started
Chart Elements Not Started Not Started Not Started
Modify Chart Data Not Started Not Started Not Started
Filter Charts Not Started Not Started Not Started
Trendlines Not Started Not Started Not Started
Dual-Axis Charts Not Started Not Started Not Started
Chart Templates Not Started Not Started Not Started
Sparklines Not Started Not Started Not Started

Print and Distribute lock Subscribe to unlock

Page Size and Scale
Print Area and Page Breaks
Print Titles, Gridlines, and Headings
Headers and Footers
Margins and Orientation
Inspect for Issues

Intermediate Formulas lock Subscribe to unlock

Reference External Worksheets
Absolute and Relative References
Order of Operations
Cell and Range Names
Insert Functions
CONCAT Function
PMT and NPER Functions
Display Formulas
Date Formulas

Manage Data lock Subscribe to unlock

Quick Analysis
Data Validation
Outline and Subtotal
Flash Fill
Import and Export Data

Tables lock Subscribe to unlock

Insert a Table
Sort Data
Add Rows and Columns
Table Styles
Remove Duplicates
Slicers
Structured References

Intermediate Formatting lock Subscribe to unlock

Apply Conditional Formatting
Apply and Remove Cell Styles
Create and Modify Cell Styles
Find and Replace Formatting
Apply a Theme

Collaboration lock Subscribe to unlock

Cell Comments
Share Workbooks
Co-author Workbooks
Protect a Worksheet
Protect Workbook Structure
Password Protection