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
| +229 | Should My Intern Get a Return Offer? | 58 | 2d |
| +96 | UBS Accused of Favoring H-1B Workers While Cutting U.S.-Born Employees | 15 | 1h |
| +78 | Incompetent and annoying co-intern | 23 | 16h |
| +67 | Getting Laid in IB? | 28 | 2d |
| +66 | Intern keeps sleeping at work - what to tell them | 28 | 19h |
| +55 | Living in greenwich as an analyst? | 12 | 16h |
| +42 | NYC Associate Budget | 14 | 20h |
| +36 | Nauseous every morning for past 3 years in IB, anyone else? | 21 | 1d |
| +35 | Quick Thoughts on CVC AI Sale Process | 7 | 22h |
| +29 | Going out / social schedule as AN1 | 14 | 3d |
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.
Debitis fuga ut natus aut. Distinctio quia porro blanditiis laborum fugit. Explicabo amet sit nulla repudiandae quo repudiandae enim harum. Impedit laudantium quis nesciunt sequi expedita vel dolorem. Officia sunt facilis tempore dolorem eaque ex quas. In perferendis qui quis.
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...