Mastering Data Analysis in Excel

share ›
‹ links

Below are the top discussions from Reddit that mention this online Coursera course from Duke University.

Offered by Duke University. Important: The focus of this course is on math - specifically, data-analysis concepts and methods - not on Excel ... Enroll for free.

Reddsera may receive an affiliate commission if you enroll in a paid course after using these buttons to visit Coursera. Thank you for using these buttons to support Reddsera.

Taught by
Jana Schaich Borg
Assistant Research Professor
and 1 more instructor

Offered by
Duke University

Reddit Posts and Comments

0 posts • 4 mentions • top 4 shown below

r/datascience • comment
10 points • vinzinc

To say or call Excel as a waste of time would mean that you are looking at data science as an incredibly small silo of applications. Data Science is not at all about the tools you use, be it R or Python or Excel. In fact, Data Science is about analyzing the data, gaining insights from it using various statistical and computer science tools and then understanding the story told by the data. Most of the time on Data Science is spent on the processing of the data itself and on understanding the existing patterns in the data. It will be of great use to you if you begin to download data on excel, and then explore column by column the data, plot it to see any patterns and also understand the relationship between 1 variable(column) to another. Only by doing the above can you begin to grasp the way you analyze the data. Excel is also quite capable in both plotting and making linear models which by itself are a big deal. If you go through the data and learn to explore it in excel, you will have a wonderful visual intuition of what to do and what not to do when you start analyzing tools in R or Python. I am both a post graduate in business management and now pusuing same in data science and I can tell you that if you do not know what to do with the data in Excel, you wont know what to do with it in R or Python either.

I highly recommend you to get started on your data using the concepts as taught in https://www.coursera.org/learn/analytics-excel/

Do no give up. Just barge in. I have explored more than a 100 big datasets and each dataset has its own challenges. Happy exploring.

r/datascience • comment
2 points • RedOnesLastSmarties

I don't think they mean "manually" I think they mean Excel most likely.

Using Pivot tables and manually counting, all are easily accomplished in Excel

https://www.coursera.org/learn/analytics-excel

r/datascience • comment
1 points • whileTeorems

https://www.coursera.org/learn/analytics-excel/home/welcome

The second course of a business/data analytics specialization, which by the way treats everything you cited. I'm enrolled with a paid subscription and I'm not really sure you can audit the course but you can anyway try to enroll as you will have a free week.

r/IWantToLearn • comment
1 points • watnouwatnou

Maybe try this coursera course?

I have to say I would advise to take a look at R for doing this. R is immensly superior in terms of advanced analytics possibilities and gives options to work a lot more structured than in excel. Lot's of courses on R in coursera, e.g. time series with R. It will of course be a lot more effort and you have to be open to learn the R programming language.

​

​

​