Introduction to Data Analysis using Excel

Provided by:
9/10 stars
based on  2659 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
21033 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
2659 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, 7 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
Abhishek Pandey profile image
Abhishek Pandey profile image

Abhishek Pandey

8/10 starsCompleted
2 hours ago
Everything in this course for a beginner is a stepping stone. I would like to do more courses after getting certificate. Instructor was very clear and focused on what he delivers or wants to convey. Good Luck!
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
1 day, 15 hours ago
I thought the course was great! The content followed a nice progression, and I felt that it was easy to follow but also allowed for troubleshooting that led to worthy discussions in the forum. Definitely, the best way to get the most out of this course is to not look at the formulas right away and copy and paste them into your excel sheet. Try to figure them out yourself and look back if you have trouble. You learn from doing, not from copying.
Was this review helpful? Yes0
 Flag
Raul Manriquez profile image
Raul Manriquez profile image
10/10 starsCompleted
  • 0 reviews
  • 0 completed
1 day, 19 hours ago
Content is suffice enough and it is well complemented with all the suggested online reading. Amazing well prepared instructor and there was always an answer to students queries! Maybe some questions need review regarding ambiguity but I will give this course 11 out of 10. Thanks!
Was this review helpful? Yes0
 Flag
Manuj Bansal profile image
Manuj Bansal profile image

Manuj Bansal

10/10 starsCompleted
2 days, 7 hours ago
Wonderful course. You just have to go through the videos carefully, my personal way way to watch them once then watch them again and re enact what Dany was trying to do. I feel more confident with exce
Was this review helpful? Yes0
 Flag
Paola Alvarez profile image
Paola Alvarez profile image

Paola Alvarez

10/10 starsCompleted
2 days, 15 hours ago
Very good course. Instructor was very clear. Slicers were new for me and I'm glad to be able to use them by taking the course. Now my presentations will look better and more professional.
Was this review helpful? Yes0
 Flag
Emran Hossen profile image
Emran Hossen profile image
10/10 starsCompleted
  • 0 reviews
  • 0 completed
3 days, 14 hours ago
Good !!! it helps me learn new thing, specially slicer. On the other hand, I think that it helps me in learning advance excel in the future.I am working for a multinational company, I think its help me the greater presentation of data in front of Management,
Was this review helpful? Yes0
 Flag
Mohibur Rahman profile image
Mohibur Rahman profile image

Mohibur Rahman

10/10 starsCompleted
3 days, 17 hours ago
It was really a good course to me to learn lots of things. I had the very basic concept regarding the contents wrapped up in this course. Now I can say I am an advanced one.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
4 days, 13 hours ago
It was a very educative course. I learnt thigns that i didn´t know. The quizzes and the labs were really helpfull to understand the use of the tools. The teacher was practical in the aplications of the formulas ans the pivot tables
Was this review helpful? Yes0
 Flag
a k profile image
a k profile image

a k

10/10 starsCompleted
4 days, 18 hours ago
Excellent beginning course! I found this course to be very helpful for those that want a basic and beginning understanding of Microsoft Excel. Although the course consisted of good material, I wish there was closer relation between the video and lab material.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

8/10 starsCompleted
5 days, 9 hours ago
Interesting. Sometimes it was difficult to connect video lectures with quiz and lab demonstrations. Really liked being able to play with actual data to understand how to do everything. Otherwise useful information
Was this review helpful? Yes0
 Flag
Vale Gur profile image
Vale Gur profile image

Vale Gur

10/10 starsCompleted
5 days, 14 hours ago
Very informative course. The pace could be a bit faster but it wasn't boring to follow it. I missed the possibility to see clearly what the instructor was doing on the screen but during labs all the skills were practised and everything became clear.
Was this review helpful? Yes0
 Flag
Aritra Sur profile image
Aritra Sur profile image

Aritra Sur

8/10 starsCompleted
5 days, 18 hours ago
Easy to follow and well organized. The lab activities are very interesting and useful. I would recommend the course to those who are interested. Perhaps, a final test/lab to summarize and strengthen all the acquired info would be advantageous. Expected more contents.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

8/10 starsCompleted
6 days, 16 hours ago
Easy to follow and well organized. The lab activities are very interesting and useful. I would recommend the course to those who are interested. Perhaps, a final test/lab to summarize and strengthen all the acquired info would be advantageous.
Was this review helpful? Yes0
 Flag
Trang Nguyen profile image
Trang Nguyen profile image
10/10 starsTaking Now
  • 0 reviews
  • 0 completed
1 week ago
The course is very practical. The information from instructor is well explained. It is not difficult to follow. I have learned a lot. I would recommend the course for those who are interested.
Was this review helpful? Yes0
 Flag
David Cruz profile image
David Cruz profile image

David Cruz

10/10 starsCompleted
1 week ago
It's a very interesting course. All the topics are very well explained from instructor. The discussion chart is very helpful in order to solve any concern. The extra material is also very helpful and it's an excellent tool to complete the course and to learn more about Excel features.
Was this review helpful? Yes0
 Flag
Ajay Jaiswal profile image
Ajay Jaiswal profile image

Ajay Jaiswal

10/10 starsCompleted
1 week ago
Student profile image Student 8/10 starsCompleted 1 year, 7 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? Yes0
 Flag
EMRE HANGUL profile image
EMRE HANGUL profile image

EMRE HANGUL

10/10 starsCompleted
1 week, 2 days ago
This was an all around great lesson. I am about to be an Industrial Engineer and I have learnt, remembered and perfected many primitive, yet vital concepts in Excel. If you know Excel very little or you just want to remember/enhance your capabilities in creating charts, PivotTables etc, you should take a look at this course.
Was this review helpful? Yes0
 Flag
Amiya Rath profile image
Amiya Rath profile image

Amiya Rath

8/10 starsCompleted
1 week, 2 days ago
This was an excellent course. Highly recommended for those who use MS Excel. This course helps in fine tuning and giving certain insights into the way some of the finer aspects of MS Excel.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
1 week, 2 days ago
There are great course materials and engaging labs. The videos and instructions are easy to follow. Even with prior experience of working with PivotTables, I've learnt smth new. It is worth taking!
Was this review helpful? Yes0
 Flag
K Patel profile image
K Patel profile image

K Patel

10/10 starsCompleted
1 week, 3 days ago
I thought it was easy to understand and similar to actual classes in school that challenge you in the homework. I feel a lot more confident to say I know how to use excel for data analysis now!
Was this review helpful? Yes0
 Flag
Mohit Baranwal profile image
Mohit Baranwal profile image

Mohit Baranwal

10/10 starsCompleted
1 week, 4 days ago
This is the one of the best courses available on the internet if you want to get good in your analytics using excel. And the instructor explains the concepts very well.
Was this review helpful? Yes0
 Flag
Azamat Sayapov profile image
Azamat Sayapov profile image

Azamat Sayapov

10/10 starsCompleted
1 week, 4 days ago
This course is amazing! I was absolutely new to Excel, but now I feel myself much better in it. Looking forward to new courses on macro creation in excel and VBA
Was this review helpful? Yes0
 Flag
Barbara Wilkins profile image
Barbara Wilkins profile image

Barbara Wilkins

10/10 starsCompleted
1 week, 5 days ago
I really enjoyed this class. The labs were challenging, yet the information was all there. I am also currently enrolled in the Marketing Analytics Micro Masters Program and this was a great compliment to the program. I have learned so much! Thank you
Was this review helpful? Yes0
 Flag
Angel Pun profile image
Angel Pun profile image

Angel Pun

10/10 starsCompleted
1 week, 6 days ago
The content is quite useful, but the instructor has quite a strong accent and sometimes not fluent, I need to read the caption to follow the class. Besides, the quality in most of the video is quite lagging, thus instructor voice is not clear.
Was this review helpful? Yes0
 Flag
Philip Dain profile image
Philip Dain profile image

Philip Dain

10/10 starsCompleted
1 week, 6 days ago
The course was great, very good, would recommend, thumbs up, gold star, high five, pat on the back, helpful, educational, instructive, enjoyable, well-designed.
Was this review helpful? Yes0
 Flag
Dave Daniel profile image
Dave Daniel profile image

Dave Daniel

10/10 starsCompleted
2 weeks ago
I enjoyed this course very much and learned a LOT. Hopefully I will be able to find applications in my line of work and other associations where I can put these capabilities to use. Am looking forward to more courses like this one!
Was this review helpful? Yes0
 Flag
Bhushan Hatwalne profile image
Bhushan Hatwalne profile image

Bhushan Hatwalne

10/10 starsCompleted
2 weeks, 1 day ago
Learned new things in MS Excel. I have been working with Pivots but this is taking it to the new levels.Instructor is knowledgeable and has good understanding of the subject. Looking forward to the new course
Was this review helpful? Yes0
 Flag
ziling yu profile image
ziling yu profile image

ziling yu

10/10 starsCompleted
2 weeks, 2 days ago
This is very good course for people to begin data analysis with excel. I will continue to do the rest. The lab and quiz are very interesting. It does not take me much time to complete but it is good to practice. I love it. Also, the lab are connected from the lecture one to the last one. This is great.
Was this review helpful? Yes0
 Flag
Halee Taylor profile image
Halee Taylor profile image

Halee Taylor

10/10 starsCompleted
2 weeks, 2 days ago
This course taught me a lot of new things and also challenged me to think harder. This will help me tremendously in the working world of today. Great if you want to learn Excel but don't want to pay an arm and a leg to do it.
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.