MS Excel Toronto - Google Sheets vs Excel - Cool features in one but not the other - David Benaim

Session recorded live on March 2, 2021

The MS Excel Toronto Meetup group is organized by

-----------------------
About this session:

Many think Google Sheets is a less advanced tool than Excel with better collaboration options. But in 2021, Google Sheets actually does many things much better than Excel. Data validation, spreadsheet protection, auto-refreshable Pivot Tables, extra functions and much more flexibility in dynamic arrays are examples where Google Sheets outperforms Excel.

On the other hand, Excel has great features not available in Google Sheets. XLOOKUP, Flash fill, Power Query and AGGREGATE are some examples.

While Google Sheets started as an online replica of Excel, Excel also replicated some of Google Sheets’ most loved features in recent years, such as comments and coauthoring. Come join in on the fun and vote for which app performs better at which task!

---------------------
About the Speaker: David Benaim

David Benaim has been Running a data analytics firm in Cambodia since 2013. He has worked with over 100 organizations and provided MS Office training for 2000+ participants in Excel, Power BI, presentation skills & email management. David was recently given the prestigious Microsoft MVP award for Excel. David is also a paid written & video blog author for UK’s chartered accounting institute focusing on being on the cutting edge of the new & exciting features and has a YouTube channel with over 100 how-to videos on business tech (Power BI, Excel, Zoom, Google Sheets, PowerPoint).

Find more about David's work and connect with him:

-----------------------

[ExcelOffTheGrid]

Celia - Thanks for the shout-out :-)

It's been 7+ years since I've used Google Sheets. At the time, I found the differences to Excel quite frustrating but looks like there are some good features in there.

Thanks for sharing David.

[wayneedmondson]

Hi Celia. Thanks for posting this! Was great to be able to view the session replay, since I missed the live event. Awesome content from David Benaim! As always, many thanks for all the opportunities to learn at your channel :)) Thumbs up!!

[wisecatnoroboris]

Thank you, as my two favorite software :) it was very interesting