Introduction to Data Analysis using Excel

Provided by:
9/10 stars
based on  3637 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
23854 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
3637 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
3 years, 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
Y H profile image
Y H profile image

Y H

10/10 starsCompleted
12 hours ago
Great course. It was easy to follow, and I personally enjoyed the Discussion section that it helped me at times during the quiz. I will recommend anybody to take this online training of Data Analysis.
Was this review helpful? Yes0
 Flag
BH NG profile image
BH NG profile image

BH NG

10/10 starsCompleted
1 day, 6 hours ago
Very good. I was very impressed by this online training of Data Analysis using Excel. It has great content, instruction and provider. It would be better to have more demonstration for all the samples instruction and exercises for better understanding. Thanks to Microsoft Excel.
Was this review helpful? Yes0
 Flag
William profile image
William profile image

William

10/10 starsCompleted
3 days, 14 hours ago
Great content, easy to follow, and great experience. The information was clear and understandable. Great value for the information. I am looking forward to the next course and being able to advance my knowledge and expertise in data analytics.
Was this review helpful? Yes0
 Flag
Carmel Eje profile image
Carmel Eje profile image

Carmel Eje

10/10 starsCompleted
4 days, 7 hours ago
I had a very good experience in learning from this course. I am able to better understand the use of Excel for Data Analysis. The quizzes and laboratory exercises also enhanced the way I learn through this course.
Was this review helpful? Yes0
 Flag
Abhinav Kumar Singh profile image
Abhinav Kumar Singh profile image

Abhinav Kumar Singh

10/10 starsCompleted
6 days, 18 hours ago
Really informative course. I completed the free course only so I didn't have access to the quizzes, but the videos were great. Hope you make similar courses more.Thanks a lot!
Was this review helpful? Yes0
 Flag
Mervyn Sek profile image
Mervyn Sek profile image

Mervyn Sek

10/10 starsCompleted
1 week ago
Besides having the demonstration videos, it was beneficial to include the transcript on the right. I was able to efficiently review certain parts just by clicking on the respective parts of the transcript! The quizzes, which required the learner to process/ analyse the data before responding, allowed for immediate revision and application of learning! I love this format of e-learning! Kudos to the trainer Dany Hoter and the Microsoft team!
Was this review helpful? Yes0
 Flag
Daniela profile image
Daniela profile image

Daniela

10/10 starsCompleted
1 week ago
The content was very useful. I liked a lot this course. The only issues that I had, were the formulas to create a new table based on the pivot table.
Was this review helpful? Yes0
 Flag
Sue Perry profile image
Sue Perry profile image

Sue Perry

8/10 starsCompleted
1 week ago
I learnt a lot, but will need to re-visit some of the sections to reinforce the knowledge. Great pace and useful that we can download the lectures afterwards to be able to review.
Was this review helpful? Yes0
 Flag
Molly profile image
Molly profile image

Molly

10/10 starsCompleted
1 week, 1 day ago
I think this course was fantastic. I learned a lot about pivot tables and some sophisticated charting. It has opened my eyes up to the power of Excel for data analysis. Great to be provided with datasets to explore in the labs. The instructor was amazing, he provided enough details and examples to explain his lectures and let you practice. Top marks to the instructor. Thank you !!!
Was this review helpful? Yes0
 Flag
Adem profile image
Adem profile image

Adem

10/10 starsCompleted
1 week, 1 day ago
Excellent course with very practical lab exercises. I am keen to continue on this series... I would've loved to see a recommendation of related courses as part of the wrap-up, probably something for edX to think about...
Was this review helpful? Yes0
 Flag
Dhivesh Ramesh Kumar profile image
Dhivesh Ramesh Kumar profile image

Dhivesh Ramesh Kumar

8/10 starsTaking Now
1 week, 2 days ago
It was really informative. The course structures were well organized and were introduced in an understandable manner. The course was filled with knowledge and introduction to extensive features of Excel that can ease the data analysis. The exercise provided were very similar to demonstration. In overall, a good educational prospect
Was this review helpful? Yes0
 Flag
Alejandro Quijano profile image
Alejandro Quijano profile image

Alejandro Quijano

10/10 starsCompleted
1 week, 2 days ago
Habla muy lento el instructuor, el quiz del modulo 6 no tiene relación con el vídeo . debería haber prorroga para las actividades. Pero en general el contenido muy bueno con herramientas muy utiles.
Was this review helpful? Yes0
 Flag
Rob Eitzen profile image
Rob Eitzen profile image

Rob Eitzen

10/10 starsCompleted
1 week, 3 days ago
I've taken several online courses in the data analysis track and Dany is my favorite. I could visualize his talks with Jack & Lucy. The background was very helpful in thinking through the processes he walked us through.
Was this review helpful? Yes0
 Flag
Arumugam Subas Chantirabos profile image
Arumugam Subas Chantirabos profile image

Arumugam Subas Chantirabos

8/10 starsCompleted
1 week, 3 days ago
beautiful, excellence,. marvelous. jolly good. i learned alot from these course. please send me more link to study/. 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
Walter Can profile image
Walter Can profile image

Walter Can

10/10 starsCompleted
1 week, 4 days ago
Very Good. Simple and easy to let me understand. Even though I do not have excel on hand, I still can learn some skills from video lecture, lab. Especially VLOOKUP, it is very useful to me.
Was this review helpful? Yes0
 Flag
Tomás Maldonado profile image
Tomás Maldonado profile image

Tomás Maldonado

10/10 starsCompleted
1 week, 4 days ago
Any course should serve to learn and apply in the real world. I liked the examples and the clarity of the instructor to convey their experience. It also helped me to reinforce some points related to pivot tables. The complementary readings will be very useful for later consultations.
Was this review helpful? Yes0
 Flag
TVM Akash profile image
TVM Akash profile image

TVM Akash

10/10 starsCompleted
1 week, 4 days ago
Introduction to Data Analysis using Excel is good online course. I miss certification and could have been better if there was a side by side connection between video lecture and quiz/lab material. Some time the instructor was little confusing and have to see video again to clarify what he really mean. Main highlight are 1. Exercise are easy to follow. 2 Simple demonstration 3. Exercise similar to demonstration 4. Demonstration of complexities well its a, learned a lot new thing in excel Good job.
Was this review helpful? Yes0
 Flag
Nikita Shah profile image
Nikita Shah profile image

Nikita Shah

10/10 starsCompleted
1 week, 5 days ago
Very helpful course. Lab exercise covered all the lecture discussion and got chance to practice on all the topics. Great Job. The course was very well explained, easy to understand and very well formatted. I haven't paid for the certificate but I wish I would have gotten chance to work on quiz as well.
Was this review helpful? Yes0
 Flag
Paulo Inácio profile image
Paulo Inácio profile image

Paulo Inácio

8/10 starsCompleted
1 week, 5 days ago
I did not pay the certificate but at least I should be able to access to the soluttions of the quiz. Otherwise does not make any sense , it is not a free course
Was this review helpful? Yes0
 Flag
Rudy Figueroa profile image
Rudy Figueroa profile image

Rudy Figueroa

10/10 starsCompleted
1 week, 5 days ago
Good course, well explained, I really enjoy learning new thing related to analysis of data. This course was very challenging because I have to investigate and understand how the formulas work using pivot tables, I want to take the next course because this all information is really important in the professional life.
Was this review helpful? Yes0
 Flag
AKINTUNDE ONIFADE profile image
AKINTUNDE ONIFADE profile image

AKINTUNDE ONIFADE

8/10 starsCompleted
1 week, 5 days ago
A very good and informative course, however I would like if some explanations of some topics can be more simplified even to was a great challenge for me to figure things out myself. I enjoyed it!
Was this review helpful? Yes0
 Flag
Waheed Iqbal profile image
Waheed Iqbal profile image

Waheed Iqbal

10/10 starsTaking Now
1 week, 6 days ago
Excellent Job, I love the way he was talking and describing the whole topics, Pivot Table presentations and It's Dashboard reporting was just awesome, It helps me out in my own projects and delivered in a good manner and easy to understand. Thumbs up
Was this review helpful? Yes0
 Flag
Lawrence Osuwat profile image
Lawrence Osuwat profile image

Lawrence Osuwat

10/10 starsCompleted
2 weeks, 1 day ago
Excellent and worthwhile. Data analysis is a critical component of life. Whether it is for academicians, researchers, or simply someone in business. Therefore, this has been a course of benefit to me
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
2 weeks, 2 days ago
Great course! I had tried a different course on basic Excel on another platform which covered a lot about Pivot Tables etc, but none of them really gave me clarity. This instructor was soo good and taught with such clarity based on relatable examples! This is definitely what I needed.
Was this review helpful? Yes0
 Flag
Rajan Yadav profile image
Rajan Yadav profile image

Rajan Yadav

10/10 starsCompleted
2 weeks, 2 days ago
So much to learn and implement in day to day operations at work. It would have been great if lab content was more challenging. Each topic has been explained point by point, with links provided separately for refreshment of basics. Would love to see more such courses from Micosoft.
Was this review helpful? Yes0
 Flag
Student data profile image
Student data profile image

Student data

10/10 starsCompleted
2 weeks, 3 days ago
it was good, simple content. the instructor was good when it comes to proceeding ideas i learned stuff according to data science. I took this course as a step of thousand-mile steps in data science . thank you
Was this review helpful? Yes0
 Flag
Student data profile image
Student data profile image

Student data

10/10 starsCompleted
2 weeks, 3 days ago
it was good, simple content. the instructor was good when it comes to proceeding ideas i learned stuff according to data science. I took this course as a step of thousand-mile steps in data science . thank you
Was this review helpful? Yes0
 Flag
Student data profile image
Student data profile image

Student data

10/10 starsCompleted
2 weeks, 3 days ago
it was good, simple content. the instructor was good when it comes to proceeding ideas i learned stuff according to data science. I took this course as a step of thousand-mile steps in data science . thank you
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
2 weeks, 4 days ago
Great curriculum that hits all of the major introductory topics for someone pursuing a career in data/business analytics. The instructor did a great job of explaining the concepts and showing how they can be applied in real-world scenarios.
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.