Every registration supports local education. TrainUp Gives Back
Logo

Your Career Training Marketplace

Questions? Call Toll-Free: 1-866-540-9677

  • Instant Access ImageInstant Access
    From Anywhere
  • Unlimited Viewing ImageUnlimited
    Viewing
  • calendar Image 6-12 Months
    To Complete

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.

Learning Objectives
  • 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
  • Audience

Get the latest industry news, recommended courses, & promotions from TrainUp.com sent straight to your inbox.