Join London's financial modelling community to hear from David Benaim, data scientist and Excel training specialist. Since unlocking the power of Google Sheets earlier this year, many of the spreadsheet solutions David creates relies on both mediums to do different things. Google sheets has some mind blowing functionality that will shock even the most advanced Excel users. Most think Google’s only advantage is collaboration, but that is so far from the case. Google does data validation, commenting and protection much better than Excel, not to mention it has an entirely new class of functions (filter functions) that acts like a query tool returning a range of values dynamically. On the flip side, modern Excel has some great things that google doesn’t.
This talk is applicable to daily users of Excel and Google Sheets at any level. Here's an article David recently wrote for ICAEW on the subject: https://ion.icaew.com/itcounts/b/weblog/posts/excel-tip-of-the-week-240---6-things-google-sheets-does-better-than-excel
We will also discuss the revolutionary new “Dynamic Array” functionality (already existent in Google Sheets) that is coming to Excel.

Danielle Stein Fairhurst

Levi

David Benaim

London Financial Modellers

Career & Business

Financial Education

Finance

Microsoft Excel

Spreadsheets

Financial Modeling

Data Analytics

Microsoft Excel PowerPivot

Excel vs Google sheets showdown: Crazy cool features in one but not the other

Canada Water Library & Culture Space

Share

London Financial Modellers

Excel vs Google sheets showdown: Crazy cool features in one but not the other

London Financial Modellers

Details

Members are also interested in