File Name
Forecast_Sheet_Practice.xlsx
Historical Sales Data
|
Month |
Sales |
|
Jan-26 |
40000 |
|
Feb-26 |
42000 |
|
Mar-26 |
45000 |
|
Apr-26 |
47000 |
|
May-26 |
50000 |
|
Jun-26 |
53000 |
|
Jul-26 |
55000 |
|
Aug-26 |
58000 |
|
Sep-26 |
60000 |
|
Oct-26 |
64000 |
|
Nov-26 |
67000 |
|
Dec-26 |
72000 |
Tasks
Task 1 — Prepare Data
Ensure:
- Dates are valid Excel dates.
- Data is sorted chronologically.
- Sales values are numeric.
Task 2 — Create Forecast
Use:
Data → Forecast Sheet
Set the forecast end date to:
30-Jun-2027
Task 3 — Review Forecast
Analyze:
- Forecast values
- Upper confidence boundary
- Lower confidence boundary
- Overall trend
Task 4 — Create Forecast Report
Include:
- Historical Sales
- Forecast Sales
- Forecast Chart
- Confidence Interval
- Short analysis
Final Challenge
Create a 12-Month Sales Forecast Report containing:
Historical Data
January–December 2026
Forecast
January–June 2027
Report Sections
- Historical Sales Table
- Forecast Table
- Forecast Chart
- Upper Confidence Boundary
- Lower Confidence Boundary
- Sales Trend Analysis
- Business Planning Notes