Course Content
Getting Started with Microsoft Excel
Getting Started with Microsoft Excel
0/2
Basic Workbook Operations
Basic Workbook Operations
0/2
Formulas and Functions
Formulas and Functions
0/3
Data Analysis Tools
Data Analysis Tools
0/3
Creating Charts and Graphs
Creating Charts and Graphs
0/2
Advanced Excel Features
Advanced Excel Features
0/3
Collaborating and Sharing Workbooks
Collaborating and Sharing Workbooks
0/3
Microsoft Excel Course
About Lesson

What-If Analysis

  • Using Goal Seek: Click ‘What-If Analysis’ in the Data tab, choose ‘Goal Seek’, and set the target value, the changing cell, and the cell to achieve the target.
  • Using Data Tables: Create one-variable or two-variable data tables to see how changing input values affect the output.