Introduction to Data Analysis using Excel

Provided by:
9/10 stars
based on  3123 reviews
Provided by:
Cost FREE , Add a Verified Certificate for $99
Start Date Upcoming

Key Concepts

lightbulb
We've created a summary of key topics covered in this course to help you decide if it's the right one for you. Click individual badges to see more courses on the same topic.

Course Details

Cost

FREE,
Add a Verified Certificate for $99

Upcoming Schedule

  • Upcoming

Course Provider

edX online courses
Harvard University, the Massachusetts Institute of Technology, and the University of California, Berkeley, are just some of the schools that you have at your fingertips with edX. Through massive open online courses (MOOCs) from the world's best universities, you can develop your knowledge in literature, math, history, food and nutrition, and more. These online classes are taught by highly-regarded experts in the field. If you take a class on computer science through Harvard, you may be tau...
Harvard University, the Massachusetts Institute of Technology, and the University of California, Berkeley, are just some of the schools that you have at your fingertips with edX. Through massive open online courses (MOOCs) from the world's best universities, you can develop your knowledge in literature, math, history, food and nutrition, and more. These online classes are taught by highly-regarded experts in the field. If you take a class on computer science through Harvard, you may be taught by David J. Malan, a senior lecturer on computer science at Harvard University for the School of Engineering and Applied Sciences. But there's not just one professor - you have access to the entire teaching staff, allowing you to receive feedback on assignments straight from the experts. Pursue a Verified Certificate to document your achievements and use your coursework for job and school applications, promotions, and more. EdX also works with top universities to conduct research, allowing them to learn more about learning. Using their findings, edX is able to provide students with the best and most effective courses, constantly enhancing the student experience.

Provider Subject Specialization
Sciences & Technology
Business & Management
22314 reviews

Course Description

The ability to analyze data is a powerful skill that helps you make better decisions. Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool.

In this course, you will learn how to perform data analysis using Excel’s most popular features. You will learn how to create pivot tables from a range with rows and columns in Excel. You will see the power of Excel pivots in action and their ability to summarize data in flexible ways, enabling quick exploration of data and producing valuable insights from the accumulated data.

Pivots are used in many different industries by millions of users who share the goal of reporting the performance of companies and organizations. In addition, Excel formulas can be used to aggregate data to create meaningful reports. To complement, pivot charts and slicers can be used together to visualize data and create easy to use dashb...

The ability to analyze data is a powerful skill that helps you make better decisions. Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool.

In this course, you will learn how to perform data analysis using Excel’s most popular features. You will learn how to create pivot tables from a range with rows and columns in Excel. You will see the power of Excel pivots in action and their ability to summarize data in flexible ways, enabling quick exploration of data and producing valuable insights from the accumulated data.

Pivots are used in many different industries by millions of users who share the goal of reporting the performance of companies and organizations. In addition, Excel formulas can be used to aggregate data to create meaningful reports. To complement, pivot charts and slicers can be used together to visualize data and create easy to use dashboards.

You should have a basic understanding of creating formulas and how cells are referenced by rows and columns within Excel to take this course. If required, you can can find many help topics on Excel at the Microsoft Office Support Site. You are welcome to use any supported version of Excel you have installed in your computer, however, the instructions are based on Excel 2016. You may not be able to complete all exercises as demonstrated in the lectures but workarounds are provided in the lab instructions or Discussion forum. Please note that Excel for Mac does not support many of the features demonstrated in this course.

After taking this course you’ll be ready to continue to our more advanced Excel course, Analyzing and Visualizing Data with Excel.

Reviews 9/10 stars
3123 Reviews for Introduction to Data Analysis using Excel

Ratings details

  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars

Rankings are based on a provider's overall CourseTalk score, which takes into account both average rating and number of ratings. Stars round to the nearest half.

Sort By
Student profile image
Student profile image

Student

8/10 starsCompleted
2 years, 6 months ago
Very good. Would have been even better if there was a closer connection between video lecture and quiz/lab material. Something like the following: 1. A simple demonstration 2. Exercise similar to demonstration 3. Demonstration of complexities 4. Exercise requiring generalization of complexities. Good job.
Was this review helpful? Yes5
 Flag
Dusko Milosevic profile image
Dusko Milosevic profile image

Dusko Milosevic

8/10 starsCompleted
1 day, 13 hours ago
Very good course, I have been learned something new on easy and fast way. Quiz was not able to be done, but lab was ok and enough to increase my knowledge.
Was this review helpful? Yes0
 Flag
Sheik Baker profile image
Sheik Baker profile image

Sheik Baker

10/10 starsCompleted
1 day, 19 hours ago
The course is good, but there is always room to improve. Adding some more project could make it more practical. I love the step by step build up. In professional life this kind of progression happens a lot.
Was this review helpful? Yes0
 Flag
Eduardo Alves profile image
Eduardo Alves profile image

Eduardo Alves

10/10 starsCompleted
2 days, 5 hours ago
Fantastic. I just love this course and the method used by you guys. I won't stop studing this content. Here in Brazil we don't have this kind of material for free. From now on you alwais will see me. See you in the next course!
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 0 reviews
  • 0 completed
5 days, 13 hours ago
Fantastic course and a very good one for people who started considering analyzing data in Excel. Will continue to learn other course and move on with the data analysis studies.
Was this review helpful? Yes0
 Flag
JOSE MANUEL VOLQUEZ RODRIGUEZ profile image
JOSE MANUEL VOLQUEZ RODRIGUEZ profile image

JOSE MANUEL VOLQUEZ RODRIGUEZ

10/10 starsCompleted
1 week ago
Excellent course! highly recommended. I really enjoyed taking it. Indeed, I finished it in only one week because the content was really interesting and easy to understand. Now, I have many ideas to improve me Excel Reports.
Was this review helpful? Yes0
 Flag
Gabriela Duran profile image
Gabriela Duran profile image

Gabriela Duran

10/10 starsCompleted
1 week, 3 days ago
Me ha encantado todo el contenido del curso y como se ha organizado de forma de hacerlo más ameno y no tan complicado. La forma de ir acumulando todo las tablas que se han visto en el curso esta muy bien para seguir el hilo del curso y corregir errores que podría haber cometido.
Was this review helpful? Yes0
 Flag
Hai Qing (Tory Heagan) Yao profile image
Hai Qing (Tory Heagan) Yao profile image

Hai Qing (Tory Heagan) Yao

8/10 starsCompleted
1 week, 4 days ago
The instructor knows the best. Oho, I've not previously known that reporting and analysis could be different. I sincerely hope that this Brave New World would bring new changes to Sciences in whole. Thanks.
Was this review helpful? Yes0
 Flag
CN L profile image
CN L profile image

CN L

10/10 starsCompleted
1 week, 5 days ago
A great course with a good combination of lectures and tutorials. Even without paying for a certificate, I was able to learn a lot of practical skills, which is important to me. Would like to see a couple of lessons, if not warrant an entire course, on how to clean up real world data, for example when the data format in a column is not consistent.
Was this review helpful? Yes0
 Flag
David Hamrick Jr profile image
David Hamrick Jr profile image

David Hamrick Jr

10/10 starsCompleted
1 week, 6 days ago
Lectures, followed by readings, then quizzes and finally labs was a great format for my learning. I felt that the lectures videos could have covered the same information in half the time (drawn way out). I would like to see more to the point videos. Other than that, great course!
Was this review helpful? Yes0
 Flag
Sarah Zhang profile image
Sarah Zhang profile image
8/10 starsCompleted
  • 0 reviews
  • 0 completed
2 weeks, 2 days ago
Clear lectures and explanations, easy to follow along and to the point! Labs provide good practice for getting used to actually using new techniques and are aligned closely to the content of the lectures. I learned a lot through this course, and would recommend to anyone who wants a better grasp of excel data analysis. Content is a bit dry but I suppose that's kinda the nature of the material. My one main gripe is that users who are just auditing the material don't get access to the quizzes and questions in the labs, which is like half the material in the course so it severing limits how much I can glean from the course (I understand this is probably from EdX's end and not Microsoft's but still)
Was this review helpful? Yes0
 Flag
Tatiana Nikulina profile image
Tatiana Nikulina profile image

Tatiana Nikulina

8/10 starsCompleted
2 weeks, 6 days ago
Thank you, interesting and useful for the first meeting with Excel. Was a bit too simple for my level, still found new information in the last two lectures.
Was this review helpful? Yes0
 Flag
Jignesh Mehta profile image
Jignesh Mehta profile image

Jignesh Mehta

10/10 starsCompleted
2 weeks, 6 days ago
The instructor Danny was great. I understood his lectures clearly and so I could do the lab pretty well using his lectures.Also, the Community TA 's answers to questions from students on the discussion modules were excellent. About the course content, this is my very first data analytics class so I can't give an objective answer about the course content.I enjoyed the class and I have enrolled for the next class.Thank you very much!
Was this review helpful? Yes0
 Flag
Ijeoma Davida profile image
Ijeoma Davida profile image

Ijeoma Davida

10/10 starsCompleted
2 weeks, 6 days ago
The instructor Danny was great. I understood his lectures clearly and so I could do the lab pretty well using his lectures. Also, the Community TA 's answers to questions from students on the discussion modules were excellent. About the course content, this is my very first data analytics class so I can't give an objective answer about the course content. I enjoyed the class and I have enrolled for the next class. Thank you very much!
Was this review helpful? Yes0
 Flag
Abdullah Sagheer profile image
Abdullah Sagheer profile image

Abdullah Sagheer

10/10 starsCompleted
2 weeks, 6 days ago
The Instructor was very good and knowledgeable, its just that he speaks in a monotonous tone which can be hard to focus on. The course content was brilliant, the practical step by step approach has helped me learn by forcing me to practically carry out what I saw in the video. Thank you Microsoft!
Was this review helpful? Yes0
 Flag
 profile image
 profile image

6/10 starsCompleted
  • 0 reviews
  • 0 completed
2 weeks, 6 days ago
First of all I do appreciate what you guys prepared for us all. The videos that were able to be downloaded which favours guys like us in Africa where data bundle purchase is high and wifi is not in all places. Second the instructor was beautiful and the videos were so clear. The exercise files aimed at teaching us how to learn basic data analysis tools and hidden scenery in Excel. Thanks so much guys cause me as a person, I have learnt a lot from this
Was this review helpful? Yes0
 Flag
David Marsh profile image
David Marsh profile image

David Marsh

10/10 starsCompleted
3 weeks ago
Very good course. Excellent progression, in both Content & Labs. Quizzes & Labs were clear and unambiguous. (Which is unusual for these courses) Learnt lots, even in shortcuts for more general Excel use.
Was this review helpful? Yes0
 Flag
Anne-Marie Gaudreau profile image
Anne-Marie Gaudreau profile image

Anne-Marie Gaudreau

10/10 starsCompleted
3 weeks, 1 day ago
Learned a lot on Pivot Tables, will save me so much time at work !! Weel explained, the examples are simple to understand and the labs make you practice. THANKS !
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 0 reviews
  • 0 completed
3 weeks, 1 day ago
Thank you,it was really useful and interesting! Even do not wanted to be over :) it was first time for me taking online course, I will definitely continue using this method of education. the course, instructor and material was very intense and knowledgeable.
Was this review helpful? Yes0
 Flag
Tony Zhou profile image
Tony Zhou profile image

Tony Zhou

10/10 starsCompleted
3 weeks, 3 days ago
Excellent, much appreciate. Brought total different view for what I thought about Excel, about me: I was thinking I already know well about Excel before. This leads me really to care more about what I already have, do I really know enough as I think. Focus on what you think you already have, you may discover more.
Was this review helpful? Yes0
 Flag
John McLeod-Moya profile image
John McLeod-Moya profile image

John McLeod-Moya

8/10 starsCompleted
3 weeks, 4 days ago
Audited this course and found it very informative. I am not so sure that the context of the skills applies directly to my industry, since I am a researcher and not a project manager. Still it was very informative and well presented.
Was this review helpful? Yes0
 Flag
barry liu profile image
barry liu profile image

barry liu

10/10 starsCompleted
3 weeks, 4 days ago
I have gained a lot in this course, I have never used excel before and I think he is a very boring program, but in this course, I found a lot of interesting and deserved places to learn. Course tests are not fully synchronized. In the process of additional research to complete them is a good opportunity to learn.
Was this review helpful? Yes0
 Flag
Rex Martin profile image
Rex Martin profile image

Rex Martin

8/10 starsCompleted
3 weeks, 4 days ago
This was a good course. I learned a lot. the course material and the quizzes were not exactly in synch. I had to do some extra research to complete them.
Was this review helpful? Yes0
 Flag
Suraj Agarwal profile image
Suraj Agarwal profile image

Suraj Agarwal

8/10 starsCompleted
3 weeks, 2 days ago
Excellent course with smooth-as-butter content. Real life scenario has helped with the implementation of what I've learnt here. Manner of explanation and follow-up is very easy to grasp for very beginners as well. One of the best courses here on EdX.
Was this review helpful? Yes0
 Flag
Katie Huang profile image
Katie Huang profile image

Katie Huang

10/10 starsCompleted
3 weeks, 5 days ago
The course is very useful and provides students with lots of techniques in excel. With this class, I have a solid grasp of how to utilize data and find connection between a large amount of numbers. Everything is good.
Was this review helpful? Yes0
 Flag
KAVINESH SANKAAR T S profile image
KAVINESH SANKAAR T S profile image

KAVINESH SANKAAR T S

10/10 starsCompleted
3 weeks, 6 days ago
Overall everything was perfect. But some visual navigation can be implemented to navigate between the sessions. Apart from that everything is top notch...!!!
Was this review helpful? Yes0
 Flag
Meg G profile image
Meg G profile image

Meg G

10/10 starsCompleted
4 weeks ago
The lectures are very crisp and to the point. They focus on the theme / topic completely. The tutor was very clear in the explanations, examples shared
Was this review helpful? Yes0
 Flag
Edward profile image
Edward profile image

Edward

10/10 starsCompleted
1 month ago
Very useful and effective course. Lab problems really help understanding course materials. Lecture videos' resolution is sometimes not high enough - maybe zooming in the screen will be better.
Was this review helpful? Yes0
 Flag
Radwa Taha profile image
Radwa Taha profile image

Radwa Taha

8/10 starsCompleted
1 month ago
It is usefu.Iknow new information .There are some good points .I enjoy labs very much.There are some points which aren,t exist in videos such as & in sumifs .There are some difficult questions in quiz .but it is a wonderful effort of Dany .our instructor is very helful .He clarifies difficult points.Thank you
Was this review helpful? Yes0
 Flag
Robbin Huang profile image
Robbin Huang profile image

Robbin Huang

10/10 starsCompleted
1 month ago
This course use case analysis to give lesson which is more easy to understand. The content is also very reasoable, but maybe the provider should give us more information about the meaning of some signals in Excel(for example, what is the difference between $H1,H%1 and$H$1).
Was this review helpful? Yes0
 Flag

Rating Details


  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars

Rankings are based on a provider's overall CourseTalk score, which takes into account both average rating and number of ratings. Stars round to the nearest half.