Introduction to Data Analysis using Excel

Provided by:
9/10 stars
based on  3723 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
24288 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
3723 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
6 months, 1 week ago
A bit difficult lectures started after some lectures. Very good. Would have been even better if there was a closer connection between video lecture and quiz/lab material.
Was this review helpful? Yes0
 Flag
PRASANJEET Das profile image
PRASANJEET Das profile image

PRASANJEET Das

10/10 starsCompleted
6 months, 1 week ago
The explanation by Dany was according to my pace and the demonstration on Excel hand in hand really good. I really appreciate the good work and free course available made by Edx and great content provided by Microsoft
Was this review helpful? Yes0
 Flag
 profile image
 profile image

8/10 starsCompleted
  • 0 reviews
  • 0 completed
6 months, 1 week ago
It was interesting, informative and insightful. I found the lecture materials and scenario very useful, and the instructor knowledgeable about the subject matter. However, some formulas provided by the instructor were not correct but the course met my expectation and I will be able to apply what I learn here in my job.
Was this review helpful? Yes0
 Flag
Nnaemeka profile image
Nnaemeka profile image

Nnaemeka

8/10 starsCompleted
6 months, 2 weeks ago
The course was a challenging but the instructor did well to break it down for a lay man to understand with easy and the provider did also well. its a top notch
Was this review helpful? Yes0
 Flag
RIASAT HEDAYET WRIBHU profile image
RIASAT HEDAYET WRIBHU profile image

RIASAT HEDAYET WRIBHU

10/10 starsCompleted
6 months, 2 weeks ago
It was a fantastic course indeed. If you do it sincerely than undoubtedly you can develop your skills in excel. The instructor well elaborated the content, which made the course easy to comprehend. The exercises gave a hands-on experience to the course content.Top rated course.
Was this review helpful? Yes0
 Flag
Nazish Azim profile image
Nazish Azim profile image

Nazish Azim

10/10 starsCompleted
6 months, 2 weeks ago
Very Informative course. The instructor well elaborated the content, which made the course easy to comprehend. The exercises gave a hands-on experience to the course content.
Was this review helpful? Yes0
 Flag
Sundararajan Subramaniam profile image
Sundararajan Subramaniam profile image

Sundararajan Subramaniam

10/10 starsCompleted
6 months, 3 weeks ago
Informative and attractive learning platform. Very good, the instructor was really effective, very simple to understand. The exercises were fun to do, when you have a problem the extra readings are really helpful and even offer more than you can apply in daily basis.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 0 reviews
  • 0 completed
6 months, 3 weeks ago
Very good, the instructor was really effective, very simple to understand. The exercises were fun to do, when you have a problem the extra readings are really helpful and even offer more than you can apply in daily bases so if you really curious you lear a lot more.
Was this review helpful? Yes0
 Flag
May Lee profile image
May Lee profile image

May Lee

10/10 starsCompleted
6 months, 3 weeks ago
This course is very informative. I find the instructor effective in giving instructions and able to lay out all the details in I would say “entertaining” way. I do not know anything about excel, not even the basics so this course’s been helpful for me. I am very glad I check out edX and found this course.
Was this review helpful? Yes0
 Flag
Alyona Bukhvalova profile image
Alyona Bukhvalova profile image

Alyona Bukhvalova

10/10 starsCompleted
6 months, 3 weeks ago
all three have done their job great, especially the instructor Dany, i really enjoyed how he explained everything - it was very clear and useful. i wish i took this course 4 years ago it would really help me on demand planning position at the beginning but even now i learned a lot og nice excel tricks. Thanks to everyone who created this course and made it public for everyone interested.
Was this review helpful? Yes0
 Flag
Stephanie Hukom profile image
Stephanie Hukom profile image

Stephanie Hukom

10/10 starsCompleted
6 months, 3 weeks ago
I really love the content, including the demonstration video, it does help me to understand more about Excel. I'd like to join in another course like this but please give the notes in front of the course that only the participant who pay the certificate can take the quiz. So far this course really help me.
Was this review helpful? Yes0
 Flag
Jane F profile image
Jane F profile image

Jane F

8/10 starsCompleted
6 months, 3 weeks ago
Excellent exposure especially for working adults. 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. Well done
Was this review helpful? Yes0
 Flag
Kayathri Subramaniam profile image
Kayathri Subramaniam profile image

Kayathri Subramaniam

10/10 starsCompleted
6 months, 3 weeks 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
Praveena Selvalingam profile image
Praveena Selvalingam profile image

Praveena Selvalingam

10/10 starsCompleted
6 months, 3 weeks ago
The content was good, but an overview of what other tools are available would have been nice. Also, I expected some theory or methods on how to analyze data, but this was limited to just explaining how to use excel tools. The course name is a bit misleading. Finally, Edx used to grant access to all the materials and exercises and for an unlimited time regardless of whether you paid or not. Payment was just to earn the certificate. Keep the idea of making knowledge available for everyone, don't turn it into a for profit platform.
Was this review helpful? Yes0
 Flag
Andres Chavez profile image
Andres Chavez profile image

Andres Chavez

6/10 starsCompleted
6 months, 3 weeks ago
The content was good, but an overview of what other tools are available would have been nice. Also, I expected some theory or methods on how to analyze data, but this was limited to just explaining how to use excel tools. The course name is a bit misleading. Finally, Edx used to grant access to all the materials and exercises and for an unlimited time regardless of whether you paid or not. Payment was just to earn the certificate. Keep the idea of making knowledge available for everyone, don't turn it into a for profit platform.
Was this review helpful? Yes0
 Flag
Maria Herrera profile image
Maria Herrera profile image

Maria Herrera

10/10 starsCompleted
6 months, 3 weeks ago
The couse was very good, the thing I would like to highlight is that I didnt feel support from the staff. When I had a question, I had to investigate myself to clarify, which is good beacuse I learned a lot but still, I would like to feel more support in futures courses.
Was this review helpful? Yes0
 Flag
Juan profile image
Juan profile image

Juan

10/10 starsCompleted
6 months, 3 weeks ago
Very good. I recommend this course for everyone who wants to get started and understand the power of excel for data analysis by focusing on pivot tables and charts. Good examples but you should pay to get full content, particulary quizes.
Was this review helpful? Yes0
 Flag
Theresa profile image
Theresa profile image

Theresa

10/10 stars
6 months, 4 weeks ago
The course provides a thorough introduction to the data analysis tools in Excel and plenty of exercise work to practice what is being taught. Only drawback for those taking the free course is that there is a time limit of 1 month.
Was this review helpful? Yes0
 Flag
Anreena Francis profile image
Anreena Francis profile image

Anreena Francis

10/10 starsTaking Now
6 months, 4 weeks ago
A good starting for me and take some time for me to understand and observe on the video lecture. I wish if could give more examples and samples before the lab material begin. Expected an audio explanation for easy understanding but manage to quiz/lab with simple knowledge that I have.
Was this review helpful? Yes0
 Flag
Peter Brooks profile image
Peter Brooks profile image

Peter Brooks

8/10 starsCompleted
6 months, 4 weeks ago
Interesting course, instructor was very engaging. Will be applying a lot of this content in my day to day tasks. I would encourage any individuals with an interest in Excel, data analysis and data visualization to complete this course.
Was this review helpful? Yes0
 Flag
David Gradoville profile image
David Gradoville profile image

David Gradoville

10/10 stars
7 months ago
Loved the instructor...very knowledgeable and easy to understand. Also very good at explaining Excel concepts. I thought that the quizzes and tests were very well created and made the student recall the lecture and were a very good way to allow for retention of the subjects.
Was this review helpful? Yes0
 Flag
Sakhi Solanki profile image
Sakhi Solanki profile image

Sakhi Solanki

10/10 starsCompleted
7 months ago
The demonstration, the explanation was done so efficiently that learning these new concepts were made interesting! It truly was quite an insightful course and you learn a lot about how to effectively represent your data.
Was this review helpful? Yes0
 Flag
Lavennia profile image
Lavennia profile image

Lavennia

8/10 starsTaking Now
7 months ago
Good. The use of Excel is widespread in the industry. It is a very powerful data analysis tool and almost all big and small businesses use Excel in their day to day functioning. This is an introductory course in the use of Excel and is designed to give you a working knowledge of Excel with the aim of getting to use it.
Was this review helpful? Yes0
 Flag
Sumit profile image
Sumit profile image

Sumit

8/10 starsCompleted
7 months ago
The instructor was very well cnversant with the subject matter and explained everything nicely. The reading resources were also helpful. For people auditing this course, Assignment questions could have ben provided.
Was this review helpful? Yes0
 Flag
Ramon Griffith profile image
Ramon Griffith profile image

Ramon Griffith

10/10 starsCompleted
7 months ago
Very good course with excellent presentation of information/supplementary material. However, more connections should be made between quiz/lab and lecture material.
Was this review helpful? Yes0
 Flag
Peter Opiyo profile image
Peter Opiyo profile image

Peter Opiyo

10/10 starsCompleted
7 months ago
the course was on point and i got exactly what i needed to start on Data analysis. The instructor had a way of pretending that he is just learning that now, and i found it hilarious. than you microsoft for this course
Was this review helpful? Yes0
 Flag
Ananya J profile image
Ananya J profile image

Ananya J

10/10 starsCompleted
7 months ago
I think it teaches all the necessary basics very well. although i have worked with excel for a bit before, i learned quite a few things on how things could be done easier and simpler. good job Dany and Microsoft!
Was this review helpful? Yes0
 Flag
Cezar Estrologo profile image
Cezar Estrologo profile image

Cezar Estrologo

10/10 starsCompleted
7 months, 1 week ago
The course is very helpful and gives deeper knowledge in using excel. The instructor should make the cursor more visible to follow easily because it is hard for me since I have been using a phone to learn.
Was this review helpful? Yes0
 Flag
Yuvah Raj Morgan profile image
Yuvah Raj Morgan profile image

Yuvah Raj Morgan

6/10 starsCompleted
7 months, 1 week ago
Hi, after completing the course, I found it is important to the working class people before the graduates. Im able to clarify this courses for few words:- Efficient, Effective, Emphasize, Knowledgeable, Professional, Educating, Thoughtful, Organize, Good Exposure, Essential, Good Branding by Microsoft, and VALUABLE
Was this review helpful? Yes0
 Flag
Jaime Corral Riverola profile image
Jaime Corral Riverola profile image

Jaime Corral Riverola

8/10 starsCompleted
7 months, 1 week ago
Un muy buen curso introductorio. Conviene tener un cierto rodaje con el desempeño de tablas dinámicas, pero tampoco es necesario para sobrellevar el curso. Tiene una dinámica muy amena y el instructor aporta información muy útil que te puede servir si trasladas esos consejos a tu día a día. Very good course, with an easy way of format to follow and very good instructor. I appreciate how he is able to provide usefull knowledge you can use after that for your professional daily basis.
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.