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.
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.
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