In this Short Take to Microsoft Excel 2016 training class, learn to review and learn about macros, find errors in data and proof your data using validation. Learn to use what if scenarios for analysis and forecast.

Prerequisites: To get the most from the training, we highly recommend you take the Short Take sessions in order (i.e. Short Take 1, Short Take 2, etc.) or have previous experience as outlined in the class objectives.

Course Length:  3 hours

Course Objectives

Upon successful completion of this course, you will learn to:

• Automate workbook functionality.
• Create sparklines and map data.
• Forecast data.

Automating Workbook Functionality

• Apply Data Validation
• Search for Invalid Data and Formulas with Errors
• Work with Macros

Creating Sparklines and Mapping Data

• Create Sparklines
• Map Data

Forecasting Data

• Determine Potential Outcomes Using Data Tables
• Determine Potential Outcomes Using Scenarios
• Use the Goal Seek Feature
• Forecasting Data Trends