Introduction to Data Analysis using Excel

Provided by:
9/10 stars
based on  2097 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
19058 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
2097 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
11 months, 2 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? Yes4
 Flag
maitri shah profile image
maitri shah profile image

maitri shah

10/10 starsCompleted
2 hours ago
its a good refresher for anyone interested in business/data analysis line of work. having worked in policy, this course helped me gain a valuable insight into my future job search. the videos and the lab exercises are closely related. no surprises there! explained in a lucid user-friendly way. Thank you, Microsoft and Dany.
Was this review helpful? Yes0
 Flag
Eapen ,Tholmas profile image
Eapen ,Tholmas profile image

Eapen ,Tholmas

10/10 starsCompleted
17 hours ago
Excellent course. Helped me to understand how to analyze, format and present data using pivot tables and charts. I liked the lab exercises very much and they helped me to understand the subject better.
Was this review helpful? Yes0
 Flag
Aoife Doherty profile image
Aoife Doherty profile image

Aoife Doherty

6/10 starsCompleted
22 hours ago
I thought the instructor was great, seemed really knowledgeable The content was good - some was a bit irrelevant and I found it about too difficult and not really what I was looking for out of this course (SUMIFS for example) but overall it was good.
Was this review helpful? Yes0
 Flag
Emmanuel Afolayan profile image
Emmanuel Afolayan profile image
10/10 starsCompleted
  • 1 review
  • 1 completed
1 day, 21 hours ago
I am so excited to formally begin my journey to being an MS Excel expert! The Videos ,further readings, quizzes and the labs are super rich except that I would have wanted more detailed explanations on some of the excel functions used in this course. The instructor and the provider are super solid! Thumbs up to them! I Can not wait to start the next course "visualising and analysing data in excel". Many thanks
Was this review helpful? Yes0
 Flag
Raphael Adebisi profile image
Raphael Adebisi profile image

Raphael Adebisi

10/10 starsCompleted
2 days, 14 hours ago
The course content is great, the instructor also is superb. The Provider did a good job by incorporating many hands on lab, which makes the course more interesting. However, Things like linking excel sheet, v-lookup and other function would have been great for a beginner.
Was this review helpful? Yes0
 Flag
Martin Nkole profile image
Martin Nkole profile image

Martin Nkole

10/10 starsCompleted
2 days, 17 hours ago
Great content and exceeding my expectation. The instructor was good and explained every detail clearly. The provider was very helpful as the guidelines and question where in line with the knowledge gained. See you on the next part.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

8/10 starsCompleted
3 days, 12 hours ago
It was a good course, I was familiar with most of the content but it was a good refresher! The instructor was clear and to the point on how to use certain excel tools. See you on the next course!
Was this review helpful? Yes0
 Flag
Nebojsa Koprivica profile image
Nebojsa Koprivica profile image

Nebojsa Koprivica

8/10 starsCompleted
4 days, 3 hours ago
I expected a bit more instructor tutorials. I believe that some stuff we did throughout course is not essential when it comes to data analysis. Anyway, see you on the next course.
Was this review helpful? Yes0
 Flag
Michael Ng profile image
Michael Ng profile image

Michael Ng

10/10 starsCompleted
4 days, 4 hours ago
The content is great! Especially for a beginner like me who has not had any experience in Excel at all. I hope to learn more courses from Microsoft. It is comprehensive in terms of content and yet easy to understand. It is progressive. I am now more confident in using the beast called Excel.
Was this review helpful? Yes0
 Flag
Lizeth Salas profile image
Lizeth Salas profile image

Lizeth Salas

10/10 starsCompleted
4 days, 19 hours ago
I was able to understand tools that I had never used before. This will be a new skill to add to my Resume. Labs and quizzes very understandable. I will continue with the next training.
Was this review helpful? Yes0
 Flag
Nelson Lopez profile image
Nelson Lopez profile image

Nelson Lopez

10/10 starsCompleted
4 days, 20 hours ago
This was a Great course! It´s an easy and modern way to learn, under our own paste; congratulation to all! This way of education really opens an opportunity to many people around the world; thank you so much.
Was this review helpful? Yes0
 Flag
Jesús Canales profile image
Jesús Canales profile image

Jesús Canales

10/10 starsCompleted
4 days, 20 hours ago
Buen curso, la explicación y el material excelente. Buena introducción al análisis de datos con Microsoft Excel. Buena también con la integración de datos.
Was this review helpful? Yes0
 Flag
Alexeis Patricio Huaiquin Rosas profile image
Alexeis Patricio Huaiquin Rosas profile image

Alexeis Patricio Huaiquin Rosas

8/10 starsCompleted
5 days, 19 hours ago
Very well structure, understandable and enjoyable. EXCEPT for Lecture 6 (getting data from pivot and Sumifs function), I found the class to be too simple in comparison to the Lab 6, and I could really learn how to Sumifs and had a ton of problems using GetPivotData. And it wasn't only me, a lot of people were struggling with the same thing in the forum. But overall a great course, but I suggest restructuring Lec 6.
Was this review helpful? Yes0
 Flag
Ankita Sahu profile image
Ankita Sahu profile image

Ankita Sahu

10/10 starsCompleted
6 days, 3 hours ago
The course is well structured and informative. The labs are designed so as to clear all concepts that were explained in the video lectures. The content is also very helpful. The instructor was clear and crisp. Full points to this course
Was this review helpful? Yes0
 Flag
Khaled Elsayad profile image
Khaled Elsayad profile image
8/10 starsCompleted
  • 0 reviews
  • 0 completed
6 days, 15 hours ago
Interesting and useful and clear and good Easy to understand Good teach Intresting vedio Lab Tests Thank you for you More successful in the next course Good bay
Was this review helpful? Yes0
 Flag
Melinda Lotz profile image
Melinda Lotz profile image

Melinda Lotz

10/10 starsCompleted
6 days, 19 hours ago
It was great, it provided the right amount of challenge to keep one interested and learning the concepts without getting frustrated. The way the content was structured was smart and flowed well and allowed for an easy and smooth learning experience.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

8/10 starsCompleted
6 days, 20 hours ago
Very pleased with content - now much more familiar with pivot table and chart capabilities. Would have liked to seen screen zoomed in so I can read formulas and more easily view creation of pivots.
Was this review helpful? Yes0
 Flag
Citizen Munkaila Mohammed Kabore profile image
Citizen Munkaila Mohammed Kabore profile image
10/10 starsCompleted
  • 0 reviews
  • 0 completed
6 days, 20 hours ago
The course content was apt and very practical. The instructor knows the subject matter. His mode of delivery made the course very enjoyable. The could have been better however, if bigger fonts were used to make his workings on the presentation more visible.
Was this review helpful? Yes0
 Flag
A Bhalerao profile image
A Bhalerao profile image

A Bhalerao

10/10 starsCompleted
1 week ago
Learnt many new things about Data Analysis. The course was well organised and helped learning. Excel has many powerful functions that were informed as part of the course. Will surely take the next one as well.
Was this review helpful? Yes0
 Flag
Kah Lung Ling profile image
Kah Lung Ling profile image
8/10 starsCompleted
  • 1 review
  • 1 completed
1 week ago
Very Good! I learnt a lot from this course. This course improved my knowledge on data analysis using Excel which might be useful for my future career. I like the video lectures very much. The video lectures are short but sufficient for me to master every important knowledge of this course.
Was this review helpful? Yes0
 Flag
Jonathan Jonathan profile image
Jonathan Jonathan profile image

Jonathan Jonathan

8/10 starsCompleted
1 week ago
Fast-paced content. Did improve my knowledge about Excel and summarizing data. Video lectures are also good, whose content using a mini case-based problem and giving an exact example of what we're going to solve in the quiz/lab assessment.
Was this review helpful? Yes0
 Flag
GURUPRASAD NAGRAJ profile image
GURUPRASAD NAGRAJ profile image

GURUPRASAD NAGRAJ

10/10 starsCompleted
1 week, 1 day ago
Overall course was very good. Did understand it better. At times the stuffs shown in videos was too small to have a look at it. Unable to see the stuffs. may be this can be overcome. Well understood the concept of DATA ANALYSIS. Will work more on it and gain mastery. Found little bit tough the last part - POWER PIVOT. may be I did not put efforts. But will do it over a period of time. Thanks a lot to everybody involved. looking forward to more such courses
Was this review helpful? Yes0
 Flag
SUBAIR MANJERIKUNNATH profile image
SUBAIR MANJERIKUNNATH profile image

SUBAIR MANJERIKUNNATH

8/10 starsCompleted
1 week, 2 days ago
The course content is well enough to illustrate the concept of data analysis. The videos, contents are excellent. A glance to the analysis. The illustration found useful and informative. It is recommendable for medium proficiency users.
Was this review helpful? Yes0
 Flag
Omar Dhieb profile image
Omar Dhieb profile image

Omar Dhieb

10/10 starsCompleted
1 week, 2 days ago
This is an interesting course and I'm so happy to finish it and I hope to do the next course to earn series in excel courses.this course is easy to understand it and the exercices are very clear .so I don't find problem with this course .
Was this review helpful? Yes0
 Flag
Adriana Baruch profile image
Adriana Baruch profile image
10/10 starsCompleted
  • 0 reviews
  • 0 completed
1 week, 2 days ago
It would help if we could clearly see the tables in the lectures. Sometimes it is difficult to follow because the tables are not readable. Or to write down the formulas below the lectures.
Was this review helpful? Yes0
 Flag
shweta Narayanan profile image
shweta Narayanan profile image

shweta Narayanan

10/10 starsCompleted
1 week, 2 days ago
It is a very good course for beginners like me. The way it has been presented is also very good and easily understandable. If the excel view in lecture was bigger for the learner to see it would be great.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
1 week, 3 days ago
Perfect course to refresh tables and pivot tables, and also to learn new tricks. In order to improve lectures, I would recommend making bigger the Excel view in the video because it is hard to follow even in HQ when seeing it in a tablet or small laptop. The rest of it is Excel-lent!
Was this review helpful? Yes0
 Flag
Vignesh Mahalingam profile image
Vignesh Mahalingam profile image
10/10 starsCompleted
  • 1 review
  • 1 completed
1 week, 3 days ago
It is a very useful course.All the topics were covered in a very detailed manner. Very useful for a beginner. It would be better if there was a separate excel file given during the video lecture so that it will be easy to practice/try the exercise.
Was this review helpful? Yes0
 Flag
Yash Khunger profile image
Yash Khunger profile image
10/10 starsCompleted
  • 0 reviews
  • 0 completed
1 week, 3 days ago
This course is very good for a beginner.It does not go in depth to explain all the functions and features of Excel .But it really gives a nice overview of what can be done and how it can be done.
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.