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: MrExcel 2024 Igniting Excel
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
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: MrExcel 2024 Igniting Excel
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
Transcript of the video:
Down below the video, if you click “Like”, that'll make sure that YouTube shows this video to more people – Thanks!
Alright, now let's take a look at Copilot in OneDrive analyzing an Excel workbook.
But first, quite the controversy yesterday. These mugs that I'm selling, I offer the left-handed version with the message “Spreadsheets are my Jam” facing out for people that use the mug in their right hand. But I get a lot of pushback saying that's not how it works. So I have a quick little survey out here.
We've had 34 answers so far. 23 out 34 people are using the mug in their dominant hand. Six have no preference.
I'm trying to figure out how to name these - Left-handed, right-handed mugs.
Remember a few days ago this amazing trick from Dr. Nitin where he took Excel financial statements and then Copilot, in his case in Word, in my case, in OneDrive produced perfect analysis.
So I'm like, Hey, if copilot in OneDrive is better than the Copilot in Excel, let's throw a regular Excel file at it. But hey, not so fast there, Sparky.
Let's take a look at what was really happening. When I gave it this financial statement. And it gave me all of these words.
It wasn't doing many calculations. In the most part, it was just understanding that Net Operating Revenues were important. This is the current year, previous year, and the year before that. And it restated that into a sentence.
Out of this whole analysis that it gave me. The only two calculations that did is one number divided by one other number in two cases. Everything else is just repeating what's found here. So while it looked really impressive when I saw it. There's not a lot of math that's happening.
And it seems to be that Copilot in OneDrive is really bad at doing a lot of math.
In the original version of this video, there was eight minutes of me asking Copilot in OneDrive various questions about this file. Getting an answer, and then coming back and creating a pivot table to show that the answer was completely wrong.
I'm going to skip most of that. Here's one quick example.
Find all records for the customer, MySpreadsheetLab, and sum the revenue column.
All right? Just, I mean, look at these general answers here.
I mean, adding them up in my head. They are clearly above 47,640.
So, hey, back in video 2652 when I said that Copilot in OneDrive was better at analyzing Excel files and Copilot in Excel. Well, that was a party trick.
Now that we have this advanced analysis that runs Python.
Here's an amazing chart where I said, “Hey, take this data, summarize it by customer and year and show me all of the customers where they bought more this year than last year.” I never would've been able to get to that in Copilot in OneDrive because it couldn't even add up the revenue for one customer. And here in Copilot in Excel, we get a whole program written in Python. Clearly this is running circles around Copilot in OneDrive when you have any kind of detailed analysis.
Hey, I want to thank you for stopping by. We'll see you next time for another net cast from MrExcel. Just below the video, click this store icon.
We have a whole bunch of new mugs and shirts professionally designed, all kinds of great fun slogans for you or your favorite Exceller. If you like these videos, please down below, Like, Subscribe, and Ring the Bell. Feel free to post any questions or comments down in the comments below.
Alright, now let's take a look at Copilot in OneDrive analyzing an Excel workbook.
But first, quite the controversy yesterday. These mugs that I'm selling, I offer the left-handed version with the message “Spreadsheets are my Jam” facing out for people that use the mug in their right hand. But I get a lot of pushback saying that's not how it works. So I have a quick little survey out here.
We've had 34 answers so far. 23 out 34 people are using the mug in their dominant hand. Six have no preference.
I'm trying to figure out how to name these - Left-handed, right-handed mugs.
Remember a few days ago this amazing trick from Dr. Nitin where he took Excel financial statements and then Copilot, in his case in Word, in my case, in OneDrive produced perfect analysis.
So I'm like, Hey, if copilot in OneDrive is better than the Copilot in Excel, let's throw a regular Excel file at it. But hey, not so fast there, Sparky.
Let's take a look at what was really happening. When I gave it this financial statement. And it gave me all of these words.
It wasn't doing many calculations. In the most part, it was just understanding that Net Operating Revenues were important. This is the current year, previous year, and the year before that. And it restated that into a sentence.
Out of this whole analysis that it gave me. The only two calculations that did is one number divided by one other number in two cases. Everything else is just repeating what's found here. So while it looked really impressive when I saw it. There's not a lot of math that's happening.
And it seems to be that Copilot in OneDrive is really bad at doing a lot of math.
In the original version of this video, there was eight minutes of me asking Copilot in OneDrive various questions about this file. Getting an answer, and then coming back and creating a pivot table to show that the answer was completely wrong.
I'm going to skip most of that. Here's one quick example.
Find all records for the customer, MySpreadsheetLab, and sum the revenue column.
All right? Just, I mean, look at these general answers here.
I mean, adding them up in my head. They are clearly above 47,640.
So, hey, back in video 2652 when I said that Copilot in OneDrive was better at analyzing Excel files and Copilot in Excel. Well, that was a party trick.
Now that we have this advanced analysis that runs Python.
Here's an amazing chart where I said, “Hey, take this data, summarize it by customer and year and show me all of the customers where they bought more this year than last year.” I never would've been able to get to that in Copilot in OneDrive because it couldn't even add up the revenue for one customer. And here in Copilot in Excel, we get a whole program written in Python. Clearly this is running circles around Copilot in OneDrive when you have any kind of detailed analysis.
Hey, I want to thank you for stopping by. We'll see you next time for another net cast from MrExcel. Just below the video, click this store icon.
We have a whole bunch of new mugs and shirts professionally designed, all kinds of great fun slogans for you or your favorite Exceller. If you like these videos, please down below, Like, Subscribe, and Ring the Bell. Feel free to post any questions or comments down in the comments below.
