Volver a Introduction to Spreadsheets and Models

4.2

estrellas

2,462 calificaciones

•

414 revisiones

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

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

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

- IA para todos
- Introducción a TensorFlow
- Redes neurales y aprendizaje profundo
- Algoritmos, parte 1
- Algoritmos, parte 2
- Aprendizaje Automático
- Aprendizaje automático con Python
- Aprendizaje automático con Sas Viya
- Programación R
- Introducción a la programación con Matlab
- Análisis de datos con Python
- Aspectos básicos de AWS: El paso a la nube nativa
- Aspectos básicos de la plataforma en la nube de Google
- Ingeniería de confiabilidad del sitio
- Hablar inglés de manera profesional
- La ciencia del bienestar
- Aprendiendo a aprender
- Mercados financieros
- Prueba de hipótesis en el área de la salud pública
- Aspectos básicos del liderazgo diario

- Aprendizaje profundo
- Python para todos
- Ciencia de Datos
- Ciencias de los Datos Aplicada con Python
- Aspectos básicos de los negocios
- Arquitectura con Google Cloud Platform
- Ingeniería de datos en la plataforma en la nube de Google
- Excel para MySQL
- Aprendizaje automático avanzado
- Matemática aplicada al aprendizaje automático
- Automóviles de auto conducción
- Revolución de la cadena de bloques para la empresa
- Análisis comercial
- Habilidades de Excel aplicadas para los negocios
- mercadeo digital
- Análisis estadístico con R para el área de la salud pública
- Aspectos básicos de la inmunología
- Anatomía
- Gestión de la innovación y del pensamiento de diseño
- Aspectos básicos de la psicología positiva

- Soporte de TI de Google
- Especialista en compromiso con el cliente de IBM
- Ciencia de datos de IBM
- Administrador de proyectos aplicado
- Certificado profesional de IA aplicada de IBM
- Aprendizaje automático para análisis
- Análisis y visualización de datos espaciales
- Gestión e ingeniería de construcción
- Diseño instruccional

- Maestría en Ciencia de Datos
- Licenciatura en Ciencias de la Computación
- Títulos de Ciencias de la Computación e Ingeniería
- Maestría en Aprendizaje Automático
- Maestría en Administración de Empresas y títulos de estudios de negocios
- Maestría en Ingeniería Eléctrica
- Maestría en Salud Pública
- Maestría en Tecnología de la Información