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

Student

10/10 starsCompleted
4 years ago
Very good course, thank you a lot! I really enjoy it. I did not have any experience with power query and power pivot. Now I can try to use it at my work and do my pivot tables and charts more interactive.
Was this review helpful? Yes0
 Flag
Alexander Ortiz de Latierro profile image
Alexander Ortiz de Latierro profile image
10/10 starsCompleted
  • 1 review
  • 1 completed
4 years ago
The course is very useful. I have learned a lot and installed Excel 2016 on my computer. I am seeing forward to use Power BI. I will tell about my experience to my friends and to my work community.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
first of all. it is an awesome course, i learned a lot from it and from the content as well, just few comments about the instructor that he dealing with the steps of each module very quick but overall he is very good.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
I had a nice time in the course duration. I so much appreciate the instructor who always was able to carry each participate along anytime they need clarification on issues. Thanks a million.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

8/10 starsCompleted
  • 1 review
  • 1 completed
4 years ago
Great Content to learn about Excel & the resources are just apt to get a complete knowledge. Please suggest me some practical assignments so that I don't forget what I have learned.
Was this review helpful? Yes0
 Flag
Jose Aníbal Cárdenas Vera profile image
Jose Aníbal Cárdenas Vera profile image
10/10 starsCompleted
  • 1 review
  • 1 completed
4 years ago
What Microsoft and edX did with this course was awesome! I really had the opportunity to learn very valuable tools. All the exercises and quizzes were optimal for learning reinforcement and the help provided was fast and effective. Thanks a lot!
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
all of three is quite good.good clarity of language. rather than that the sequence of the the course is very interesting and the module provided by them is quite good.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
Amazing course! The teacher has been incredibly clear in explaining the content. This opened a whole new world for me with Excel. Hope to use it soon in my current job and boost my career!
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsTaking Now
4 years ago
Very useful course, well structured content and the self paced format is extremely handy. Learning can be readily applied on my job. Much interested in power BI and the natural language query.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
Informative course Would be good to learn this topic more detailed. The last module.... I don't have copany's account, so didn't manage to try to use Power BI
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
The course was fantastic as it exposed me to features and capabilities that I did not know existed in Excel before. It has demonstrated to me that Excel could be used to do a lot more sophisticated Data Processing and Analysis than I imagined.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
I found the course very useful and the content was good but I think it needs more explanation and more details. Thanks for the course and waiting for more courses Best Regards
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

6/10 starsCompleted
4 years ago
The course dives straight into some gory details in the very first module. The content provider should disclose the need for some pre-work for participants to maximize benefits from these modules. The flow of content could be fine tuned to be lucid. The content flow between modules does not seem very natural.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
The course content was very useful, it gave me new knowledge in data analysis. Big thanks to Mr. Dany Hoter & Microsoft who had given such an easy-to-understand course for a newbie in excel.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
Instructor was good and straight forward in data presentation. Each lesson was just the right amount of time. I like the format - lesson, quiz, lab. The labs really help to check your understanding of the topic and get hands on experience with the data/functions.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
The course covers good basics about Excel Data Model, pivot tables and charts. Easy to follow even if you are new to the concepts, but provides enough knowledge to get going with the tools. It would have like more time on DAX formulas and use, or resources to learn more, even though I'm sure it's easy to find on the Microsoft website.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
The content is well laid out and the lessons are easy to understand and do. Labs is great and overall simple and easy to do. The lectures are easy to understand and the examples are fairly easy to solve and follow.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
The instructor was very good. I really enjoyed learning with him. One thing i want to mention here that i haven't that knowledge of excel even you can say i know nothing about excel except entering data, but after that course i have enough knowledge. It was a pleasant experience and was my first online course too. Thanks for this opportunity.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
I've already spent time filling this in & it didn't save! Video presentation was ok but not polished. Seemed like spent too much time getting to explain the Advanced DAX formulas that ran out of time when finally got to it.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
The topics were a good selection. The exercises were good, but I was frustrated not being able to refresh the data in the module 7 lab. It would've been good to have had more explanation of the advanced DAX functions; seemed like the instructor ran out of time. He was ok, though not very polished in presentation. The Rating stars don't show in IE 11.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 1 review
  • 1 completed
4 years ago
It was simply amazing..i loved the course The excel files proved to be really useful and Mr. Dany Hoter was very clear and crisp The additional features of Excel 2016 definitely help reduce day to day work and enhance viewing experience More courses as such will be really helpful Thank you
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 1 review
  • 1 completed
4 years ago
I really enjoyed the course, it was very beneficial and a good introduction to the new features in Excel 2016. I would like to thank you all for this great work.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
Great Topics, Crisp and Clear. Nice examples to practice. Course will surely leverage the knowledge of using Excel in more faster way and representing it in many ways. I started using more options in Excel which are easier in cleaning the data faster. Power BI is just great feature to represent data with drill down options & easily shareable with multiple prospects.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
Loved the course and the features covered. Some of the lectures were not polished but the information provided was excellent. Very much appreciated the information on DAX formulas and power pivot. Can't wait for my company to begin using Excel 2016.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
the course provider material and management are very good. step by step videos help to understand the course and the instructor explained it very logical and easy way and i learn a lot new things i MS excel.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
Nice, really helped get the feel and the basic blueprint of data analysis. Lab content could be more "problem solving" oriented i.e. additional section for just lab exercises to get the student an end-to-end feel of working with data.
Was this review helpful? Yes0
 Flag
Aakash Saboo profile image
Aakash Saboo profile image
10/10 starsCompleted
  • 1 review
  • 1 completed
4 years, 1 month ago
content is absolutely good! the questions in the quiz actually tests whether you have listened and understood the video or not and the lab exercises are really good to get your hands on what has been taught in the lecture video. some times it was difficult to understand the instructor but that is okay. FoR THE STUDENTS WHO WILL BE OPENING EXCEL FOR THE FIRST TIME THROUGH THIS COURSE: You might not understand anything in the first module but refer to the links provided within the module and have patience and you will be good to go. overall perfect,short videos,apt content,apt lab exercises,apt content for beginners
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 1 month ago
overall good course.Course provide the detailed knowledge about the excel but sometimes I feel that some basic guidance is missing. This course can be enhanced for the freshers, because as a fresher it will be difficult to understand some modules of course.Find this course interesting and looking forward to learn more courses from Microsoft.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 1 review
  • 1 completed
4 years, 1 month ago
This was a fantastic course with content very relevant for those with a prior Excel experience and at least a little background in pivotTables and pivotCharts. The video were concise and the instructor explained the topics clearly and showed relevant examples. The frequent quizzes help make sure that you are on-track, and if not it's easy to go back and review the previous topic. I'm glad I found this course and would highly recommend it!
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

4/10 starsCompleted
4 years, 1 month ago
The subject should have been more in-depth and the Quizzes were pretty simple to answer. There should have been more questions in the quizzes to get more qualified
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.