Advanced Microsoft Excel 2019

This course assists in mastering many features in Microsoft Excel 2019 that most users don't know exist.

Syllabus

Lesson 1 - Customizing Excel

Lesson 2 - Table Management

Lesson 3 - Data Validation

Lesson 4 - Custom Controls

Lesson 5 - Conditional Formatting

Lesson 6 - Consolidating and Outlining

Lesson 7 - Excel Functions and Nesting

Lesson 8 - Import External Data

Lesson 9 - Data Tables

Lesson 10 - What-If Analysis Tools

Lesson 11 - Advanced PivotTables

Lesson 12 - Analysis ToolPak, Advanced Filter, Array Formulas, and More!