### Top 50 MOOCs

To support our site, Class Central may be compensated by some course providers.

# Mastering Data Analysis in Excel

500
students interested
Important: The focus of this course is on math - specifically, data-analysis concepts and methods - not on Excel for its own sake. We use Excel to do our calculations, and all math formulas are given as Excel Spreadsheets, but we do not attempt to cover Excel Macros, Visual Basic, Pivot Tables, or other intermediate-to-advanced Excel functionality.

This course will prepare you to design and implement realistic predictive models based on data. In the Final Project (module 6) you will assume the role of a business data analyst for a bank, and develop two different predictive models to determine which applicants for credit cards should be accepted and which rejected. Your first model will focus on minimizing default risk, and your second on maximizing bank profits. The two models should demonstrate to you in a practical, hands-on way the idea that your choice of business metric drives your choice of an optimal model.

The second big idea this course seeks to demonstrate is that your data-analysis results cannot and should not aim to eliminate all uncertainty. Your role as a data-analyst is to reduce uncertainty for decision-makers by a financially valuable increment, while quantifying how much uncertainty remains. You will learn to calculate and apply to real-world examples the most important uncertainty measures used in business, including classification error rates, entropy of information, and confidence intervals for linear regression.

All the data you need is provided within the course, all assignments are designed to be done in MS Excel, and you will learn enough Excel to complete all assignments. The course will give you enough practice with Excel to become fluent in its most commonly used business functions, and you’ll be ready to learn any other Excel functionality you might need in the future (module 1).

The course does not cover Visual Basic or Pivot Tables and you will not need them to complete the assignments. All advanced concepts are demonstrated in individual Excel spreadsheet templates that you can use to answer relevant questions. You will emerge with substantial vocabulary and practical knowledge of how to apply business data analysis methods based on binary classification (module 2), information theory and entropy measures (module 3), and linear regression (module 4 and 5), all using no software tools more complex than Excel.

#### Taught by

Jana Schaich Borg and Daniel Egger

#### Tags

Cost Free Online Course (Audit)
Subject Data Analysis
Institution Duke University
Provider Coursera
Language English
Certificates Paid Certificate Available
Calendar 6 weeks long
##### FAQ View All
What are MOOCs?
MOOCs stand for Massive Open Online Courses. These are free online courses from universities around the world (eg. Stanford Harvard MIT) offered to anyone with an internet connection.
How do I register?
To register for a course, click on "Go to Class" button on the course page. This will take you to the providers website where you can register for the course.
How do these MOOCs or free online courses work?
MOOCs are designed for an online audience, teaching primarily through short (5-20 min.) pre recorded video lectures, that you watch on weekly schedule when convenient for you.  They also have student discussion forums, homework/assignments, and online quizzes or exams.

## Reviews for Coursera's Mastering Data Analysis in Excel 1.7 Based on 25 reviews

• 5 stars 12%
• 4 star 0%
• 3 star 0%
• 2 stars 20%
• 1 stars 68%

Did you take this course? Share your experience with other students.

• 1
1.0 2 years ago
dropped this course.
FYI: I paid for this course.

I was really enjoying the course (second course in the series)up until week 1 and really looking forward to the simple and easy way of learning from week 1 and course 1 of this series.

But just in week 2, things started to derail. Mr.Egger was making so many technical assumptions on part of the student, which was unfair since the course and certificate series are supposed to be Introductory level with no prior experience. For example:

1. In the PPV and NPV video, you just ran through without any easy way for student to grasp such important concepts.

2. Then, he started to use "z" score without introducing it / explaining it in the soldier example.

I wonder whether there were missing videos in week 2, because:

1. In the practice quiz, a question was on "the new minimum cost per event/cost per test", which he never even discussed in any of the lecture.

2. In the practic…
34 people found
1.0 2 years ago
completed this course.
Don't waste your time. I finished the course (waiting on the peer review grade) and did learn some things. But the learning was from the discussion forum and a lot of trial and error. The only Excel you will do is in the assignments. The lectures are terrible. If you are not familiar with the material you certainly won't learn anything. Each week has about 30-40 minutes (week 5 had 19 minutes) of the professor going over the mathematical theory with almost no actual examples. You are then given an excel spreadsheet and told to put what you learned to use. Towards the end of the class it seems that the staff just gave up and released all of the answers to the quizzes.

I see one of two things here. One, the staff at Duke are completely clueless and thought this course matches the description and is sufficient to learn.

Or two, they knew it was insufficient but were under a deadline so they just went through with it. I think this is the most likely answer.
26 people found
2.0 2 years ago
by partially completed this course, spending 8 hours a week on it and found the course difficulty to be hard.
This course is NOT the course to take if you want to learn Excel or to build analytical models in Excel. Instead it's a course that seems to be presenting fairly sophisticated analytical techniques using already-built Excel models. The lectures went from a somewhat promising start to a steady downhill progression of blackboard presentations that ultimately completely confused me. I'm stubborn, so I'm planning to retake the class. The second time around I'll know to start working on the final by week 2 so I can tackle it as we go through the material. Starting the final after listening to all of the lectures simply told me how little of the material I had actually understood and am now able to apply. I really enjoyed the professor in the first course of the specialization; on this course he seemed to be just going through the paces with little enthusiasm and no patience for those of us who haven't majored in Statistics.
14 people found
1.0 2 years ago
by completed this course, spending 5 hours a week on it and found the course difficulty to be hard.
The class focused on how certain statistical models are implemented in Excel - in theory. Although no math backgound was required, don't even think about taking this class unless you are an Excel power user with integral and differential Calculus, statistics I and II, and machine learning under your belt otherwise you will be totally lost.
22 people found
1.0 2 years ago
by dropped this course, spending 12 hours a week on it and found the course difficulty to be hard.
DO NOT WASTE YOUR TIME WITH THIS COURSE.

I concur with Brian O's assessment. He is 100% right with his comments about what is needed. I have all of that and more (S.T.E.M. courses out my ears, grad and undergrad) and have successfully completed six other quantitative courses from Coursera. It is sloppy and unprofessional beyond belief. Terms are not defined, quizzes are confusing and you will spend most of your time trying to figure out what is being asked. It's not worth your time, let alone the \$79 for a cert. In addition, most of what he does in Excel is much better done in R or JMP or any of the other packages out there.

10 people found
1.0 2 years ago
partially completed this course.
The course content had very little to do with Excel. More like Excel is just a briefly mentioned tool, rather than the main training environment of the course. Moreover, all the concepts taught are very loosely related to each other. At points it feel like the concepts are just there for the sake of making the course looking high-level and complicated. But at the core of it, it feels like there's little to none coherency in all the lectures, assignments and problems put forward.
6 people found
1.0 2 years ago
completed this course.
The course video lectures are of no use, if you want to complete this course, you gotta work a lot by yourself. Discussion Forum may help you. Better you spend your time learning same concepts from anywhere else. Literally, every concept taught has a better explained video on youtube.
11 people found
1.0 3 months ago
completed this course.
Frankly the course left me feeling disappointed - the concepts therein are truly important and interesting, and Mr. Egger is an enthusiastic, likeable and very knowledgeable teacher.

BUT

This is NOT an introductory course. This is NOT a course on Excel. This is NOT a course you can complete working less than 15 hours per week on. And most certainly NOT a course that gives you what you need.

The format: the teacher will mention a very advanced statistical concept, go through it briefly using horribly formatted scribbles and hand-drawn "diagrams". Then the learner is instructed to download a pre-built spreadsheet that has all the formulae in it, and learn from it.

This is not an exaggeration. If you want to understand the concepts (which again, are worth learning) behind, be prepared to learn them on Khan Academy, youTube or anywhere else. Painstakingly. With a LOT of time. The course forums are chock full with frustrated learners, p…
1.0 8 months ago
partially completed this course.
I concur with all other negative comments. I had a high expectation and was very excited to take this course, but found out this course has very little to do with Excel. It is mainly statistics. Worse than that, the video lectures are way too brief, I took all Calculus courses back in college, and still found the material hard to understand in the way Mr. Egger explains. I had to search a lot outside sources (online text and YouTube videos) to help me get a better idea. The quizzes followed every lecture just jump into practical problems. I had to guess through the first time in order to get a hint, and spent even more time to trace back the theories mentioned in the lectures. The Excel sheets attached in every week lecture are well designed, but he never rarely uses in his videos.

I completed 5 weeks (total 6 weeks), and now I'm considering dropping this course. Week 6 is a final project to build a model using 200 historical data to predict whether to accept or rejec…
1.0 2 years ago
is taking this course right now.
I'm currently struggling through this course. Having completed 4 weeks with more hours spend than advertised, I can only say that to pass the exams you just need to write down each answer and resit the exam for the incorrect answers until you pass the test. The video lessons do not give you the tools or the knowledge to pass the tests. Prior advance math and statistics knowledge is assumed by the professor and it definitely does not cater to beginners, as advertised.

Based on comments above I started working on the final assignment and am feeling utterly demotivated as the prior video lessons do not prepare you enough for the final assignment...BEWARE!
1 person found
1.0 2 years ago
is taking this course right now.
I had such high expectations for this course, and I am absolutely crushed by how far it has fallen from them. I'm not learning very much and am only passing the quizzes by relying on the hints provided after failing them the first time. Even after I manage to pass a quiz, I do not have a thorough understanding of the material--certainly nothing I would actually be able to use in a job in the industry.

I'm becoming very concerned that I paid for this course and the specialization. Beware.
5 people found
2.0 2 years ago
partially completed this course.
I paid for this course, I have engineering background and work in IT so I had already learnt some of the math and statistics needed in this course, but forgotten after 12 years. The course videos are very poorly designed and I had to refer a lot elsewhere like on youtube and Khan academy, which in spite of being a free website was so much better. I ended up making a donation to KA and would recommend taking their High School Probability and Statistics course before you take this one.
3 people found
2.0 10 months ago
by is taking this course right now.
I enjoyed Week 1 of this course (and have completed the previous course in the specialization), but like many other reviewers, am finding the material in Week 2 way over my head and poorly explained. This is not an "introductory" course by any means - if you do not have some prior knowledge of the mathematical and statistical concepts covered here you will flounder. I'm spending half my time looking up things elsewhere to get clarification (for free) that I'm not getting here in a course I'm paying for. Not sure I'll be sticking with this one.
1.0 2 years ago
completed this course.
Please, save yourself 6 weeks of your precious time! Material is really poor and final project is disconnected from weekly lessons. Duke University Board must have a look at this course and take it out from the catalog until material is improved
3 people found
2.0 2 years ago
by completed this course.
If you want to learn some skills in excel, i don't think it worth learning because from the second week i'm keep learning some math knowledge and they're sometimes difficult to understand.
3 people found
1.0 8 months ago
dropped this course.
I dropped into the 6th week. I totally concur with the other negative comments. I found the errors to be totally unacceptable. Disappointing because I really wanted to learn something.

BTW - I was going to rate it zero stars but it makes me place at least one star.
1.0 12 months ago
partially completed this course.
It's a math course not an Excel course. It's difficult and the instructor's sloppy hand doodling/writing in the videos only made it more challenging to capture what was being taught.

1.0 a year ago
audited this course.
This course talks little about excel. Instead, it spent a lot of time on statistics.

Do not take this course if you want to learn practical skills.