Register Online - Add to Cart

Credits

Sponsored by Lorman Education
Only registered attendee will receive continuing education credit.
Product ID: 404503
 
Credit & Course Provided by:

Utilizing "What If" Data Analysis in Microsoft® Excel®

Live Webinar
October 30, 2018
1:00 pm ET (12 pm CT, 11 am MT, 10 am PT)
1 hour 30 minutes
Live Webinar$99Register Now
Can't Attend?   Audio & Reference Manual$99Add to Cart

Learn several important features of Excel® that comprise a powerful set of techniques that can assist you solve a variety of what-if-questions.

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 sophisticated mathematical models such as those found in the Excel® add-in called Solver. An easy-to-use feature called Goal Seek allows you to ‘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. With a Data Table, you can easily create a grid of solutions based on two variables. Scenario Manager lets you create multiple scenarios within the same worksheet and a way to easily view different outcomes. The Solver add-in feature allows you to attain a goal based on multiple cells undergoing changes based on upper and lower constraints. These various features comprise a powerful set of techniques for solving a variety of what-if questions.

Learning Objectives

  • You will be able to review Excel®'s PMT function to make a monthly payment calculation match a goal.
  • You will be able to identify and set up multiple scenarios for fluctuating numbers.
  • You will be able to define and expand by using nested IFs.
  • You will be able to describe and create sophisticated models based on many different cells changing within constraints.

Registration

Live Webinar$99Register Now
Can't Attend?   Audio & Reference Manual$99Add to Cart