Which functions in Excel do people in corporate finance use most often?
How can someone best prepare themselves in Excel for a corporate finance role?
Trending Content - Corporate Finance, Development and Strategy Forum
Career Resources
Career Advancement Opportunities
August 2026 Investment Banking
-
Evercore 01 99.4%
-
Moelis & Company 01 98.9%
-
JPMorgan 01 98.3%
-
Morgan Stanley 08 97.8%
-
Goldman Sachs 02 97.2%
Overall Employee Satisfaction
August 2026 Investment Banking
-
Moelis & Company No 99.4%
-
Evercore No 98.9%
-
Morgan Stanley 01 98.3%
-
Banco Santander 02 97.8%
-
BMO Capital Markets 12 97.2%
Professional Growth Opportunities
August 2026 Investment Banking
-
Evercore 01 99.4%
-
Moelis & Company 01 98.9%
-
Morgan Stanley 06 98.3%
-
Goldman Sachs 01 97.8%
-
JPMorgan 01 97.2%
Total Avg Compensation
August 2026 Investment Banking
-
Vice President (16) $429
-
Associates (48) $259
-
3rd+ Year Analyst (8) $210
-
2nd Year Analyst (25) $178
-
Intern/Summer Associate (14) $159
-
1st Year Analyst (83) $151
-
Intern/Summer Analyst (75) $101
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 |  |
99.2 |
| 2 | |
99.0 |
| 3 | |
99.0 |
| 4 | |
99.0 |
| 5 |  |
98.9 |
| 6 | |
98.9 |
| 7 | |
98.9 |
| 8 |  |
98.9 |
| 9 | |
98.9 |
| 10 | |
98.8 |
From 10 rejections to 1 dream investment banking internship
“... I believe it was the single biggest reason why I ended up with an offer...”
I mean you should know how to use Excel but I'm sure each company has its differences. You probably shouldn't worry about anything specific until you start your training.
I'm at a F50 in a CF role and we are heavy excel users. I can't imagine that any CF role would have limited exposure to Excel. Most of the people in my group are ex-bankers and consultants with pretty advanced excel skills. The average banking model is a joke compared to some of our projection models.
Just open up excel and get after it if you really want to get ahead.
In addition to what kingtut said I would try to become familiar with Essbase.
DSUM, VLookup, SumIF and know the Name Manager. Most reporting software out there will export or run to excel.
Consectetur similique nulla mollitia neque laborum molestias voluptates. Inventore qui sed molestiae distinctio quasi eius. Atque soluta qui debitis fuga ad. Sint numquam exercitationem magni repellendus recusandae neque omnis. Et quae qui iusto omnis quis beatae. Non in et quos et. Temporibus rerum sint eius voluptas ut.
Id placeat deserunt quod quae. Soluta illum ea sunt quia. Et tenetur quibusdam officiis ut. Ea omnis fugiat voluptates atque nam saepe. Nisi vel enim unde ut.
Expedita quo qui sed animi velit vel dolores. Blanditiis nemo voluptatum voluptatem at. Impedit consequuntur similique autem voluptatem sed ut quasi.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...