Five Ways M365 Copilot Helps Buyers Work Faster and Smarter in Excel

Microsoft’s M365 Copilot is built directly into Excel.  You must have a Microsoft 365 Enterprise subscription, as well as an additional M365 Copilot subscription, but its ability to handle so many of the Excel tasks buyers are tasked with is well worth it. 

It also comes with enterprise-grade data security, meaning you can use your company’s data safely within the Microsoft ecosystem. 

For manufacturing buyers, Copilot can quickly become one of the most useful digital assistants in your toolkit.

From within Excel workbooks, you can type (or speak) natural-language prompts in the Copilot pane – such as asking it to summarize data, create charts, or write formulas – and Copilot will work with the data in the open Excel file. 

Here are five practical ways buyers can use M365 Copilot in Excel. 

1. Data Analysis and Insights 

Copilot can instantly summarize procurement trends, supplier performance, and spend patterns. What used to take hours of pivot tables and filters can now be done with a single prompt. 

Example: Type “Analyze monthly raw material costs by supplier and highlight those with more than a 10% increase.”

Copilot scans the data in the open worksheet and returns a short explanation with tables or charts showing where costs are climbing. Buyers can then focus on root causes and corrective action instead of manual analysis. 

This is especially powerful during quarterly business reviews. You can ask Copilot to identify the top five cost drivers or suppliers that improved delivery performance. The insights appear instantly, ready for inclusion in a presentation. 

2. Data Visualization 

Copilot can create professional charts and graphs using plain language. No need to click through menus or tweak chart options.  

Example: “Create a bar chart showing the top 5 suppliers by total annual spend.”

Copilot generates the visual, applies consistent formatting, and labels it clearly. You can then ask it using natural language to adjust titles, change chart types, or add trend lines. 

For purchasing teams presenting savings updates or spend analyses, this feature helps transform raw data into visuals that executives can understand at a glance. 

3. Formula and Calculation Assistance 

Writing complex formulas can be slow and error-prone. Copilot can generate them for you or explain what existing ones do.  

Example: “Calculate the average unit cost across multiple suppliers and flag any above the mean.”

Copilot builds the formula, applies it, and can even color-code the results. It understands functions like VLOOKUP, INDEX-MATCH, and SUMIFS, so you don’t have to memorize syntax. 

This makes it easier for buyers to model cost scenarios, validate supplier quotes, or compare bids without worrying about formula errors. 

4. Data Cleaning and Organization 

Procurement data often comes from different systems and suppliers. That means inconsistent formatting, duplicate names, and merged text fields. Copilot can clean that up fast.  

Example: “Split ‘Item Description’ into ‘Category’ and ‘Subcategory,’ and remove duplicates.”

In seconds, it organizes the data into usable fields. 

Clean data means fewer mistakes in spend analysis and faster turnaround when management needs reports. 

5. Automation and Macros 

Repetitive monthly reporting tasks can be automated using Copilot without writing VBA code.  

Example: “Create a macro to generate a monthly purchase summary by commodity and supplier.”

Once recorded, you can trigger it anytime. 

Automating routine work frees buyers to focus on value-added activities such as supplier development, negotiations, and strategy. 

Conclusion

M365 Copilot in Excel changes how purchasing teams use data. It brings the speed and intelligence of AI directly into the tool buyers already use daily.

With strong data protection, natural-language interaction, and automation built in, Copilot helps buyers spend less time preparing spreadsheets and more time making better decisions.  

APD offers a wide range of insightful resources, including expert-led training, on-demand webinars, and blogs on leveraging AI for purchasing!