Excel: Advancing your Knowledge
Hands-On Instructor Led – 3-hour Session
About: This Advanced Microsoft Excel 2016 training class is designed for students that want to continue their learning and start exploring Macros and Advanced Excel Scenerios.
Audience Profile: Students who are very comfortable with advanced formulas, pivot tables and charts. This course is designed for students at a strong intermediate level of Excel.
Prerequisites: Intermediate Excel
Course Topics
- Advanced Formulas – VLOOKUP, INDEX and MATCH
- Using Absolute and Mixed Reference in Formulas
- The Record Macro Dialogue Box
- Naming Macros
- Recording absolute and Relative Reference Macros
- Running Macros
- Adding Macros to the Quick Access Toolbar
- Copying Macros Between Workbooks
- Macro Security Settings
- What-If Scenarios
- Scenario Concepts
- Creating Scenarios
- Managing Scenarios
- Scenario Reports