PRE-ASSESSMENT
+ SECTION 1 | INTRODUCTION - 1 MODULE
Unit 1 | What's New in Excel 2019?
1. What's New in Office 2019?
+ SECTION 2 | EFFICIENCY AND RISK - 13 MODULES
Unit 2 | Templates
1. Introduction
2. Default Templates and Creating Modular Workbooks
3. Customized Interface
4. Exercise
Unit 3 | Increasing Efficiency and Reducing Risk
1. Introduction to Design Standards
2. Controls and Checks
3. Techniques
4. Review and Documentation
5. Exercise
Unit 4 | Data Validation
1. Data Validation Formulae
2. Data Validation With Dependent Lists
3. Data Validation Alternatives
4. Exercise
+ SECTION 3 | ADVANCED TECHNIQUES - 29 MODULES
Unit 5 | Functions With Superpowers
1. Introduction
2. MOD
3. OFFSET
4. INDIRECT
5. LOOKUP From Right to Left - CHOOSE
6. Dynamic Ranges vs Tables
7. Exercise
Unit 6 | Array Formulas
1. Array Formulae Explained
2. Alternatives to Array Formulae
3. Exercise
Unit 7 | Tables
1. Automatic Expansion
2. Table Formulae
3. Working With Data in Tables
4. Slicers in Tables
5. Table Benefits and Drawbacks
6. Exercise
Unit 8 | Advanced Range Names
1. Advanced Range Names
2. Using Names in Formulae
3. Formula in Range Names
4. Exercise
Unit 9 | WhatIf Analysis
1. Goal Seek
2. Data Tables
3. Solver Add-In
4. Scenario Manager
5. Exercise
Unit 10 | Problem Solving
1. Introduction
2. Boolean Logic and Arrays in Action
3. Using Tables
4. Exercise
+ SECTION 4 | EXCEL INTERACTIVITY - 9 MODULES
Unit 11 | Form Controls
1. Basic Form Controls
2. Advanced Controls
3. Exercise
Unit 12 | Visual Basic and Macros
1. Writing Code Directly: Sub Procedures
2. Writing Code Directly: User-Defined Functions
3. Structure and Worksheet Change Event
4. Interactive VBA
5. VBA Projects
6. Exercise
+ SECTION 5 | SPREADSHEET IMPACT - 16 MODULES
Unit 13 | Conditional Formatting
1. Conditional Format Formulae
2. Advanced Conditional Formatting
3. Creative Conditional Formatting
4. Exercise
Unit 14 | Charts That Inspire
1. What Makes a Good Chart?
2. Advanced Charts and Techniques Part 1
3. Advanced Charts and Techniques Part 2
4. Advanced Charts and Techniques Part 3
5. Exercise
Unit 15 | Sparklines
1. Sparklines
2. Advanced Uses: Dynamic References
3. Exercise
Unit 16 | Graphics Tricks and Techniques
1. Excel Camera
2. Power View
3. 3D Map
4. Exercise
+ SECTION 6 | TURNING DATA INTO DECISIONS - 21 MODULES
Unit 17 | Working With External Data
1. Introduction
2. Understanding Data Structures
3. Get & Transform: From Database to Spreadsheet
4. Data Model
5. Exercise
Unit 18 | Advanced Uses of PivotTables
1. Advanced PivotTable Techniques
2. Using PivotTables as a Management Report Engine
3. Understand Data With Slicers and Timelines
4. Working With PivotCharts
5. Building an Interactive Dashboard
6. Exercise
Unit 19 | Power Pivot
1. Introduction
2. Power Pivot Data Tools
3. Basic Data Analysis Expressions
4. Advanced Data Analysis Expressions
5. Time Intelligence Functions
6. Exercise
Unit 20 | Reporting With Power Pivot
1. Additional Features
2. Advanced Techniques
3. Creating a Dashboard
4. Exercise
FINAL ASSESSMENT