Excel for Business Professionals and Managers

How to Use Microsoft Excel to Advance your Career, Make Better Decisions, and Manage Money Better
3.8 (4 ratings)
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.
109 students enrolled
Instructed by Justin Ren Business / Management
$19
$20
5% off
Take This Course
  • Lectures 52
  • Length 3 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 3/2015 English

Course Description

UPDATE 11/7/2015: Another Bonus material posted! - Flashfill! Check out the new Bonus section.

UPDATE 6/13/2015: Bonus material posted! - Online survey/event sign-up/quiz made easy with Excel online! Check out the new Bonus section.

UPDATE 5/20/2015: Lecture 1 and 2 combined, and video updated.

UPDATE 4/16/2015: Lecture 8 video updated.

---------------

Have you ever received an Excel spreadsheet from your colleagues and wondered: What on earth is this doing?

Have you ever wondered if you should re-finance your mortgage or car loan but do not know how much money you can save?

Have you ever thought about keeping tracking your stock portfolio by building an Excel spreadsheet?

Hi, I am Professor Justin Ren. I have taught thousands of students over the years, and I have consulted Fortune 500 companies as well as small start-ups. Two things continues to amazes me to this day:

(1) How prevalent Excel is in the workplace. In fact, many of the biggest corporations in the world run many of the most important strategic analysis and decisions based on Excel spreadsheets. The same is true for small businesses. Or even in managing our own daily lives. In my humble opinion, Excel is here to stay despite the fact that there are more and more alternative spreadsheets programs. Excel remains the indisputable go-to choice for serious spreadsheet modelers.

(2) How common it is for people to use Excel improperly or 'dangerously'. Let me give you an example. In my consulting and teaching career over the years, I have seen too many instances where people do 'copy and paste' in a rather haphazard manner: ignoring formula when they should be kept, or keeping formula in when they should be thrown away. The consequence of such bad practices can sometimes be devastating: Do you know that bad Excel practices played a role in the 2009 financial crisis (Just google “London whale Excel")? It is those mispractices that motivated me to write a training course to teach how to do Excel analytics in a safe and proper way.

This introductory series is designed for readers who are interested in building business analytics skills and applying them into business situations such as:

● Meeting budgets,

● Predicting demand,

● Selecting mortgages,

● Managing cash flows,

● Picking stock portfolios,

● Identifying trends and patterns,

● Making purchase decisions to minimize cost…

When it comes to analytics with Excel, my view is that there is a set of essential skills to be acquired. Such skills include:

● Finding information efficiently;

● Using commonly used math, statistical, and financial functions;

● Building a correct and clear model to analyze a problem;

● Scenario analysis to make decision under uncertainty;

● Summarizing information (e.g., with pivot tables);

● Finding patterns among data;

●Simulation and analyzing risks;

● Optimization for better decision making.

Those skill sets are taught through an extensive set of examples in this series. There are seven modules in this course:

1: Basic Skills

2. Model Building

3. Power Analytics with Data Tables and Pivot Tables

4. Visualizing data

5. Pattern Finding, Curve Fitting, and Regression

6. Problem Solving and Optimization

7. Simulation

Each section will be taught with real-life examples. There are videos to watch, files to download, and problems to practice.

I trust you will enjoy this learning journey. It is my goal that by taking this course, you will become a better business person, a better manager, and a better decision maker.

What are the requirements?

  • You need to have a copy of Microsoft Excel on your computer (PC or Mac).

What am I going to get from this course?

  • Build your ability to think logically
  • Construct managerial decision problems in Excel spreadsheets
  • Improve decision making

What is the target audience?

  • Any who desires to make better decisions, whether professional or personal, with Excel can benefit from this course
  • This course is NOT for those who just wants to learn Excel functions. Instead, this course is about solving real problems with Excel.

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

Section 1: Fundamental Skills
Use Ctrl (or ⌘) + Arrow key to quickly navigate in a table
Preview
01:17
01:23

For Mac users, go to: goo.gl/hTo8ei

01:40

Download Excel File: goo.gl/rsNp4O

01:29

Download Excel File: goo.gl/rsNp4O

01:02

Download Excel File: goo.gl/HP9b82

01:15

Download Excel File: goo.gl/HP9b82

02:17

Download Excel File: goo.gl/HvdalB

03:01

Download Excel File: goo.gl/HvdalB

03:24

Download Excel File: goo.gl/uf76nu

Section 2: Organizing Data
02:36

Download Excel File: goo.gl/9GF19p

02:39

Download Excel File: goo.gl/PnXt8w

02:51

Download Excel File: goo.gl/MKb5tb

04:43

Download Excel File: goo.gl/Uuj8NK

03:04

Download Excel File: goo.gl/UepOhv

03:08

Download Excel File: goo.gl/VgfQz9

02:31

Download Excel File: goo.gl/fbrVY4

01:55

Download Excel File: goo.gl/cBUV5x

03:15

Download Excel File: goo.gl/gNEHYc

Section 3: Function!
02:38

Download Excel File: goo.gl/2CUwgs

04:19

Download Excel Function: goo.gl/HfWLvS

01:42

Download Excel Function: goo.gl/QddO4U

02:35

Download Excel Function: goo.gl/4WnPIi

02:49

Download Excel Function: goo.gl/lfKsiS

Number of Payment for Investment or Loan
02:13
Working with Texts
02:13
Section 4: Build Models!
05:24

goo.gl/8J6378

Rule #2: Progress Logically step by step
05:24
Rule #3: Think Hard and Clever
09:39
Section 5: Visualize!
(For PC) Visualize Data with Conditional Formatting
04:27
(For Mac) Visualize Data with Conditional Formatting
03:37
01:22

Download Excel File: goo.gl/wnZ33V

02:56

Download Excel File: goo.gl/wnZ33V

Visualize Interaction with 3-D plot
05:27
Manage Projects with Gantt Chart
04:00
Section 6: Scenarios!
02:59

goo.gl/1NMFkl

06:19

Download Excel File: goo.gl/WLCNYd

What-ifs with One-way DataTable (Part 3): Select Selling Channels
02:37
3-D Scenario Analysis with Two-way DataTable (I): Drivers of Mortgage Payment
04:54
3-D Scenario Analysis with Two-way DataTable (II): Drivers of Drug Demand
04:22
Section 7: Pivot!
05:54

Download Excel File: goo.gl/FpzURZ

Deeper Market Intelligence with PivotTable: A Case Study
Preview
10:59
Use PivotTable to Visualize Data Distribution
03:16
Section 8: Find Patterns!
Fit Lines and Curves Through Data
Preview
03:04
Prediction and Regression with LINEST
05:06
Predicting Yes/No Type of Outcomes
05:43
Forecast Future with Data Smoothing
03:56
Section 9: Optimize!
Optimize Linear Problems (1): Advertising Spending
03:29
Optimize Linear Problems (2): Schedule Interns
03:31
Optimize Linear Problems (3): Decide Order Quantities
05:14
Optimize Go-or-No-Go Type of Decisions
Preview
04:48
Section 10: Bonus!
Online survey/event sign-up/quiz made easy with Excel online!
03:08
Bonus: Flashfill (Windows only) is a Godsend
02:57

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Dr. Justin Ren is an Associate Professor of Business Administration in the Operations and Technology Management Department, Dean's Research Fellow, and Senior Fellow of Health Policy Institute at Boston University School of Management. He was also a Visiting Scholar and Research Affiliate at Massachusetts Institute of Technology (MIT) Sloan School of Management from 2009-2013.

For almost ten years, Professor Ren has been teaching analytics courses which focuses on tools and frameworks that help managers gain market intelligence and make strategic decisions. He also teaches in executive education in financial risk management. He is a certified teacher by the Harvard Business School Case Method Discussion Leadership Program.

Professor Ren has consulted for Fortune 500 companies as well as start-ups. His work has been mentioned in Sloan Management Review, China Daily, and the World Financial Review. He has been invited to give lectures and presentations around the world at institutions such as Harvard University, MIT, Duke, Dartmouth, Georgetown, Emory, INSEAD (France), Hong Kong University of Science and Technology, Peking University (China), and Tsinghua University (China).

Professor Ren received his M.S. in Operations Research and Ph.D. in Operations and Information Management from The Wharton School at the University of Pennsylvania.

Ready to start learning?
Take This Course