Chat with us, powered by LiveChat

Excel 2019 Intermediate

Learn by doing—not watching—with interactive simulations.

1,620 users

Course Includes

  • Custom-branding Certificate of Achievement
  • Custom-branding Interactive Tutorials
  • Custom-branding 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.

Try sample lessons in the course outline shown below!

Proven Learning Method

Learning Method Diagram
Skill Assess Learn Verify Improvement

Excel 2019 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
Outline and Subtotal
Data Validation
Flash Fill
Import and Export Data

Tables lock Subscribe to unlock

Insert a Table
Sort Data
Filter 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
Version History
Protect a Worksheet
Protect Workbook Structure
Password Protection