My Shopping Cart
There are no items in your shopping cart.

Excel 2013: Working with Excel's What-If tools - IF Function, Goal Seek, Scenario Manager, Solver, and More! (IME261B)

Presented By : Dennis Taylor
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Webinar
60 minutes
  •  Wed, February 17, 2016
Event Description
See the sneak peek before you buy!
1.0 CPE

Using Excel's What-If Tools to Manage Dynamic Data

Whenever you want to explore the impact of using different variables when analyzing data, you need to have Excel tools that allow you to work with dynamic data. These techniques range from using IF functions (extended via nesting and the use of AND and OR functions) to Goal Seek, Scenario Manager, and a sophisticated mathematical modeling tool - the Excel add-in called Solver.

Explore these various features in this webinar with expert speaker Dennis Taylor. Learn how to use the What-If tools and a powerful set of techniques for solving a variety of what-if questions.

This webinar will demonstrate multiple examples of using the IF function - as a stand-alone feature, in a nested variation, and in combination with the AND, OR, and NOT functions. The Goal Feature will show users how to come up with a different answer for a formula based on changing a formula component. Solver (a much more sophisticated version of Goal Seek) will be demonstrated with three variables. Viewers will also see how Scenario Manager will let them store alternate scenarios in the same worksheet.

Session Highlights:

  • IF function - used in a variety of ways, including nesting (multiple IFS) and with the AND, OR, and NOT functions
  • Goal Seek - "work backward" with a formula so that you can get a different answer based on changing one of a formula's components - you set up the goal and Excel reworks the formula.
  • Data Table - easily create a grid of solutions based on two variables.
  • Scenario Manager - create multiple scenarios in the same worksheet; easily view different outcomes.
  • Solver - attain a goal based on multiple cells undergoing changes based on upper/lower constraints.

Who Should Attend

Any Excel user who works with dynamic data and seeks potentially multiple answers based on changing variables will benefit from this webinar.

About Our Speaker(s)

Dennis Taylor, Microsoft Excel Training ExpertDennis Taylor
Dennis Taylor has taught thousands of Excel seminars and classes since the early 90's, is the author/presenter of over 250 Excel webinars, and authored the book Teach Yourself Microsoft Excel 2000. He has taught hundreds of public Excel seminars in the US and Canada since 2006 and has recorded over 100 Excel courses bo... More info

Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
    Subject: You might be interested in this event from AudioSolutionz
    Event Title: Excel 2013: Working with Excel's What-If tools - IF Function, Goal Seek, Scenario Manager, Solver, and More!
    Presenter(s): Dennis Taylor Protection Status