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