Sales Forecast Dashboard Generator
Sales Forecast Dashboard Generator
— Prompt —
Create an Excel spreadsheet that forecasts sales for [insert time period] across [insert number] of product categories. Include columns for historical sales, projected growth rate, seasonal adjustments, and total revenue. Visualize monthly sales trends using line and bar charts. Add filters by region and sales rep. Make the sheet dynamic with formulas that auto-update projections.
Why It Works
Combines historical and projected data for dynamic forecasting. Chart visuals aid quick interpretation, while filters make it interactive.
Example Output
A spreadsheet that auto-calculates monthly sales projections for 6 products, visualized in a line graph, with dropdowns to filter by sales region.