Analyzing and Visualizing Data with Excel

Provided by:
9/10 stars
based on  1642 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
22621 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
1642 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
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
Thanks for this great and helpful course. I just hope to see more course related to business and Microsoft software both, like learning more about excel in business, or other software. Thanks you again. Thank you Dany.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
I think this course is clear and practical that i find very useful to me. Before the course, i have no idea with visualization in excel live pivot table or pivot chart. After this course, i can create diffrent type of chart and play with them. It's fun. I got to learn some special features of Excel 2016 and the power of Power BI. Hope that i can have some experience with it soon. Thank you
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
Overall the course was really good , and the Instructor explained the details needed in a really simple way ,but the problem is that the course is designed for 2016 specially for features like the pivot charts ,and the calendar wasn't helpful and took a lot of time to find ways around it.
Was this review helpful? Yes0
 Flag
Saurabh Yadav profile image
Saurabh Yadav profile image
8/10 starsCompleted
  • 1 review
  • 1 completed
4 years ago
First of all I would like to thank Microsoft for providing this course as it is very much helpful. Also the faculties , the way of explanation all's very good. Good Job by Microsoft .
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
A good knowledgeable course to use the advance functionality of the MS Excel. It was working fine with Excel 2010 with a little difficulty due to the difference in interface of the Instructor.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
The content was right on the money for what i was looking for, to get a better understanding of Pivot Tables. It was good to find out about new features in Excel.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
A really great course and easy to follow, I came in with basic knowledge of Excel and understood almost everything. Many thanks to professed Dany Hoter, The Microsoft and other who were involved in this course.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
It was a great experience, I really enjoy the course and learned a lot of techniques and importante topics in the area of BI. I hope they are more courses in the future like this.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
Great introduction to some features in Excel that I was not previously aware of and definitely will come in handy for creating Pivot tables and charts. Personally, I think it's a fun course because there are more videos showing examples and exercises than there are reading materials.
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.