excel google really liked for the possibility of working with tables on the Internet.
Great job!! Will check it out 😊
What are the pros of using Excel over Google Sheets at this point? I'm failing to see many.
@karlnislow I guess if your Infosec doesn't allow for "unsecured confidential online data"??? There really aren't that many.
@jonathanlaniado Interesting, curious what you mean by that?
@karlnislow Well, I worked at a company last year whose Info. & Security department did not allow Google Sheets to be used organization-wide. They claimed it wasn't secure enough for our confidential data to be uploaded on there.
@jonathanlaniado That's interesting. Just researched a bit. It seems like it has to do with how data at rest is secured in each system. Additionally, it appears Excel has more failsafe options using multi-sheet encryption.
@karlnislow Speed. Only thing I ever really run to Excel for is spreadsheets with 400k+ rows. 😅 I also use Numbers from time to time because of the nice charting defaults and mobile friendly UI
@jonbjornn is it still worth using Excel and not some custom solution specifically tailored for the task with this amount of data?
@karlnislow Speed is an issue with larger files and if they have lots of formulas. Pivottable in Excel is superior to the one you have in Sheets. You can bring multiple data tables in an Excel sheet ( no idea if you can do it in Sheets)
@jonbjornn Agreed. Speed is certainly a limitation for larger data sets and more complicated models. I wish you could buy more dedicated bandwidth as needed and set refresh rates.
@kaan_aksoy1 Agree that speed is a limitation. What about pivot tables is inferior right now? What do you mean when you say, "You can bring multiple data tables in an Excel sheet."?
@karlnislow I'm just aware of one. Extracting trendline equations from graphs or even just showing the trendline equation in the graph. I don't see that on Google Sheets.
Anyone know if this will work for the free version of Google Sheets?
@benjamin_wilkins It will not. I just tried :)
So, macros are called automation here?
As someone who has been making Google Apps scripts the hard way for repeating processes, the new macros feature will be a game changer!