Excel 2016 Short Take 6 of 6 – $129
- October 30, 2017
9:00 am - 12:00 pm - October 30, 2017
1:00 pm - 4:00 pm
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
Venue: Virtual Live Instructor Led
« Excel 2016 Short Take 5 of 6 – $129 (Previous Post)
(Next Post) PowerPoint 2016 Short Take 1 of 4 – $129 »