Introduction to Data Analysis using Excel

Provided by:
9/10 stars
based on  3055 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
22114 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
3055 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, 4 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
Kevin Damewood profile image
Kevin Damewood profile image

Kevin Damewood

10/10 starsCompleted
1 day, 10 hours ago
I just finished up my first year as an outsourced accountant/financial consultant and this course was just what I needed to bring my skill set to the next level! I cannot wait to take more classes.
Was this review helpful? Yes0
 Flag
Walter Thompson profile image
Walter Thompson profile image

Walter Thompson

10/10 starsCompleted
3 days, 6 hours ago
Much enjoyed the course. The course covered much more than I thought an introductory course would cover. The labs were very instructional. Kudos to Microsoft for putting time and effort into building real-life labs. I like how the module quiz questions enforced understanding of the materials covered in the video lecture and further reading. Best course so far in the Data Analysis series. Definitely would recommend this course to anyone seeking to learn about Excel Pivot Table functionality.
Was this review helpful? Yes0
 Flag
Ethan Servas profile image
Ethan Servas profile image

Ethan Servas

8/10 starsCompleted
1 week ago
Course was very informative. Some of quiz questions I had to look up and answer using outside sources but other than that the course is pretty straight forward.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
1 week, 1 day ago
While the content was very good, it was sometimes very difficult to understand the presenter as their English skills weren't the best. It made the presentation seem incoherent at times. This was easily seen when looking at the text readout of the presentation.
Was this review helpful? Yes0
 Flag
NKEM MOYE profile image
NKEM MOYE profile image

NKEM MOYE

10/10 starsCompleted
1 week, 2 days ago
THE COURSE CONTENT IS A GOOD START TO DB ANALYTICS. I STRONGLY ENCOURAGE THAT ENROLLMENT OF THIS COURSE WOULD TRULY GO A LONG WAY TO MAKING MASTERY OF DATA ANALYSTS
Was this review helpful? Yes0
 Flag
William Minckler profile image
William Minckler profile image

William Minckler

10/10 starsCompleted
1 week, 2 days ago
Wow. This is more than an INTRODUCTION. Whew! LOL. While laborious at times, I agree that we often learn by DOING. Great instruction on Excel techniques.
Was this review helpful? Yes0
 Flag
Gaurav Goel profile image
Gaurav Goel profile image

Gaurav Goel

10/10 starsCompleted
1 week, 4 days ago
Really Good one and I have been able to learn new thing with will further add feathers to my hat at workplace. The content is well designed, which keeps pacing gradually. excellent tutorial
Was this review helpful? Yes0
 Flag
Tomas Gutierrez profile image
Tomas Gutierrez profile image

Tomas Gutierrez

10/10 starsCompleted
1 week, 4 days ago
Overall very pleased with the course content and pacing. Labs are great for wrapping up concepts. I Recommend watching the lectures directly from youtube in fullscreen 1080p for best visibility.
Was this review helpful? Yes0
 Flag
Florence Ngai profile image
Florence Ngai profile image

Florence Ngai

10/10 starsCompleted
1 week, 4 days ago
Well taught. The content is about right. The lectures are great and the instructions are clear. The quiz/labs that follow the lectures are actually reviews of the lectures. I picked up new things from the lectures. The only negative comment is the Excel exercise in the lecture video can use bigger fond size.
Was this review helpful? Yes0
 Flag
Hitesh Langer profile image
Hitesh Langer profile image

Hitesh Langer

10/10 starsCompleted
1 week, 4 days ago
The content was great and I learned many new things regarding excel. The instructor was great, but he lacked communication skills. The only problem I found was there was not much similarity between lab practice and demonstration during the video.
Was this review helpful? Yes0
 Flag
Saikath Bose profile image
Saikath Bose profile image

Saikath Bose

10/10 starsCompleted
1 week, 5 days ago
Very well put content, but a little more slower pace required. Needed to go backto the lectures a few times to refresh a few concepts to answer questions. All in all a very good course and learnt a lot of new functions to use.
Was this review helpful? Yes0
 Flag
Lyudmila Simeonova profile image
Lyudmila Simeonova profile image

Lyudmila Simeonova

10/10 starsCompleted
1 week, 5 days ago
It was a great experience for me participating in this course. I recommend the course to all that want to improve their Excel knowledge - it is interesting, useful and helpful.
Was this review helpful? Yes0
 Flag
Ahmed Hassan profile image
Ahmed Hassan profile image

Ahmed Hassan

10/10 starsCompleted
1 week, 6 days ago
Awesome.it was very good instructor and i got a lot of information from him . I will advice my friends to take this course.Thank you very much and thanks for Microsoft and EDX for making this course available for learning more
Was this review helpful? Yes0
 Flag
Jerod Meagher profile image
Jerod Meagher profile image
10/10 starsCompleted
  • 0 reviews
  • 0 completed
2 weeks ago
Just what I wanted. Relevant, good pace, well-explained with solid examples. I finished in a week working steadily and have strong foundation now in Excel for data analysis. Although I did the free version without quizzes, I was able to follow along for the most part and still work through most areas that the people who paid struggled with.
Was this review helpful? Yes0
 Flag
ibrahim alhammadi profile image
ibrahim alhammadi profile image

ibrahim alhammadi

10/10 stars
2 weeks ago
new and powerful information to me, i was not familiarise with the pivot tables and know i can see how useful it is. when it comes to data analysis excel amazed me with the capabilities i thought that excel is just a tool to create tables only, but know i clearly can see that it is something way better than that.
Was this review helpful? Yes0
 Flag
Diego Martinez profile image
Diego Martinez profile image

Diego Martinez

10/10 starsCompleted
2 weeks, 1 day ago
The content was good, and the instructor and labs were great. I think you have to work a little more in the questions because some of them are really confusing, not just for me but for a lot of user in the posts. At least you should give some hints about that to answer the question one should include some other columns and thinks like that
Was this review helpful? Yes0
 Flag
Chitra D profile image
Chitra D profile image

Chitra D

10/10 starsCompleted
3 weeks, 1 day ago
This course is excellent content wise. You can learn a lot about data analysis and visualizations in Excel, specially Excel 2016. The instructor explained everything really well. Thanks to him.
Was this review helpful? Yes0
 Flag
German Oroza profile image
German Oroza profile image

German Oroza

10/10 starsCompleted
3 weeks, 2 days ago
great! and thank you very much very nice, simple instructions , and excel itself has become very easy to use . id really like to know more about data science whats the next course?
Was this review helpful? Yes0
 Flag
A French profile image
A French profile image

A French

6/10 starsCompleted
3 weeks, 2 days ago
The content was good and pace appropriate for the topic. The labs reinforced the skills presented. The assessments were good, but often had misleading or unclear wording to questions. Recommended/further reading would be required for someone who had not used these features in Excel before.
Was this review helpful? Yes0
 Flag
Austin Eweroke profile image
Austin Eweroke profile image

Austin Eweroke

8/10 starsCompleted
3 weeks, 2 days ago
Quite an interesting and useful course. The instructor proved also to be good and clear in delivering the trainings. It will be nice to continue in the next related course as the instructor had mentioned.
Was this review helpful? Yes0
 Flag
Rounak Kumar profile image
Rounak Kumar profile image

Rounak Kumar

10/10 starsCompleted
3 weeks, 2 days ago
Very good course for beginners. Explained with easy examples. Lab works were also designed properly to include all the content taught in the lectures.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
3 weeks, 3 days ago
Overall, this course was very good. I would suggest putting the labs before the quizzes. The labs provide information used in the quizzes, and allows the student to make sure they've learned the techniques before they're tested.
Was this review helpful? Yes0
 Flag
Chris profile image
Chris profile image

Chris

8/10 starsCompleted
3 weeks, 4 days ago
The lectures were very good and covered the topics well. They ripped a good deal of the learning out of this course when they deleted the quizzes on the free version though.
Was this review helpful? Yes0
 Flag
Chukwuemeka Chikata profile image
Chukwuemeka Chikata profile image

Chukwuemeka Chikata

10/10 starsCompleted
3 weeks, 4 days ago
Fantastic! Clear and precise approach to learning. Would be great to make the instructor's excel screen a bit bigger and more legible. Would also be great to provide to the students the latest version of excel which already contains the most recent updates, maybe a trial version, so that all the latest functionalities are available to the students.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

8/10 starsCompleted
  • 0 reviews
  • 0 completed
3 weeks, 4 days ago
Thank you so much "edx" for uploading the course. this course highlighted some of the pivot Table advance features. great course for new and moderate excel users. you will learn something new.
Was this review helpful? Yes0
 Flag
Arnnav Aggarwal profile image
Arnnav Aggarwal profile image

Arnnav Aggarwal

10/10 starsCompleted
4 weeks, 1 day ago
This was really a brilliant course. It indeed helped me to get in-depth knowledge of Excel, particularly data analysis using pivot tables and charts. I pursued this certified course which was an eye opener. I had never thought of creating such databases in Excel.
Was this review helpful? Yes0
 Flag
Ruchika Sharma profile image
Ruchika Sharma profile image

Ruchika Sharma

10/10 starsCompleted
1 month ago
I audited this course, so could't take part in quizzes. But valuable course for no cost.Course Content was well thought out, very well presented and easily digested. Was hppy to have been able to download and perform all the lab exercises
Was this review helpful? Yes0
 Flag
Kieron Clarke profile image
Kieron Clarke profile image

Kieron Clarke

6/10 starsCompleted
1 month ago
Course Content was well thought out, very well presented and easily digested. The instructor was excellent and the videos are a really handy way to present the course material. My only complaint would be that you cannot access the quiz material as an auditor, which means you have no way within the course to see if you have learnt and use the course material correctly.
Was this review helpful? Yes0
 Flag
Asad Shahbaz profile image
Asad Shahbaz profile image

Asad Shahbaz

10/10 starsCompleted
1 month ago
It a amazing course and I learn too much new in this course. 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.
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.