
Using What If Analysis to Forecast Profits Based on Sales Values in Excel
The video explains how to use different what-if analysis tools in Excel to forecast profits based on historical data and sales values. The tools used in this video include Scenario Manager, Goal Seek, Data Table, and Forecast Sheet. The video starts by creating a new column and using the average formula to calculate the average…