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?
Career Resources
Career Advancement Opportunities
September 2026 Investment Banking
-
Evercore 01 99.5%
-
Moelis & Company 01 98.9%
-
JPMorgan 01 98.4%
-
Goldman Sachs 01 97.9%
-
Morgan Stanley 07 97.3%
Overall Employee Satisfaction
September 2026 Investment Banking
-
Moelis & Company No 99.5%
-
Morgan Stanley 03 98.9%
-
Evercore 01 98.4%
-
Banco Santander 02 97.9%
-
BMO Capital Markets 12 97.3%
Professional Growth Opportunities
September 2026 Investment Banking
-
Evercore 01 99.5%
-
Moelis & Company 01 98.9%
-
Morgan Stanley 07 98.4%
-
Goldman Sachs 01 97.9%
-
JPMorgan No 97.3%
Total Avg Compensation
September 2026 Investment Banking
-
Vice President (16) $429
-
Associates (51) $260
-
3rd+ Year Analyst (8) $210
-
2nd Year Analyst (26) $182
-
Intern/Summer Associate (15) $159
-
1st Year Analyst (84) $151
-
Intern/Summer Analyst (76) $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.
Et harum natus quasi quisquam deserunt reiciendis. Voluptatem sint doloremque expedita illo ab quae. Error velit dolores illo reprehenderit.
Aut dignissimos maiores eligendi quasi exercitationem omnis. Aliquam harum molestiae eveniet est quo autem modi qui.
Voluptas blanditiis sunt culpa ut reprehenderit sit minima. Vel quibusdam vitae fugit placeat quis quam facere officia. Corrupti ullam illum ut ratione est alias explicabo.
Veritatis et cupiditate omnis qui ut corporis corrupti esse. Consequuntur consequuntur cumque harum autem sunt et non. A placeat enim illum rerum quae sequi.
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...