Build an Excel PivotTable Revenue Report
Learn to analyze monthly revenue by product or region using sample records in Excel. Follow guided steps to calculate revenue, build and configure a PivotTable, create a chart, and check your understanding
Prompt template
- Format
- Text Parameterized
- Inputs
- Dimension (text) · Required Excel_version (text) · Required
- Outputs
- Guided_pivottable_lesson (text)
Teach me how to analyze monthly revenue by ${dimension} in ${excel-version}. Generate 25 sample records with dates, products, regions, units, and prices. Guide me through calculating revenue, building a PivotTable, grouping dates, and creating a chart. Pause after each step and test my understanding.
Replace the ${…} placeholders with your values
before using this prompt. See parameters
and defaults below
Parameters
Replace each placeholder with your own value, or use its default when one is provided
${dimension}
dimension
Required
${excel-version}
excel-version
Required
What you'll create
This prompt creates a guided Excel lesson for analyzing monthly revenue by a chosen dimension, such as product or region. It includes 25 sample records and pauses after each step to test understanding
Usage instructions
Frequently asked questions
Can I analyze revenue by product or by region?
Yes. Choose either product or region as the dimension for the monthly revenue analysis
What does the lesson cover after calculating revenue?
It guides you through building a PivotTable, grouping dates, and creating a chart
Comments
Tried this prompt? Share what you made, compare results, or ask a question