Introduction to Data Analysis using Excel

Provided by:
9/10 stars
based on  2930 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
21741 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
2930 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 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
john smith profile image
john smith profile image

john smith

6/10 starsCompleted
2 days, 1 hour ago
1. The video quality can be further improved as it is quite small & not able to see the icons clearly. 2. The questions should be labelled accordingly for easy reference
Was this review helpful? Yes0
 Flag
satya kumar profile image
satya kumar profile image

satya kumar

8/10 starsCompleted
2 days, 20 hours ago
1. Instructor was quite good, however it would be better, if the video's quality gets improved. 2. Course content is fair enough to make a normal person to understand. with much practice, it will make our self better. 3. Quizzes, questions, discussions were appreciated, where the user can gain much exposure to the required knowledge. 4. Download facility of every file makes the user very much statistic. 5. With help of the App it makes much easier to acquire knowledge from anywhere
Was this review helpful? Yes0
 Flag
Denis Barry profile image
Denis Barry profile image

Denis Barry

10/10 starsCompleted
3 days ago
excellent course. Would recommend to anybody working with excel. Well laid out format. Videos not too long and links to reading material were excellent way of getting more information. Could have included a few extra screenshots in lab section of what output to produce looked like.
Was this review helpful? Yes0
 Flag
Swapnil Avhad profile image
Swapnil Avhad profile image

Swapnil Avhad

10/10 starsCompleted
3 days, 1 hour ago
Great content and step by step knowledge advancement in the course makes it a must take course!! Wonderfully taught by the lecturer with the help of real - life example. The LAB parts do make sure that you have understood well and can implement whatever has been taught.
Was this review helpful? Yes0
 Flag
Arsalan Masood profile image
Arsalan Masood profile image

Arsalan Masood

10/10 starsCompleted
5 days, 1 hour ago
Well developed course with good contents, labs, and quizzes. The course is divided into easily managed small lectures. This was my first course and I am planning to do another course in this series. This course is good for all professionals and must for officials and students in the field of accountancy, finance, supply chain and budgeting.
Was this review helpful? Yes0
 Flag
J H profile image
J H profile image

J H

8/10 starsCompleted
5 days, 11 hours ago
My first edX course and I loved it. The course was exactly as advertised. Exposing someone like me with a basic knowledge of Excel to some of the more powerful functionality of the software. It was great to be able to manipulate and visualize the data so easily. Two recommendations (1) some of the questions could be clearer and (2) with my monitor it was difficult to see what the instructor was doing in the video - too small - it would be helpful to zoom in sometimes. Overall I was very pleased and will continue on with the other courses.
Was this review helpful? Yes0
 Flag
Olacir profile image
Olacir profile image

Olacir

10/10 starsCompleted
5 days, 21 hours ago
The course was good to me, and most of other students of, think the same, the instructor is very good. About the content, the exercises are also other good point in this, helping alot in the learning, with the material provided to learn more about the subjects covered, (links to microsoft pages in this most), and also the course staff, which also helps answering questions. And Edx, of course, for its good platform to learn, by organization, resources. Very good, I learned about the course proposuse and a something more about Excel.
Was this review helpful? Yes0
 Flag
Birhanu Taye profile image
Birhanu Taye profile image

Birhanu Taye

8/10 starsCompleted
6 days, 4 hours ago
The course really makes me to revisit the power of Excel for analysis purpose. The way the course organize and presented is very nice. I am quite sure i will exercise through my day to day reporting and analysis tasks. Thanks Edx and MicroSoft.
Was this review helpful? Yes0
 Flag
Favour Osemwegie profile image
Favour Osemwegie profile image
8/10 starsCompleted
  • 0 reviews
  • 0 completed
6 days, 11 hours ago
Some of the questions in the quizzes were not practiced in the tutorials, some were tougher. The instructor was audible, the demonstrations were perfect, the study materials were helpful and the quizzes were interesting. Thank you Edd.
Was this review helpful? Yes0
 Flag
Boluwatife Popoola profile image
Boluwatife Popoola profile image

Boluwatife Popoola

8/10 starsCompleted
1 week ago
The course content is really interesting and practical. Though, some details in the quiz and lab were not practiced in the video i.e. VLOOKUP. The instructor was fluent and clear.
Was this review helpful? Yes0
 Flag
Kawuma Peter profile image
Kawuma Peter profile image

Kawuma Peter

10/10 starsCompleted
1 week ago
The course is fantastic!! Real life skills for sure. I only want to suggest that the wording on the certificate changes a bit. When u write "got a passing grade" it means barely made it in many parts of the world. Words like excelled make the certificate more solid
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 0 reviews
  • 0 completed
1 week ago
I enjoyed taking this course. I found it extremely beneficial and useful. The assessments were quite easy to do, because of the step by step instructions available. This also made it possible to put the skills learnt to immediate practise for retention. kudos
Was this review helpful? Yes0
 Flag
Abimbola Akinwande profile image
Abimbola Akinwande profile image

Abimbola Akinwande

10/10 starsCompleted
1 week ago
I enjoyed taking this course. I found it extremely beneficial and useful. The assessments were quite easy to do, because of the step by step instructions available. This also made it possible to put the skills learnt to immediate practise for retention. kudos
Was this review helpful? Yes0
 Flag
Abimbola Akinwande profile image
Abimbola Akinwande profile image

Abimbola Akinwande

10/10 starsCompleted
1 week ago
I enjoyed taking this course. I found it extremely beneficial and useful. The assessments were quite easy to do, because of the step by step instructions available. This also made it possible to put the skills learnt to immediate practise for retention. kudos
Was this review helpful? Yes0
 Flag
Abimbola Akinwande profile image
Abimbola Akinwande profile image

Abimbola Akinwande

10/10 starsCompleted
1 week ago
I enjoyed taking this course. I found it extremely beneficial and useful. The assessments were quite easy to do, because of the step by step instructions available. This also made it possible to put the skills learnt to immediate practise for retention. kudos
Was this review helpful? Yes0
 Flag
Abimbola Akinwande profile image
Abimbola Akinwande profile image

Abimbola Akinwande

10/10 starsCompleted
1 week ago
I enjoyed taking this course. I found it extremely beneficial and useful. The assessments were quite easy to do, because of the step by step instructions available. This also made it possible to put the skills learnt to immediate practise for retention. kudos
Was this review helpful? Yes0
 Flag
Timothy Yorty profile image
Timothy Yorty profile image

Timothy Yorty

10/10 starsTaking Now
1 week ago
This is an excellent course. I enrolled to learn about pivot tables in preparation for a 3-day course on MS PowerBI, hopefully this has prepared me for that class. Recommendations: 1) Organize the online class structure a little better. It's a little difficult to stop and restart and know where you're at in the overall course. 2) the instructor computer screen views appeared blurry.
Was this review helpful? Yes0
 Flag
Timothy Yorty profile image
Timothy Yorty profile image

Timothy Yorty

10/10 starsTaking Now
1 week ago
This is an excellent course. I enrolled to learn about pivot tables in preparation for a 3-day course on MS PowerBI, hopefully this has prepared me for that class. Recommendations: 1) Organize the online class structure a little better. It's a little difficult to stop and restart and know where you're at in the overall course. 2) the instructor computer screen views appeared blurry.
Was this review helpful? Yes0
 Flag
Jen Omena profile image
Jen Omena profile image

Jen Omena

6/10 starsCompleted
1 week, 1 day ago
Fairly ok. A closer view of the instructor's screen would have been great particularly when he was typing formulas. Still not 100% comfortable with formulas especially nested ones and would have to retake this course or something similar.
Was this review helpful? Yes0
 Flag
Prateek Jain profile image
Prateek Jain profile image

Prateek Jain

10/10 starsCompleted
1 week, 1 day ago
Very useful. As a neophyte to excel, I learned a lot about pivot tables, sorting techniques, formulating the tables and all above how to analyze them in meaning full way by charts & labels. Overall the technique of lecture-quizzing-add on materials-labs with a good real world problem script makes this course very effective as well as makes it easy to remember about the various tools based on tasks & clients requirements.
Was this review helpful? Yes0
 Flag
A Bell profile image
A Bell profile image

A Bell

10/10 starsCompleted
1 week, 1 day ago
Lots of content & tools learned but much of it is copy and paste or going to Google to answer, no true problem solving & navigating which options to choose. Definitely shows you the ropes but would need a more interactive class to truely master the basic skills
Was this review helpful? Yes0
 Flag
Alberto Perez profile image
Alberto Perez profile image

Alberto Perez

8/10 starsCompleted
1 week, 1 day ago
It is a great starting point for Data Analysis and to know the basic and new function for analysis in Excel. I did not rank top 10 because during some videos I have difficulties to read the excel examples therefore to follow the steps. But overall my experience was satisfactory.
Was this review helpful? Yes0
 Flag
Hugo Azevedo profile image
Hugo Azevedo profile image

Hugo Azevedo

10/10 starsCompleted
1 week, 1 day ago
Very interesting course, served as a refresh to so old Excel knowledge and opened my curiosity to the ability of the program, at the same time contributing to a new view of how to analyze data. Looking forward for the next course
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
1 week, 1 day ago
This was my first EdX course which I completle finished as the whole course was very clear and the instructor was perfect. Thanks a lot for your time and effort. Thumps up
Was this review helpful? Yes0
 Flag
Tatiana Martinez profile image
Tatiana Martinez profile image

Tatiana Martinez

10/10 starsCompleted
1 week, 1 day ago
First time taking a course with Edx it was a good experience. Very interesting course, I learned a lot and quizzes and labs were very helpful to practice what I learned. Links were very informative covering all the information I needed to complete quizzes. Instructor was very professional and easy to follow and content was good enough to provide what I was looking for. Thank you.
Was this review helpful? Yes0
 Flag
vinayak chavan profile image
vinayak chavan profile image

vinayak chavan

10/10 starsCompleted
1 week, 1 day ago
Really nice course. Additionally given links were informative. According to me, Knowledge checks/quiz were more effective and fruitful than Lab exercise. I would suggest adding some more videos.
Was this review helpful? Yes0
 Flag
Bhagwati Maurya profile image
Bhagwati Maurya profile image

Bhagwati Maurya

10/10 starsCompleted
1 week, 2 days ago
First of all Thank you very much for the Course. I learned a lot it was Great Learning with edx, as i want to become an analyst course helped me a lot, Thank you very much once again
Was this review helpful? Yes0
 Flag
NIKHIL ARORA profile image
NIKHIL ARORA profile image

NIKHIL ARORA

10/10 starsCompleted
1 week, 2 days ago
It was a wonderful course as it provided me with many unknown features of EXCEL. The Instructor was excellent to engage me with the curiosity to learn more.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 0 reviews
  • 0 completed
1 week, 2 days ago
very informative and easy to comprehend even foe novice. the download files (video and excel) are golden and a better reference for future. The instructor made the whole program seemed easy. i really enjoyed it.
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.