Excel for Business Professionals and Managers

How to Use Microsoft Excel to Advance your Career, Make Better Decisions, and Manage Money Better
4.0 (5 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
25% 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


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


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

Who 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.


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

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


Download Excel File: goo.gl/rsNp4O


Download Excel File: goo.gl/rsNp4O


Download Excel File: goo.gl/HP9b82


Download Excel File: goo.gl/HP9b82


Download Excel File: goo.gl/HvdalB


Download Excel File: goo.gl/HvdalB


Download Excel File: goo.gl/uf76nu

Section 2: Organizing Data

Download Excel File: goo.gl/9GF19p


Download Excel File: goo.gl/PnXt8w


Download Excel File: goo.gl/MKb5tb


Download Excel File: goo.gl/Uuj8NK


Download Excel File: goo.gl/UepOhv


Download Excel File: goo.gl/VgfQz9


Download Excel File: goo.gl/fbrVY4


Download Excel File: goo.gl/cBUV5x


Download Excel File: goo.gl/gNEHYc

Section 3: Function!

Download Excel File: goo.gl/2CUwgs


Download Excel Function: goo.gl/HfWLvS


Download Excel Function: goo.gl/QddO4U


Download Excel Function: goo.gl/4WnPIi


Download Excel Function: goo.gl/lfKsiS

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


Rule #2: Progress Logically step by step
Rule #3: Think Hard and Clever
Section 5: Visualize!
(For PC) Visualize Data with Conditional Formatting
(For Mac) Visualize Data with Conditional Formatting

Download Excel File: goo.gl/wnZ33V


Download Excel File: goo.gl/wnZ33V

Visualize Interaction with 3-D plot
Manage Projects with Gantt Chart
Section 6: Scenarios!



Download Excel File: goo.gl/WLCNYd

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

Download Excel File: goo.gl/FpzURZ

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

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