When someone wants to know what grade he or she needs on the final exam to pass the class, Excel's What-If Analysis feature helps figure it out. With the 27th and final installment from the Microsoft Excel 2016 video series, scholars learn how to use What-If Analysis to fill in missing information based on available data. Additionally, viewers learn how to use GoalSeek to find unknown values in a worksheet.

Concepts

basic computer skills, computer software, microsoft excel, spreadsheet skills, technology resources

Show More Show Less

Instructional Ideas

• Have individuals write a list of different ways to use What-If Analysis and GoalSeek

Classroom Considerations

• Requires a projector and speakers or headphones and a computer for each student 
• Content is information-heavy; pupils may need to view more than once

• This video is hosted on YouTube

Pros

• Provides a text lesson resource
• Clear and easy to understand
  

Cons

• None

Common Core

SL.9-10.3 SL.11-12.3