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
student profile image
student profile image

student

10/10 starsCompleted
1 month, 3 weeks ago
Un curso muy completo y avanzado sobre Modelos de Datos, cómo trabajar con ellos y poder trabajar con los datos para tener un buen análisis de la información.
Was this review helpful? Yes0
 Flag
Andre Tng profile image
Andre Tng profile image

Andre Tng

10/10 starsCompleted
1 month, 4 weeks ago
Clear and detailed course, simple to follow as well. Lab exercises were stimulating and purposeful. I came in knowing nothing about Pivot Tables or data models but now have a good grasp of how to use them for visualisations.
Was this review helpful? Yes0
 Flag
Nur Abdul profile image
Nur Abdul profile image

Nur Abdul

10/10 starsCompleted
1 month, 4 weeks ago
The course very useful and complete for the beginner .Especially on the Pivot, charts. the Exercise is good to try what we have learn from the course. I would recommend the course to others taking one introduction course before (for example, Data Analysis: Take it to the MAX(), from DelftX University, provided also in edX, quite good). Very fruitful content.
Was this review helpful? Yes0
 Flag
Luis Pedro Insua profile image
Luis Pedro Insua profile image

Luis Pedro Insua

10/10 starsCompleted
2 months ago
Excellent course. Great if you already have intermediate or advanced Excel skills. As a sales analyst, it took my abilities to another level. I have already built multiple dashboards and managers are very impressed.
Was this review helpful? Yes0
 Flag
Surbhi Gupta profile image
Surbhi Gupta profile image

Surbhi Gupta

6/10 starsCompleted
2 months ago
the person who teaches is bit slow and and some part are less clear. Rest else was good and i really learnt something new from it. would love to practice it in my professional life and enhance my skills using it more and more. Thank You. Very complete course about Pivot Tables, Pivot Charts, Data models and Visualization
Was this review helpful? Yes0
 Flag
Ola Ade profile image
Ola Ade profile image

Ola Ade

10/10 starsCompleted
2 months ago
Awesome!!!!..now its time to practice more. Had basic functional knowledge in excel prior to the course but now feel a lot more different with valuable content I can speak to anywhere. It sure has opened doors to more learning on Data Analysis.
Was this review helpful? Yes0
 Flag
Taylor Pickup profile image
Taylor Pickup profile image

Taylor Pickup

6/10 starsCompleted
2 months ago
The instructor was great and the material he demonstrated was great. However, there is not enough content here to fully prepare someone for the 70-779 exam. The instructor needs to go into a lot more detail to cover the content that the exam will cover.
Was this review helpful? Yes0
 Flag
Laura Atieno profile image
Laura Atieno profile image

Laura Atieno

10/10 starsTaking Now
2 months, 1 week ago
The course content was amazing. It gave me various ways of using, analyzing and visualizing data in Excel. The Lab lessons also gave me an opportunity to put into practice what I had learned from the videos. The instructor, Dany was amazing in explaining all the various functionalities in Excel. He took his time and took us step by step through the course. Thank you. The provider, EDX, is amazing to give us such a course and it was easy to navigate through the course.
Was this review helpful? Yes0
 Flag
Ayodeji Apampa profile image
Ayodeji Apampa profile image

Ayodeji Apampa

10/10 starsCompleted
2 months, 1 week ago
The content of the course is suited to help gain a better understanding of the Excel tool. Mr Dany Hoyter does a great job to help break down what could have been an otherwise complex course. Thank you edX for providing this opportunity to help upgrade my skills
Was this review helpful? Yes0
 Flag
Samir Mehdiyev profile image
Samir Mehdiyev profile image

Samir Mehdiyev

10/10 starsCompleted
2 months, 1 week ago
The course provides good grounds on the subject of data analyses using Excel. Good starting point for the one who plans to use this MS tool for the purpose.
Was this review helpful? Yes0
 Flag
Luisa Rodriguez profile image
Luisa Rodriguez profile image

Luisa Rodriguez

8/10 starsCompleted
2 months, 1 week ago
The content is good and helpful, a great complement if you already have knowledge. The Instructor explains very clear all the modules. It would be good to have son free quizzes.
Was this review helpful? Yes0
 Flag
Seiban Mohammad profile image
Seiban Mohammad profile image

Seiban Mohammad

10/10 starsCompleted
2 months, 1 week ago
It was great in general. However I have some complaints about two quiz questions: For Module 7 – Quiz 1: I watched the videos and checked the script word by word but didn't see anything about the second option of question 1 . However, (unfortunately after I got it wrong) I checked the link provided for the lecture (which I thought is only for extra information about the topic) and found that the answer was written there. This is really unfair as I got all my previous answers correct and this one was the first one that I couldn't get it right because of this. I think from the very beginning you should have stated that the links are mandatory to study from. Otherwise, we shouldn't be punished for something we thought optional. As for Module 8 – Quiz1: (Question1): In the video, there is no single word about sharing the reports between users using BI. Again, I lost the mark for this question because of such unfair question that contain... It was great in general. However I have some complaints about two quiz questions: For Module 7 – Quiz 1: I watched the videos and checked the script word by word but didn't see anything about the second option of question 1 . However, (unfortunately after I got it wrong) I checked the link provided for the lecture (which I thought is only for extra information about the topic) and found that the answer was written there. This is really unfair as I got all my previous answers correct and this one was the first one that I couldn't get it right because of this. I think from the very beginning you should have stated that the links are mandatory to study from. Otherwise, we shouldn't be punished for something we thought optional. As for Module 8 – Quiz1: (Question1): In the video, there is no single word about sharing the reports between users using BI. Again, I lost the mark for this question because of such unfair question that contains an answer not mentioned in the video Also, I got one option correct (the one was mentioned in the video) but didn't get the score for this question because I had to get two options correct. I'm really disappointed I hope these two questions to be revised and not to deduct marks from me as I got at least the answers/options mentioned in the videos correct. I really aimed to get the full mark in all quizzes and Lab sections but I was frustrated and disappointed by losing two precious scores for the above mentioned reasons.
Was this review helpful? Yes0
 Flag
Rocío Marcalain profile image
Rocío Marcalain profile image

Rocío Marcalain

10/10 starsCompleted
2 months, 1 week ago
Excellent course! I've been using Excel for ages and there are so many functionalities I didn't know about. This course and the previous one have given me many new skills for using pivot tables and charts with much more confidence than before, as well as the data model aspects which I was not so much aware about. The instructor is very clear and didactic. I've very much enjoyed this course and will go on learning about PowerBI. Thank you, Dany!
Was this review helpful? Yes0
 Flag
Jordan profile image
Jordan profile image

Jordan

6/10 starsCompleted
2 months, 1 week ago
If I was Microsoft I would be embarrassed to put my name on a course with this terrible of an instructor and presentation. The course content was not bad, but the teaching was horrendous. The instructor stumbled through half of his sentences, used poor or incorrect grammar continuously, and they even had a very robotic sounding AI (think Stephen Hawking's robot voice) "teach" a couple of videos. I did learn the basics of what I wanted to, but it was not nearly as thorough as I'd hoped. Luckily my company paid for me to take this course, but I would be mad if I spent my own money on this bad of a course.
Was this review helpful? Yes0
 Flag
Soya Naidu profile image
Soya Naidu profile image

Soya Naidu

10/10 starsCompleted
2 months, 1 week ago
The course content was excellent, especially if used in the business environment. The procedures can easily be manipulated for other faculties. Dany, at times rushed through the steps & this made the couse a bit daunting. However, after reviewing the videos a few times the explanations& steps became easier to understand & implement.
Was this review helpful? Yes0
 Flag
Fernando Foronda Sancho profile image
Fernando Foronda Sancho profile image

Fernando Foronda Sancho

10/10 starsCompleted
2 months, 1 week ago
Very complete course. I really recommend to take the previous introduction course just as a refresh. Danny is great as a instructor. He speaks very clear and in detail without being overwhelmed. In my opinion, you have tu pay for the certificate is you really want learn. I took the introduction without certificate, but I can't imagine how less I would learn in this course if couldn't do the exercise, quizzes and labs.
Was this review helpful? Yes0
 Flag
Erik Haslev profile image
Erik Haslev profile image

Erik Haslev

10/10 starsCompleted
2 months, 1 week ago
It was very clear and to the point instructions and visualization of how to use the solutions. He understands exactly what my questions and needs are and address them right on. Very interesting and valuable. Thanks.
Was this review helpful? Yes0
 Flag
Harshada Tapale profile image
Harshada Tapale profile image

Harshada Tapale

10/10 starsCompleted
2 months, 1 week ago
It was really good . I learned allot from this my excel knowledge was not so good earlier but now by this course i can definitly say i can do now. 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? Yes0
 Flag
Camilo Reyes profile image
Camilo Reyes profile image
10/10 stars
  • 0 reviews
  • 0 completed
2 months, 2 weeks ago
Good step by step and examples. It would be great to be able to check on the progress and answers of the quizzes when the course is done in audit mode
Was this review helpful? Yes0
 Flag
Juan Lopez profile image
Juan Lopez profile image

Juan Lopez

10/10 starsCompleted
2 months, 2 weeks ago
Very complete. Each topic explained in a general but interesting way which encourage us to continue learning more. Very clear and easy to learn. Thanks a lot
Was this review helpful? Yes0
 Flag
Mayursinh Rana profile image
Mayursinh Rana profile image

Mayursinh Rana

6/10 starsCompleted
2 months, 2 weeks ago
This Course is useful But I think, In Content more Hyperlink is there and feel like Boaring.In course, get the knowledge of Excel Function like power pivot,Power Query,Data Model etc.
Was this review helpful? Yes0
 Flag
ANUP GEDIYA profile image
ANUP GEDIYA profile image

ANUP GEDIYA

8/10 starsCompleted
2 months, 2 weeks ago
Course very helpful to touch the new horizon and understanding the detail concept of EXCEL data handling by using the features like Power Pivot, Power query, Data Model etc.
Was this review helpful? Yes0
 Flag
Thanigaivel MANIKANNAN profile image
Thanigaivel MANIKANNAN profile image

Thanigaivel MANIKANNAN

10/10 starsCompleted
2 months, 3 weeks ago
Very good course for Power Pivot, data import and pivot table features. Has required content and Lab exercises. Highly recommended for those interested to learn about Power Pivot and Excel Data Model
Was this review helpful? Yes0
 Flag
Sara profile image
Sara profile image

Sara

8/10 starsCompleted
2 months, 3 weeks ago
This course helped me to learn more about analyzing and visualizing data in Excel. The course was well-paced and I appreciated the step-by-step model that the instructor followed. I had relatively basic knowledge of the material and was able to follow along. would have enjoyed a few more labs/real world scenarios to practice my new skills, but I guess that's what my job is for?! Thanks to all for the experience!
Was this review helpful? Yes0
 Flag
Konyegwachie Chukwuma profile image
Konyegwachie Chukwuma profile image
10/10 starsCompleted
  • 2 reviews
  • 2 completed
2 months, 3 weeks ago
The course was a big eye-opener into data modeling, power query, pivot tables, and lots more. I never knew Excel could do so much and much more. I would recommend this course for anyone that wants to further his/her knowledge of Data Analysis. Thankyou Dany so much and Thankyou Microsoft.
Was this review helpful? Yes0
 Flag
Akash Kolge profile image
Akash Kolge profile image

Akash Kolge

8/10 starsCompleted
2 months, 3 weeks ago
It was very helpful although i am a beginner i was able to understand and learn much from it. The contents provided were new to me and difficult to grasp all of it, but it was understandable.
Was this review helpful? Yes0
 Flag
Akash Kolge profile image
Akash Kolge profile image

Akash Kolge

8/10 starsCompleted
2 months, 3 weeks ago
It was very helpful although i am a beginner i was able to understand and learn much from it. The contents provided were new to me and difficult to grasp all of it, but it was understandable.
Was this review helpful? Yes0
 Flag
PARTH PATEL profile image
PARTH PATEL profile image

PARTH PATEL

8/10 starsCompleted
2 months, 3 weeks ago
It was a very useful experience for upgrading self knowledge and learn advance technologies required in day today's continuous upgrading world. As excel is the must required for presenting reports and file
Was this review helpful? Yes0
 Flag
Maryam Junaid profile image
Maryam Junaid profile image

Maryam Junaid

8/10 starsCompleted
2 months, 3 weeks ago
perhaps add more theory for the DAX formulas etc however there are a lot of helpful aspects such as the visualization of data using reports and dashboards etc.
Was this review helpful? Yes0
 Flag
Wu Derek profile image
Wu Derek profile image

Wu Derek

8/10 starsCompleted
2 months, 3 weeks ago
very helpful course. Let me learn more about how to analyze and visual data with Excel. I need to learn it and apply to my job. I spend a lot of time to collect and analyze data to present third party logistics performance. These tools can help me to work more efficiency. 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.