How to Group Excel Sales Data by Quarter Using Copilot
Question details
The user wants to analyze their Excel data by grouping and summarizing book sales by quarter using AI prompts.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Analyzing a dataset containing release dates and sales figures to generate quarterly sales totals.
- Observed behavior
- The user needs to generate a PivotTable, PivotChart, and a written summary of quarterly sales automatically using Microsoft Copilot.
Ensure your sales data is formatted as an Excel Table and that your workbook is saved to OneDrive or SharePoint, as Copilot requires this setup to access and analyze the data.
Use a Copilot Prompt to Group Data by Quarter
Use Copilot's chat interface to automatically generate a PivotTable and PivotChart summarizing your quarterly sales.
Microsoft Copilot in Excel can understand natural language prompts to perform complex data analysis, such as grouping dates into quarters and calculating sales totals.
Select the range containing your book sales and release dates, then press Ctrl+T or go to Insert > Table to format it as an Excel Table.
Click the Copilot button located on the Home tab of the Excel ribbon to open the Copilot chat pane on the right side of your screen.
In the Copilot chat box, type the following prompt: "Show sales by quarter based on the release date." Press Enter to submit the request.
Copilot will generate a written summary and a preview of the chart. Review the quarterly totals, then click the "Add to a new sheet" button to insert the generated PivotTable and PivotChart into your workbook.
Analyze Spreadsheets Seamlessly with WPS Office
If you are looking for a highly capable, free alternative to Microsoft Office, WPS Office offers powerful spreadsheet analysis tools. It features full compatibility with Microsoft Excel formats and provides an intuitive interface for creating PivotTables, charts, and performing advanced data analysis without the high subscription costs.
Frequently Asked Questions
Why is the Copilot button missing from my Excel ribbon?
The Copilot button may not appear if you do not have an active Copilot for Microsoft 365 license, your organization has restricted access, or your file is saved locally instead of on OneDrive or SharePoint.
Do I have to format my data as a table to use Copilot?
Yes, Copilot in Excel requires your data to be formatted as an official Excel Table (using Ctrl+T or Insert > Table) to accurately identify headers, analyze the dataset, and generate insights.
Can Copilot group my sales data by month instead of by quarter?
Yes. You can easily adjust your analysis by changing the prompt in the Copilot pane to: "Show sales by month based on the release date." Copilot will update the PivotTable and PivotChart accordingly.
