What would it take for you to give up Excel?

Interested to know under what circumstances people would consider shifting from Excel to something else. Google Sheets currently doesn't have the same level of features as Excel, but there are obvious advantages in terms of things like collaboration.

Some aspects of Excel are seriously frustrating (can't dual screen the same model, no version control, trace/precedents dependents is essential but pretty terrible). Some of these things can be solved by plugins but not all of them. So what would it take for you to move? Either onto Google Sheets or even completely different software.

Parity with Excel in terms of what features? And then what extra things would make your like way easier?

I always thought Google Finance getting (pretty much) canned was a real shame for their competitiveness in the financial modeling space. Being able to pull up-to-date financials for free would be a massive plus imo if they'd extended to things like fundamentals.

11 Comments
 

Google Sheets is good for anyone not doing any serious calculation.

To move away from Excel, Id need BBG/FactSet/CapIQ compatibility, better array calculations, a more efficient language than VBA (really shouldnt be hard), and the same file type compatibility (eg xls/xlsx/csv/xml...). Oh and the stupid E -> scientific notation needs to go. Literally the dumbest thing on Excel, whoever thought that was a good idea should be fired.

 

Couldn't agree more about a more efficient VBA. For most VBA functions I do now I can either figure it out with some time or a quick Google search will give me some lines of code, but there should definitely be an easier way to do it.

Love, abigreguy
 

Also completely agree on the VBA point. What language would be your preference? Python? And with a better programming language, couldn't you get rid of array calculations all together?

Really don't understand why they haven't included something to let you turn off E+ notation as a default rather than making you format everything separately.

 

Python mostly because it was what I was taught, and its open source. However, my firm makes using open source software incredibly annoying and there seems to be no solution to this bureaucracy. BQuant for bloomberg looks promising, havent really tested it out for work yet though.

I also like MATLAB a lot for its libraries, charting and array calculations. But the incremental benefit between a fully functioning Python platform and MATLAB is definitely not worth the price.

 

Definite SB - thanks a lot. Every time I've tried to dual screen, the focus stays the same on both windows as you scroll. Don't know how I ever missed this.

 

Given the absolute uselessness of real-time collaboration for what deal professionals do, I don't think there is anything that could make that a reality. One person builds a model, it is then reviewed in isolation by someone more senior, then it is distributed. I see absolutely no value in having real-time collaboration except for some weak analyst that isn't able to develop the requisite skill set.

 

I take the point that real-time collaboration isn't necessary (or even desirable) in lots of situations. But the option to do so is surely a benefit? Pretty sure a number of ECM departments pay ridiculous amounts ($5k - 10k per deal) for Dealogic's Bookbuilder for IPOs which is basically just a single sheet spreadsheet with collaboration capabilities and security. I'm assuming there are other similar use cases.

Also, though not directly a "collaboration" feature, it would be useful to be able to pull a sell-side model internally without having to email someone. That way I don't have to ask them to send me a bunch of models I don't want as well as the one I do. Would also be great if I then got pinged if the model updated with new results.

 

I’n response to your sentimental longing for Google Finance, create an account on atom.finance, then navigate to their Sandbox product (financial modeling with consensus projections pre-populated). This is undoubtedly the best free ‘terminal’ I’ve ever used.

 

Commodi incidunt officiis doloremque. Dolorem iure ea commodi debitis asperiores. Voluptate impedit aut maiores maiores beatae.

Et et illum laudantium suscipit sit laboriosam ad nemo. Numquam ipsum aliquam eaque aperiam voluptatem saepe quisquam eius.

Ut facilis illo velit vitae. Officia blanditiis cum error illo. Est odio voluptas eveniet doloribus aut. Beatae et consequatur ex. Tenetur culpa qui pariatur debitis dignissimos molestiae iure.

Optio eaque enim quo eligendi. Quod voluptates unde expedita dolores quae est. Ex minus dicta deserunt iusto. Eos voluptatum vero necessitatibus repudiandae in beatae. Explicabo beatae aperiam rem quod ut labore consequatur natus.

Career Advancement Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • JPMorgan 01 98.4%
  • Guggenheim Partners 02 97.9%
  • Morgan Stanley 06 97.4%

Overall Employee Satisfaction

November 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 99.0%
  • Evercore 01 98.4%
  • Banco Santander 04 97.9%
  • BMO Capital Markets 13 97.4%

Professional Growth Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

November 2026 Investment Banking

  • Vice President (17) $409
  • Associates (58) $261
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (29) $183
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (77) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
Secyh62's picture
Secyh62
99.0
4
kanon's picture
kanon
99.0
5
GameTheory's picture
GameTheory
98.9
6
CompBanker's picture
CompBanker
98.9
7
Betsy Massar's picture
Betsy Massar
98.9
8
dosk17's picture
dosk17
98.9
9
DrApeman's picture
DrApeman
98.9
10
bolo up's picture
bolo up
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”