Microsoft Excel 2016 Advanced: Apps and What-if Analysis

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

Prerequisite
None

Expected Duration
47 minutes

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.

Objective

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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.