But Sheets has a good feel, it’s free (must be the best free software out there surely) and also has some key advantages over Excel namely it’s far better than Excel (so far) for shared spreadsheets situations, it works with Google Forms and it has some killer functions such as…
- GoogleFinance to grab stock data straight from Google Finance GOOGLEFINANCE(“GOOG”, “price”, DATE(2014,1,1), DATE(2014,12,31), “DAILY”) [how good is that!)
- GoogleTranslate =GOOGLETRANSLATE(“text”, “source language”,”target language”).
OK if you Google hard enough I am sure there are UDFs written in VBA that are at least the equivalent of GOOGLEFINANCE. Still, sometimes yours truly will be using Google Sheets for certain jobs that suit the situation even though ‘theGoogleSheetsFactor.com’ doesn’t have the same ring to it! But it is very good. I think if you are a basic to intermediate spreadsheet user and just don’t have the time or need to get more deeply into Excel, it would be hard to blame you for being a Sheets fan. I love it’s ribbon, well actually its just a simple file menu – almost like the simple much loved Excel 2003 file menu pre Excel 2007.
It’s also worth having a play with Google Forms. You can go into directly or from the Form menu in Sheets. It’s pretty cool to be able to collect data and have it saved to a nominated spreadsheet. But you can’t do any calculations on the forms which I think makes them still limited. For instance it’s all very well using Google Forms for say as an employee timesheet, but there is currently no easy way to put some logic and rigor into the forms that does sensibility checks or compares to a roster or rota of normal working hours. Or say you wanted to give a customer a calculator to consider certain products or services you can’t multiply hours times a rate or x metres times a $/mtr. Maybe it will come.
Lastly on this general topic, I thought this was a great short and quirky video that summarises Excel vs Google Sheets situation really well.