Introduction to Data Analysis using Excel

Provided by:
9/10 stars
based on  3714 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
24051 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
3714 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, 10 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
Armando Garcia Zacaneyes profile image
Armando Garcia Zacaneyes profile image

Armando Garcia Zacaneyes

10/10 starsCompleted
2 hours 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
2 hours 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
1 day, 18 hours 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
1 day, 18 hours 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 days, 1 hour 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 days, 20 hours 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 days, 21 hours 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
1 week, 3 days 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
1 week, 5 days 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
1 week, 6 days 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
2 weeks, 2 days 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
2 weeks, 4 days 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
2 weeks, 5 days 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
2 weeks, 5 days 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
2 weeks, 5 days 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
2 weeks, 6 days 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
3 weeks, 1 day 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
3 weeks, 3 days 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
3 weeks, 4 days 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
3 weeks, 4 days 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
student profile image
student profile image

student

10/10 starsCompleted
3 weeks, 5 days ago
A bit difficult lectures started after some lectures. Very good. Would have been even better if there was a closer connection between video lecture and quiz/lab material.
Was this review helpful? Yes0
 Flag
PRASANJEET Das profile image
PRASANJEET Das profile image

PRASANJEET Das

10/10 starsCompleted
3 weeks, 5 days ago
The explanation by Dany was according to my pace and the demonstration on Excel hand in hand really good. I really appreciate the good work and free course available made by Edx and great content provided by Microsoft
Was this review helpful? Yes0
 Flag
 profile image
 profile image

8/10 starsCompleted
  • 0 reviews
  • 0 completed
3 weeks, 5 days ago
It was interesting, informative and insightful. I found the lecture materials and scenario very useful, and the instructor knowledgeable about the subject matter. However, some formulas provided by the instructor were not correct but the course met my expectation and I will be able to apply what I learn here in my job.
Was this review helpful? Yes0
 Flag
Nnaemeka profile image
Nnaemeka profile image

Nnaemeka

8/10 starsCompleted
1 month ago
The course was a challenging but the instructor did well to break it down for a lay man to understand with easy and the provider did also well. its a top notch
Was this review helpful? Yes0
 Flag
RIASAT HEDAYET WRIBHU profile image
RIASAT HEDAYET WRIBHU profile image

RIASAT HEDAYET WRIBHU

10/10 starsCompleted
1 month ago
It was a fantastic course indeed. If you do it sincerely than undoubtedly you can develop your skills in excel. The instructor well elaborated the content, which made the course easy to comprehend. The exercises gave a hands-on experience to the course content.Top rated course.
Was this review helpful? Yes0
 Flag
Nazish Azim profile image
Nazish Azim profile image

Nazish Azim

10/10 starsCompleted
1 month ago
Very Informative course. The instructor well elaborated the content, which made the course easy to comprehend. The exercises gave a hands-on experience to the course content.
Was this review helpful? Yes0
 Flag
Sundararajan Subramaniam profile image
Sundararajan Subramaniam profile image

Sundararajan Subramaniam

10/10 starsCompleted
1 month ago
Informative and attractive learning platform. Very good, the instructor was really effective, very simple to understand. The exercises were fun to do, when you have a problem the extra readings are really helpful and even offer more than you can apply in daily basis.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 0 reviews
  • 0 completed
1 month ago
Very good, the instructor was really effective, very simple to understand. The exercises were fun to do, when you have a problem the extra readings are really helpful and even offer more than you can apply in daily bases so if you really curious you lear a lot more.
Was this review helpful? Yes0
 Flag
May Lee profile image
May Lee profile image

May Lee

10/10 starsCompleted
1 month, 1 week ago
This course is very informative. I find the instructor effective in giving instructions and able to lay out all the details in I would say “entertaining” way. I do not know anything about excel, not even the basics so this course’s been helpful for me. I am very glad I check out edX and found this course.
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.