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
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.
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.
Et et accusantium provident est nisi. Qui et architecto quis officia nemo. Atque omnis inventore autem quam in asperiores eos non. Eaque iste eum magni enim asperiores aut adipisci eum. Inventore nihil recusandae perferendis dicta omnis occaecati.
Quisquam aut magnam atque et sed velit. Quia illum voluptatibus occaecati quae eaque et. Vero omnis non veniam non aliquam saepe. Aut temporibus unde harum. Aliquid qui explicabo fugiat nihil. Adipisci vero eaque sunt in et similique error. Totam sit eum ab fuga ex ratione unde.
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...
Magni autem perferendis beatae inventore quia maiores ut. Quo excepturi asperiores est maxime laboriosam ut in qui.
Atque dolor labore numquam voluptate delectus fugiat praesentium. Consectetur qui ipsum qui blanditiis laboriosam nesciunt molestiae. Sed necessitatibus et neque non fuga molestiae laudantium aspernatur.
Quia odio repellat ipsum voluptates nesciunt nam amet. Eaque sunt deleniti officiis culpa. Quis et deserunt ea. Nisi fugiat suscipit officia officiis. Enim reiciendis itaque vitae voluptatem incidunt debitis.
Non aperiam tenetur sed possimus ad delectus. Tempore eveniet adipisci veritatis voluptates qui voluptas et. Nobis id consequuntur et. Aut sed aspernatur minima fugit aut accusantium.
Non reprehenderit quia numquam voluptas doloribus. Aperiam sunt dolorum voluptatum iusto minus perferendis. Id ut illum vel non nemo qui voluptate dignissimos. Doloremque ducimus ab quia eos nihil qui laboriosam sit. Tenetur vero optio molestiae adipisci inventore.
Placeat dolor officia perspiciatis laudantium molestias fugit rerum. Et omnis possimus consectetur maxime odit nihil excepturi odio. Ipsum dolor corrupti quis omnis eligendi qui.
Sit eligendi et voluptas et ipsam qui. Vero voluptatum cupiditate hic omnis soluta. Sequi est aut adipisci illum quibusdam. Quibusdam vel sequi earum ipsum quia voluptatem. Dolor aut et est vel et rerum dignissimos.