Basic Excel

Soxx's picture
Rank: Baboon | 162

I'm a current senior in high school interested in majoring in finance. I'm trying to get ahead of the game and prepare myself prior to taking classes. I received the 6 free modeling courses as a result of signing up for this site and found the first course (Excel shortcuts) very useful. However, I didn't understand any of what I was actually doing, as I was just hitting the keys I was told to hit. When I received the second course (calculating DCF), I was way out of my league. Is there anywhere I can learn more about Excel and how formatting the actual model works? I have very basic Excel knowledge and don't fully understand the format of models. If anybody has some insight, that would be very helpful. Thanks!

Comments (30)

Jan 28, 2016

Don't stress on the format of the model right now after all you're only in high school! Take the time to actually develop an understanding of the concepts of the DCF model and valuation itself. As you go through business school, excel will become like a second language to you so don't worry!!

    • 1
Jan 29, 2016

You are wasting your time learning Excel and DCFs right now. Though it takes some time to prepare for your banking interviews, you sure as hell don't need 2+ years. You should spend your time doing something more productive, like participating in good ECs, volunteering, entrepreneurship, etc.

Jan 29, 2016

I don't see there being any harm in buying WSP's Excel program and maybe practicing a hour a week or so.

Jan 29, 2016
200WEST:

I don't see there being any harm in buying WSP's Excel program and maybe practicing a hour a week or so.

Just from experience...I took WSP's excel course during my sophomore year in college and honestly it made me wish I had taken it sooner. Valley its definitely worth a look if you get the chance

Jan 29, 2016

and it's only like 35 bucks or so.

Jan 29, 2016

So Wall Street Prep's excel crash course is good for beginners?

Jan 30, 2016

check out the BIWS (breaking into wall street) excel training module. I think its somewhere around $40. If you're on a budget, youtube has plenty of excel video tutorials. Just find a user whose teaching style your comfortable with, and watch all of their videos.

Jan 30, 2016
captainkoolaid:

check out the BIWS (breaking into wall street) excel training module. I think its somewhere around $40. If you're on a budget, youtube has plenty of excel video tutorials. Just find a user whose teaching style your comfortable with, and watch all of their videos.

Actually it's Wall Street Prep that offers an Excel crash course for $40. BIWS' package is $197.

"Now go get your f'n shinebox!"

Jan 30, 2016

What excel versions should the videos cover?

Jan 30, 2016

Relax, it doesn't take long to get fairly proficient in Excel. Take one of the online WS prep courses and go over it a few times, I'm sure it has the necessary content.

Jan 30, 2016

I think it's important you find out what version of excel your firm is using. If you are not familiar with excel as it is and learn 2003, show up to work and they're using 2007, it might be a pretty big adjustment.

Jan 30, 2016

You can't be "terrible at Excel" if you "have used it only a handful of times". Practice. Posters above have given ver good suggestions.

Jan 30, 2016

This isn't something to stress over. There where quite a few kids in my training class that didn't know the first thing about excel, and by the end of the program a lot them where flying through spreadsheets no mouse and all.

One thing I will say that's invaluable, that you should know, is: "Alt" + "e" + "s", paste special. As an intern, you'll likely be doing a lot of formatting bitch work on books and such, so you'll use that short-cut many times over. Anyone here who works can prolly attest to that.

Jan 30, 2016

So what Excel versions are commonly used?

Jan 30, 2016

If I were you I would buy a good excel book, that way you can reference it from time to time. They can be had for relatively cheap (thank goodness since a new excel is launched quite often). I don't know what edition you have, so it's hard to say which book to buy.

PS This also assumes that you have only limited excel background.If you only want to brush up on a few formulas/formatting issues, then obviously a book would be less useful to you. I can't really direct you to any good online resources because I myself, even though I've been through some excel courses, use a book. It's on my bookshelf and I reference it from time to time.

Jan 30, 2016
phillperry:

If I were you I would buy a good excel book, that way you can reference it from time to time. They can be had for relatively cheap (thank goodness since a new excel is launched quite often). I don't know what edition you have, so it's hard to say which book to buy.

PS This also assumes that you have only limited excel background.If you only want to brush up on a few formulas/formatting issues, then obviously a book would be less useful to you. I can't really direct you to any good online resources because I myself, even though I've been through some excel courses, use a book. It's on my bookshelf and I reference it from time to time.

Yeah, limited-ish. Like you say, largely need to brush up. I dont have any books at this stage but I will head down in the morning to see what i can find.

Jan 30, 2016

motion training on youtube.com

"Look, you're my best friend, so don't take this the wrong way. In twenty years, if you're still livin' here, comin' over to my house to watch the Patriots games, still workin' construction, I'll fuckin' kill you. That's not a threat, that's a fact.

Jan 30, 2016

I would strongly recommend Breaking Into Wall Street.

Jan 30, 2016

Thanks guys. This seemed a decent resource http://www.mrexcel.com/ - not sure if anyone has used it.

Jan 30, 2016

Wall Street Prep's excel intro package is good.

Jan 30, 2016

Udemy has some descent online Excel courses that you should check out.
Each course is often packed with tutorial videos and Excel files to work along.
Not as elaborate as WallStreetPrep, but it's definitely cheaper so all depends on your budget.

Jan 30, 2016

A majority of your value-add as an SA will be in your formatting in PPT and things of that nature. By all means, bone up on Excel if you can, but don't sweat it; I haven't seen too many summers charged with building accretion/dilution or lbo models.

Jan 30, 2016

I 2nd this request, who knows of any free material on the web regarding financial applications in excel?

Jan 30, 2016

What are you looking to learn here? A modeling in excel course? Are you looking to get taught short-cuts? Or are you simply asking for things that allow you to learn to navigate faster in excel?

Jan 30, 2016
Comment
Jan 30, 2016