Analyzing and Visualizing Data with Excel

Provided by:
9/10 stars
based on  1624 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
22460 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
1624 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
3 years, 10 months ago
Very complete 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). If not, maybe I would recommend taking one introduction course before (for example, Data Analysis: Take it to the MAX(), from DelftX University, provided also in edX, quite good).
Was this review helpful? Yes4
 Flag
Gabriel Rocha profile image
Gabriel Rocha profile image

Gabriel Rocha

10/10 starsCompleted
14 hours ago
Very good course!! All the videos and the exercises are of excellent quality. It's difficult to find a material so rich in details even just being a fast course
Was this review helpful? Yes0
 Flag
Travis profile image
Travis profile image

Travis

10/10 starsCompleted
3 days, 17 hours ago
Great next step if you have some experience working with Excel, as it dives further into the data model, functions/formulas, and visualization. The Power BI piece at the end isn't necessarily enough to be useful, but it's good to know how to connect data to Power BI.
Was this review helpful? Yes0
 Flag
Huynh Truc Van Phan profile image
Huynh Truc Van Phan profile image

Huynh Truc Van Phan

10/10 starsCompleted
5 days, 10 hours ago
The course was really nice and interesting. It provided me the knowledge that I did not know before, especially with the DEX language, the Power Query and Power BI. It was a bit ashamed because Excel 2016 on Mac OS could not provide the full utilities so I always have to use VMWare from my university to practice Excel. In sum, the course was nice with good practice.
Was this review helpful? Yes0
 Flag
Triantafyllos Tsouplakis profile image
Triantafyllos Tsouplakis profile image

Triantafyllos Tsouplakis

10/10 starsCompleted
6 days, 4 hours ago
Very interesting course. It helped me to use easily the Pivot tables and especially the Power query when importing a file (edit it before using it). The only problem encountered, was that I was using excel 2013 and it was a little bit difficult in the beginning to find where some options resided.
Was this review helpful? Yes0
 Flag
Rick Snuyder profile image
Rick Snuyder profile image

Rick Snuyder

10/10 starsCompleted
6 days, 12 hours ago
There were time when I had to stop the video and back it up a little so I could study what the instructor was doing. An eBook for the course would have been helpful also. I did have some difficulty getting a Cube function to work because in following the instructor he called out "Manufacturer" But as I was following along I was getting "ManufacturerID" in the same table.
Was this review helpful? Yes0
 Flag
Marilize van Zyl profile image
Marilize van Zyl profile image

Marilize van Zyl

10/10 starsCompleted
1 week ago
Great course enjoyed it very much. This is definitely going to help me in my profession. I would recommend you take this course if you have some knowledge of Excel already.
Was this review helpful? Yes0
 Flag
Mohamed Ayman profile image
Mohamed Ayman profile image

Mohamed Ayman

6/10 starsCompleted
1 week, 2 days ago
I did the Introduction to Data Analysis using Excel part of the certificate before this one and i expected more from this course. Also, A few questions were a bit confusing and it was difficult to determine exacting what the correct answer would be. read less
Was this review helpful? Yes0
 Flag
Therese profile image
Therese profile image

Therese

8/10 starsCompleted
1 week, 3 days ago
Excellent course. Indepth instruction in power query including pivot tables, pivot charts, and slicers. A few questions were a bit confusing and it was difficult to determine exacting what the correct answer would be.
Was this review helpful? Yes0
 Flag
saidu abubakar profile image
saidu abubakar profile image
10/10 starsCompleted
  • 0 reviews
  • 0 completed
1 week, 5 days ago
The course content can be safe explained owing to the way it was design by the instructor and i believe in future many others will still like to join this moving train of success. The instructor were excellent in delivering their lectures and we really appreciate their effort towards developing the young generation.
Was this review helpful? Yes0
 Flag
suwadu robert silubonde profile image
suwadu robert silubonde profile image

suwadu robert silubonde

10/10 starsCompleted
1 week, 5 days ago
The course content was very rich in detail, Dany delivered the subject in a very clear and concise manner. I look forward to other Microsoft courses. Thank you very much for the education!
Was this review helpful? Yes0
 Flag
Marvin Menjivar profile image
Marvin Menjivar profile image

Marvin Menjivar

10/10 starsCompleted
2 weeks, 2 days ago
Great explanation and content!.. It gives an overview of can be done with excel data model.. a great tool that it's similar to Power BI but with expanded capabilities
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

6/10 starsCompleted
3 weeks ago
Quite good with lots of demos and practices. Very complete 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)
Was this review helpful? Yes0
 Flag
Gustavo Bernardini profile image
Gustavo Bernardini profile image

Gustavo Bernardini

10/10 starsCompleted
3 weeks ago
Was excelent, the content, instructor and EDX Platform. Congratulations to Microsoft and EDX, it is a wonderfull iniciative to make available a lot of knowledge that was impossible to find easly before
Was this review helpful? Yes0
 Flag
Joanna Salisbury profile image
Joanna Salisbury profile image

Joanna Salisbury

10/10 starsCompleted
3 weeks, 4 days ago
Easy to understand and follow with videos, text and further information, as well as lab exercises that lets you put into practice what you have just learned.
Was this review helpful? Yes0
 Flag
Светлана Солдатова profile image
Светлана Солдатова profile image
10/10 starsCompleted
  • 0 reviews
  • 0 completed
1 month ago
Very useful and well structured course. Al the information is explained in plain language. There are a lot of examples/screenshots that help to understand the material.Thank you very much!
Was this review helpful? Yes0
 Flag
Luis Palma profile image
Luis Palma profile image

Luis Palma

10/10 starsCompleted
1 month, 1 week ago
Well organized with enough content for Excel users at any level. The sample files are easy to understand and with enough data to complete as many exercise as possible. I liked the introduction to Cubes and Power BI
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
1 month, 1 week ago
I felt the instructor needed to be more organized in the way he presented the content. He would be explaining thing "B", and then he would go back to thing "A" because he had not mentioned something. It happened more than once during the course.
Was this review helpful? Yes0
 Flag
Mainak Ch profile image
Mainak Ch profile image

Mainak Ch

10/10 starsCompleted
1 month, 1 week ago
Really informative course. I had some prior knowledge of excel and this was indeed a great value addition to my knowledge, looking forward to more such courses.
Was this review helpful? Yes0
 Flag
Okey Udo profile image
Okey Udo profile image

Okey Udo

8/10 starsCompleted
1 month, 2 weeks ago
This was a very insightful journey. I have used Microsoft Excel as part of my work tool for over 15 years, but my knowledge of the capabilities of Excel has never been challenged as it was in this course. Kudos to the team that put this course together.
Was this review helpful? Yes0
 Flag
Romain Conti profile image
Romain Conti profile image

Romain Conti

10/10 starsCompleted
1 month, 2 weeks ago
This class is really interesting to discover the broad options that Excel can provide you. You would not learn how to create reports but how to interpret it.
Was this review helpful? Yes0
 Flag
Zachary Gibbs profile image
Zachary Gibbs profile image

Zachary Gibbs

10/10 starsCompleted
1 month, 2 weeks ago
Danny Hoter knows his stuff about the excel environment. This course should be thought best as a intro to excel queries, with a virtual instructor to show you the different advanced functions that are available. You got to remember that Bibles are written about this stuff, and you can get lost in the sea of knowledge. This course touches on data model, queries, measures, and data visualizations which is the next step towards true power computing. This class would be better if an accompanying pdf was provided with resources provided by module. Not requesting a book, but a 5-10 pg pdf of resources where student could jump off the excel cliff with another point of references as the next steps are Cube functions, Data layout, vba functions DAX architecture.
Was this review helpful? Yes0
 Flag
Michael McMillen profile image
Michael McMillen profile image

Michael McMillen

6/10 starsCompleted
1 month, 4 weeks ago
The course provides a great introduction to queries, the excel data model and visualizations. It would be nice to have labs where all of this knowledge is applied to answer questions. Exercises similar to the last lab, but with the starting point being a collection of raw data, and maybe some snapshots and links to reference articles at most as hints. I feel like there needs to be a bit more room for experimentation and collaboration.
Was this review helpful? Yes0
 Flag
Sriram Sridharan profile image
Sriram Sridharan profile image

Sriram Sridharan

10/10 starsCompleted
1 month, 4 weeks ago
Course content is very useful for some one who is using excel for analysis & visualization. Course content was good. One suggestion would be to provide more lab exercises to ensure we become more thorough.
Was this review helpful? Yes0
 Flag
Elvis Leo profile image
Elvis Leo profile image
10/10 starsCompleted
  • 0 reviews
  • 0 completed
2 months ago
Excellent content and provision. The instructor was the best i have ever had in all the online courses i have pursued. The course was very educative and i request that you continue to do the same in every other module you provide. I also request that you prepare a course on excel functions and applicability independent of any other course. It will be very important for us. thank you
Was this review helpful? Yes0
 Flag
Ijeoma Davida profile image
Ijeoma Davida profile image

Ijeoma Davida

8/10 starsCompleted
2 months ago
The instructor is exceptional and the content is great. However, I have Excel 2019, and couldn't do the lab in Module 4 very well using Excel 2016 instructions in the lab. Also, Module 5 lab ( the DAX functions lab) was impossible to do with Excel 2019, hence, I couldn't do Lab 7
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
2 months ago
Overall a very strong course for those looking to get familiar with Excel's capabilities of Analyzing and Visualizing data. There were a few sections that were pure informational and no hands on learning but given the purpose of the course overall it met the objectives and the best part its FREE!!!!
Was this review helpful? Yes0
 Flag
Vishnu Sagar profile image
Vishnu Sagar profile image
10/10 starsCompleted
  • 0 reviews
  • 0 completed
2 months, 1 week ago
The content, explanations and labs are detailed and well drafted in a way a layman could understand. As for the delivery goes, I think the instructor is not so good at communicating his expert knowledge. It was more of a dull presentation.
Was this review helpful? Yes0
 Flag
David Jagtman profile image
David Jagtman profile image

David Jagtman

10/10 starsCompleted
2 months, 1 week ago
Good course that has radically improved my understanding of PowerPivot and Query editor within Excel and hence my overall understanding of the capabilities of Excel. The course instructor was clearly very knowledgeable and was so kind to often explain multiple ways to get to the same result. The only feedback I could give is that the instructor occassionally had some long breaks in his speaking, spoke in convoluted sentences or was surprised by one of his actions. Perhaps he could still work on improving his delivery. His voice was pleasant to listen to and he made a positive impression overall though.
Was this review helpful? Yes0
 Flag
Arun Smuel profile image
Arun Smuel profile image

Arun Smuel

8/10 starsCompleted
2 months, 1 week ago
The course was great, but i believe the instructor could be more clear on the delivery of the material. He was extremely knowledgeable but his delivery of the material could be greatly improved. Cheers!
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.