Font size:

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.
  • 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
Register Now
Microsoft Excel 2016 Advanced: Apps and What-if Analysis Online course
  • Course ID:
    267149
  • Duration:
    47 minutes
  • Price:
    $75