Back to Introduction to Spreadsheets and Models

4.2

stars

2,892 ratings

•

519 reviews

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.
Basic familiarity with, and access to, Excel or Sheets is required....

Jun 22, 2017

This course has made me understand cost accounting, has provided a fresh perspective on how to solve some of the challenges i had with management accounting and as a bonus, made me love maths again :)

Sep 12, 2017

So many tools that I knew existed and have tried to use the How-To's to learn how they work and until the Prof takes you through them one-at-a-time, they never make sense. Great Stuff!

Filter by:

By Robert P

•Apr 19, 2019

Quizzes need to explain why some question answers are incorrect, or else learning is almost impossible.

By N B

•Apr 21, 2019

The information is glossed over quickly and does not prepare the learners for the quiz questions at all. The quizzes are set up in such a manner that it is extremely difficult to learn from them. There is no feedback on written in answers, which makes it impossible to understand the mistake that was being made. The questions on the quiz were also more specific and demanding than any lecture or material from the course would suggest. Interesting material presented in a poor manner.

By Ravi D

•May 21, 2019

The lectures are very thin, and questions very arbitrary. In the end I felt this course was very low value.

The tests themselves are poorly graded, obvious correct formula answers are marked wrong (tested my answers on excel).

The Teaching staff are not available. Most answers are 2-3 years old.

By Aditya P

•Apr 06, 2019

No theory, Very vague. Questions asked unrelated to what the teacher said.

By Meg B

•Apr 07, 2016

What to say about this course? On the one hand, I learned a lot which merits the three stars. On the other hand, the quizzes were very poorly designed. It took me the maximum three tries on every single quiz to pass and I did just barely. Hey, this is EXCEL, not advanced calculus! Also, there were questions on the quiz that weren't even covered in the particular module. E.g., on quiz #1, there was a question about "objective functions" which the instructor didn't explain until the last course module. There were times when I questioned my own sanity until I read in the course discussions that others were experiencing the same issues. Before presenting this course again, TEST, TEST, TEST the quizzes and answers!! And if you're not going to allow for a range of correct answers or formatting variances, then change all questions to multiple choice where there's (maybe) a fighting chance of passing. I am immensely relieved this course is done and I can move on to the next one in the specialization--hoping it's better organized as was the Fundamentals course that Richard Waterman taught. I was fearful that a course in Excel was going to doom me for the rest of the specialization. Last recommendation: improve the presentation materials. Provide more details for reference purposes. Okay, I'm going to go relax, now, to recover from this trying experience....

By Nicholas J C

•Feb 10, 2019

Extremely content light. Quizzes are bizarre and basically rely that you go back to the lecture and find the one sentence where a comment was made. There's no interactivity. Really pales in comparison to the first course in the sequence. I really hope this specialization gets better or this will be a SLOG. I expected better from Wharton!

By Leonard P

•Jun 10, 2018

I am really trying to learn throughout my learning experience and I think I did throughout this course. However, I believe that there are certain irregularities within this framework, as questions in tests are not communicated properly and furthermore not fully articulated throughout the lectures. This is just to give one feedback and improve certain conditions for upcoming modules. Thank you very much for giving me some extra knowledge and good luck for the upcoming future.

By Hayk L

•May 13, 2019

While the course can be useful to learn some modelling tricks with Excel, I found the quizz somehow badly designed for some questions, especially the one requiring entering formulas as in real life, a goal could be achieved using several different ways of writing formulas.

But otherwise, the teacher was clear and to the point.

By Evan H

•May 11, 2019

I thought this was a great course. I have an undergraduate finance degree and it encompasses a lot of the econ/ math/ finance courses I took and actually shows you how all of these elements are applied. Eye opening for me and very helpful.

By Guillermo E F

•May 16, 2019

I felt modules 1 and 2 tests where a bit misleading in some questions. I think there could be better questions to assess the learning of those modules

By Gitesh S

•Apr 05, 2016

This course was very average to me. Compared to the first course in the specialization, Fundamentals of Quantitative Modeling, which was absolutely great.

What I liked:

Good info on the tools in excel that are needed.

What I didn't like:

Time spent on content that necessarily wasn't regarding models; the critical material was buried in videos and was very brief. More time should have been spent. Additionally the quiz questions were subjective at times based on what was said on video and the formula answers weren't correctly graded in many cases.

This course could have been much better, maybe I was just spoiled by the first course.

By Steven B

•Jan 01, 2019

Course content is generally very good, but could go a bit deeper on the formulation of optimization models, but that may be coming in future classes. Some quiz questions are a bit ambiguous, causes grades to be lower than what should be achievable.

By Loh T J

•Jan 08, 2019

The slides were not informative.

By Joe M

•Feb 10, 2019

I did not find it as hands on as I would like and found that the answers to the quiz's were not really in the material

By Ivan D A G

•Jan 08, 2019

Muy útil para aprender lo básico en esta materia. Tal vez se podrían ver más ejemplos de modelos más complejos, solo para abrir la mente de los participantes a las posibilidades en el trabajo de la vida real. En todo caso, me ha resultado muy útil y lo recomendaré a mis colegas. Gracias por su apoyo y estoy a sus órdenes en Colombia. + 57 317 366 2160

Very useful to learn the basics in this matter. Maybe you can see more examples of more complex models, just to open the minds of the participants to the possibilities in real-life work. In any case, I found it very useful and I recommend it to my colleagues. Thank you for your support and I am at your service in Colombia. + 57 317 366 2160

By Alan N D V P

•May 11, 2017

Excelente curso. O início é bem básico introduzindo à algumas funções do excel, porém o curso em si consegue uma boa profundidade em análises financeiras e, principalmente, projeções baseados em cenários. Aprendemos a diminuir os riscos das análises e a montar boas planilhas para planejar de forma fácil e com maior probabilidade de sucesso. Os vídeos são curtos e objetivos, o que facilita a velocidade do aprendizado.

By Debangsha K S

•Jun 07, 2017

This course was really helpful. Professor Huesman is an extraordinary pedagogue. This course really intrigues you with the statistical playfulness and mathematical insights through a very simple yet immensely useful tool named Microsoft Excel (as I have used that throughout the course), so thanks to Microsoft. Finally Pf. Huesman, you rock!! (pardon for the unprofessional language)

By Joswa A

•May 05, 2017

This course really helped me in understanding use of spreadsheets for financial modelling. I have now understand the use of several functions, and the data analysis tool and Excel solver in creating a good and accurate forecasting and models. This course helped me to learn more uses of excel in my profession. The course is very challenging yet it is very exciting to learn.

By Agasthya R

•Apr 20, 2020

I began this course with very limited knowledge about data modeling and ended it with a great overview of its different aspects. Prof. Don Huesman explains concepts elegantly and at the right pace. The content and teaching were engaging and easy to follow. I would definitely recommend this course to anyone who wants to gain good knowledge on how to create data models.

By Jose R D

•May 08, 2020

It covers some of the most useful and important tools at hand for probabilistic and optimization models in Excel and Google Sheets. The course seems easy but it requires some homework and additional investigation and practice to go be successful. The quizzes are a bit tricky and require a minimum level of skills to pass. Really good course.

By Shreshth V

•Dec 25, 2019

This course helped me learn about using spreadsheets, and the functions in spreadsheets to create models. This also helped me learn how to do statistical operations and linear programming. I created models for risk and uncertainty and used Solver function to maximize the profit potential for dummy business.

By Hristo D

•Apr 24, 2016

This course helped me understand the functionality of Excel and Google Sheets better. I was very intrigued by the fact how this software provides functionality into building business decision-making models, without necessarily having to resort to much more complex statistical packages such as Stata.

By maanas s

•Dec 17, 2018

it was very hard course for me to accomplish, but I really liked the lecturer helping me out at every juncture of class. introduction to spreadsheets and models is a must to go with course, it enhances your ability to understand all the basic and much needed knowledge for ms-excel.

By Guilherme A G d S

•Jun 17, 2017

Apesar desse curso ser uma introdução, o considero como nível mediano. A grade é bem coerente e a preparação para o terceiro e o quarto módulo são bem feitas. Recomendo para quem quer começar a estudar programação linear, simulações de Monte Carlo e modelos de regressão.

By Ankit S

•May 18, 2020

Had no idea how powerful Excel was before this course! Learnt how to conduct so many types of data analysis and the inferences one can draw from them thanks to this course. Some of the questions were challenging and really helped fortify the concepts learnt.

- AI for Everyone
- Introduction to TensorFlow
- Neural Networks and Deep Learning
- Algorithms, Part 1
- Algorithms, Part 2
- Machine Learning
- Machine Learning with Python
- Machine Learning Using Sas Viya
- R Programming
- Intro to Programming with Matlab
- Data Analysis with Python
- AWS Fundamentals: Going Cloud Native
- Google Cloud Platform Fundamentals
- Site Reliability Engineering
- Speak English Professionally
- The Science of Well Being
- Learning How to Learn
- Financial Markets
- Hypothesis Testing in Public Health
- Foundations of Everyday Leadership

- Deep Learning
- Python for Everybody
- Data Science
- Applied Data Science with Python
- Business Foundations
- Architecting with Google Cloud Platform
- Data Engineering on Google Cloud Platform
- Excel to MySQL
- Advanced Machine Learning
- Mathematics for Machine Learning
- Self-Driving Cars
- Blockchain Revolution for the Enterprise
- Business Analytics
- Excel Skills for Business
- Digital Marketing
- Statistical Analysis with R for Public Health
- Fundamentals of Immunology
- Anatomy
- Managing Innovation and Design Thinking
- Foundations of Positive Psychology