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

aicreatormentor Republished on Nov 16 0 Bookmarks 0 Copies
Bookmark 0

Prompt template

Usage instructions
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

Provide your Excel version and choose whether to analyze by product or region. That choice determines the report dimension; the prompt still covers revenue calculation, date grouping, a PivotTable, and a chart

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

Up to 4 results. Images up to 2 MB; MP4, WebM, or MOV videos up to 4 MB each