3 ms·
Google Sheets/App Scripts will let you do anything you want pretty much. You can call REST api endpoints, query some DB to bring in the "real time data", many o
by Cshelton 8y ago
Google Sheets/App Scripts will let you do anything you want pretty much. You can call REST api endpoints, query some DB to bring in the "real time data", many other ways to do it.
Pretty easy compared to Excel.
Oh.. and Microsoft's new 365 platform.. doesn't support Macros AT ALL. Nor RTD, unless you write your own excel 365 add on. Have fun with that.
My favorite feature, export a workbook with many sheets to html from google sheets, it's formatted beautifully in HTML. Now go to Excel and do that same. It never gets it right and is so ugly.
Google sheets, feature wise, is kicking the crap out of Microsoft now. People in the finance world will see this and the transition will/is happening.