Voltar para Introduction to Spreadsheets and Models

4.2

stars

2,403 classificações

•

404 avaliações

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!

Filtrar por:

por Robert P

•Apr 19, 2019

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

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

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

por Aditya P

•Apr 06, 2019

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

por 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!

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

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

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

por 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

por Loh T J

•Jan 08, 2019

The slides were not informative.

por 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

por 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

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

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

por 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)

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

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

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

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

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

por Janice N C W

•Feb 18, 2019

A little more technical compared to the first Course in this Business & Finance Specialization and requires more time to understand the various uses of modelling. Definitely useful if one has intention of mastering Data Analysis and projections.

por Jafed E

•Jul 06, 2019

I enjoy the lectures. The professor has a good speaking and teaching style which keeps me interested. Lots of concrete math examples which make it easier to understand. Very good slides which are well formulated and easy to understand

por Siddharth B

•Jun 04, 2018

The course is truly helpful for those who do not have prior understanding on how to implement the business problems into Excel. This courses teaches me the usage of excel tools to come at the final outcome for decision making.

por Kenneth B

•May 11, 2016

Concise, no fluff spreadsheet modeling fundamentals with quality instruction concerning the different functions, data analysis and solver add-ins needed to start building effective financial models. Thanks Professor Huesman.

por Farouk G

•Jul 21, 2019

Very well-structured, full of practical content - also includes a great tutorial on solving linear programs in Excel. Felt like I was learning with every video, which is not always the case with online courses. Well done!