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