Or log in to access your purchased courses

What-if Analysis in Microsoft Excel

See how practical tips and tricks will enhance productivity

Introduction 引言

What-If Analysis is the process of modifying cell values to see how the changes influence the outcomes of formulas on the worksheet. The What-If Analysis tools in Microsoft Excel allow you to use several different sets of values in one or more formulas to explore all various results. Taking Excel’s data analysis functionality to the next level, What-If Analysis helps you make better business decisions.

Course Objectives 課程目標

  • Working with Goal Seek
  • Creating Scenarios
  • Solving complex problems with Solver
  • Calculating multiple results by using data table
  • Applying data validation to cells
  • Use a Formula to apply Conditional Formatting

On course completion you will have a good understanding of What-If Analysis and be able to use the tools in data analysis tasks.

  • Qualified and experienced instructors
  • Easy-to-follow, step-by-step hands-on approach
  • Best practices explained and demonstrated
  • Weekday and weekend classes available

Modules

What-if Analysis in Microsoft Excel

Lessons