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
| +144 | Americas M&A League Table Q2 Updated | 64 | 2h |
| +132 | New Article: Dramatic Slide as UBS #22 (US) & New Leadership Desperately Needed | 25 | 1d |
| +64 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 12 | 5h |
| +55 | Restructuring: Anti-climactic Experience | 11 | 4h |
| +50 | Boutique firm wants access to my LinkedIn? | 40 | 5h |
| +45 | IB Net Worth / Savings Check | 20 | 2h |
| +33 | Investment Banking in Mexico | 9 | 1d |
| +33 | Investment Banking is Hard | 14 | 10h |
| +23 | PWP vs BofA | 21 | 11m |
| +21 | Excel macros for QOL formatting | 0 | 5d |
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.
Voluptatem odio aut mollitia et sequi. Impedit amet ut eos. Ut maxime minus dolores nemo. Atque in omnis possimus minus saepe.
Velit qui velit aperiam accusamus eos qui dignissimos. Culpa eius nulla repudiandae sit autem unde quae odit.
Occaecati dignissimos voluptatum natus qui dolorem voluptas. Beatae at veritatis corporis aliquam enim ex.
Debitis et consectetur autem magnam. Neque quae accusamus maxime libero. Aut quia est repellat quas non hic. Dolore ipsum rem quae voluptatem quasi. In est omnis nostrum rerum.
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...