Course Summary
This course provides a comprehensive introduction to spreadsheets and models in business. It focuses on building practical skills in Excel and modeling techniques to help you make informed business decisions.Key Learning Points
- Learn the fundamentals of Excel including formulas, formatting, and data analysis
- Understand modeling techniques such as sensitivity analysis, optimization, and scenario analysis
- Apply your skills to real-world business situations and make informed decisions
Related Topics for further study
Learning Outcomes
- Master Excel and modeling techniques to help you make informed business decisions
- Create and analyze complex spreadsheets to identify trends and patterns
- Apply your skills to real-world business situations and communicate your findings effectively
Prerequisites or good to have knowledge before taking this course
- Basic knowledge of Excel
- Access to Microsoft Excel (preferably 2016 or later)
Course Difficulty Level
BeginnerCourse Format
- Online
- Self-paced
- Video Lectures
Similar Courses
- Data Analysis and Presentation Skills: the PwC Approach
- Introduction to Data Analysis
- Excel Skills for Business: Essentials
Related Education Paths
Notable People in This Field
- Author and Professor
- Statistician and Founder of FiveThirtyEight
Related Books
Description
The simple spreadsheet is one of the most powerful data analysis tools that exists, and it’s available to almost anyone. Major corporations and small businesses alike use spreadsheet models to determine where key measures of their success are now, and where they are likely to be in the future. But in order to get the most out of a spreadsheet, you have the know-how to use it. This course is designed to give you an introduction to basic spreadsheet tools and formulas so that you can begin harness the power of spreadsheets to map the data you have now and to predict the data you may have in the future. Through short, easy-to-follow demonstrations, you’ll learn how to use Excel or Sheets so that you can begin to build models and decision trees in future courses in this Specialization.
Outline
- Spreadsheets: A Tool for Thinking with Numbers
- 1.1 Objectives and a Little Spreadsheet History
- 1.2 Navigating a spreadsheet and crafting formulas
- 1.3 Using functions
- 1.4 Using conditional expressions in formulas
- 1.5 Common errors in spreadsheets
- 1.6 Differences between Sheets and Excel
- PDF of Module 1 Lecture Slides
- Module 1 examples
- Module 1 Quiz: History, Formulas, Functions and Errors
- From Spreadsheet to Model
- 2.0 Module Introduction
- 2.1 Using assumptions and decision variables in spreadsheet models
- 2.2 Structuring a spreadsheet to model variables, objectives, and objective functions
- 2.3 Constructing simple cashflow model
- 2.4 What-if analysis and sensitivity analysis
- 2.5 Limits to simple, deterministic models
- PDF of Module 2 Lecture Slides
- Module 2 examples
- Module 2 Quiz: Classic Models
- Addressing Uncertainty and Probability in Models
- 3.0 Introduction
- 3.1 Random variables and probability distributions
- 3.2 Changes in discrete and continuous time
- 3.3 Power, exponential, and log functions
- 3.4 Probability trees and decision trees
- 3.5 Correlation and Regression
- PDF of Module 3 Lecture Slides
- Module 3 examples
- Additional reading on exponential and other functions
- Module 3 Quiz: Probability, Correlation, and Regression
- Simulation and Optimization
- 4.0 Introduction
- 4.1 Monte Carlo Simulations
- 4.2 Linear Programming
- 4.3 Next Steps, and Differences between Excel and Sheets
- PDF of Module 4 Lecture Slides
- Module 4 examples
- Links and other resources for further study
- Module 4 Quiz: Simulations, Scenarios, and Optimization
Summary of User Reviews
Learn how to use spreadsheets and models in business with this introductory course from Wharton. Read reviews to see what users thought.Key Aspect Users Liked About This Course
Many users found the course to be very informative and helpful in understanding how to use spreadsheets for business purposes.Pros from User Reviews
- Thorough coverage of spreadsheet functions and modeling techniques
- Easy to follow explanations and examples
- Real-world applications and case studies
- Interactive quizzes and assignments to reinforce learning
Cons from User Reviews
- Some users found the pace to be too slow or too fast
- Limited interaction with instructors or other students
- Not suitable for advanced users or those with extensive spreadsheet experience
Don Huesman
4.2 Raiting
SQL Server SSAS (Multidimensional MDX) - an Introduction
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Create cubes from databases, analyse them in Excel, SSRS etc. using SSAS MDX (a Business Intelligence tool). Exam 70-768 Reviews: " -- Lakeside David-Debo...
Ethereum : Decentralized Application Design & Development
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Develop a full DAPP | ICO | Setup Private network in next 2 weeks using Web3J, TruffleV4, MetaMask, Ganache, Solidity ++...
Risk Management and Credit Principles
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Get introduced to risk management, credit principles, and business risk as they relate to a borrower. The course begins with an introduction to risk management and credit principles....
Agile Organization
- 4.7
-
![]()
![]()
![]()
![]()
![]()
The theory of Agile is simple. However, it takes experience, knowledge, and expertise to scale it successfully. Not every aspect of the business is suitable for the application of Agile....
