Just a quick question for current Analysts and Associates.
Do you guys mostly use Excel, or does a point ever come that the data you are dealing with gets so huge that you have to get into using Access as well?
What about M.S. Project? Ever ended up using that?
Appreciate the response....
| +224 | UBS Accused of Favoring H-1B Workers While Cutting U.S.-Born Employees | 55 | 1h |
| +124 | ONLY THESE BANKS OR YOU STRUCK OUT | 34 | 15h |
| +111 | IB Energy Drink Tier List / Ranking | 73 | 14h |
| +91 | PJT M&A Group Selection 2026 | 14 | 1d |
| +59 | Firm Thinks I'm Lying About Offer | 18 | 1d |
| +51 | Feedback for internship first desk at IBD BB - personal fit, "don't be too confident" | 29 | 1d |
| +40 | Indiana University Fraternity Pipelines | 20 | 3h |
| +33 | Stay at Weak Dealflow Team or Lateral? | 10 | 19h |
| +30 | Does BofA still pay its associates rat pellets? | 15 | 1d |
| +30 | Rogo AI | 11 | 5h |
Career Resources
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.
I don't know of any bankers that use Access, its generally all Excel. I work in PE now and can't think of when I'd ever use Access, though I did use it a fair amount (used SPSS too) in management consulting - since at times you're dealing with massive fucking data dumps.
Hey Smuggy97,
did you make a transition straight from Management Consulting to PE? or did you go through the proper route i.e. DCM-> M&A -> PE
Cuz I was told by someone that a lot of PE shops prefer people with Management consulting experience.
Always excel, never access.
It's been about 90% excel, 10% access. I consider that a shame, though - it's much easier to manage large data sets and turn data into information when using Access, because if you're competent enough understanding SQL and writing queries (and VB scripts occasionally), it makes life much easier.
Professional-grade data management requires a database imho. Using excel is winging it. It'll work for most cases but end up costing you time and effectiveness in the long run.
Is most of the time as an analyst /associate spent in due dilligence i.e. understanding the business and looking at statements, or do you guys get a chance to go for marketing the sceurities or getting the clients as well.
Access is a crappy database to begin with, if you were going to use a database, you'd want to use something else. Excel has a ton of functionality, especially when you learn VBA. Most people don't even scratch the surface on what Excel can do.
Excel. Never used Access in last 3 years
Excel is what I use for financial modelling.
Access really isn't applicable for doing DCF/financial statement type analysis.
If you are in university try to model questions from your corporate finance book on excel. It will help you become familiar with using it. (note: this is not the same thing as the models you will build at work).
Thing I dislike alot about university problem solving is that when practicing corp finance book questions on the computer in Excel or a spreadsheet package of choice(read: OpenOffice). The experience you get is hardly of any use on the exam/test, where you are pretty much stuck with pen,paper&calculator.
Dolor sunt ipsum consectetur omnis. Voluptas quis consequatur pariatur voluptatem architecto.
Qui nam ut facilis odio consequatur aut perferendis. Nemo fuga mollitia eveniet eos ratione ut. Culpa qui sed unde reprehenderit accusamus.
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...