Analyzing and Visualizing Data with Excel

Provided by:
9/10 stars
based on  1812 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
23843 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
1812 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
Ioannis Palierakis profile image
Ioannis Palierakis profile image

Ioannis Palierakis

10/10 starsCompleted
3 months, 2 weeks ago
Completely and relatively easy for someone who already has experience and expertise in software. Interesting stuff concerning Power Pivots & Data Models. I will cerntenly think to take more courses both from @Microsoft & @edX !!!
Was this review helpful? Yes0
 Flag
Emmanuel Onyije profile image
Emmanuel Onyije profile image

Emmanuel Onyije

10/10 starsCompleted
3 months, 2 weeks ago
Course content and provider is okay but as a beginner it was hard. Teaching beginners and student with knowledge i believe should have a different approach. Video seems to be a bit longer than excepted sometimes. It can be in bits
Was this review helpful? Yes0
 Flag
Alina Shrestha profile image
Alina Shrestha profile image

Alina Shrestha

8/10 starsCompleted
3 months, 2 weeks ago
The content of the course is really great. I enjoyed the learning process through the lab work. Discussion section is very active and helpful to understand the course.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 0 reviews
  • 0 completed
3 months, 2 weeks ago
Excellent way to learn about Excel and its capabilities in reporting and doing analyzing. DEX is one of the powerful knowledge to have when working with Excel which will help in getting more advanced calculation in pivot. The way the course is structured is not very intense which learners will be able to take it on the weekends or after work and still finish the course with ease.
Was this review helpful? Yes0
 Flag
Tariq Aljanady profile image
Tariq Aljanady profile image

Tariq Aljanady

10/10 starsCompleted
3 months, 2 weeks ago
Outstanding course from all of its part quality of video , professional instructor and great variety of exercise. The more things also that the excel scenario was logic any one can understand which motivate me do my best to solve be excel.
Was this review helpful? Yes0
 Flag
Deep Singh Rawat profile image
Deep Singh Rawat profile image
6/10 starsCompleted
  • 0 reviews
  • 0 completed
3 months, 2 weeks ago
Wow...this course reveals that how powerful Excel is becoming with amazing features. There are other software for business data analysis but Excel is going to be here for long. The power pivot, power view features in Excel and Power BI has come at the time when Excel was pointed to have shortcoming to handle millions of rows of data. Course taught by MVPs are more interesting than folks from Microsoft itself. Thank you edx and instructor for your efforts.
Was this review helpful? Yes0
 Flag
Enric Boira profile image
Enric Boira profile image

Enric Boira

10/10 starsCompleted
3 months, 3 weeks ago
It's been a great course to have a good general knowledge about very useful power tools in Excel, so that you can start working with them. It was a very good complement to my initial very basic knowledge!
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
3 months, 3 weeks ago
It was really wonderful experience, and special thanks to Microsoft team and edx platform to arrange such informative course. In depth explanation of different functions and usage of power pivot have made my life more easier than before.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

8/10 starsCompleted
3 months, 3 weeks ago
Good course. I wish you'd allow auditors to take the quizzes and also give some values as correct answers to ensure my models and analysis were correct. Need a reasonable knowledge to begin- I was expecting a bit of a gentler introduction.
Was this review helpful? Yes0
 Flag
Alireza Al profile image
Alireza Al profile image

Alireza Al

10/10 starsCompleted
3 months, 3 weeks ago
well organized, complete package for those want to dive data analytics reports.it is really helpful and thoroughly recommended before starting Power BI.
Was this review helpful? Yes0
 Flag
Jurges profile image
Jurges profile image

Jurges

10/10 starsCompleted
3 months, 3 weeks ago
It was really interesting and it had a lot of information that was related to real-life problems especially when it comes to Dax formulas. Also, the instructor gave the information in a clear way and it was easy to understand but if you had already some prior knowledge otherwise would be a little bit difficult.
Was this review helpful? Yes0
 Flag
Nicolas Machuca profile image
Nicolas Machuca profile image
8/10 starsCompleted
  • 0 reviews
  • 0 completed
3 months, 3 weeks ago
Very interestings tools. I recomended the course 100%. Personally the tought part was the one when you should upload the data from different sources and from SQL data base cause at the begging i couldn't sign in, fourtunetly i could and after that i could finished the section. Thanks for the course.
Was this review helpful? Yes0
 Flag
Bryanna Dickson profile image
Bryanna Dickson profile image

Bryanna Dickson

10/10 starsCompleted
3 months, 3 weeks ago
As someone looking to explore more advanced functions of Excel, this course provided me a sense of direction and exposure to several key topics without being overwhelming. I'd recommend to anyone who does a lot of reporting or is interested in learning more about data analysis without getting into heavy programming. Overall, very fun and useful course!
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

8/10 starsCompleted
3 months, 3 weeks ago
I think the instructor explained clearly which helps me to understand the content. I would recommend this course especially for those who are seeking jobs that require the use of excel. It's so much fun to learn through the labs :)
Was this review helpful? Yes0
 Flag
Adriano Lira da Silva profile image
Adriano Lira da Silva profile image

Adriano Lira da Silva

10/10 starsCompleted
3 months, 3 weeks ago
I really recommend this course. It is a very good complement if you already have some knowledge of Excel with tables and formulas. Very complete course about Pivot Tables, Pivot Charts, Data models and Visualization. Thank you edX for this course.
Was this review helpful? Yes0
 Flag
Vikas Kapoor profile image
Vikas Kapoor profile image

Vikas Kapoor

10/10 starsCompleted
3 months, 4 weeks ago
It's great. It gives you great knowledge about visualization and it's my first online course and I have a great experience with his online course. Great one should go for it.
Was this review helpful? Yes0
 Flag
Inigo Dader profile image
Inigo Dader profile image

Inigo Dader

6/10 starsCompleted
3 months, 4 weeks ago
Probably ok if you do not pay for it. I have paid the price to have access to whole content of the course as well as to have the final certificate, but I am quite disappointed. This course is focus on showing what buttons to click in order to use really basic DAX, Pivots and Data Model, but in most of the modules it does not explain the reasoning of the software behind. For that price I would have expected that. On top of that it is much more enriching to have this type of course with two instructors having discussions rather than only one presenting (see the one on Transact SQL as example)
Was this review helpful? Yes0
 Flag
Dennis Dida profile image
Dennis Dida profile image

Dennis Dida

10/10 starsCompleted
3 months, 4 weeks ago
The content was well covered, especially the the models.The instructor knows his content and use the command to instruct perfectly. I will highly recommend him to extend on DAX.
Was this review helpful? Yes0
 Flag
Felix Ajao profile image
Felix Ajao profile image

Felix Ajao

8/10 starsCompleted
3 months, 4 weeks ago
It is insightful but the instructions need to be clear for lab exercises and excel dataset alternatives. Completed the course about Pivot Tables, Pivot Charts, Data models and Visualization. It is a good complement if you already have some knowledge of Excel (tables, formulas). Highly recommended for beginners and professionals. Great work
Was this review helpful? Yes0
 Flag
TEJAS S profile image
TEJAS S profile image

TEJAS S

8/10 starsCompleted
3 months, 4 weeks ago
Good course which helped me improve my knowledge of MS Excel. All the content were very good. I did not had any idea about pivot charts and pivot tables but now I have learnt about them. Overall, the course was very much interesting.
Was this review helpful? Yes0
 Flag
Ayodeji Ayeni profile image
Ayodeji Ayeni profile image

Ayodeji Ayeni

8/10 starsCompleted
3 months, 4 weeks ago
Interesting course content. I like the Lab questions as they are require you to understand the videos. I expect a bit more on power BI and SQL. I also would like to learn more about DAX and Max.
Was this review helpful? Yes0
 Flag
CARLOS ORTEGA JIMENEZ profile image
CARLOS ORTEGA JIMENEZ profile image

CARLOS ORTEGA JIMENEZ

10/10 starsCompleted
4 months ago
Very useful course to introduce the EXCEL DATA MODEL and the way of working useful to get advantage of it. Thanks . The examples used in the labs are very useful as templates for reference in case you need to apply the knowledge later and to secure the right appliance. The references provided by the course are also very interesting to expand the knowledge. THANKS
Was this review helpful? Yes0
 Flag
Erwin Welbergen profile image
Erwin Welbergen profile image

Erwin Welbergen

10/10 starsCompleted
4 months ago
Very clear content, well built up, as a 'novice' to Power Query and Power pivots I had no problem keeping up and answering most quizz questions correctly. The host has a very pleasant en patient way of delivering the material. I particularly like the 'natural feel' of the course. As a basis for follow up courses I will surely continue with it. I actually enrolled to solve a few problems I had with making reports for a company, and I am now confident I can solve these problems with what I have learned.
Was this review helpful? Yes0
 Flag
Kevin Holston profile image
Kevin Holston profile image

Kevin Holston

10/10 starsCompleted
4 months, 1 week ago
I enjoyed the course and learned more about features/functionality (Pivot tables, pivot charts, slicers), data models and DAX. I liked Mr. Dany Hoter as an instructor.
Was this review helpful? Yes0
 Flag
Olusegun Oladejo profile image
Olusegun Oladejo profile image

Olusegun Oladejo

10/10 starsCompleted
4 months, 1 week ago
A very complete and comprehensive course, easy to learn and follow as well. Mr. Dany Hoter was a good presenter and the Lab environment was seamless and conducive for learning. Great job for those who put these resources together.
Was this review helpful? Yes0
 Flag
JIN SUNG CHOI profile image
JIN SUNG CHOI profile image

JIN SUNG CHOI

8/10 starsCompleted
4 months, 1 week ago
I had seen Pivot table from someone, however I had poor knowledge of Pivot table before taking this course "Analyzing and Visualizing Data with Excel"
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

8/10 starsCompleted
4 months, 1 week ago
This course is highly recommended for beginners and people with basic Excel knowledge and provides useful tools to upgrade your Excel reports. I did not know Power Query and Power Pivot before, and they can really make your life easier.
Was this review helpful? Yes0
 Flag
Azizbek Mamajonov profile image
Azizbek Mamajonov profile image

Azizbek Mamajonov

8/10 starsCompleted
4 months, 1 week ago
I have learnt a lot from this course. It was useful for me in terms of structuring data and its visualizing. Also, there were some parts which were not clearly explained in detail. Overall I have acquired a lot of essential skills in working with Excell.
Was this review helpful? Yes0
 Flag
Satyam Tripathi profile image
Satyam Tripathi profile image

Satyam Tripathi

10/10 starsCompleted
4 months, 1 week ago
Attending this course was a seamless experience for me. Although I am new to data analysis, but learning got easier because of the way this course was delivered.
Was this review helpful? Yes0
 Flag
Satyam Tripathi profile image
Satyam Tripathi profile image

Satyam Tripathi

10/10 starsCompleted
4 months, 1 week ago
Attending this course was a seamless experience for me. Although I am new to data analysis, but learning got easier because of the way this course was delivered.
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.