EXI – Excel 2019 Intermediate

• Duration: 10 weeks

Lesson 1: Working with Functions

•  Topic A: Work with Ranges
•  Topic B: Use Specialized Functions
•  Topic C: Work with Logical Functions
•  Topic D: Work with Date and Time Functions
•  Topic E: Work with Text Functions

Lesson 2: Working with Lists

•  Topic A: Sort Data
•  Topic B: Filter Data
•  Topic C: Query Data with Database Functions
•  Topic D: Outline and Subtotal Data

Lesson 3: Analyzing Data

•  Topic A: Create and Modify Tables
•  Topic B: Apply Intermediate Conditional Formatting
•  Topic C: Apply Advanced Conditional Formatting

Lesson 4: Visualizing Data with Charts

•  Topic A: Create Charts
•  Topic B: Modify and Format Charts
•  Topic C: Use Advanced Chart Features

Lesson 5: Using PivotTables and PivotCharts

•  Topic A: Create a PivotTable
•  Topic B: Analyze PivotTable Data
•  Topic C: Present Data with PivotCharts
•  Topic D: Filter Data by Using Timelines and Slicers

Appendix A: Mapping Course Content to Excel Associate (Office 365 and Office 2019): Exam MO-200
Appendix B: Mapping Course Content to Excel Expert (Office 365 and Office 2019): Exam MO-201
Appendix C: Microsoft® Excel® 2019 Common Keyboard Shortcuts
Appendix D: Financial Functions
Appendix E: Working with Graphical Objects
Appendix F: Using Array Formulas