Welcome to Nonprofit.Courses

Live Event Calendar

When’s the next webinar or podcast or conference?

Here’s where you find out – and more.

Loading Events

« All Events

  • This event has passed.

Utilizing What-If Data Analysis in Microsoft® Excel®

January 21 @ 1:00 PM - 2:00 PM EST

$99
Lorman Logo

Learn about the what-if analysis tools available, including scenarios, data tables, and goal seek.

 

Reviewing different values to observe variation in results is a common task in analysis. Scenarios, data tables, and goal seek are the most popular. These What-If analyses help us predict outcomes more accurately. Seeing different scenarios and their potential outcomes determines the effect of decisions and problem-solving. Like scenarios, data tables help you explore a set of possible outcomes and show you all the outcomes in one table. Goal Seek will tell you what you need to do to achieve the target. By learning formulas and dropdowns, we can create a what-if analysis, and by putting in values and making scenarios such as best, base, and worst-case scenario, we can accomplish our goal.

 

Learning Objectives

  • You will be able to describe a process to show scenarios such as best case, expected case, and worst case.
  • You will be able to explain the what-if analysis tools including scenarios, data tables, and goal seek.
  • You will be able to identify the use of solver and arrays.
  • You will be able to discuss how analysis helps us to make better decisions.

Venue

On Your Computer, Phone or Tablet

Organizer

Lorman
View Organizer Website

Questions or Corrections? Contact us by Clicking Here.

Want to Post an Event?

Go HERE for Single Day Events.

Go HERE for Multi-Day Events.

Exciting New Content Upcoming Live Events Special Offers & More!
Don't miss out! Get Weekly Alerts on ...
Stay up to date
Don't miss out on the latest Content & Events!
0
Would love your thoughts, please comment.x
()
x