Introduction to Data Analysis using Excel

Provided by:
9/10 stars
based on  2796 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
21322 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
2796 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
1 year, 9 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
Abhay Joshi profile image
Abhay Joshi profile image

Abhay Joshi

8/10 starsCompleted
19 hours ago
Good Course but was very less course content. Some additional things can also be completed in the stipulated time of the course. Lab work and quiz were good.
Was this review helpful? Yes0
 Flag
Roberta profile image
Roberta profile image

Roberta

10/10 starsCompleted
3 days, 5 hours ago
The course content and the structure of exercises in the labs are excellent. I've learnt a lot, especially doing the labs. My only suggestion would be to improve the clarity of certain questions. In some cases, it was difficult to understand what was being asked. But overall, I really enjoyed doing this course and will certainly recommend it to my colleagues who want to start learning data analysis using in Excel.
Was this review helpful? Yes0
 Flag
Pratz profile image
Pratz profile image

Pratz

10/10 starsCompleted
4 days, 6 hours ago
I thoroughly enjoyed the course and learned something about data analysis techniques using excel. I completed the course in about 4-5 days and such was my curiosity to learn. The instructor was up to the point and delivered the content with much ease and good pace. The exercises were also very helpful in understanding the concepts and provided hands on learning. I would surely recommend this course to someone who is eager to learn the basic data analysis techniques.
Was this review helpful? Yes0
 Flag
MAURICIO CRUZ profile image
MAURICIO CRUZ profile image

MAURICIO CRUZ

10/10 starsCompleted
4 days, 21 hours ago
Interesting and satisfactory method, actually really good. I had some empiric knowledge about excel on reporting methods, but I increased my level of reporting using pivot charts and pivot tables, also, I got some analysis skills. Dany was an excellent instructor, He was calm, knowledgeble and made himself understandable. Great course.
Was this review helpful? Yes0
 Flag
kamlesh dabi profile image
kamlesh dabi profile image
10/10 starsCompleted
  • 0 reviews
  • 0 completed
5 days, 7 hours ago
Course content was well design for new student. Instructors and their teaching methodologies was very good. Course content was based on basics that was the main part of the course.
Was this review helpful? Yes0
 Flag
Martin B. profile image
Martin B. profile image

Martin B.

8/10 starsCompleted
5 days, 22 hours ago
Very good for those with zero knowledge in tables and pivots as well as for those who are proficient in those topics. I reconsider myself as an expert but this course helped me to sort my knowledge and get familiar with some new Excel 2016 features.
Was this review helpful? Yes0
 Flag
Penchal Reddy profile image
Penchal Reddy profile image
10/10 starsTaking Now
  • 0 reviews
  • 0 completed
4 days, 23 hours ago
this is very helpful for me and it is telling the high knowledge lecture is explainig very eacy to understand thanks for all and qustions is veryu easy understanding.
Was this review helpful? Yes0
 Flag
Fernando Castillo profile image
Fernando Castillo profile image

Fernando Castillo

10/10 starsCompleted
1 week ago
Very good course, it is good explained and cover a lot of information, but if you want to enrich your knowledge you will need to go deeper in the topics by your own.
Was this review helpful? Yes0
 Flag
vishal kumar profile image
vishal kumar profile image

vishal kumar

10/10 starsTaking Now
1 week 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? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
1 week, 1 day ago
Very good, i've learned new things on pivot table. However the lab explenation should be more detailed. Maybe there should be some picture how correctly done excercise should look like
Was this review helpful? Yes0
 Flag
sultan hashem profile image
sultan hashem profile image

sultan hashem

8/10 stars
1 week, 1 day ago
Introduction to Data Analysis using Excel is interesting course. the instructor is nice, but he is teaching fast. I cannot catch it sometimes. The screen is too small, and I cannot see characters. Overall, the course should teach slowly and more example instead of simple instruction. more topics recommend included and more cartoon picture to make audience interesting. The pivot chapter taught too fast and I cannot follow to practice. This course is useful for analyzing data and applies to workplace. From first five part, I think the way of teaching good, but the end parts are too confused. The labs are too many data, so I cannot get answers for my questions. If the homework is easy, students are excited to study. However, this course is advance for office workers, so they are experience/ Thus, they are easily to catch up. However, it is difficult to those who did not know much about data and excel. I still like this course because it... Introduction to Data Analysis using Excel is interesting course. the instructor is nice, but he is teaching fast. I cannot catch it sometimes. The screen is too small, and I cannot see characters. Overall, the course should teach slowly and more example instead of simple instruction. more topics recommend included and more cartoon picture to make audience interesting. The pivot chapter taught too fast and I cannot follow to practice. This course is useful for analyzing data and applies to workplace. From first five part, I think the way of teaching good, but the end parts are too confused. The labs are too many data, so I cannot get answers for my questions. If the homework is easy, students are excited to study. However, this course is advance for office workers, so they are experience/ Thus, they are easily to catch up. However, it is difficult to those who did not know much about data and excel. I still like this course because it gives me a try and decide to get certificate or not. Thank you
Was this review helpful? Yes0
 Flag
Ly Nguyen profile image
Ly Nguyen profile image
6/10 starsCompleted
  • 0 reviews
  • 0 completed
1 week, 1 day ago
Introduction to Data Analysis using Excel is interesting course. the instructor is nice, but he is teaching fast. I cannot catch it sometimes. The screen is too small, and I cannot see characters. Overall, the course should teach slowly and more example instead of simple instruction. more topics recommend included and more cartoon picture to make audience interesting. The pivot chapter taught too fast and I cannot follow to practice. This course is useful for analyzing data and applies to workplace. From first five part, I think the way of teaching good, but the end parts are too confused. The labs are too many data, so I cannot get answers for my questions. If the homework is easy, students are excited to study. However, this course is advance for office workers, so they are experience/ Thus, they are easily to catch up. However, it is difficult to those who did not know much about data and excel. I still like this course because it... Introduction to Data Analysis using Excel is interesting course. the instructor is nice, but he is teaching fast. I cannot catch it sometimes. The screen is too small, and I cannot see characters. Overall, the course should teach slowly and more example instead of simple instruction. more topics recommend included and more cartoon picture to make audience interesting. The pivot chapter taught too fast and I cannot follow to practice. This course is useful for analyzing data and applies to workplace. From first five part, I think the way of teaching good, but the end parts are too confused. The labs are too many data, so I cannot get answers for my questions. If the homework is easy, students are excited to study. However, this course is advance for office workers, so they are experience/ Thus, they are easily to catch up. However, it is difficult to those who did not know much about data and excel. I still like this course because it gives me a try and decide to get certificate or not. Thank you.
Was this review helpful? Yes0
 Flag
Ana Nedden profile image
Ana Nedden profile image

Ana Nedden

10/10 starsCompleted
1 week, 1 day ago
Very useful, for everyone who uses Excel Graphics! I will just enroll in the next one! Some excercises are more complex but with the help of the discussion forum I could come through all.
Was this review helpful? Yes0
 Flag
Alisha profile image
Alisha profile image

Alisha

10/10 starsCompleted
1 week, 2 days ago
This course was amazing, I cannot wait to complete the next one. I enjoy the course comments section also. I do wish the course lecture video quality was better (HD) as it was hard to see at times. Thanks so much to the course creators and thank you for creating workarounds for people with different versions of excel like myself :)
Was this review helpful? Yes0
 Flag
Pascal Odira profile image
Pascal Odira profile image

Pascal Odira

10/10 starsCompleted
1 week, 2 days ago
Thank you so much for this course, and thank you Dany Hoter, you have been a great instructor. I liked and enjoyed the course content as it covered most of the areas I was challenged in my use of Excel, especially on Dashboards and Pivot Tables.
Was this review helpful? Yes0
 Flag
MURAT ALTINOK profile image
MURAT ALTINOK profile image

MURAT ALTINOK

10/10 starsCompleted
1 week, 2 days ago
I really enjoyed the course and learned new information. I'll use Pivot and tools more actively in reporting. Thanks to this training I expanded my experience. Finally I had a wonderful experience taking the course. I would like to thank the instructor and the Microsoft team.
Was this review helpful? Yes0
 Flag
Oluwabiyi Benjamin profile image
Oluwabiyi Benjamin profile image
10/10 starsCompleted
  • 0 reviews
  • 0 completed
1 week, 2 days ago
I really enjoyed the course and I have been able to apply some of the knowledge gained in my workplace, however I would have loved if there are more challenging task as assignment which may not necessarily be graded. Overall, i had a wonderful experience taking the course, a big thank you to the instructor and the Microsoft team.
Was this review helpful? Yes0
 Flag
ABDUL BASIT profile image
ABDUL BASIT profile image

ABDUL BASIT

8/10 starsCompleted
1 week, 2 days ago
Course content was very good. All the lab video lecture and quiz/lab material.excel files really help me in understanding everything clearly. this course very help full for me. Great course for understanding how business skill in excel work, I did some other course before this one and it was more on a higher level, which are already implemented in library and showing how to use them, but this course gave me more insight on how they actually work, which is really useful and interesting. Great material and interesting tasks, not too difficult.
Was this review helpful? Yes0
 Flag
Ashwani Kumar profile image
Ashwani Kumar profile image

Ashwani Kumar

10/10 starsCompleted
1 week, 2 days ago
Course content was very good. All the labs and small quizzes after performing operations on excel files really help you in understanding everything clearly even if it wasn't clear during lecture.
Was this review helpful? Yes0
 Flag
Nwachukwu Ujubuonu profile image
Nwachukwu Ujubuonu profile image

Nwachukwu Ujubuonu

10/10 starsCompleted
1 week, 6 days ago
For the content, I loved the way it was easy to access and understand For the instructor, I found him boring but still good at his job For the providers, they did a good job
Was this review helpful? Yes0
 Flag
Kai profile image
Kai profile image

Kai

8/10 starsTaking Now
1 week, 6 days ago
In general, it's tough for beginners, but it's very insightful and interesting course format: step by step from video introduction to orientation, practicing, and test. Also noted that there are some cool charts, like map of Excel 2016. They are very helpful.
Was this review helpful? Yes0
 Flag
XC TSUI profile image
XC TSUI profile image

XC TSUI

10/10 starsCompleted
2 weeks, 1 day ago
In general, it's tough for beginners, but it's very insightful and interesting course format: step by step from video introduction to orientation, practicing, and test. Also noted that there are some cool charts, like treemap of Excel 2016. They are very helpful.
Was this review helpful? Yes0
 Flag
Adam profile image
Adam profile image

Adam

10/10 starsCompleted
2 weeks, 1 day ago
Very interesting course. The instructor clearly explains how to use Excel analytical tools in real life. Labs allow student to train new skills. It really extended my knowledge of new functions of Excel 2016+. One little disappointment: there was not presented in the lecture how to manage outliers in conditional formatting.
Was this review helpful? Yes0
 Flag
Mahmoud M. Morsy profile image
Mahmoud M. Morsy profile image
8/10 starsCompleted
  • 0 reviews
  • 0 completed
2 weeks, 2 days ago
Very Good course. i really taught a new things that i don't know it before, and the quizzes/labs are very useful for applying what i learned. Microsoft is a good organization and we are used to find these beautiful contents from it. Good Work
Was this review helpful? Yes0
 Flag
Avi Lupovitch profile image
Avi Lupovitch profile image

Avi Lupovitch

10/10 starsCompleted
2 weeks, 2 days ago
i really liked the course. i think it was very comprehensive and helpful. the lectures were clear and not too long. and the exercises were one level above the lecture to see if you read the additional reading that was requested. During the course i had to think and to confront challenges and that helped me learn better. thank you.
Was this review helpful? Yes0
 Flag
Adam profile image
Adam profile image

Adam

10/10 starsCompleted
2 weeks, 4 days ago
Very pleased with this course. I learned a lot of valuable information. Each lesson was easy to follow and the quizzes matched well with the content in the lesson. I would recommend this course to others. I look forward to taking the next course.
Was this review helpful? Yes0
 Flag
Mina Salib profile image
Mina Salib profile image

Mina Salib

10/10 starsCompleted
2 weeks, 4 days ago
Excellent course, i have learned new techniques about pivot tables, pivot charts and multiple tables. In addition, i have learned new functions such as SUMIFS() function.
Was this review helpful? Yes0
 Flag
Mariano Mannai profile image
Mariano Mannai profile image

Mariano Mannai

10/10 starsCompleted
2 weeks, 4 days ago
Very good!! Now I know very powerful instruments to work efficiently. Exercises were very useful and my focus is participate actively to next course of excel
Was this review helpful? Yes0
 Flag
Allan profile image
Allan profile image

Allan

6/10 starsCompleted
2 weeks, 5 days ago
Some aspects were great, some could be improved. I intend to take more Excel courses from EdX. Some videos should have been longer. But overall, I found it worthwhile.
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.