Excel Intermediate Course Outline
Microsoft®
Excel 2021 Intermediate
Improve your Excel 2021 skills: Create eye-catching charts; use practical formulas; add conditional formatting; gain speed with tables; and more.
Create Charts
Move and Resize
Chart Types
Layout and Style
Titles and Legends
Gridlines, Labels, and Data Tables
Chart Elements
Modify Chart Data
Filter Charts
Trendlines
Dual-Axis Charts
Chart Templates
Trendlines
Page Size and Scale
Print Area and Page Breaks
Print Titles, Gridlines and Headings
Headers and Footers
Margins and Orientation
Inspect for Issues
Reference External Worksheets
Absolute and Relative References
Order of Operations
Cell and Range Names
Insert Functions
CONCAT Function
PMT Function
Display Formulas
Date Formulas
Insert a Table
Sort Data
Filter Data
Add Rows and Columns
Table Styles
Remove Duplicates
Slicers
Structured References
