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
Maria Jessamin Caguicla profile image
Maria Jessamin Caguicla profile image

Maria Jessamin Caguicla

10/10 starsCompleted
7 months, 1 week ago
It was excellent, easy to follow though I got a hard time on the last 3 lessons. And I got a problem on my copy of Microsoft excel 2016 nevertheless, I learned a lot from the instructor and its content.
Was this review helpful? Yes0
 Flag
Anthony Antidormi profile image
Anthony Antidormi profile image

Anthony Antidormi

10/10 starsCompleted
7 months, 1 week ago
Great course! Though I would have preferred to have unlimited attempts at completing the quizzes and labs (I spent too much time worrying about whether or not I knew the answer because I knew I could not reset the quiz/lab and try again)
Was this review helpful? Yes0
 Flag
Ozgur Celik profile image
Ozgur Celik profile image

Ozgur Celik

10/10 starsCompleted
7 months, 2 weeks ago
Before taking this course I had almost no experience with this content but now I really feel very comfortable. I just wish that there were more exercises.
Was this review helpful? Yes0
 Flag
Sumiya Malik profile image
Sumiya Malik profile image

Sumiya Malik

8/10 starsCompleted
7 months, 2 weeks ago
This is a very good and basic course to gain introductory knowledge about Excel for professionals. The way the instructor explains and goes through with the exercises is really great. The only thing I feel is it would be much better if we had the sample excel files for the examples that the instructors shows in the video lectures. All in all its really good for those who lost their touch on excel and who are new to this tool.
Was this review helpful? Yes0
 Flag
Alexander Orozco profile image
Alexander Orozco profile image

Alexander Orozco

8/10 starsCompleted
7 months, 2 weeks ago
Excelente curso. mejoro mucho mi nivel de Excel y el analisis de datos teniendo un mejor enfoque para aumentar mis capacidades a futuro con otras herramientas.
Was this review helpful? Yes0
 Flag
SHIV KUMAR profile image
SHIV KUMAR profile image

SHIV KUMAR

10/10 starsCompleted
7 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
Anas Adaileh profile image
Anas Adaileh profile image
8/10 starsCompleted
  • 0 reviews
  • 0 completed
7 months, 3 weeks ago
the course really good and really helpful it well helpes you a lot in your work with good example also the instructor really great he do everything step by step and not too long
Was this review helpful? Yes0
 Flag
Saranya Balachandran profile image
Saranya Balachandran profile image

Saranya Balachandran

8/10 starsTaking Now
7 months, 3 weeks ago
instructor was very helpful.He provide us the instructions very clear and reply very fast when we asked any questions regarding the certificate claim.
Was this review helpful? Yes0
 Flag
Ritz Sethi profile image
Ritz Sethi profile image

Ritz Sethi

8/10 starsCompleted
7 months, 3 weeks ago
It was a very useful course, unless you are a mac user in which case i felt lost! In the last exercise i couldnt find the "more tables" option on my Mac at all.
Was this review helpful? Yes0
 Flag
Deepali Dcruz profile image
Deepali Dcruz profile image

Deepali Dcruz

10/10 starsCompleted
7 months, 3 weeks ago
It was really a nice experience to learn through quiz and lab exercises, it helped to test all the knowledge we learned in the lecture and in further reading materials. As an introduction it covered all the aspects.This was the first time i enrolled for an online course and i really enjoyed it. Looking forward for other courses. Thank you
Was this review helpful? Yes0
 Flag
Diogo Queirós profile image
Diogo Queirós profile image

Diogo Queirós

10/10 starsCompleted
7 months, 4 weeks ago
A very clear and well presented course. The quizzes and lab work really helped understand everything presented. It made the difference when consolidating the knowledge
Was this review helpful? Yes0
 Flag
Harsh Lochan profile image
Harsh Lochan profile image

Harsh Lochan

8/10 starsCompleted
7 months, 4 weeks ago
Very good course. A few lab exercises on SUMIFS and VLOOKUP would have been helpful. I did not completely understand some of the formulae that one must copy from the course page. However, a very good foundation or refresher course for Excel everybody will benefit from. Worth every cent.
Was this review helpful? Yes0
 Flag
Georgi Marinov profile image
Georgi Marinov profile image

Georgi Marinov

8/10 starsCompleted
7 months, 4 weeks ago
Since I previously enrolled and got the verified certificate for the course "DAT207x: Analyzing and Visualizing Data with Power BI" and I am able to make comparison, I have the feeling that the content of this Excel course was kind of not complete and not enough, comparing to the Power BI one. The content was informative and useful though. What made a bad impression was that I posted a question concerning the difference between the paid and the non-paid version of the course (if there is a difference in the content released or only in the availability of quizes and labs in the paid version) and for 10 days nobody answered.
Was this review helpful? Yes0
 Flag
Debi Yusuf profile image
Debi Yusuf profile image

Debi Yusuf

8/10 starsCompleted
7 months, 4 weeks ago
Finally! I'm completed this course. After joined and completed every single step in this course, My skill and knowledge about excel is improved better than last.
Was this review helpful? Yes0
 Flag
Jeewhan Kim profile image
Jeewhan Kim profile image

Jeewhan Kim

8/10 starsCompleted
7 months, 4 weeks ago
A job well done! I was wondering if there was a course out there for people that already graduated from college, to further study computer skills. The course was a bit confusing with some parts but overall it was a great course.
Was this review helpful? Yes0
 Flag
ankit jaiswal profile image
ankit jaiswal profile image
8/10 starsCompleted
  • 0 reviews
  • 0 completed
7 months, 4 weeks ago
Very Good content. Easy instructions, good guidance on lab work and moderate pace of teaching. This course exposed me to many new things. Looking forward to other excel courses.
Was this review helpful? Yes0
 Flag
Namita Yadav profile image
Namita Yadav profile image

Namita Yadav

8/10 starsCompleted
7 months, 4 weeks ago
very good content. Easy instructions and moderate pace of teaching. I had only basic knowledge of excel and this course made me exposed to so many new things.
Was this review helpful? Yes0
 Flag
Ana Blanco profile image
Ana Blanco profile image

Ana Blanco

8/10 starsCompleted
8 months ago
Easy and clear instructions, moderate and gradual pace of teaching skills. I really liked the way the previous practices were continually integrated to the new ones. I had a bit of a problem figuring out some instructions in the Labs, but nothing that was too tricky to resolve. It was overall a great course.
Was this review helpful? Yes0
 Flag
Olubunmi Dili-Ejinaka profile image
Olubunmi Dili-Ejinaka profile image

Olubunmi Dili-Ejinaka

8/10 starsCompleted
8 months ago
The training was fabulous but require more time for students to internalize with more practices. The hints was mostly useful and also having students write on their experience from the course was equally interesting. This was an added advantage to knowing what my fellow colleagues felt about the course. Thank you.
Was this review helpful? Yes0
 Flag
Wei Xiang Tan profile image
Wei Xiang Tan profile image

Wei Xiang Tan

10/10 starsCompleted
8 months ago
Very good, only thing is that more information could have been provided for mac users to make this course more mac friendly (particularly for the last lab exercise)
Was this review helpful? Yes0
 Flag
Berenice Bravo profile image
Berenice Bravo profile image

Berenice Bravo

8/10 starsCompleted
8 months ago
Excellent, I have no idea about working with tables in excel, they help me a lot to do nice analysis in a easy way. It si very helpful and you explain so well. Thanks a lot
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
8 months ago
The course content was amazing and easy to understand. Extra resources were provided and questions were answered in the discussion box. would recommend.
Was this review helpful? Yes0
 Flag
LP Ong profile image
LP Ong profile image

LP Ong

10/10 starsCompleted
8 months ago
course content was good. but the video lecture and quiz/lab does not link for some. lesson 6 lab is alittle confusing, took me awhile to follow the instructions.
Was this review helpful? Yes0
 Flag
Nigel O'Neill profile image
Nigel O'Neill profile image

Nigel O'Neill

8/10 starsCompleted
8 months ago
Very good. Some questions were a little confusing and not always relating to the lectures. Picked up some useful tips and I'll be back for the follow up course.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

8/10 starsCompleted
8 months ago
Awesome course, but the relative lectures didn't match with the quiz and lab material, but working it out got me more of an understanding which was valuable.
Was this review helpful? Yes0
 Flag
Mohamed Belkhalfi profile image
Mohamed Belkhalfi profile image

Mohamed Belkhalfi

10/10 starsCompleted
8 months ago
Very well explained, can be challenging sometimes but if you give it enough time you notice that it's not that hard. I only did the audit version it's sad that i wasn't allowed the see the quizzes but the labs were enough. Looking forward to do the following courses.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

8/10 starsTaking Now
8 months ago
The instructor was very knowledgeable. Drawbacks include: a key glossary of formulas for use in the instruction. There was some disconnect for me w/the use of them in the exercises. The lectures were an excellent tool to demonstrate the use of the pivot tables. I don't believe you receive that instruction when you take the basic excel course. Wish that I had taken the course earlier as it would have helped me w/a labor intensive data project at work.
Was this review helpful? Yes0
 Flag
Y H profile image
Y H profile image

Y H

10/10 starsCompleted
8 months 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
8 months 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
8 months, 1 week 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

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.