Desktop Certifications     Microsoft     Microsoft Office Specialist (MOS) on Microsoft Office 2016     77-727 Excel 2016: Core Data Analysis, Manipulation, and Presentation

---

Microsoft Excel 2016 is a very powerful data analysis tool, but its functionality can be enhanced even further using third-party applications. This course covers how to find, install, and manage apps. It also covers What-if analysis, where Excel offers a number of ways of exploring how altering inputs can affect the outcome of calculations.

---

---

Objectives

Excel 2016 Apps start the course add an add-in for Microsoft Excel 2016 to your Microsoft account insert and manage an add-in in Microsoft Excel 2016 What-if Analysis use Goal Seek to find required input values in Microsoft Excel 2016 determine a value based on a number of variables using Solver in Microsoft Excel 2016 create and compare scenarios using scenario manager in Microsoft Excel 2016 create a summary report of scenarios in a Microsoft Excel 2016 Worksheet merge scenarios in Microsoft Excel 2016 create a single variable data table in Microsoft Excel 2016 create a two-variable data table in Microsoft Excel 2016 Practice: What-if Analysis use Goal Seek, Scenario Manager, and Data Tables to try different values in Microsoft Excel 2016