Analyzing and Visualizing Data with Excel

Provided by:
9/10 stars
based on  1801 reviews
Provided by:
Cost FREE , Add a Verified Certificate for $99
Start Date In Session

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

  • In Session

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
23719 reviews

Course Description

This course is part of the Microsoft Professional Program Certificate in Big Data, and the Microsoft Professional Program Certificate in Data Science.

Excel is one of the most widely used solutions for analyzing and visualizing data. It now includes tools that enable the analysis of more data, with improved visualizations and more sophisticated business logics. In this data science course, you will get an introduction to the latest versions of these new tools in Excel 2016 from an expert on the Excel Product Team at Microsoft.

Learn how to import data from different sources, create mashups between data sources, and prepare data for analysis. After preparing the data, find out how business calculations can be expressed using the DAX calculation engine. See how the data can be visualized and shared to the Power BI cloud service, after which it can be used in dashboards, queried using plain English sentences, and even consume...

This course is part of the Microsoft Professional Program Certificate in Big Data, and the Microsoft Professional Program Certificate in Data Science.

Excel is one of the most widely used solutions for analyzing and visualizing data. It now includes tools that enable the analysis of more data, with improved visualizations and more sophisticated business logics. In this data science course, you will get an introduction to the latest versions of these new tools in Excel 2016 from an expert on the Excel Product Team at Microsoft.

Learn how to import data from different sources, create mashups between data sources, and prepare data for analysis. After preparing the data, find out how business calculations can be expressed using the DAX calculation engine. See how the data can be visualized and shared to the Power BI cloud service, after which it can be used in dashboards, queried using plain English sentences, and even consumed on mobile devices.

Do you feel that the contents of this course is a bit too advanced for you and you need to fill some gaps in your Excel knowledge? Do you need a better understanding of how pivot tables, pivot charts and slicers work together, and help in creating dashboards? If so, check out DAT205x: Introduction to Data Analysis using Excel.

This course is also a part of the Microsoft Excel for the Data Analyst XSeries

Reviews 9/10 stars
1801 Reviews for Analyzing and Visualizing Data with 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
Bill Davilas profile image
Bill Davilas profile image
10/10 starsCompleted
  • 1 review
  • 1 completed
4 years, 7 months ago
This is an exemplary clear, to-the-point and practical course, extremely useful for business users. I would strongly recommend this course to anyone working with data analysis, wishing to facilitate decision making
Was this review helpful? Yes0
 Flag
Umair Naeem profile image
Umair Naeem profile image
10/10 starsCompleted
  • 3 reviews
  • 3 completed
4 years, 7 months ago
It was an Excellent Learning Experience for me. I have been using excel in my day to day job and this course will help me increase my work efficiency through all the new concepts and capabilities of MS Excel that i have learned here. Thanks
Was this review helpful? Yes0
 Flag
Charen RAVI profile image
Charen RAVI profile image
10/10 starsCompleted
  • 1 review
  • 1 completed
4 years, 7 months ago
I have been an user of Excel professionally, But I have never used Power Query and Power Pivots before. The course was interesting because we always thrive to learn the features of excel, which is a never ending chapter. Especially the lab experience right after each module was helpful. The trainer is also good with the topic. Overall it was a fantastic learning, looking forward to take up more courses on excel.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

2/10 starsTaking Now
4 years, 7 months ago
It would be helpful to know that you cannot take this course if you are on a Mac before signing up. I had to learn in the lab set up instructions that the course is not designed for Excel on a Mac. Good thing I didn't pay for a verified course!
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

2/10 starsDropped
4 years, 7 months ago
Very bad start: _ Downloadable files not available. Errors appear at multiple attempts. I cannot continue without accessing the documents. _ The instructor assumes the users have more than a basic knowledge, forcing us to complement a lot the necessary knowledge through forums and Microsoft support. It makes the course not integral, being more inconvenient for the user.
Was this review helpful? Yes0
 Flag
Kevin Morice profile image
Kevin Morice profile image
2/10 starsDropped
  • 30 reviews
  • 22 completed
4 years, 7 months ago
Yet another Microsoft course which is incompatible with many of their own products. Forget it if you are running a Mac or Linux. And if you are running Office365, their suggestion for that one is actually to buy another copy of Excel, uninstall the copy you have and install a version with LESS functionality!
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 2 reviews
  • 2 completed
4 years, 7 months ago
El curso estuvo completo. A pesar de estar íntegramente en inglés (lo cual también se reflejaba en las variaciones en la versión de Excel) las explicaciones para sobrepasar los problemas fueron satisfactorias.
Was this review helpful? Yes0
 Flag
Rabei Al Khattab profile image
Rabei Al Khattab profile image

Rabei Al Khattab

10/10 starsCompleted
4 years, 8 months ago
I enjoyed the experience I had and content thought in this class. It was well structured and the flow was smooth from one topic to another.
Was this review helpful? Yes0
 Flag
Md. Abdus Sattar Linkon. profile image
Md. Abdus Sattar Linkon. profile image
10/10 starsTaking Now
  • 1 review
  • 0 completed
4 years, 8 months ago
dear mr dany hoter i will be gratfull if u use a simple accent in this course that every one can understand even if he is not fluent in english because not all people not fluent in english.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 8 months ago
Enthusiastic instructor. Learned lots. Only downside is that it would have been useful to have had Excel 2016. 2013 works, but need add-ins.
Was this review helpful? Yes0
 Flag
Miguel Franco profile image
Miguel Franco profile image

Miguel Franco

2/10 starsDropped
4 years, 8 months ago
It shall be wonderful to have this course with the system requirements available for Mac and linux. Not everything is Windows!!!
Was this review helpful? Yes0
 Flag
Ge Jing profile image
Ge Jing profile image

Ge Jing

10/10 starsCompleted
4 years, 8 months ago
Very good course.I learned a lot which don't know before. Especially the power pivot, data model, query, it's good tool, very smart. Thanks for microsoft providing pretty good course. But the cerficate is not quick enough. Hope I will receive the cerficate soon.
Was this review helpful? Yes0
 Flag
Jesus rivera profile image
Jesus rivera profile image

Jesus rivera

10/10 starsCompleted
4 years, 8 months ago
Amazing course great examples and it applies to real work duties you might have to deal with :) i took the course and im glad i did
Was this review helpful? Yes0
 Flag
Francesco Martella profile image
Francesco Martella profile image
10/10 starsCompleted
  • 1 review
  • 1 completed
4 years, 8 months ago
Really amazing, perfectly done even for unexperienced people. The instructor has been extremely professional and claire in all his explications. One regret is to have enrolled too late, after the deadline so I couldn't take the certificate. Thanks
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years, 8 months ago
The course content is actually very beneficial and the fact that it is provided by Microsoft gives you a sense of confidence in this course. Even though the instructor seems quite knowledgeable, he is not very organized and seems to be a bit unprepared.
Was this review helpful? Yes0
 Flag
Myroslav Kolodii profile image
Myroslav Kolodii profile image
10/10 starsCompleted
  • 1 review
  • 1 completed
4 years, 8 months ago
Instructor has a deep knowledge on the subject, and the content helps to understand material easier, providing real work scenarious. As for the provider - it has been one of many courses, which I took in edX, and can leave only positive feedback on that.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsDropped
4 years, 8 months ago
This has been an overall excellent course. I was very pleased with the contents, I have learned a lot, and it is specially satisfactory for me to learn the new capabilities and functionalities of Microsoft Excel 2016, which allows me to be up to date with the latest technology improvements. I recommend it very much.
Was this review helpful? Yes0
 Flag
Luca Adorni profile image
Luca Adorni profile image

Luca Adorni

9/10 starsCompleted
4 years, 8 months ago
I completed the course, it was great, the contents were clear despite in foreign language. Thanks to the Instructor's expertise I was able to discover and explore a new useful tool Edx tools to attend the course were user friendly and reliable.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years, 8 months ago
The instructor is really great, and I love that he is not reading from a teleprompter. The content is good, although a little bit basic even for people with no experience in Excel.
Was this review helpful? Yes0
 Flag
Lucas Cotta profile image
Lucas Cotta profile image
8/10 starsCompleted
  • 1 review
  • 1 completed
4 years, 8 months ago
I did the course but I couldn't finish, because I travelled to China and lost some dues.. Are you guys going to offer the course again? The course was very helpful.. Although I finished, I would love to obtain the certification! Thanks
Was this review helpful? Yes0
 Flag
Vijaya Lakshmi profile image
Vijaya Lakshmi profile image
10/10 starsCompleted
  • 1 review
  • 1 completed
4 years, 8 months ago
My Only suggestion, Danny could smile a bit.:) The course was Awesome! Look foreword to more such courses. Also , please ensure while developing the course that it is relevant also to people in developing world with their existing tools.
Was this review helpful? Yes0
 Flag
Roman Svavolya profile image
Roman Svavolya profile image

Roman Svavolya

9/10 starsCompleted
4 years, 8 months ago
The instructor provided clear instructions using the sample files which are available for students. The course should be very useful for persons who works with finance analysis and data measurement and evaluation.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 8 months ago
Able to get some expertise on excel with this course. It has a detailed information and links to get more information on some features and examples provided by instructor helped me a lot to understand and able to complete all exercises in this course.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 8 months ago
The content was of good quality and instructor was articulate enough. Homework assignments were just repetition of the work shown in videos. Something more difficult should be introduced.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years, 8 months ago
Well presented material about the Business Intelligence features of Excel 2016: - Easy to understand with independence of your previous knwoledge - Good examples in order to reinforce the concepts To say something not so good, I would prefer to go deeper in some concepts, maybe a more advanced course in the future? Thanks for this MOOC
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years, 8 months ago
The course content was very good. Some of the assignments could've been explained in a manner so they would be easier to understand for non native english speakers. The instructor on the other side was very good content wise, however he could've been more enthousiastic. In other words the intructor's presentation/lecturing skills weren't as good as the content. Thoroughly enjoyed this curse for the rest!
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 8 months ago
Excellent Course! The lectures were pretty clear and the exercises pretty challenging. On a whole, Excel for Data Analysis and Visualization, served the purpose to the fullest.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

6/10 starsCompleted
4 years, 8 months ago
I learned various new skills, however the main negative thing I would say is to have more clear, concise presentation videos. Also, tailer the assignments etc to show Excel 2010 methods as at times it was difficult to know what to press, etc. Aside from those two comments, this course was good. Perhaps actual have some data analysis instead of always calculate the revenue for everything.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

4/10 starsCompleted
4 years, 8 months ago
The content of the course was very basic, the assessments were pretty much brainless (you could just repeat what was done in the videos, step by step). I apologise for mentioning it, but the instructor is also not very good. This would not be a problem if the videos were not so long. He does give some good insights sometimes, but better preparation and understanding of the audience would be very much appreciated.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

8/10 starsCompleted
  • 1 review
  • 1 completed
4 years, 8 months ago
Thanks Microsoft for providing such a course, it's my first so the content was very good except that it is for a certain level of excel users, the instructor was accurate focused and well presented. I hope I will attend more courses with you. Thanks
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.