Excel For Top MBAs (And Wannabes)

MS Excel cases walked through by a top 10 MBA instructor
5.0 (1 rating) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
26 students enrolled
$25
Take This Course
  • Lectures 64
  • Length 5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2015 English

Course Description

Excel For Top MBAs (And Wannabes) is for anyone who wants to learn the key lessons of Microsoft Excel, finance, wealth building, and business planning/analysis. In this course you'll learn everything from the basics of what a spreadsheet is to how to manipulate it to solve common problems in life and business. You will learn many techniques but they'll all be in the contest of solving a problem so that when you encounter questions like "what should I plan for my retirement?" or "how might I think about pricing this new product?" or "can I really afford this house?" or "how do I get out of this debt I'm drowning in?" so that you will have an advantage in attacking this problems going forward with analytical skills that would impress any employer and improve just about any business. You'll be an expert before you know it.

What are the requirements?

  • Before starting this course you'll need a computer with a monitor, mouse and speakers. The computer will need MS Excel 2007 or later installed. If you don't have access to MS Excel, then you can use Google Sheets for all of the material covered here except for the one case about Ali. In MS Excel, you'll need Solver and the statistical add-ins but don't worry. I'll show you how to install and manipulate that.
  • You will need to know how to add, subtract, multiply, and divide. You may also find it useful to understand basic algebra.

What am I going to get from this course?

  • Organize, analyze, and present thoughts to solve a myriad of common business problems
  • Use statistics to add value to processes in your current and/or dream job
  • Leverage lookups and pivot tables to merge and manipulate data into valuable information that builds competitive advantage
  • Create strategies to get out of personal debt
  • Master the finances of real estate deals to build for a better retirement
  • Optimize your business through linear programming models
  • Build the analytical skills that employers want

What is the target audience?

  • Do you remember learning math in grade school and asking your teacher "When in life am I ever gonna use sine, cosine, and tangent? What the heck is the point of all of this?" If you felt that way, you are not alone and you don't need to worry. This course involves the science of the excel formulas and computing but it's a general walk-through for how to use the tools to solve business and life problems. It uses cases to tell the stories of characters with common problems like buying a home or paying down debt to make the use of MS Excel second nature to the learner. There are too many functions and uses for MS Excel (and other spreadsheet softwares) to name; matter of fact you can even create ones of your own. This course is for those who want to learn how businesses, markets, and the "nuts and bolts" of finance work through using MS Excel to improve profitability and make good decisions. It is not for learners who want to master one specific skill set within Excel. Subjects like macros, engineering functions, power query, and monte carlo simulations won't be covered here.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Course/Instructor Intro
Preview
01:33
Section 1: Buddy's Hotel Bill
Buddy's Hotel Bill
Preview
02:47
05:44

Spreadsheets are such a funny buzzword and sometimes they can be intimidating. Learn how they can help us solve problems as simple as 1+1=? or as difficult as Black-Scholes Options Pricing.

08:41

You'll make order of the rows, columns, and cells in order to help our good friend, Buddy, solve his problem. Tables are the most basic form of data ordering and I'll yet make an metaphorical carpenter out of you!

03:29

Once you have learned the substance of the data table we create (the formulas and all such things), we will polish it through number formatting, understanding the print options, and emphasizing the cells most important to us.

03:05

A model is only as good as the assumptions you put in it. "Garbage in garbage out" is a common saying among analysts who build models. Here you'll find out why.

Section 2: Samantha's Decision
03:34

Samantha has a problem. It's a good problem and it'll help you figure out how to discount future values of cash flows.

1 question

This quiz ensures that you understand the very basics of navigating Excel's spreadsheets.

03:21

Here we use a table to restate the pertinent facts of the case. I find it easier to remember things when I write them down. You may too.

07:40

Here we build a table examining the key components of Samantha's Rhino job offer.

03:02

We set up a table for Rhino here and set up the frame for discounted cash flow analysis.

04:25

We will finish setting up the table of facts for Rhino and discounting the cash flows of future years.

02:58

Having taken out the time to finish Rhino, we can copy it, change the facts, and say "B-I-N-G-O!!"

04:13

Here we compare the two options. You will learn to span formulas across multiple worksheets and compare the two choices.

02:46

This is an introduction to using graphs in analysis.

Section 3: Financial Planning Quiz
Article

This is an extended quiz in finance. It tests what you know so far about calculating present value and extends that knowledge to future values. Then you draw key lessons about retirement and wealth building. But try to answer the question on your own first. Then compare it to what is shown.

02:54

Here you'll understand a strategy for how to tackle this retirement problem.

05:45

Here, were outline monthly incomes for the four ladies.

08:25

You'll calculate the monthly contributions to the retirement accounts in the value of the time they were paid.

06:30

Find a new way to apply the difference between present value and future value of an asset.

07:35

Here you'll figure out who does the best in retirement and by how much.

07:25

You'll see your conclusion in pretty colors.

Section 4: Rajiv and Chemeka
03:39

Should they buy the house, invest in the market, pay down student loan debt? Find out on the next episode of Dragonba... no wait!

06:58

When you have too many facts, it's usually good to write them down so that you can make sense of it all. That's what you'll do here.

05:22

How much does Rajiv have to pay every month currently?

06:36

Amortization schedules are the crux of this section and here is where you'll build Rajiv's. You can change the assumptions and create your own for yourself.

03:45

What if we changed a few things in Rajiv's Amortization Schedule?

03:36

What does Chemeka's debt picture look like?

Also, I like to sing songs sometimes.

04:58

Let's build a mortgage to examine new debt from the house and explore each of the options.

08:12

What is a tax shield? If you are taxed at 30% and you make $100. Ordinarily, you'd pay $30. But if you paid $15 in interest expense then you'll only be taxed on $85. You essentially get back 30% of $15, which is $4.50.

09:21

Leverage makes the world economy go around but it also causes it to slow down whenever people can't make payments on loans. You'll help our favorite couple figure out what level of debt and leverage they'd feel comfortable with.

Section 5: The Stats of Bubble Jones
03:51

Download this spreadsheet and use it as a basis to build your analysis of the Stats and Figures of Bubble Jones.

05:32

Learn to combine two (or more) tables of data into one integrated source.

06:38

Let's begin to build a pivot table.

Pivot Table 2
05:00
Pivot Table 3
04:05
2 questions

Let's see what you can figure out.

Regression
02:45
Setup for Regression 1
07:22
Setup for Regression 2
03:05
Setup for Regression 3
06:09
Regression Output
03:07
Trim the Fat
05:12
Business Analysis Using Regression
05:49
Final Answer
05:46
Section 6: The Bakery
03:24

Download the attached spreadsheet and let's get to work.

02:06

Install the Solver Add-In.

03:54

Put the facts into a table and learn more facts. Facts on, facts on facts!!

02:01

This is pretty straight forward.

03:46

Make Solver do all the hard work for you.

02:54

This is pretty self explanatory. You'll learn to interpret the solver reports you just had Excel create for you.

Section 7: Ali's Factory
02:59

Learn graphing, EOQ, more on the Solver Add In.

Setup
05:12
Count Up the Cost
08:34
The Long Way Widgets
09:49
The Long Way Gadgets
03:15
Data Filter (Still the Long Way)
01:57
06:16

Let's use Solver one more time but in a different way.

Section 8: Ostrich Motor Company
Ostrich Motor Company
03:23
06:40

You'll use algebra to derive a demand curve for the new product.

04:52

How do you know if it's worth it if we don't yet know profit at any given level of production/price?

Ostrich Long Way
03:13
Long Way Graph
01:38
Easy Way
03:09
Calculus Way
10:01
Thank You
01:30

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Bruce Vann, Darden MBA

Ready to start learning?
Take This Course