3 ms·
I adore this video. I wish there was a version of a talk like this but for Google Sheets, or at least comparison of Excel and Google Sheets features as of 2023.
by layman51 3y ago
I adore this video. I wish there was a version of a talk like this but for Google Sheets, or at least comparison of Excel and Google Sheets features as of 2023. I saw an article[1] that tries to replicate the cool automatic data-table features of Excel in Google Sheets but it seems easier to just use Excel.
[1]: https://spreadsheet.dev/how-to-make-a-table-in-google-sheets https://spreadsheet.dev/how-to-make-a-table-in-google-sheets
- XzAeRosho 3y agoThe only thing that Google Sheets has in their favor, is their JavaScript API to interact with the sheets. But even that is fairly slow compared to any scripting done in Excel.
- ryanjshaw 3y agoExcel Online has Typescript-based [1] automation with Office Scripts [2]. There's even an online VS Code-based editor in development [3]. You can run these scripts non-interactively in Power Automate and integrate with pretty much anything, it's all pretty powerful. [1] https://learn.microsoft.com/en-us/office/dev/scripts/develop/typescript-restrictions https://learn.microsoft.com/en-us/office/dev/scripts/develop... [2] https://learn.microsoft.com/en-us/office/dev/scripts/overview/excel https://learn.microsoft.com/en-us/office/dev/scripts/overvie... [3] https://learn.microsoft.com/en-us/office/dev/scripts/develop/vscode-for-scripts https://learn.microsoft.com/en-us/office/dev/scripts/develop...