How to become very proficient in excel?
How to become proficient in excel within a short period of time? any good website or programs that u might now? thanks
Trending Content - Investment Banking Forum
| +238 | UBS Healthcare | 49 | 5d |
| +166 | Coverage Banking is Paradise | 16 | 12h |
| +79 | Shana tova - happy new year | 15 | 3h |
| +49 | Lost all ambition / don’t care at all anymore | 20 | 1m |
| +45 | My Motivation Is At An All Time High | 11 | 11h |
| +37 | Are Canadians still get jobs in the US? | 20 | 8h |
| +31 | London Recruiting is Paradise | 9 | 13h |
| +24 | What is the role of an analyst at your firm? | 4 | 1d |
| +24 | MM IB --> NYC IB? | 13 | 13m |
| +21 | "Don't include firm in Cover Letter's file name" | 9 | 4d |
Career Resources
if money is no object, http://www.WallStreetPrep.com/programs/details.php?package_id=37. what the banks teach u at their training sessions is enough. however, retaining that info from the classroom and using it on the desk is different. overall, practice your shortcuts and commands until they become second nature and stored in your long-term memory.
I wanna become an excel master (Originally Posted: 04/26/2014)
Does anyone know of programs to download or at least some good sites to acquire decent excel skills
Becoming an excel master is quite easy. When you use a desktop unplug your mouse or when you use a laptop disable the trackpad. You'll be a master in a week.
find a case(valuation, data mapping) and use active learning to get better at excel. reading shortkeys and functions won't do shit for you.
I have never worked in finance (just passed CFA L1 and starting to look) but from what I've gathered, working with data in Excel is the only way to become good at it. There are modeling courses out there (WSP, Training the Street, BIWS) but from what I gather they are very expensive and they can only really teach you the very basics. But if you PM me, I'll send you some links I find useful for Excel in general (can't post links yet BC I'm so new to WSO).
Its better to join an institute..
I'm with @"bearing". When I started work at Big 4, my senior came to my desk on the first day disabled my trackpad and took my mouse. He gave it back after about a month when he saw that I didn't need it anymore. Best excel master class I ever had.
Mastering excel (Originally Posted: 03/15/2013)
Hi,
How long to get really good at excel? No VBA but very proficient?
I am pretty good as it is, but not that great at shortcuts. I figured if I can master a video game in say 40 hours I should be able to do the same with excel.
For data analysis based stuff, what are the essentials?
Thoughts please.
This post is very vague. Get good at excel? Excel is just a spreadsheet program. At doing what? DCFs, regression/statistical type stuff?
I guess regression/ statistical kind of stuff.
I have a data analysis type role, but know little about what I will actually be doing. Just want to polish up before I start.
http://www.alumni.hbs.edu/new_alumni/toolkit/tools/introregression.xls
Such a vague post, but this code should definitely help you start off in the right direction towards becoming a god of the spreadsheet universe: Up, Up, down, down, left, right, left, right, B, A
How to become an EX(CEL)PERT? (Originally Posted: 07/02/2015)
Could anyone recommend any useful/effective and most importantly FREE Excel course online or any methods to nail this programme? I know it takes time and practice, but there must be some way! Many thanks.
Try VBAisfun on YouTube if you're new. He's got some cool and interesting videos that teach the basics of VBA. But if you want comprehensive info I'd recommend you buy a course (e.g. BIWS)
None of these Excel classes will make you proficient in Excel. The only way to get good at Excel is to use it in class or on the job. These Excel classes will certainly teach you some good basic functions, but the more advanced ones are tough because the only real way to memorize them is to have to use them.
Sil is pretty accurate. You can learn all the technicals but unless you're one of the lucky few tech savants you're still going to spend a lot of time reviewing how to use each function at first. It takes time working with them to really remember them.
To save yourself some money, my advice would be to Google "Training the Street excel shortcuts" or something of the sort in Google Images. Just make sure that you are using the same version of Excel. Most Excel shortcuts from older versions work in newer version, but no the other way around. Then, force yourself to use the keyboard. It will be horrible at first, but you will get used to it.
Distinctio voluptatem velit eligendi pariatur nihil sed culpa. Qui delectus debitis et ipsum possimus. Id tenetur consequatur deserunt iusto. Labore dolor quod dignissimos ex ducimus. Ut facilis soluta modi quibusdam ea. Commodi ex voluptatem cupiditate doloribus aperiam. Corporis voluptatem et eius totam sit ad.
Qui ratione ut minima ut cum quaerat iste. Repellat rerum ut voluptatem dicta. Officiis ullam aut dolores dolores qui impedit voluptas. Aut nesciunt blanditiis dicta incidunt ut quibusdam laborum. Officia eius eveniet esse.
Tempore error necessitatibus cumque labore dolores. Natus labore totam quas qui expedita harum. Aspernatur aliquid illo fugit ratione. Esse sequi repudiandae vero rerum in repudiandae.
Consectetur eius velit sit dicta aut ratione. Laudantium culpa quo aut eaque et deleniti voluptatem adipisci. Velit hic doloremque molestiae ut inventore laudantium.
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...