Microsoft Excel: Using What-If Analysis-When, Why, and How 2018

  • 12 Oct 2018
  • Webinar

Description

Microsoft Excel: Using What-If Analysis-When, Why, and How 2018 is an event dedicated to training on Excel What-If Analysis. Learn about Excel Scenario Manager, Excel Data Menu, Excel Data Table, Excel Solver.

Microsoft Excel: Using What-If Analysis-When, Why, and How 2018 covers topics such as:

  • Consider one approach for working around the 32-input limit built into Scenario Manager.
  • Avoid writing repetitive formulas with Excel’s Data Table feature.
  • Gain an understanding of Excel’s Goal Seek feature, which is useful in simplifying what-if analyses.
  • Explore Excel’s Scenario Manager feature that enables you to store various sets of inputs, such as best case, worst case, and most likely, but without having to replicate worksheets or workbooks.
  • Merge scenarios from other workbooks into your present workbook.
  • Get a basic introduction to Excel’s Solver feature.
  • See how to save Solver results to Excel’s Scenario Manager for reuse.
  • See how to enable Excel’s Solver Add-in for more complex what-if analyses.
  • Use the Summary Report aspect of Scenario Manager to compare different scenarios side by side.
  • Use the FORECAST function in Excel 2016 to extrapolate trends based on existing data in your spreadsheets.

Microsoft Excel: Using What-If Analysis-When, Why, and How 2018 intended for:

  • Marketing and Management Consultants
  • CPAs and Accountants
  • CFOs
  • Bankers
  • Financial Planners and Consultants
  • Controllers
  • Business Analysts
  • Business Professionals
  • Human Resources Staff
  • Bookkeepers

Past Events

Important

Please, check "Microsoft Excel: Using What-If Analysis-When, Why, and How" official website for possible changes, before making any traveling arrangements

Event Categories

Business: Finance, Human Resources (HR), Management, Operations
Technology: Software & Applications

Other Events with Similar Categories

Other Events with Similar Location or Organizer

Featured Conferences & Exhibitions