What version of excel do most banks do?
Will this differ with boutiques too? I have been trying to teach myself on excel 07 but realized it is a lot easier to use (in my opinion) than 03
Trending Content
Career Resources
WSO Free Modeling Series - Now Open Through
April 30, 2024
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
2007
We have 2003 at work. God help us when they switch us over to 2007 - I have heard horror stories of shortcuts not working, etc.
Heard that Harris Williams recently switched to 2007 and it has been a total mess.
Yep most are '07.
Most banks are 2007 now. The old shortcuts work correctly for the most part. It will sting at first but then it will feel good.
P.S. Harris Williams was a total mess long before they switched to 2007
That's not true at all. I work at a BB and both my roommates work at two different ones as well. It's 03 at all of them. 03 is so ingrained in the system, there would be a mass mutiny if anyone tried to switch. All you college kids need to stop opining on things you know nothing about.
which sucks because I used 2007 for the past few years during school.
I know of a boutique and three BB's that still use 2003
Everybody uses 03. The kid who said people use 07 is a college undergrad whos never set foot in a BB.
Although boutique uses 2007, most of the documents and excel files are in 2003 format.
The boutique I'm interning at uses 2003, which sucks cuz I trained myself on 2007. But it doesn't suck that much because it's excel, and it's still easy no matter what (plus it's summer, and shit is chill).
We're on 2003. Mostly because '07 blows when you've actually used it for a while. Bunch of fancy additions that add no actual value to a model or pitch.
Anyone know what version Deutsche Bank in New York uses?
Anyone know?
I'm working 2 internships this summer, one office has version 2007 and the other still has 2000! So I have to learn both of them instead of 2003 like I'm used to.
wtf does it matter?
I'm making it up as I go along.
From my understanding, and I could be wrong, it actually does matter because there are some differences in the keyboard shortcuts between different versions of Excel.
www.gottamentor.com
2003, and it matters a lot. 2007 has a totally different layout. Most of the shortcuts from 2003 still work but you have to know them by memory to get to them. That said, 2007 is way more robust, more stable, and can create some killer-looking charts.
03
Anybody trained in 2003 can very rapidly get up the curve with 2007. Most of the shortcuts in 2003 still work in 2007 and 2007 offers a few nice-to-haves that 2003 lacks.
The truth is that if people had spent 5 years learning 2007 and had to switch to 2003, they'd be claiming 2003 sucks. It's all a matter of what you're used to.
Jackofalltrades -- why the hate on Harris Williams?
~~~~~~~~~~~ CompBanker
Nope. Maybe you should create another post about it...
banker88, we get it, you have two internships.
also, my boutique uses the googleDocs versions of excel.
Which version of Excel do BB's use? (Originally Posted: 11/29/2012)
Does anyone know what version of excel GS uses currently?
Excel? GS doesn't use Excel. GS uses Open Office Calc.
Troll much?
I know one GS office uses Excel 2010, not sure about NYC though.
2007 is fairly common.
2007 or 2010. Can be a pain in the ass if/when your old models start breaking when you upgrade Excel.
This x1000... So frustrating when we upgraded from 2003. Also, the charts do not paste in as clearly for some reason, an annoying aesthetic result of the upgrade...
thanks!
Which Excel version? (Originally Posted: 04/08/2011)
Which Excel version are most BBs using now for IB? I did a search, but nothing recent enough and this is a time sensitive question.
I know 2007 well, just used 2003 and realized I don't know how to do shit with it.
most still on 03
How likely is a change to a more recent version in the next 2 to 4 years?
most still use 03 but are starting test projects with 10
Are the shortcuts still the same?
Made the switch from a 2003 environment to a 2007 environment. Shortcuts are generally the same, but formatting is a pain in the ass because things are all over the place and in different places. Formatting graphs is the worst.
But.... "adapt and overcome" right
^ I've tried both 2007 and 2010 and I feel like they are essentially the same thing besides more cooler looking layout in 2010 etc.
The real gap is from 2003 to 2007
I use 2007 now. I used to use 2003 and knew every trick in the book so I was hesitant to switch. Still, they kept all the old shortcuts (as far as I can tell), so all the old short cuts still work. They also added new shortcuts based on the new layout, but I haven't bothered to learn any of those (I hope they keep the old ones forever, obviously they easily can if they want, but I wouldn't put it past microsoft to do something stupid like make them invalid - do the old shortcuts still work in 2010 version?). The shift from 2003 to 2007 takes a little while but it's not that bad at all. I actually like 2007 more than 2003 now that I've gotten used to it and learned some new tricks that were'nt possible on 2003.
What cool things can I do in 2010 that I can't in 2007? Is it worth to get 2010?
2007 is much better in almost all ways, these days I try not to touch 03 if I can help it.
^ and are the banks going to switch over / can I use it on my own?
The align functions are different in powerpoint. I also believe that pasting links is different in powerpoint.
We just moved to 2010, it's sweet but definitely a pain in the ass to adjust from 2003.
2010 you can install as 64-bit. No real differences. I bought Office Suite 2010 through my old employer for 2010 but it was mostly to get the upgraded version of Outlook and OneNote which saw significant upgrades between 2007 and 2010 (2010 has the ribbon in every program, unlike 2007 which only had it in a few)
Biggest improvement for me is having more than 65K rows, and filesizes are much smaller
BB I interned at in 2008 and MM I work at now both use 2003. Friends at BB & MM shops still use 2003. Training the Street still teaches 2003.
pb, I bet a lot of places will be rolling out 2010 soon. Can't use '03 forever, and '10 is pretty sweet. I'd be surprised if a lot of places don't roll it out this summer for their 2010 analyst and associate training.
Sit eos nulla aut tempora sint consequatur qui. Modi mollitia eius harum aut corporis.
Amet sint voluptatem sint reprehenderit architecto. Illum sunt repellendus quibusdam incidunt quos animi recusandae. Ad accusamus et laudantium sit eveniet.
Perspiciatis vel facilis quaerat reprehenderit suscipit non beatae. Cupiditate et quisquam labore voluptates. Ab voluptatum exercitationem veniam vero ratione eius. Autem inventore deserunt et dignissimos non minus unde. Eos aut ut non ea. Officia quisquam quas doloribus nam dignissimos quod.
Atque autem molestiae dolorem quidem rerum veritatis ea. Et temporibus numquam id tempore deserunt occaecati facilis. Molestiae accusantium unde praesentium odit. Rerum modi non hic distinctio dolorem quo. Soluta et voluptatem et fugit placeat et. Eum reprehenderit est aut culpa. Quaerat magni molestiae facere exercitationem rerum numquam.
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...
Officia recusandae tempore est aspernatur sunt. A doloribus doloribus repudiandae necessitatibus expedita. Aut eos qui ducimus quis magni. Enim vitae quibusdam ex vel.
Velit quo sed ab et quidem aliquam voluptatibus. Libero eum non molestiae ratione rerum aut. Laborum voluptatem nulla ea magni aut omnis. Sunt dolor voluptatem ut quibusdam. Dolores animi itaque repellendus quibusdam.