Uploaded August 2025 | Updated September 2026, 1 week ago
$$ Requires a 365 Copilot licence at US$30 per month
microsoft.com/en-us/microsoft-365-copilot/pricing
Microsoft Excel’s new =COPILOT function might look groundbreaking at first glance—but is it really a game-changer or just clever demo material? In this video, we walk through the functionality of the beta =COPILOT formula, showcasing how it can generate dummy data, identify duplicates, and even return movie ratings with natural language prompts. But the key message is clear: don’t be fooled by the hype.
Here is real-world caution based on hands-on testing—pointing out the feature's limitations, its lack of reliability for core calculations, and warning against replacing foundational Excel functions like SUMIFS, INDEX MATCH, or COUNTIFS. Instead, =COPILOT should be seen as a potential support tool for training or quick insights, not a dependable workhorse for business-critical tasks. Whether you're an Excel newbie or a seasoned pro, this is one feature update you need to understand before you start relying on it.
🫶🏻 Join the channel to get access to perks:
youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join
🧑🏻🎓Learning Power BI?
Check out our online course
accessanalytic.thinkific.com
📗 Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World.
🌐 https://accessanalytic.com.au/
$$ Requires a 365 Copilot licence at US$30 per month
microsoft.com/en-us/microsoft-365-copilot/pricing
Microsoft Excel’s new =COPILOT function might look groundbreaking at first glance—but is it really a game-changer or just clever demo material? In this video, we walk through the functionality of the beta =COPILOT formula, showcasing how it can generate dummy data, identify duplicates, and even return movie ratings with natural language prompts. But the key message is clear: don’t be fooled by the hype.
Here is real-world caution based on hands-on testing—pointing out the feature's limitations, its lack of reliability for core calculations, and warning against replacing foundational Excel functions like SUMIFS, INDEX MATCH, or COUNTIFS. Instead, =COPILOT should be seen as a potential support tool for training or quick insights, not a dependable workhorse for business-critical tasks. Whether you're an Excel newbie or a seasoned pro, this is one feature update you need to understand before you start relying on it.
🫶🏻 Join the channel to get access to perks:
youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join
🧑🏻🎓Learning Power BI?
Check out our online course
accessanalytic.thinkific.com
📗 Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World.
🌐 https://accessanalytic.com.au/
