Excel Analysis Data & Analysis
Prompts
-
Sales Report From a Raw Export: Pivot Plan
Plan the pivots before building them.
-
Monthly Variance Analysis Workbook
Explain budget versus actual differences.
-
RFM Customer Segmentation in Excel
Score customers by recency, frequency and monetary value.
-
Break-Even Analysis Workbook
Model fixed costs, variable costs and volume.
-
What-If Scenario Tables in Excel
Test assumptions systematically.
-
Cleaning a Messy Export Before Analysis
Create a repeatable clean-up sequence.
-
Cash Flow Forecast Workbook
Plan 13 weeks of inflows and outflows.
-
Pareto 80/20 Analysis in Excel
Find the few categories that cause most of the result.
-
Seasonality Index From Monthly History
Measure normal highs and lows by month.
-
Survey Cross-Tabulation in Excel
Compare groups with percentages and caution.
-
Discount Impact Analysis
Check whether a promotion actually paid.
-
Headcount and Attrition Analysis
Understand turnover with careful definitions.
-
Budget Versus Actual Dashboard Plan
Plan a one-page management view.
-
Outlier Detection Methods in Excel
Spot unusual values and decide what to do.
-
Linear Trend Forecast With Honest Caveats
Project a simple trend and state its limits.
No prompts match those filters.