Course Name: Excel: What-If Analysis
CPE Credits: 2
Type: Online/Video
Exam: Passing grade (70%)
Price: $30
Description:
In this presentation, we will introduce you to Excel’s powerful What-If Analysis tools. You’ll see how and when to make use of Excel’s Scenario Manager, as well as how to use the Data Table feature to compare calculation results based on one, two, or three inputs. The presentation will contrast Excel’s Goal Seek feature with the Solver feature, and offer a sense of how to use the new Forecast Sheets feature in Excel 2016.
We demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. We also provides an Excel workbook that includes most of the examples he uses during the webcast.
Upon completion of this course, the learner will be able to:
- Identify the button you use within the Scenario Manager dialog box to import one or more scenarios from one workbook to another.
- Recognize the ribbon tab where the Macros command appears in Excel.
- Recall how to use the Data Table feature in Excel to compare calculation results based on varying inputs.