025003-06
If you have a large and complex Excel workbook, you'll inevitably be juggling numerous variables and values to analyze or even anticipate different business scenarios. In this course, you'll learn the skills you need to make the best use of the Excel features that support advanced planning, scheduling, forecasting, and other types of data analysis.
This course is intended for students who are experienced Excel 2016 users and have a desire or need to advance their skills in working with some of the more advanced Excel features.
Topic A: Determine Potential Outcomes Using Data Tables
- What-If Analysis
- Data Tables
- One-Variable Data Tables
- Two-Variable Data Tables
- The Data Table Dialog Box
- How to Create a Data Table
- Determining Potential Outcomes Using Data Tables
Topic B: Determine Potential Outcomes Using Scenarios
- Scenarios
- The Scenario Manager Dialog Box
- The Add Scenario Dialog Box
- The Scenario Values Dialog Box
- The Scenario Command
- How to Work with Scenarios
- Determining Potential Outcomes by Using Scenarios
Topic C: Use the Goal Seek Feature
- The Goal Seek Feature
- The Goal Seek Dialog Box
- Iterative Calculations
- How to Use the Goal Seek Feature
- Using the Goal Seek Feature
Topic D: Forecasting Data Trends
- The Forecast Sheet
- How to Create a Forecast Sheet
- Forecasting Data with the Forecast Sheet
SKU | 025003-06SE |
---|---|
Weight | 0.0000 |
Coming Soon | No |
Days of Training | No |
Audience | Student |
Product Family | FocusCHOICE |
Product Type | Digital Courseware |
Electronic | Yes |
ISBN | 1424628172 |
Language | English |
Page Count | No |
Curriculum Library | Excel |
Year | 2016 |
Manufacturer's Product Code | No |
Current Revision | 1.0 |
---|---|
Revision Notes | No Revision Information Available |
Original Publication Date | 2017-12-15 00:00:00 |