Shopping Cart

Become a Instructor

Introduction to Modeling in Excel for Decision Makers

196 minutes of course content

Review course syllabus

$79.00 (taxes calculated at checkout)

100% money-back guarantee  |  Click here to read more

Share this course:
Facebook Google LinkedIn Pinterest Twitter

Course Description

Part 1 demonstrates how to use Excel efficiently. You will begin with the AutoFill, efficient selection of cells with shortcuts and learn to how to use functions and addressing correctly. Part 1 also covers naming of cells and ranges and variety of topic on how to create charts, add data to charts and inserting pictures to charts. The last session of this part is about Sparklines.

Part 2 covers two frequently needed skills: the IF function, text manipulation (text to columns), text functions and the use of the Flash Fill.

Part 3 introduces all the statistical tools you need as a decision maker, analyst or a student – without being a trained statistician. It covers descriptive statistics, frequency distributions and frequency distributions charts. You will also learn how to use the Data Analysis tool-pack add-in, simple regressions and how to fit functions to linear or nonlinear curves.

Part 4 enhances your Excel decision making skills. This is an introduction to the “What IF Analysis”, using conventional and unconventional Excel tools. The techniques will be first applied to a simple financial model. Part 4 continues with the Goal Seek, Data Tables sensitivity analysis and it ends with a business plan case study. 

Part 5 demonstrates range and exact match VLOOKUP functions in the first part. The second half covers “going the third dimension”, summing several sheets to a single summary sheet.

Part 6 is about data bases and data-mining. It begins with sorting and filtering data, it covers Subtotals and Grouping data for better analysis of your database. It ends with a comprehensive set of pivot table sessions. 

Each session will include two Excel workbooks, one for you to practice the session and a post session solved workbook.

After taking this course you'll be able to:  

  • Use Excel efficiently, utilizing the auto-fill and important shortcuts
  • How to create formulas and use functions absolute and relative addressing
  • Benefit from the Naming of cells and ranges
  • Produce and format charts
  • Work and manipulate text
  • Solve statistics problems
  • Use what-if-analysis for simple and complex managerial decision making   
  • Utilize lookup functions
  • Sum a few sheets into a summary sheet
  •  Use filter, sort and summarize data
  • Create reports and Pivot Tables and perform other data mining techniques

    This course is for professionals within the following business functions: 

    • are an MBA student or plan to begin your MBA
    • spend more than 5 hours a week using Excel
    • are in a decision-making position at any level – it will improve your decision-making ability
    • doing any analysis in accounting, finance, marketing & sales, HR or strategy – this will enable you to handle your analysis in a very efficient and creative way
    • make any quantitative and graphical presentations
    • are an executive assistant you can support management with your skills
    • are planning to take the next seminar in the series: Advanced Analytical Techniques for Decision Making

    1. Course Description

      1. The Course Syllabus
      2. About the Presenter
      3. Course Description
    2. PART 1: Excel Efficiency - 44 Minutes

      1. Excel Efficiency
      2. Download Part 1 Files 
      3. Auto Fill
      4. Selecting in Excel
      5. Selecting in Excel
      6. Formulas & Addressing
      7. Naming Cells and Ranges
      8. Simple & Quick Charts
      9. Advanced Charting Techniques
      10. Sparklines
    3. PART 2: The IF function and Text Manipulation - 15 Minutes

      1. Introduction
      2. Download Part 2 Files
      3. The If Function
      4. Text manipulation
      5. Flash Fill
    4. PART 3: Statistics for the Not-Statistician - 32 Minutes

      1. Introduction
      2. Download Part 3 Files
      3. Descriptive Statistics
      4. Frequency Distributions
      5. Data Analysis
      6. Regression
      7. Fit a formula to a curve
    5. PART 4: What-If Analysis - 34 Minutes

      1. Introduction
      2. Download Part 4 Files
      3. Goal Seek
      4. Data Tables Sensitivity Analysis
      5. Using Scroll Bars for Sensitivity Analysis
      6. what-If Review Example
    6. PART 5: VLOOKUP and 3D Excel - 21 Minutes

      1. Introduction
      2. Download Part 5 Files
      3. Basic Range VLOOKUP
      4. An Exact Match VLOOKUP
      5. VLOOKUP Review
      6. Going the 3rd Dimension 1
      7. Going the 3rd Dimension 2
      8. Going the 3rd Dimension 3
    7. PART 6: Data and Data Mining - 50 Minutes

      1. Introduction
      2. Download Part 6 Files
      3. Sorting Data
      4. Auto Filter
      5. Subtotal and Group and Outline
      6. Introducing Pivot Tables
      7. Pivot Examples
      8. Advanced Pivot Table Example
      9. Pivot Table Case Study

    About the Expert

    Isaac Gottlieb

    Isaac Gottlieb

    Isaac Gottlieb, PhD Dr. Isaac Gottlieb received his PhD from Columbia University in Industrial and management Engineering. He is currently a a professor at Temple University. He is the author of the book “Next Generation Excel: Modeling In Excel For Analysts And MBAs (For MS Windows And Mac OS)”, Wiley Publications. Professor Gottlieb has taught this course, an academic course as well as a workshop at several universities including, Columbia, NYU, Rutgers and Temple in the USA; and in several universities abroad. He has also conducted this workshop in numerous corporations. He also teaches courses in Analytic techniques For Decision Making, Operations Management and Statistics for managers. Isaac Gottlieb was awarded the Microsoft MVP (Most Valuable Professional) for 2014-16. With over 25 years of industrial experience in manufacturing and consulting, Dr. Gottlieb applies these techniques to a variety of applications. Dr. Gottlieb authors an Excel Tip of the Month newsletter mailed to over 50,000 subscribers.
    Read more