Microsoft Excel Tutorial: Copilot In OneDrive Versus Copilot In Excel for Excel Workbooks

In today’s video, we’re diving into Copilot in OneDrive and how it handles analyzing an Excel workbook.

But first, let’s settle a little controversy that popped up about my “Spreadsheets are my Jam” coffee mugs. Take my survey to let me know if you carry your coffee mug in your dominant hand or not.

Now, let’s get back to Excel. Remember that awesome trick from Dr. Nitin, where he used Copilot in Word to analyze financial statements? Well, I decided to throw a regular Excel file at Copilot in OneDrive to see how it performs. Spoiler alert: it didn’t do much math. It mostly reworded the data into sentences without doing many calculations. Out of the entire analysis, only two numbers were actually divided!

In the original cut of this video, I spent eight minutes testing Copilot in OneDrive with various questions and showing the answers were always wrong. I won’t bore you with all that, but let me show you one example. I asked it to find all records for the customer “MySpreadsheetLab” and sum the revenue column. The answers it gave were clearly wrong, as I could easily see the total was higher than what it calculated.

So, back in video #2652, I said that Copilot in OneDrive was better than Copilot in Excel at analyzing files—turns out, that was just a party trick! With Copilot in Excel, especially now that it can run Python, you get far more accurate and detailed analysis. For instance, I asked it to summarize sales by customer and year, highlighting where sales increased. No way could Copilot in OneDrive handle that.

To wrap things up, Copilot in Excel is way ahead when it comes to complex data analysis, especially with Python in the mix. If you’re doing anything beyond basic data summaries, stick with Excel for the heavy lifting. Be sure to check out the rest of my channel for more Excel tips and tricks! Don’t forget to subscribe and comment below about those mug names!

Buy Bill Jelen’s latest Excel book: https://www.mrexcel.com/products/latest/

Table of Contents
(0:00) Copilot in OneDrive versus Copilot in Excel
(0:14) Survey: Do you use coffee mugs in your dominant hand?
(0:36) Episode 2652 – how did Copilot in OneDrive really work?
(1:45) How does Copilot in OneDrive handle lots of math?
(2:03) Total the revenue for this one customer
(2:41) Another demo of Copilot with Excel with Python
(3:10) Wrap-up
(3:20) Spreadsheet Merch

This video answers these search terms:
Copilot in OneDrive vs Excel analysis
Excel financial analysis with Copilot
Copilot in OneDrive vs Copilot in Excel
Python in Excel for data analysis
How to use Copilot in Excel
Excel Copilot vs OneDrive Copilot performance
Automating Excel analysis with Python
Copilot financial statement analysis
Comparing Excel Copilot and OneDrive Copilot
Excel Copilot Python integration tutorial