Microsoft Copilot - Excel has forever changed

Courses for Data Nerds
==================================

Books for Data Nerds
==================================

Tech for Data Nerds
==================================

Social Media / Contact Me
======================

As an Amazon, Coursera, and Parallels Affiliate Programs member, I earn a commission from qualifying purchases on the links above. It costs you nothing but helps me with content creation.

#datanerd #dataanalyst #datascience

[jeremybyington]

“Hey, Copilot, I’m late to the meeting. Did anyone mention me?”

“Yes, John said ‘Surprise! Jeremy is late again. Man, that guy needs to go.’ and Karen said ‘Keep this between us, but Sue in HR has already got the paperwork ready and they are just waiting on him to finish his current task so we don’t get screwed over.’”

[salihovic]

Interesting insights on co-pilot! The potential for automating tasks in Microsoft apps is promising. However, the data limitations in Excel and the need for cloud storage are notable drawbacks. Looking forward to seeing how co-pilot evolves in future versions. 👍

[sanakhvi]

"Excel has forever changed"

Video : "i'm disappointed it doesn't work"

[omf-tor]

I’ve had the same experience using Copilot in Excel. Copilot in Teams meetings is probably the most capable at this time.

[TheMasatosan]

Thanks Luke. Have been watching your videos. Very good work.

[sammito_]

6:12 the reason why it didn’t generate a response, it’s likely due to you overflowing its context window. For LLMs such as GPT-4, the context window is similar to a computer’s RAM —in the sense that they act similarly—. This context window is measured in “tokens”. GPT-4 has 8K, 32K and 128K tokens. Not sure which model you’re using with co-pilot but 8K is about 20 pages of text, 32K is about 75 pages of text and 128K is about 300 pages of text. That’s for one whole interaction. And the models at any given case can only generate about 4K tokens worth of a response, that also counts against your context window.

[danquixote]

Thanks Luke, great info as usual. I'd be so dissapointed if I had forked out $20 for CoPilot and it wasn't able to analyse my data and actually cost me time rather than saved me time. It's going to be great - just not yet. Very glad to see it will be available for Mac though.

[skemsen]

I just discovered your channel now and I'm really liking your style 🤓

[thilotrost]

Thank you for the analysis Luke, wanted to try it out myself and this saved me a lot of time.

[rp]

Changed forever? Not quite. I’ve been using it for months and I can assure you it is completely overhyped. I’m sure it’ll improve over time, but has a way to go.

[mikeyj]

This vid had me cracking up. Thank you for this summary.

[ufsduuq]

Appreciate the honest and transparent work. Saves me a lot of time.

[davidtowers]

Great video as usual - all my questions answered without having to spend hours playing around myself.

[cvanzyl]

That was an AWESOME video, practical, engaging with great real world data and humor, thanks man! !!

[stephenfulford]

Good to have confirmation it's not just me that found the excel functionality very limited. It seems like a dream come true, on paper, but then I found I could get whatever insights I want faster manually most of the time.

[bt]

Thank you for this, not enough videos showing capabilities and drawbacks out there.

[danilocorreia]

I mean, you have a data with 40k rows you might as well use Python or R to make your analysis. Excel and any sheets app is only capable of performing well until certain point.

[marlinhicks]

Great video! I wanted to ask how you went about collecting, organizing and maintaining the job data.

[JesusDiaz-yccs]

Well I'm officially obsolete, all hail our new Excel overlord Copilot!

[m.w.]

Great vid again, so nice to see the latest news explained like this, this way you know what to subscribe to or better wait a while (or forget about it) but hoping copilot is gonna work because of it’s MS connection