Is Excel still the undisputed king of the spreadsheet world, or has Google Sheets finally taken the crown? In this episode of the M365 Show, we sit down with Microsoft MVP and stand-up comedian David Benaim to settle the debate once and for all. Whether you are a data scientist or someone who just wants to organize a grocery list, this deep dive covers everything you need to know about the tools we use every day.

We explore the fascinating history of spreadsheets, from the days of Lotus 1-2-3 to the modern era of AI-driven data analysis. David shares his unique journey from being a professional accountant in Cambodia to performing sold-out comedy shows about pivot tables at the Edinburgh Fringe. We break down the technical differences between Excel and Google Sheets, discussing why Power Query remains a game-changer for Microsoft users while Google continues to lead the way in seamless, bug-free collaboration.

You will also learn about the latest AI innovations, including Microsoft Copilot and Google Gemini, and how they are automating mass data research. David explains why he believes spreadsheets will never die and shares the number one habit every professional should adopt today to save hours of manual work. Plus, stay tuned for a look at the famous 1900 date bug that Excel still has not fixed after four decades!

The m365.fm Podcast is also on:
Apple Podcasts:https://podcasts.apple.com/us/podcast/can-google-sheets-beat-excel-microsoft-mvp-david-benaim/id1810175174?i=1000775966815
Spotify: https://open.spotify.com/episode/1uqIAswnnhRzC3Ja1oE3ij

Chapters

0:00 Intro and Meeting the Excel Comedian
3:15 From Accounting to Stand-up Comedy
7:50 The 40 Year History of Excel
11:20 Is Excel Dead? The Future of Data
14:45 Why Google Sheets is Underestimated
18:30 The Power of Tables and Grouping
22:15 Why Power Query is a Game Changer
25:45 New Competitors: Canva and Zoom Sheets
29:00 The Truth About Real-time Collaboration
33:15 AI Showdown: Copilot vs. Gemini
37:30 Python Integration and Advanced Functions
41:00 Coding for Spreadsheets: VBA vs. Apps Script
44:15 Power BI and the Business Intelligence World
47:30 The Funniest Spreadsheet Mistakes and Bugs
50:00 Rapid Fire Round and Final Tips
52:00 Where to Connect with David Benaim

If you found these insights helpful, please subscribe to the channel and hit the notification bell for more M365 strategy. Which side are you on? Let us know in the comments if you prefer the robust power of Excel or the flexibility of Google Sheets!

#Excel #GoogleSheets #DataAnalytics #M365 #Spreadsheets