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
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 8 months ago
Amazing work although this could have been done initially before proceeding with the data model which was completed earlier(Analyzing and Visualising data with excel). Dany is good just one suggestion. Sometimes the screen is blurred in the video which I think will have to be zoomed in next time.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

6/10 starsCompleted
4 years, 8 months ago
I think that the video of explication is very poor, and some question are weird. Even so, I have learn many things about excel and I am satisfied.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years, 8 months ago
It is a very good course. I have learnt some new tools in Excel specially Pivot table, building dashboard and off course my analytical ability has improved a lot. The material, videos and the instructor are easy to understand. There should be a financial aid available for those who can't afford the course price. Thanks for providing such a good resource.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years, 8 months ago
I think the course is enough for me to work. Because my English is not good, so some question i don't know what it is. I hope you will have many advanced course about Data Analysis with Excel in future. I will enroll it. Thanks so much !
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 8 months ago
I found the course very helpful,i learnt about basics of pivot table. quiz questions were good.Labs were too good.i had a question on lecture 5 which was not answered,it would be great if someone will answer it.Module 7 and Module 8 were very easy to clear,hope some more information could have been added.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 8 months ago
I have been using Excel for quite a while and I consider myself quite good in Excel. I write macros for work in office. This course introduces some things that are completely new to me. The content is good. The instructor does a very good job to guide the learners through the topics. The only problem is the quality of the video. It basically has no difference between HD and SD. The content appears to be blur. One has to put the video to full screen in order to see the content clearly.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 8 months ago
Good course. Useful content. I plan on using what I learned in the near future. Microsoft Excel can be an extremely useful tool when one knows how to use it. Thank you
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years, 8 months ago
Overall I think it was a great course, and I'm glad I spend my time on it. It got really interesting after week 4, but I understand that it wouldn't have, unless I got the knowlege from first 4 weeks. Thank you very much!
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 8 months ago
All the topics are explained Very well. Quiz questions were Very good and Labs were amazing. I would give a rating of 5/5 to the course moderator who explained the topics so nicely. I just had a question to be answered that is in lecture 5 ,Revenue was used to calculate the Profit percentage(Margin) Instead of Cost price,Mostly Profit percentage(Margin) IS calculated as (Profit/cost price) X 100 But here it was calculated Using selling Price which is Wrong according to me. Request the moderator to answer my question.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 8 months ago
Great course! It´s well structured, gives us the possibility to interact with the course assistant and other participants. I will recommend to my colleagues and will take the second part of the course.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years, 8 months ago
I learnt few tricks and better understand now pivot tables. I liked the exercises that are really useful to understand how it works. Hopefully I was able to download excel 2016
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 8 months ago
Practical, to the point, content. Good examples with actual applicability. Only drawback is the need for newer versions of office for very specific topics. Good course schedule, easy to follow on a tight schedule.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 8 months ago
Course content was CHALLENGING!! I did not try as hard as I could have on Units 5-8, because I was on a time deadline. However, I found Units 1-4 very useful and practical for what I need to know how to do to generate data reports for my work. Liked the lecture and instructor. The only thing I would change is the visibility of his screen-make it bigger and readable for the students listening to the lecture. I could not read his screen at all..very blurry and small
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

8/10 starsCompleted
4 years, 9 months ago
Content was good. Some modules were more useful than others. But I thought that it was well-structured and the sample data were good to work with. The videos could have been done better - maybe some editing. Where there were errors or too much coughing, etc., fix and edit those out. It was a little distracting and made it seem unprofessional. The videos that were a computer voice - have a person do those. Would have made it easier to listen to.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

6/10 starsCompleted
4 years, 9 months ago
It was a good experience working with some tools to do the analysis with. But it could have been better if some additional topics of data analysis technique were introduced.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years, 9 months ago
The course content is about creating charts and tables using simple steps. The lecture is lucid and clear. The content could have included more examples and explanations of the functions used in the exercises. Thanks
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years, 9 months ago
Good course, short, informative, not too many new functions at once reduces confusion to a minimum. However, I would prefer to get less hints on "new" features of Office 365 (eg. IFS(), recommended charts), instead I would like to see more actual implementations of functions in the video. As well, I would personally hope that additional functions, like the aforementioned "IFS()", would be given to users of older Office versions as an update. Nevertheless, keep up with your insightful online course. I'm looking forward to joining the next one in order to improve my skills in Excel. Best regards, pakkun
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 1 review
  • 1 completed
4 years, 9 months ago
Great Learning experience! Microsoft + EdX best combination. No doubts left. Instructor made everything clear in the lectures. Just loved the overall experience.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 9 months ago
I have just installed 365 and did not know the powerful option I had in Excel. So glad I took up this course. The video tutorial was simple and could be easily understood.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsTaking Now
4 years, 9 months ago
The course was excellent and had a very practical approach which made the study interesting.It started right from the basics which makes it easier for anyone to understand.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

8/10 starsCompleted
  • 1 review
  • 1 completed
4 years, 9 months ago
I wished to know more contents in excel. Felt like there should be more than the one's provided as a part of the course content. But anyways, it is well an eye opener. Got to know certain new functionalities, which paved way to explore more.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

6/10 starsTaking Now
4 years, 9 months ago
Content needs to be more. More Examples, and pivot chart related details needs to be shown. More complex lab exercises to be provided and the clue needs to be hidden, let the user dig and find the clue, which will really add more value to the course.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

6/10 starsCompleted
4 years, 9 months ago
Kind of a short course. And we are given four weeks to complete it? Wow. Seems like WAY too much time. The content is ok, although I suspect that one should read the Microsoft on-line documentation that is linked at the end of each section. I guess I was expecting a lot more from the class. But I will be happy with what I got. It reminded me of a few concepts that I had forgotten, and taught me some new tricks. Unfortunately, my version of Excel 2016 apparently does not support the IFS function (not listed in the fx drop down). This function would have been very handy for the last problem set.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

6/10 starsTaking Now
4 years, 9 months ago
I am a beginner with some functions such as the IF function. So, it was a little challenge to complete the lab. Maybe I am a little tired after work, but the wording of the quizzes got me off a little, so I did not perform as expected with the quizzes.
Was this review helpful? Yes0
 Flag
Jingxian Lin profile image
Jingxian Lin profile image
10/10 starsTaking Now
  • 1 review
  • 0 completed
4 years, 9 months ago
The course content is very useful. The instructor is very clear, and the provider is very helpful. I learn a lot from this course, and I would like to recommend this course to my good friends!
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 9 months ago
So much fun to learn the new =IFS and other functions. I definitely recommended this to my peers. Took about 1.5 hours to complete the exercises and tests.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years, 9 months ago
Useful enough. Great introduction to excel. However I wish he would have performed the functions (TEXT and RIGHT) on screen than to leave us to figure it out.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

6/10 starsCompleted
4 years, 9 months ago
In one of the exercises, we were directed to use a function that was never shown in the course. It took some time to get the function to work and we had to use external resources and could not refer back to notes.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

4/10 starsTaking Now
4 years, 9 months ago
It is a bit difficult but very use full. Personally I don't think that the formula sheets are explained very well. example the =Right that didn't help in anyway. The explanations are to high level and it doesn't have sufficient examples. But all in all. I learned a lot.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

6/10 starsTaking Now
4 years, 9 months ago
Good course with detailed explanation. Some self exploration work is necessary and the course has it all to involve the students to max. Waiting for next week course topics. Ending of a Modules seemed like ending of course, although it is not.
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.