Back to Mastering Data Analysis in Excel
Duke University

Mastering Data Analysis in Excel

This course focuses on essential data analysis using Excel. Learn to design and implement realistic predictive models to reduce uncertainty for informed business decisions. In a hands-on project, you'll act as a business data analyst, building models to assess credit card applications, minimize default risk and maximize bank profits. You'll master key uncertainty measures like classification error rates, entropy of information, and confidence intervals for linear regression. Assignments use data provided within the course and basic Excel functions, ensuring fluency for future business applications. No prior knowledge of advanced Excel features (Visual Basic, Pivot Tables) is required. The Excel and data analysis skills you will learn will enable you to apply business data analysis methods based on binary classification, information theory and entropy measures, and linear regression, and prepare you for roles such as a business data analyst.

Status: Microsoft Excel
Status: Predictive Modeling
BeginnerCourse22 hours

Featured reviews

JL

5.0Reviewed Apr 14, 2018

This course is worth taking by anyone who needs to have a better understanding of how the most efficient and best decisions in the market place are taken using Data management simply in Excel.

PS

4.0Reviewed May 7, 2020

Quite comprehensive on the usage of concepts taught in the course. However, bit of diversion seems to come in assignments and quizzes. Overall, very challenging and fulfilling.

JE

5.0Reviewed Oct 30, 2015

The course deserves a 5-star rating because: (1) content is relevant, (2) the professor is concise and possesses great teaching skills, and (3) the learning modules are applicable to daily problems.

RC

5.0Reviewed Jan 14, 2017

I love this course and the way the material is explained. I plan on taking this course again to improve my understanding of the information because I think it relays very important ideas.

TB

5.0Reviewed Nov 16, 2021

I like and appreciate courses provided through Coursera.This course is very interesting and valuable for those whose jobs do have relevance with data management .God bless Coursera and Duke University

AS

5.0Reviewed Feb 14, 2019

This course has enabled me to think the way a data analyst need to think. This course helps in independent growth and getting know the topics by own research. Loved it ! Thank you !

KM

5.0Reviewed Sep 27, 2019

J'ai énormément apprécié la qualité des vidéos, des exemples pratiques, des exercices ainsi que les documents PDF, WORD et EXCEL fournis pour comprendre et suivre facilement ce cours.

PW

5.0Reviewed Oct 13, 2020

The course was excellent. A little difficult and overwhelming at times but as long as you stayed the course the professors gave you every opportunity to succeed. Thank you for your time professor.

PD

5.0Reviewed Mar 15, 2016

Dr Eggers is a tremendous professor. The course has wit and application along with assignments that are well scaffolded to the learning content. Highly recommend this class.

MM

5.0Reviewed Jun 17, 2021

I​ am very happy to learn this course and very thankful to coursera and Duke University for giving me certificate in such a course like Excel and teach me clearly in every section.

TR

5.0Reviewed Nov 26, 2017

A challenging course that rewards conscientious effort. Heavy on math, both practical and theoretical. Highly recommend comfort with college level statistics before taking this course.

MC

4.0Reviewed Feb 27, 2016

Highly useful and practical course. it can be a bit challenging for Uni graduate from irrelevant field. the First course and the visualisation course from this series of specialisation is okay .

All reviews

Showing: 20 of 946

GBT
1.0
Reviewed Feb 24, 2019
Thomas Sullivan
1.0
Reviewed Feb 12, 2019
Dennis Nielsen
1.0
Reviewed Sep 8, 2016
Will Darmohray
1.0
Reviewed May 20, 2020
Krishna K.
2.0
Reviewed Feb 18, 2018
Santiago P
1.0
Reviewed Jan 19, 2020
Courtney Budler
2.0
Reviewed Sep 2, 2018
Mohammad Aslam Pirkhan
1.0
Reviewed Jun 24, 2019
Kaiquan Mah
1.0
Reviewed Jun 6, 2016
Thanapich Thammathi
1.0
Reviewed Dec 28, 2018
He Song Koo
1.0
Reviewed Jun 26, 2016
Ted Zollinger
2.0
Reviewed Apr 28, 2020
Ricardo Gutierrez
1.0
Reviewed Jan 24, 2016
Fons 't Hart
1.0
Reviewed Apr 18, 2016
KRUTI SHAH
1.0
Reviewed May 8, 2019
Junior Ludger
5.0
Reviewed Apr 15, 2018
Alexey Kreynin
1.0
Reviewed May 4, 2020
Ir O.
1.0
Reviewed Nov 2, 2019
Ryzhov Viktor
1.0
Reviewed Feb 5, 2016
Manuel Enrique De La Rosa Gimeno
1.0
Reviewed Jun 19, 2017