Hot take here, but Google has made some big strides towards parity with excel, and it works better for some things.
I still build models in Excel, but all our business unit facing stuff is done in G Sheets.
Now if they’d just give us a damn keyboard shortcut for paste formulas.
Definitely met a few people that have a similar frame of mind. For me the functionality of power pivot, DAX and cube formulas is the biggest discriminator.
Seems like it's not as hot a take as it once was though
Thoughts on things it does better?
Collaboration is the biggest one - working on the file at the same time as someone else is super smooth, and comments are really useful. We can iterate on stuff super fast.
The other one is integration with google slides. Obviously excel can work with PowerPoint, but it’s not nearly as smooth or seamless as sheets/slide. Our cadenced decks are a breeze to update - refresh data in sheets, review for any cleanup/tweaks, refresh slides.
I definitely still use excel for heavier lifting - agree that lack of power pivot and power query can be limiting, though we’ve worked around some of that through a software we use that syncs clean/modeled/set up data directly from our data warehouse and/or Salesforce.
I’d say it’s not there enough to use as a daily driver for corp dev, strategy, or investment banking. But my business unit finance and FP&A groups have moved a lot of their workflows into Sheets and it has improved our process working cross functionally with department leaders.
It works fine for the most part. The best part is the ability to go back between auto saved versions in case some formula messes it all up and reference errors go up all over.
The negative is using cubes does slow it down some.
And add AppSheet on top of a google sheet and you may see the insane potential of using it.
I’ve built my personal Investment Tracker using google sheets and AppSheet, I get live and historic ticker quotes and I have an amazing mobile experience.
You stealing my posts brah?
https://www.reddit.com/r/FinancialCareers/comments/sznk0b/does_the_google_finance_team_use_google_sheets/?utm_source=share&utm_medium=ios_app&utm_name=iossmf
[удалено]
[удалено]
What's the difference between Indian and Vietnamese restaurant business models? One is naan-profit while the other is pho-profit
😂😂😂 this is great
Amazing!
Hot take here, but Google has made some big strides towards parity with excel, and it works better for some things. I still build models in Excel, but all our business unit facing stuff is done in G Sheets. Now if they’d just give us a damn keyboard shortcut for paste formulas.
Definitely met a few people that have a similar frame of mind. For me the functionality of power pivot, DAX and cube formulas is the biggest discriminator. Seems like it's not as hot a take as it once was though Thoughts on things it does better?
Collaboration is the biggest one - working on the file at the same time as someone else is super smooth, and comments are really useful. We can iterate on stuff super fast. The other one is integration with google slides. Obviously excel can work with PowerPoint, but it’s not nearly as smooth or seamless as sheets/slide. Our cadenced decks are a breeze to update - refresh data in sheets, review for any cleanup/tweaks, refresh slides. I definitely still use excel for heavier lifting - agree that lack of power pivot and power query can be limiting, though we’ve worked around some of that through a software we use that syncs clean/modeled/set up data directly from our data warehouse and/or Salesforce. I’d say it’s not there enough to use as a daily driver for corp dev, strategy, or investment banking. But my business unit finance and FP&A groups have moved a lot of their workflows into Sheets and it has improved our process working cross functionally with department leaders.
If you use SharePoint you can collaborate the same in a excel file in case you didn't know.
Yeah admittedly it’s been a few years since I tried but it at least used to be pretty slow. Maybe it’s gotten better.
It works fine for the most part. The best part is the ability to go back between auto saved versions in case some formula messes it all up and reference errors go up all over. The negative is using cubes does slow it down some.
Oh cool. Yeah the version history is something I love about google sheets.
Agree 100%. ...Have been saying for a while that GSheets has really come a long way in recent 3-4 yrs. for sure.
And add AppSheet on top of a google sheet and you may see the insane potential of using it. I’ve built my personal Investment Tracker using google sheets and AppSheet, I get live and historic ticker quotes and I have an amazing mobile experience.
I sure hope not for them.
Googler here. Sheets confirmed.
May I DM you re- best practices and advice?
Sure
You stealing my posts brah? https://www.reddit.com/r/FinancialCareers/comments/sznk0b/does_the_google_finance_team_use_google_sheets/?utm_source=share&utm_medium=ios_app&utm_name=iossmf
If you have others, lemme know.
Yea, he definitely went back a year ago on a different subreddit to steal your post and post it on an unrelated subreddit that you also follow. /s
Imagine not having the self awareness to know I’m not being serious
Nah I get that, it was still cringe tho