Introduction to Data Analysis using Excel

Provided by:
9/10 stars
based on  2870 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
21569 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
2870 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

10/10 starsCompleted
1 year, 11 months ago
I liked the material of the course. it helped me to start the carrier in data analytics. i would suggest to provide the path on what next should we do after this course, so it will help us grow.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
1 year, 11 months ago
I am very grateful to the instructor and all who made this course possible. thank you very much. the course was very precise and videos were very clear and the instructor was very audible. i had fun learning and applying the skills learnt to each lab. i will take this knowledge into my field of study and it will help me alot
Was this review helpful? Yes0
 Flag
 profile image
 profile image

8/10 starsCompleted
  • 1 review
  • 1 completed
1 year, 11 months ago
The course is very well structured. It would have been great if more things were covered. However, I am satisfied with the content, instructor and provider.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
1 year, 11 months ago
The content offered in this course was very helpful in getting to know the various Tools that Excel provides in analyzing the data. One should definitely take this course if he/she want's to learn the art of analyzing the data using excel and is a beginner...
Was this review helpful? Yes0
 Flag
Pulkit Maheshwari profile image
Pulkit Maheshwari profile image
8/10 starsCompleted
  • 1 review
  • 1 completed
1 year, 11 months ago
Excellent course content. Never knew excel was this vast. This course was very interactive & was a fun way to learn visualizing data through excel. Amazing Instructor with real time knowledge. the best part of this course was the discussion pane,which helped at many points. Kudos
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
1 year, 11 months ago
I enjoyed this class. I learned a lot in a short amount of time. I feel I have a better understanding on pivot tables and graphs now. Some of the quiz questions were difficult to answer correctly with the way they were worded. But, the discussion for each section helped out a bunch. Thank you for putting on a great class!
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
1 year, 11 months ago
The course content is very useful, the exercises help to understand and retain the knowledge. The instructor is clear. I would recommend this course. Excel is a very useful tool at work.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsTaking Now
1 year, 11 months ago
It is good but can improve, if you can get more exercises, and translation into other languages. If there is any possibility of this free class for a short period of time at registration
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
1 year, 11 months ago
The course overall was excellent. The Instructor taught in very well manner. The use of third person approach is really praiseworthy. Thanks for this awesome course. Also the discussions also helped me. Thanks to the entire team. Keep up the spirit.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
1 year, 11 months ago
Awesome,awesome & awesome. Very well structured and very well presented. Quizzes and lab exercise were very engaging. Will definitely recommend to my friends and colleagues. Overall the course was more than my expection
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
1 year, 11 months ago
An excellent course to start with data analysis. The instructor is also quite good, explains each and everything clearly and the contents of the course helps a lot.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
1 year, 11 months ago
This course is specifically designed for new users and helps them learn a wide variety of functions of excel. I feel much confident about my excel knowledge now.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
1 year, 11 months ago
This course is a good introduction to excel although I would have liked more coverage on the formulae. For questions where you had to select more than one answer, I would have liked it to be impossible to select more or less than the number of answers required.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
1 year, 11 months ago
The course is very helpful but sometimes the Lab requests were a bit confusing as to what is supposed to happen, overall it is a five star course! The delivery by the presenter is very nice and you get in very fast, the lab is a bit more advanced than just copying from the video so it presents a nice challenge if you are motivated to learn!
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 1 review
  • 1 completed
1 year, 11 months ago
If there is also much about how to use formulas, it will be more greatful and also how to use lookups. So far, I have learned about using miltiple pivot tables, creating relationships among them, using slicers, connecting filters among charts.. I found this course very good and just by sitting at one place, I've learnt much. Thank you
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
1 year, 11 months ago
As my first attempt to MOOC's I got a very positive impression. I'm very satisfied with the contents of the course which helped me discover the thousand hidden features of Excel. Everything is OK only I have had some problems in visualization of the screen during the lectures, that should be a bit zoomed in.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

8/10 starsCompleted
  • 1 review
  • 1 completed
1 year, 11 months ago
It would have wonderful if we have got some PDF files to study about the course by downloading that. And next thing to be mentioned is the course should give clear instruction in some questions in lab and quiz. For example lab-8 question number 1 does not give clear instruction about how many option should be marked. I really enjoyed the style how the instructor give the tips for doing task. And if the video provides more example, that will be more easy to do lab exercise. I am delighted to take this kind of virtual class in the internet. So i want to thank the provider of this course. One of the positive Aspect of this course is the students can use their leisure time to learn new things in internet with paying. The suggestion for this course is that it should provide some lab activities which must be done by student in excel and upload in this side.And that uploaded file should be checked by other students and give mark for th... It would have wonderful if we have got some PDF files to study about the course by downloading that. And next thing to be mentioned is the course should give clear instruction in some questions in lab and quiz. For example lab-8 question number 1 does not give clear instruction about how many option should be marked. I really enjoyed the style how the instructor give the tips for doing task. And if the video provides more example, that will be more easy to do lab exercise. I am delighted to take this kind of virtual class in the internet. So i want to thank the provider of this course. One of the positive Aspect of this course is the students can use their leisure time to learn new things in internet with paying. The suggestion for this course is that it should provide some lab activities which must be done by student in excel and upload in this side.And that uploaded file should be checked by other students and give mark for the work to evaluate.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
1 year, 11 months ago
I learned so much new things in this course. I do not have Power Pivot installed bu the group discussion was a big help for me to complete lab 8. I will be able to apply what I have learned in this course for my current job and looking forward to take the next course.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
1 year, 11 months ago
Very well organized. Content is superb. Learnt so many new things regarding data analysis with excel. Will help me greatly in my professional career. I hope to see more excel courses in the area of data analysis and advanced excel. Also I would like to see courses on Macro programming with Excel.
Was this review helpful? Yes0
 Flag
Abhijeet Saxena profile image
Abhijeet Saxena profile image
8/10 starsCompleted
  • 1 review
  • 1 completed
1 year, 11 months ago
Everything was good. The instructor had a nice way of teaching things. Links were very useful as they provided a lot of useful information. More questions for practice should be included in Lab part
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
1 year, 11 months ago
The course provides a great start for Data Analysis using Excel and is named appropriately. It is helpful for even beginners like myself. I hope to use the concepts learnt in further courses.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 1 review
  • 1 completed
1 year, 11 months ago
Great Course for beginners. Very helpful,learned a lot from this course. Looking forward for the next course. Excellent course for those who are looking to study data analysis for educational as well as professional purpose.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
1 year, 11 months ago
Doing the course was fun. The lesson explanation was excellent and clear. I had a lot of problem in the quizzes because sometimes he gave one function that I did not have, for example, IFs what was difficult to apply in the data and answer the questions.Apart of this, I enjoyed this course, and I feel that I got a lot of more Excel knowledge. Now I know how to work with two tables at the same time, how to present the data hierarchically when I am telling stories about some topic. One feedback I would like to give is instead to make more clear in what you are asking for in the quizzes because sometimes it was confusing me and also provide an explanation when we answer wrong. You just put the right question but then we do not know where that value is come from what is the steps we have to follow to figure out the same value. Thank you!
Was this review helpful? Yes0
 Flag
 profile image
 profile image

6/10 starsCompleted
  • 1 review
  • 1 completed
1 year, 11 months ago
The Content of this course was useful and some worth elaborate. But the instructor was not that illuminative although he did good. I know lectureres are not to disclose everything in order to have what to set as quizez and all. Thumbs up to the provider, GREAT JOB.
Was this review helpful? Yes0
 Flag
أحمد موريس profile image
أحمد موريس profile image
10/10 starsCompleted
  • 1 review
  • 1 completed
1 year, 11 months ago
This course is remarkably useful, concise and to the point. In addition, Microsoft made sure that practicality is a major feature in this course. They also made the description of the various exercises very clear and logically sequenced.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
1 year, 11 months ago
Pretty good course. Some wording of questions could be clearer. Image quality in videos could also use improvement. The edX navigation layout is a bit clumsy, especially on mobile devices (poor contrast of navigation bars, clumsy to move across the bar).
Was this review helpful? Yes0
 Flag
Juan Manuel Paz profile image
Juan Manuel Paz profile image
10/10 starsCompleted
  • 1 review
  • 1 completed
1 year, 11 months ago
Awesome course! Highly recommended for those who need to analyze and summarize data. An excellent introduction to pivot tables, pivot charts and hierarchical data.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
1 year, 11 months ago
Well designed course, gives a lot of insight about pivot tables and data visualization. It's easy to follow the examples in the lecture and the labs reflect the topics presented in each week.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
1 year, 11 months ago
Excellent! Very clear explanations from the instructor, even when I am not english speaker. only with the help of the closed caption i was able to fully understand every lesson with the explanations.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
1 year, 11 months ago
The course was well structured, providing a good platform for beginners to learn Excel. All the quizzes and labs helped to build confidence. The course instructor was excellent.
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.