Вернуться к Introduction to Spreadsheets and Models

звезд

Оценки: 3,503

•

Рецензии: 655

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

MM

21 июня 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 :)

RJ

11 июня 2020 г.

The course is worth the time , the faculty teaches you about some complicated advance formulae with so much clarity and ease that even beginners can be pro in excel related to business and finance.

Фильтр по:

автор: Rob P

•19 апр. 2019 г.

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

автор: N B

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

автор: Ravi D

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

автор: Aditya P

•6 апр. 2019 г.

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

автор: Meg B

•7 апр. 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....

автор: Nicholas J C

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

автор: Loh T J

•8 янв. 2019 г.

The slides were not informative.

автор: Hayk L

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

автор: Andre B

•5 мая 2020 г.

Keeping in mind that this course should introduce spreadsheets and models, it is quite a discombobulated attempt at doing so. The 'models' are glossed over, and too much focus is placed on simple spreadsheet functions which can easily be learned via internet searches. The quizzes are riddled with ambiguity, potential solutions don't take into account multiple solution possibilities/variations such as optional excel function parameters, and numerical questions do not specify rounding requirements. This will likely lead to several attempts to pass the quizzes despite knowing the correct answer but not the specific solution required. Thus, making quizzes a chore rather than a test of knowledge. There is a disconnect between the material covered and the material tested, and there are inconsistencies between supplied spreadsheets and in-lecture examples. Additionally there is a notable error as the lecturer refers to the 'coefficient of determination' as the 'covariance' in one of the videos. Not something you want to hear when someone is teaching the interpretation of excel regression outputs. For anyone who has used Excel before (to do a calculation) and knows how search engines work, I would not recommend taking this course. You're better off just searching the syllabus sections online as there are tons of free resources that provide exactly the same information. There are plenty of websites that can not only teach you this content, but do so much more comprehensively and in an introductory business modelling context. All of that is provided freely online, with equivalent brevity and clarity to the lectures in this course. Other online course websites also offer much more comprehensive excel modelling and intro courses that 'blow the socks off' this one and for under 20 bucks when on sale (frequently)! The only acceptable reasons to take this course are: the specialization prerequisite, or you are interested in business but 'Excel' and 'Google' are undefined words to you.

автор: Qixiang Y

•30 сент. 2019 г.

Good content, but crappy quiz.

автор: Leonard P

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

автор: Guillermo E F

•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

автор: Jeffrey C

•24 мая 2020 г.

Thought Don was a good speaker, the various examples were interesting and provided good variety for basic Excel business statistical analysis, which I believe was the purpose.

2 severe weaknesses:

1) Quizzes do not provide feedback on missed answers. I realize there is likely some concern about "giving the answers away". Therefore, once a passing grade has been obtained, the testing function should explain any and all mistakes made/or why the correct answers were correct in all iterations of the tests taken.

2) There were many references given to receiving samples of the model examples used in the course. I cannot find them anywhere; also I asked about this in the discussion section and NEVER received a reply from Wharton or Coursera.

These are significant deficiencies in teaching and customer service and remove 2 stars from my grace.

автор: Jesse U

•3 июня 2020 г.

The course is quite helpful and valuable, but i felt it could have had more context and content. The presenter Don, seemed to be reading off a script and lacked the personal touch or know how on the subject matter. Also in explaining the various funtionality, the spreadsheets were obviously pre-made, but this then led to some of the steps to be missed in being explained, how they were done etc.

автор: Adhitama B A

•3 июня 2020 г.

Very useful content but terribly demonstrated.

автор: Evan H

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

автор: Ahmad R S

•11 окт. 2021 г.

I would like to give my honest review: The course video/content is basically good, the lecturer explain it clearly and I understand it. The problem is the quiz: First, for the question that requires an excel formula typing answer, I think the answer detector is only detect the ones that match exactly the same syntax with the answer's key so if you type =B*A it will be marked wrong if the key is =A*B; second, for question that allows multiple answers, even if you answer one of the option wrong, the point is zero, no pro-rate score for the correct answers; and the third and the most important is there is no feedback for the quiz, what process is in my answer went wrong, what options did i chose wrong, no there is nothing like that at all, and some question/issue not even explained in the course video/content so in some point i feel like the lesson is not sufficient to take the quiz. Overall, I have finished the course and i would give my gratitude to the lecturer and the team behind the course and hope there will be an improvement for this course in the future.

автор: Gitesh S

•5 апр. 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.

автор: Mthokozisi C M

•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 :)

автор: Richa S

•30 июля 2021 г.

This course is a must for all the learners who want to go ahead and achieve big because this course not just teaches you about financial scenarios etc. but the knowledge can be used in real life

автор: Byron H

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

автор: Steven B

•1 янв. 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.

автор: Prateek S

•29 дек. 2018 г.

GREAT! KEEP UP THE GREAT WORK

автор: Panagiotis G

•22 окт. 2017 г.

Good and practical sessions

автор: Ao Z

•16 сент. 2017 г.

Sometimes not clear enough.

- Аналитик данных Google
- Управление проектами от Google
- UX-дизайн от Google
- ИТ-поддержка Google
- Наука о данных IBM
- Аналитик данных от IBM
- Анализ данных с помощью Excel и R от IBM
- Аналитик по кибербезопасности от IBM
- Инженерия данных IBM
- Разработчик комплексных облачных приложений IBM
- Маркетинг в социальных сетях от Facebook
- Маркетинговая аналитика Facebook
- Представитель по развитию продаж от Salesforce
- Сбытовые операции Salesforce
- Бухгалтерия от 'Интуит'
- Подготовка к сертификации Google Cloud: облачный архитектор
- Подготовка к сертификации Google Cloud: специалист по инженерии облачных данных
- Начните карьеру
- Подготовьтесь к сертификации
- Продвинуться по карьерной лестнице

- бесплатные курсы
- Изучите иностранный язык
- Python
- Java
- веб-дизайн
- SQL
- Cursos Gratis
- Microsoft Excel
- Управление проектами
- Безопасность в киберпространстве
- Людские ресурсы
- Бесплатные курсы в области науки о данных
- говорить на английском
- Написание контента
- Веб-разработка: полный спектр технологий
- Искусственный интеллект
- Программирование на языке C
- Навыки общения
- Блокчейн
- Просмотреть все курсы

- Навыки для команд по науке о данных
- Принятие решений на основе данных
- Навыки в области программной инженерии
- Навыки межличностного общения для проектных групп
- Управленческие навыки
- Навыки в области маркетинга
- Навыки для отделов продаж
- Навыки менеджера по продукту
- Навыки в области финансов
- Популярные в Великобритании курсы по науке о данных
- Beliebte Technologiekurse in Deutschland
- Популярные сертификаты по кибербезопасности
- Популярные сертификаты по ИТ
- Популярные сертификаты по SQL
- Профориентация: маркетолог
- Профориентация: руководитель проектов
- Навыки программирования на языке Python
- Профориентация: веб-разработчик
- Навыки для аналитика данных
- Навыки для UX-дизайнеров

- Сертификаты MasterTrack®
- Профессиональные сертификаты
- Сертификаты университетов
- MBA и другие дипломы в области бизнеса
- Степени в области науки о данных
- Степени в области компьютерных наук
- Дипломные программы по анализу данных
- Степени в области общественного здравоохранения
- Степени в области социальных наук
- Дипломные программы в области управления
- Дипломы ведущих европейских университетов
- Дипломы магистра
- Степени бакалавра
- Дипломы с карьерными путями, ориентированными на результат
- Бакалаврские курсы
- Что такое диплом бакалавра?
- Сколько времени нужно для получения диплома магистра?
- Стоит ли получать диплом MBA онлайн?
- 7 способов оплатить магистратуру
- Посмотреть все сертификаты