Is Excel really really much more powerful than Google spreadsheet? if yes, will Google ever catch up? Here are the pros and cons of Google spreadsheet vs Microsoft Excel. I don’t think Google is close to Excel yet.
All the Excel keyboard shortcuts around formatting and filtering are essentially left out. This means building financial models or anything requiring more than just listing out numbers requires Microsoft Excel. For these kind of files, you normally don’t share or collaborate that much on them, nor do you need 10 people to see the numbers (perhaps you may need a management of team to see the final output, but that’s further downstream). Things also load faster in Excel if you have a lot of data in your worksheets. Google Spreadsheets also lacks a lot of the extra features of Excel like Goal Seek, add-ins, etc. Google Spreadsheets is slowly catching up with their version of PivotTables, but it’s still nowhere as fast and functional as Excel.
As an aside, an easy way to learn Excel keyboard shortcuts for the Mac is this Excel keyboard cover produced by KeyCuts: thekeycuts.comExcel keyboard cover with keyboard shortcuts for Mac Excel • KeyCuts