How to Analyze Bike Sales Data with Copilot in Excel
Question details
The user wants to learn how to utilize Copilot in Excel to analyze a dataset of bike sales, generate charts, compare ratings, and create PivotTables.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Analyzing and visualizing structured sales data using AI prompts to easily extract business insights without manual charting.
- Observed behavior
- The user needs a step-by-step guide on formatting the data and prompting Copilot to generate the required charts and PivotTables.
Ensure your bike sales workbook is saved to OneDrive or SharePoint, formatted as an official Excel Table, and that you have an active Microsoft 365 Copilot license.
Use Copilot to Analyze and Chart Bike Sales
Format your data properly and use the Copilot chat pane to generate instant insights, charts, and PivotTables via natural language prompts.
To get the best results from Copilot in Excel, your data must be structured clearly with defined column headers. Copilot relies on these headers to understand the context of your requests.
Select your entire bike sales dataset, navigate to the 'Insert' tab, and click 'Table' (or press Ctrl+T). Ensure your columns have clear headers like Year, Category, Product, Sales, and Rating.
Click the 'Copilot' button located on the right side of the 'Home' tab in the Excel ribbon.
In the Copilot chat box, type a prompt such as 'Chart product ratings by year' and press Enter. Copilot will generate a visual representation that you can insert into your workbook.
Ask more specific follow-up questions to drill down into the data, such as 'Show ratings by year and product for the Bikes category'.
Instruct Copilot to 'Add a PivotTable and chart to a new worksheet summarizing bike sales by year' to dynamically organize and aggregate your data.
Analyze Sales Data Effortlessly with WPS Office
Use WPS Spreadsheet's built-in advanced tools and AI capabilities to analyze your bike sales data, generate instant charts, and gain business insights without needing an expensive Microsoft 365 Copilot subscription.
- 1. Open your sales data: Launch WPS Spreadsheets and open your .xlsx bike sales dataset.
- 2. Activate WPS AI: Click the 'WPS AI' button on the ribbon to open the intelligent assistant pane.
- 3. Ask for insights: Type your request in the chat box, such as 'Analyze sales trends by year' or 'Write a formula to average product ratings'.
- 4. Apply PivotTables: Use the 'Insert' tab to quickly add PivotTables for manual but powerful data summarization.
Frequently Asked Questions
Why is the Copilot button missing in my Excel ribbon?
The Copilot button may be missing if you do not have a qualifying Microsoft 365 Copilot license, if your organization's IT admin has disabled it, or if your Excel file is not saved to a cloud location like OneDrive or SharePoint.
Does my sales data need to be in a specific format for Copilot?
Yes, Copilot in Excel currently requires your data to be formatted as an official Excel Table (Insert > Table). It cannot analyze raw data ranges effectively.
Can Copilot create PivotTables automatically from my data?
Yes, you can ask Copilot in the chat pane to create a PivotTable summarizing specific metrics, such as sales by category, and it will generate the table in a new worksheet for you.
What kinds of prompts work best for data analysis in Excel?
Clear and specific prompts work best. Mention exact column headers, such as 'Compare Sales by Product Category for 2023' or 'Highlight the top 5 products by Rating'.
