Forum Discussion
EricPatterson
Microsoft
MicrosoftQuickly estimate sales data using Copilot in Excel
Hi everyone, over the last few weeks we have had a series of posts to show you some of the things that are possible to do with Copilot in Excel. We have transitioned from daily to weekly and we are posting on the Excel blog (https://aka.ms/xlblog).
This week's example shows how to estimate book sales for the rest of the fiscal year, starting with this table:
Table of book sales by Category (Biography, Children’s, Comic, Crime Fiction, Youth Fiction) including columns for Category, FYFY24Q1, FY24Q2, FY24Q3, FY24Q4, FY25Q1)
and resulting in this:
Table of book sales by Category with new columns for FY25Q2, FY25Q3, and FY25Q4
To read how to use Copilot to do this, click here: Quickly estimate sales data using Copilot in Excel
Stay Tuned,
Microsoft Excel Team
2 Replies
Start by ensuring your sales data table is clearly organized in Excel. For instance, you might have columns for Month/Date, Book Title, Units Sold, Revenue, and any other relevant metrics.
It sounds like you're diving into Excel's Copilot feature to analyze some sales data, specifically for estimating book sales! Copilot can really streamline this process, so here’s a quick guide on how you might go about estimating sales data using Copilot in Excel, based on the context you've given.
