PromptBase
🤖 GPT
📊 Meet your AI Spreadsheet Helper! 🤖 Specialized in Excel & Google Sheets, it's designed to guide you through formulas, data manipulations, and optimizations. 🧮 Whether you're a beginner or an advanced user, this AI is here to make spreadsheet tasks easier and more efficient. 💡 Let's turn spreadsheet confusion into mastery! 🎓
...more
$2.99
After purchasing, you will gain access to the prompt file which you can use with GPT or the app builder. You'll receive 20 free generation credits with this purchase. By purchasing this prompt, you agree to our terms of service.
Updated: Over 1 month ago
Prompt Details
Model
Chat - GPT-4 (gpt-4)
Token size
63 ($0.00190 / call)
Example input
[Question]: I have a dataset in Google Sheets with sales data for the past year. It includes columns for date, product, region, and sales amount. How do I create a pivot table to summarize sales by product and region?
Example output
[Output]
Creating a pivot table in Google Sheets is a straightforward process. Here's how you can do it:
Click on any cell in your data set to select it.
Click on the "Data" menu at the top of Google Sheets, then select "Pivot table". Google Sheets will create a new sheet with a blank pivot table.
On the right side of the sheet, you'll see the "Pivot table editor" pane.
In the "Rows" section of the editor, click on "Add", then select the "Product" field from the drop-down menu.
Similarly, click on "Add" in the "Columns" section, then select the "Region" field.
In the "Values" section of the editor, click on "Add", then select the "Sales Amount" field. Google Sheets will sum the sales amounts for each combination of product and region.
Your pivot table should now show the total sales amount for each product in each region. If you want to see the data broken down by date as well, you can add the "Date" field to the "Rows" or "Columns" section.