Course:Excel 2019 Intermediate | CustomGuide

Excel 2019 Intermediate

Excel 2019 Intermediate Try this course with a
Skill Pre-assess Lesson Post-assess Learning mode
Charts
Verified Learning
Create Charts Click to start 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
Skill Pre-assess Lesson Post-assess Learning mode
Print and Distribute
Verified Learning
Page Size and Scale
Print Area and Page Breaks
Print Titles, Gridlines, and Headings
Headers and Footers
Margins and Orientation
Inspect for Issues
Skill Pre-assess Lesson Post-assess Learning mode
Intermediate Formulas
Verified Learning
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
Skill Pre-assess Lesson Post-assess Learning mode
Manage Data
Verified Learning
Quick Analysis
Outline and Subtotal
Data Validation
Flash Fill
Import and Export Data
Skill Pre-assess Lesson Post-assess Learning mode
Tables
Verified Learning
Insert a Table
Sort Data
Filter Data
Add Rows and Columns
Table Styles
Remove Duplicates
Slicers
Structured References
Skill Pre-assess Lesson Post-assess Learning mode
Intermediate Formatting
Verified Learning
Apply Conditional Formatting
Apply and Remove Cell Styles
Create and Modify Cell Styles
Find and Replace Formatting
Apply a Theme
Skill Pre-assess Lesson Post-assess Learning mode
Collaboration
Verified Learning
Cell Comments
Share Workbooks
Co-author Workbooks
Version History
Protect a Worksheet
Protect Workbook Structure
Password Protection