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
24256 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

8/10 starsCompleted
4 years, 2 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
Alona Asuncion profile image
Alona Asuncion profile image

Alona Asuncion

10/10 starsCompleted
1 week, 1 day ago
Well instructions are well explained. Likewise, they provided some references on how to do the step by step formulation and procedure to do the tasks. The training is a good starter for those that is using excel in their reporting. It helps me a lot to understand on how do I present my reports and how to show the results effectively.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsTaking Now
  • 0 reviews
  • 0 completed
4 weeks, 1 day ago
It's the first course that I completed with Microsoft, I let it in pause couple years ago, but I came back since the last year and It still been useful to know how simple is use Excel (even version 2019) whenever you have a good instructor as Dany Hooter did. I would like to know wich are the next courses of this introduction.
Was this review helpful? Yes0
 Flag
Tshegofatso Maruping profile image
Tshegofatso Maruping profile image

Tshegofatso Maruping

10/10 starsCompleted
1 month ago
I enjoyed the course and would recommend it to anyone interested in data analysis. The instructor was fast on some points but i manged by replaying the video lecture. i struggled with using formulas but i guess its something to learn from a different course.
Was this review helpful? Yes0
 Flag
Lounangou yann profile image
Lounangou yann profile image

Lounangou yann

10/10 starsCompleted
2 months ago
very good , i enjoy all contents of the subject .the instructor was so clear he explained all part of the course like in the real situation . the parts that i prefer the most was quiz and lab parts the both gave me this opportunity to give back what i had learn and show me directly the knowledge that i gained or not
Was this review helpful? Yes0
 Flag
Valteson Santos profile image
Valteson Santos profile image

Valteson Santos

10/10 starsCompleted
2 months, 1 week ago
It's a exceptional course. I'he learned a lot about pivot tables. It will help me with my job. I expect to get more courses from microsoft and leran more about excel and Data Analysis. Thanks.
Was this review helpful? Yes0
 Flag
Chloe Ngindi profile image
Chloe Ngindi profile image

Chloe Ngindi

10/10 starsCompleted
2 months, 3 weeks ago
The course content is exceptional. The instructor was phenomenal; I struggled with fully grasping the IFSUM() function as it was complex so maybe providing more steps in completing those types of activities would assist, greatly. Overall, Mr.Dany really helped a lot. Critique: The surveys do not open and provide error messages. And there is a missing 'Additional information' page (from the link) in Module 7.
Was this review helpful? Yes0
 Flag
Student Altron Bytes profile image
Student Altron Bytes profile image

Student Altron Bytes

8/10 starsCompleted
3 months ago
I enjoyed the course, took me a while to start and to eventually finish due to work commitments but got there in the end. For that reason I am thankful for virtual training. Will apply my course content t my work.
Was this review helpful? Yes0
 Flag
Sanjiv Gautam profile image
Sanjiv Gautam profile image

Sanjiv Gautam

8/10 starsCompleted
3 months, 4 weeks ago
Its my first course, so a lot of new learnings. Contents are good and exercises are very lengthy. Pls. try explain common error areas, way to fix the error, try to ensure that questions of exercise are explained in lecture.
Was this review helpful? Yes0
 Flag
Benjamin Thompson profile image
Benjamin Thompson profile image

Benjamin Thompson

6/10 starsCompleted
4 months ago
The last part of the course was inaccessible to me as a Mac user, and other people reported similar issues. Otherwise pretty straightforward, the difficulty of units is not even. I found the final few units easier than some earlier ones, and some of the quizzes were easy to guess.
Was this review helpful? Yes0
 Flag
Armando Garcia Zacaneyes profile image
Armando Garcia Zacaneyes profile image

Armando Garcia Zacaneyes

10/10 starsCompleted
4 months ago
Very good, all concepts were teached clear and the material was excellente, i learn a lot, frome both quizzes and labs, the excersies where similar to the demonstration, so that make it easier to understand it .
Was this review helpful? Yes0
 Flag
Jibin Paul Thomas profile image
Jibin Paul Thomas profile image

Jibin Paul Thomas

8/10 starsCompleted
4 months ago
Pretty good, very informative and can be applied successfully in our area of work. The instructions given are very simple and easily follow-able, even for a fresher.
Was this review helpful? Yes0
 Flag
Jay Jay profile image
Jay Jay profile image

Jay Jay

10/10 starsCompleted
4 months ago
It's a really great and thoughtful course who wants to improve their skills. The instructions were clear and easily understand who didn't have enough knowledge of excel.
Was this review helpful? Yes0
 Flag
Mel Kelly profile image
Mel Kelly profile image

Mel Kelly

10/10 starsCompleted
4 months ago
Great course for those who work with large amounts of data and need a way to visualize the data. This will be beneficial for me professionally as I'm always seeking new ways to improve my data interpretation.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
4 months, 1 week ago
The courses was very Informative .I could understand and confident in analyzing the data through the sessions which taught through this. The class of the instructor was crisp and clear enough to understand without any doubts.
Was this review helpful? Yes0
 Flag
Molay Modey profile image
Molay Modey profile image

Molay Modey

10/10 starsCompleted
4 months, 1 week ago
The course content was well put, encouraging the building up to knowledge and application of learned topics. Thoroughly enjoyed the course and the instructor's demonstrations were explicit. Thank you!
Was this review helpful? Yes0
 Flag
Johan Meijners profile image
Johan Meijners profile image

Johan Meijners

10/10 starsCompleted
4 months, 1 week ago
It is a well prepared course, which I enjoyed to follow. Sometimes I thought something is missing, but that is the moment you are forced to think about the content. That is now (afterwards) a pre too. Thank you for the material. Johan.
Was this review helpful? Yes0
 Flag
kumutha murugan profile image
kumutha murugan profile image

kumutha murugan

10/10 starsTaking Now
4 months, 1 week ago
the course is great. At first it was a little difficult to understand the content but as time goes on it gets easier to understand. Now I'm able to fully grasp the study material and also able to do the quiz well.
Was this review helpful? Yes0
 Flag
Ashlee Hyde profile image
Ashlee Hyde profile image

Ashlee Hyde

8/10 starsCompleted
4 months, 2 weeks ago
The course content was great. Sometimes the formulas proved a bit difficult btu I enjoyed learning and am confident I can implement what I have learned into my work.
Was this review helpful? Yes0
 Flag
Yuveneswaren Bala profile image
Yuveneswaren Bala profile image

Yuveneswaren Bala

10/10 starsCompleted
4 months, 2 weeks ago
I think the content is very good and detailed. Anyone that completes the course should be able to increase their knowledge to a great extent. What will be great is to also include some tips and tricks to solve some Excel problems easily. The content can also be improved by adding sample of problems faced by most Excel users and the respective solutions.
Was this review helpful? Yes0
 Flag
Shaquana Freeman profile image
Shaquana Freeman profile image

Shaquana Freeman

8/10 starsCompleted
4 months, 2 weeks ago
The course was a great help with me learning more about Pivot tables. The videos and extra reading materials helped a lot with working through the problems Looking forward putting what I've learned in this course to use in the future.
Was this review helpful? Yes0
 Flag
Thi-Nhung Nguyen profile image
Thi-Nhung Nguyen profile image

Thi-Nhung Nguyen

8/10 stars
4 months, 3 weeks ago
Excellent course, useful and it will help me a lot for my work! I have learned pivot table, however, I got more in this course. Because I choose no pay so I can't practice quizzes but practicing with lab would still help to understand. Excel is always important tool for any business. Thank you guys a lot for this course. I really appreciate.
Was this review helpful? Yes0
 Flag
dhusminthar rao pushpanathan profile image
dhusminthar rao pushpanathan profile image

dhusminthar rao pushpanathan

10/10 starsCompleted
4 months, 3 weeks ago
very effective learning. one of the best course have attended in my life . hope to great things with knowledge. step by step by step learning modules and courses plus quizzes. interesting questions. nice exercises
Was this review helpful? Yes0
 Flag
jegwir singh profile image
jegwir singh profile image

jegwir singh

8/10 starsTaking Now
4 months, 3 weeks ago
great course to learn. more knowledge on excel. perfectly stacked courses and syllabus. detailed learning experience. step by step by step learning modules and courses plus quizzes. interesting questions. nice exercises
Was this review helpful? Yes0
 Flag
Richard Abreu profile image
Richard Abreu profile image

Richard Abreu

6/10 starsCompleted
4 months, 3 weeks ago
this course is amazing, very isntructive, very easy to understand the instructor. only down side of this course is that i, a mac user, was having difficulty performing the labs and goin along with the instructor since this course seems to especify to windows user, most notably Modul 8 took me lots of hours to complete untill i found the solution using VLOOKUP function
Was this review helpful? Yes0
 Flag
 profile image
 profile image

8/10 starsCompleted
  • 0 reviews
  • 0 completed
4 months, 3 weeks ago
This Course was really amazing in terms of new knowledge areas and on the job learning through practicing and discovering the new tasks and assignments.
Was this review helpful? Yes0
 Flag
MANIMARAN J KUMAR profile image
MANIMARAN J KUMAR profile image

MANIMARAN J KUMAR

8/10 starsTaking Now
4 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
Suthan Kanapathy profile image
Suthan Kanapathy profile image

Suthan Kanapathy

10/10 starsTaking Now
4 months, 4 weeks ago
superb, excellent, and marvelous. 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 the demonstration 3. Demonstration of complexities 4. Exercise requiring generalization of complexities. Good job.
Was this review helpful? Yes0
 Flag
Rubaraja Selvaraj profile image
Rubaraja Selvaraj profile image

Rubaraja Selvaraj

10/10 starsCompleted
4 months, 4 weeks ago
Learnt alot on formats and practiced loads of pivots. good to have practical and to see how datas make sense. 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
 profile image
 profile image

8/10 starsCompleted
  • 0 reviews
  • 0 completed
4 months, 4 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.
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.