Microsoft Excel 2016 Advanced: Apps and What-if Analysis

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level

---

Overview/Description
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.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Excel; and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016

Prerequisites
None

Expected Duration (hours)
0.8

Lesson Objectives

Microsoft Excel 2016 Advanced: Apps and What-if Analysis

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

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

use Goal Seek, Scenario Manager, and Data Tables to try different values in Microsoft Excel 2016

Course Number:
mo_adve_a01_dt_enus

Expertise Level
Expert