Curated and Reviewed by
Lesson Planet
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.
3 Views
5 Downloads
CCSS:
Adaptable
Concepts
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