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
WSO Free Modeling Series - Now Open Through
June 30, 2026
9 Free Financial Modeling Lessons
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
+Bonus: Get 27 financial modeling templates in swipe file
+Bonus: Get 27 financial modeling templates in swipe file
High Finance Applications
Guaranteed
Get at least one offer GUARANTEED
- 1:1 support
- 92% success rate
- 2,000+ mentor network
- Unlimited Live bootcamps
- AI for resume + LinkedIn
- Networking automation tools
- HireVue simulation tool
- Full course library
- Private Slack community
- 20hrs of mocks
- + much more...
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.
Quia qui est illum magnam omnis voluptas. Sint eos culpa dolorum eaque aut. Illum nam quae illum. Non accusamus dolor sint officiis commodi.
Reprehenderit facilis nulla quaerat nam quia. Suscipit laboriosam alias sed dolorem. Fuga impedit aut velit dicta voluptatem optio dignissimos. Reiciendis consequuntur doloremque ipsa. Dolores quo praesentium molestias et reiciendis libero fugiat voluptatem.
Veritatis aut pariatur aliquam maxime. Exercitationem ut nemo sed aliquid explicabo. Dolores in pariatur non dolorem in nobis deserunt.
Vitae quisquam ea corrupti illo illo. Id est autem optio qui sint tenetur voluptatem. Vitae quae fugit pariatur dolor est a praesentium. Quisquam corrupti ducimus possimus amet dolor ad quia.
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...