Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Intermediate Microsoft Excel 2019 Training
Setup
Setup for Your Class
Lesson 1 - Advanced Formulas
Activity 1 - Using Named Ranges in Formulas - Reading
Activity 2 - Review of Using Named Ranges in Formulas - Presentation (1:14)
Activity 3 - Using Named Ranges in Formulas - Exercise
Activity 4 - Exercise Solution - Using Named Ranges in Formulas - Presentation (3:00)
Activity 5 - Using Formulas That Span Multiple Worksheets - Reading
Activity 6 - Entering a Formula Using Data in Multiple Worksheets - Exercise
Activity 7 - Exercise Solution - Entering a Formula Using Data in Multiple Worksheets - Presentation (3:10)
Activity 8 - Using the IF Function - Reading
Activity 9 - Using the IF Function - Exercise
Activity 10 - Exercise Solution - Using the IF Function - Presentation (3:39)
Activity 11 - Using the PMT Function - Reading
Activity 12 - Using the PMT Function - Exercise
Activity 13 - Exercise Solution - Using the PMT Function - Presentation (5:02)
Activity 14 - Using the LOOKUP Function - Reading
Activity 15 - Using the VLOOKUP Function - Reading
Activity 16 - Using the VLOOKUP Function - Exercise
Activity 17 - Exercise Solution - Using the VLOOKUP Function - Presentation (4:01)
Activity 18 - Using the HLOOKUP Function - Reading
Activity 19 - Using the CONCAT Function - Reading
Activity 20 - Using the CONCAT Function - Exercise
Activity 21 - Exercise Solution - Using the CONCAT Function - Presentation (2:28)
Activity 22 - Using the TRANSPOSE Function - Reading
Activity 23 - Using the PROPER, UPPER, and LOWER Functions - Reading
Activity 24 - Using the PROPER Function - Exercise
Activity 25 - Exercise Solution - Using the PROPER Function - Presentation (1:31)
Activity 26 - Using the LEFT, RIGHT, and MID Functions - Reading
Activity 27 - Using the LEFT and RIGHT Functions - Exercise
Activity 28 - Exercise Solution - Using the LEFT and RIGHT Functions - Presentation (2:48)
Activity 29 - Using Date Functions - Reading
Activity 30 - Using the YEAR, MONTH, and DAY Functions - Exercise
Activity 31 - Exercise Solution - Using the YEAR, MONTH, and DAY Functions - Presentation (2:22)
Activity 32 - Creating Scenarios - Reading
Activity 33 - Advanced Formulas Quiz - Quiz
Lesson 2 - Working with Lists
Activity 1 - Converting a List to a Table - Reading
Activity 2 - Converting a List to a Table - Exercise
Activity 3 - Exercise Solution - Converting a List to a Table - Presentation (2:15)
Activity 4 - Removing Duplicates from a List - Reading
Activity 5 - Removing Duplicates from a List - Exercise
Activity 6 - Exercise Solution - Removing Duplicates from a List - Presentation (1:33)
Activity 7 - Sorting Data in a List - Reading
Activity 8 - Review of Sorting Data in a List - Presentation (2:06)
Activity 9 - Sorting Data in a List - Exercise
Activity 10 - Exercise Solution - Sorting Data in a List - Presentation (2:09)
Activity 11 - Filtering Data in a List - Reading
Activity 12 - Filtering Data in a List - Exercise
Activity 13 - Exercise Solution - Filtering Data in a List - Presentation (3:20)
Activity 14 - Adding Subtotals to a List - Reading
Activity 15 - Adding Subtotals to a List - Exercise
Activity 16 - Exercise Solution - Adding Subtotals to a List - Presentation (1:49)
Activity 17 - Working with Lists Quiz - Quiz
Lesson 3 - Working with Illustrations
Activity 1 - Working with Clip Art - Reading
Activity 2 - Working with Clip Art - Exercise
Activity 3 - Exercise Solution - Working with Clip Art - Presentation (1:41)
Activity 4 - Using Shapes - Reading
Activity 5 - Adding Shapes - Exercise
Activity 6 - Exercise Solution - Adding Shapes - Presentation (1:09)
Activity 7 - Working with Icons - Reading
Activity 8 - Working with SmartArt - Reading
Activity 9 - Using Office Ink - Reading
Activity 10 - Working with Illustrations in Excel Quiz - Quiz
Lesson 4 - Visualizing Your Data
Activity 1 - Using Charts - Reading
Activity 2 - New Charts - Reading
Activity 3 - Inserting Charts - Reading
Activity 4 - Review of Inserting Charts - Presentation (3:09)
Activity 5 - Using the Chart Recommendation Feature - Reading
Activity 6 - Inserting Charts - Exercise
Activity 7 - Exercise Solution - Inserting Charts - Presentation (2:16)
Activity 8 - Editing Charts - Reading
Activity 9 - Review of Editing Charts - Presentation (1:55)
Activity 10 - Using Chart Tools - Reading
Activity 11 - Using the Quick Analysis Tool - Reading
Activity 12 - Editing Charts - Exercise
Activity 13 - Exercise Solution - Editing Charts - Presentation (3:06)
Activity 14 - Add and Format Objects - Reading
Activity 15 - Create a Custom Chart Template - Reading
Activity 16 - Visualizing Your Data Quiz - Quiz
Lesson 5 - Working with Tables
Activity 1 - Format Data as a Table - Reading
Activity 2 - Formatting Your Data as a Table - Presentation (1:29)
Activity 3 - Move between Tables and Ranges - Reading
Activity 4 - Modify Tables - Reading
Activity 5 - Define Titles - Reading
Activity 6 - Creating and Modifying a Table in Excel - Exercise
Activity 7 - Exercise Solution - Creating and Modifying a Table in Excel - Presentation (1:37)
Activity 8 - Working with Tables in Excel Quiz - Quiz
Lesson 6 - Advanced Formatting
Activity 1 - Applying Conditional Formatting - Reading
Activity 2 - Review of Applying Conditional Formatting - Presentation (2:48)
Activity 3 - Using Conditional Formatting - Exercise
Activity 4 - Exercise Solution - Using Conditional Formatting - Presentation (5:51)
Activity 5 - Working with Styles - Reading
Activity 6 - Review of Working with Styles - Presentation (1:29)
Activity 7 - Working with Styles - Exercise
Activity 8 - Exercise Solution - Working with Styles - Presentation (2:19)
Activity 9 - Creating and Modifying Templates - Reading
Activity 10 - Advanced Excel Formatting Quiz - Quiz
Lesson 7 - Intermediate Microsoft Excel 2019 Exam
Activity 1 - Intermediate Microsoft Excel 2019 Exam - Exam
Activity 6 - Review of Working with Styles - Presentation
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock