Introduction to Data Analysis using Excel

Provided by:
9/10 stars
based on  3173 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
22474 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
3173 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, 8 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
Opeoluwa Adeyanju profile image
Opeoluwa Adeyanju profile image

Opeoluwa Adeyanju

10/10 starsCompleted
an hour ago
It was really a wonderful and amazing time learning and getting to know more advanced reasons to use Microsoft Excel. Thank you for setting this up and I hope to take other courses in this channel. The fact that I can get to download the videoes to refresh my memory is awesome
Was this review helpful? Yes0
 Flag
ARUSH UPADHYAY profile image
ARUSH UPADHYAY profile image

ARUSH UPADHYAY

8/10 starsCompleted
1 day, 7 hours ago
The course and instructor were great, I learned a lot only thing I would like to say in cons is some excel features they applied in lectures don't teach to the student.
Was this review helpful? Yes0
 Flag
Mayra Mendoza profile image
Mayra Mendoza profile image

Mayra Mendoza

10/10 starsCompleted
2 days, 13 hours ago
This course was definitely useful to me. I learned how to use other features available in Excel for Data Analysis. You do have to pay attention to the videos and take notes this will help you when you take the quizzes and labs.
Was this review helpful? Yes0
 Flag
Ashley Martinez profile image
Ashley Martinez profile image

Ashley Martinez

10/10 starsCompleted
2 days, 23 hours ago
I thought this course was a great learning tool. I do have a bit of excel background however I wish I would have taken it before I started my current job would have been even more helpful!
Was this review helpful? Yes0
 Flag
Ashley Martinez profile image
Ashley Martinez profile image

Ashley Martinez

10/10 starsCompleted
2 days, 23 hours ago
I thought this course was a great learning tool. I do have a bit of excel background however I wish I would have taken it before I started my current job would have been even more helpful!
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
3 days, 19 hours ago
Very good course, it show lots of excel function especially pivot. Instruction have good knowledge of excel, he explore pivot well. Duration of video need to reduce.
Was this review helpful? Yes0
 Flag
Arne van Zyl profile image
Arne van Zyl profile image

Arne van Zyl

10/10 starsCompleted
4 days, 14 hours ago
Excellent course and will definitely be helpful in my field. I would recommend that the video lectures should correlate more with the quiz and lab scenarios. I had issues with some questions that was not covered in the video lectures or reading material.
Was this review helpful? Yes0
 Flag
Nur Khalisza Purnama Putri profile image
Nur Khalisza Purnama Putri profile image

Nur Khalisza Purnama Putri

10/10 starsCompleted
5 days, 3 hours ago
Great! The content contained in the course is very satisfied, the material is clearly presented so it's easy to understand, very useful, the quiz and laboratory assessment are a bit challenging
Was this review helpful? Yes0
 Flag
Andre Herdian profile image
Andre Herdian profile image

Andre Herdian

10/10 starsCompleted
5 days, 10 hours ago
It helps me for advancing my carrer. I work as Account Manager in Telecommunication Company and I am sure the course will support me to analyze data. Thank You Microsoft.
Was this review helpful? Yes0
 Flag
Lori Johnson profile image
Lori Johnson profile image

Lori Johnson

10/10 starsCompleted
5 days, 23 hours ago
The course was well organized with a good balance between lectures (videos) and labs. I appreciated the focus on new features within Excel, many of which I was unfamiliar with.
Was this review helpful? Yes0
 Flag
Justin Reading profile image
Justin Reading profile image

Justin Reading

8/10 starsCompleted
6 days, 15 hours ago
The course was very informative, and a great introduction on how to use some of the tools Excel has to offer. I would recommend this course to other professionals that use Excel on a daily basis.
Was this review helpful? Yes0
 Flag
Gerhard Rosslee profile image
Gerhard Rosslee profile image

Gerhard Rosslee

10/10 starsCompleted
1 week ago
I learned plenty of new ways to use excel to illustrate data. Would recommend this to others as a great course for those with basic excel knowledge. The examples were clearly stated, had some problems with understanding what is expected of me in some of the questions.
Was this review helpful? Yes0
 Flag
Edwin Sanjaya profile image
Edwin Sanjaya profile image
10/10 starsCompleted
  • 0 reviews
  • 0 completed
1 week ago
It is a very good experience to learn from an expert directly. The video explained very well but there are some holes in the quiz because the answer cant be finded in video
Was this review helpful? Yes0
 Flag
Khoirun Ni'mah profile image
Khoirun Ni'mah profile image

Khoirun Ni'mah

10/10 starsCompleted
1 week, 1 day ago
Great. The video content explained very well by instructor in easy way. I could following the instruction for answer the question in lab. It's really help. Thank you.
Was this review helpful? Yes0
 Flag
EMI ZULFAH TIDAK ADA profile image
EMI ZULFAH TIDAK ADA profile image

EMI ZULFAH TIDAK ADA

8/10 starsCompleted
1 week, 1 day ago
Sangat baik, Saya mendapat pengetahuan baru dalam menggunakan Ms Excel. Terdapat video yang dapat mudah dipahami dan latihan soal dan lab yang membantu melatih kemampuan sesuai video yang diajarkan. Semoga ilmunya dapat bermanfaat ke depan dan dapat diaplikasikan terima kasih :).
Was this review helpful? Yes0
 Flag
Fredy Rachman profile image
Fredy Rachman profile image

Fredy Rachman

10/10 starsCompleted
1 week, 1 day ago
Very nice instructor. I get a new knowledge from this course. Today i now that excel a really big think than it's just a table. Thanks for Microsoft to learn me especially about Excel.
Was this review helpful? Yes0
 Flag
shobhit deshwal profile image
shobhit deshwal profile image

shobhit deshwal

8/10 starsCompleted
1 week, 1 day ago
the course provided is content ful and interactive, provides the very basic knowledge for excel. however the video quality while working on excel sheet might have been some better. it is hard to look at the sheets sometimes.
Was this review helpful? Yes0
 Flag
Ariel B profile image
Ariel B profile image

Ariel B

10/10 starsCompleted
1 week, 2 days ago
Very good course. Material adds value. Got to use features I didn't know about. Moving on to do the other courses in this program. Only issue I had was that some of the lecture videos were blurry and I could barely see what he was doing but the transcripts helped.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 0 reviews
  • 0 completed
1 week, 6 days ago
I took the free course, but the information provided to me showed that the payed version is worth the investment. I'm taking it again for sure and get my certificate.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

8/10 starsCompleted
  • 1 review
  • 1 completed
2 weeks, 1 day ago
Actually, I was shocked about how can't I know the HUGE things like Excel. All informations are useful for me in this course because I can acceptly beginner student for this course. But I learn also a need more experience and so need a time. It is was the maybe best thing that visualizing and understanding how can creat your data more better. Well done for everyone work on ıt this course.
Was this review helpful? Yes0
 Flag
Harshwardhan Nagar profile image
Harshwardhan Nagar profile image

Harshwardhan Nagar

4/10 starsCompleted
2 weeks, 2 days ago
The content should be full. The only fee should be charged for a certificate only. All excess of labs and quizzes should be provided in Audit mode. Rest all is good.
Was this review helpful? Yes0
 Flag
Geovani Janiski profile image
Geovani Janiski profile image
8/10 starsCompleted
  • 0 reviews
  • 0 completed
2 weeks, 3 days ago
This course was very useful to me. Learnt a lot from it. The materials available, videos, the labs and quizzes helped me to understand and get used to PivotTables, PivotCharts and so on in a simple way.
Was this review helpful? Yes0
 Flag
Najma A. profile image
Najma A. profile image

Najma A.

10/10 starsCompleted
2 weeks, 4 days ago
I found this course to be very useful and full of learning. Everything I wanted to learn were presented in the videos, quizzes and labs. I will definitely consider the next course! Thanks a lot.
Was this review helpful? Yes0
 Flag
Hubert Dębowski profile image
Hubert Dębowski profile image

Hubert Dębowski

8/10 starsTaking Now
2 weeks, 4 days ago
It's a very good course. There are some minor issues with questions but they were nothing crucial for the content. I have a weird feeling that one or maybe two questions were make prior to the lecture which demonstrate the answers for them. Next downside is that there could be more excercises. Nevertheless it is a very good course. Good job.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
2 weeks, 5 days ago
Good materials, really learnt a lot. But I can't finish some task on the mac Excel, windows Excel seems have much more functions. It would be better if there are more exercises to practice.
Was this review helpful? Yes0
 Flag
jawad nizam profile image
jawad nizam profile image

jawad nizam

10/10 starsCompleted
2 weeks, 6 days ago
it was so helpful . Very good. Would have been even better if there was a closer connection between video lecture and quiz/lab material i enjoyed it soooo much
Was this review helpful? Yes0
 Flag
Hannah Wilkinson profile image
Hannah Wilkinson profile image

Hannah Wilkinson

10/10 starsCompleted
2 weeks, 6 days ago
This course was great! The videos were clear and easy to understand and I felt the labs supported the lessons very well.. It would have been nice to have a moderator on the forums answering student questions. I did not see anyone from the course posting in the forums.
Was this review helpful? Yes0
 Flag
Somnimith Cosgrove profile image
Somnimith Cosgrove profile image

Somnimith Cosgrove

6/10 starsCompleted
3 weeks, 2 days ago
Very good in terms of the topics, exercises. The instructor is excellent, very clear... but it would have been better if the videos could show a better view of the excel sheet and therefore on the formulas. It would it be nice to zoom in. I found the IFS/IF formulas very difficult and I would appreciate more clarity on the topic.
Was this review helpful? Yes0
 Flag
Dimas Nugraha profile image
Dimas Nugraha profile image

Dimas Nugraha

10/10 starsCompleted
3 weeks, 3 days ago
its such a nice thing to learn. but the guide sometimes didn't help much, but for overall this is help me much to learn data analysis using excel. The lab it self has much data. so we can feel its true, not just some training.
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.