Analyzing and Visualizing Data with Excel

Provided by:
9/10 stars
based on  1852 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
24256 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
1852 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
5 years, 3 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
Mary Okoyo profile image
Mary Okoyo profile image

Mary Okoyo

10/10 starsCompleted
1 month ago
I have really enjoyed learning this course. I have come to learn that MS Excel is quite powerful with data analysis!! I have learnt a lot of pretty new stuff. The course content is great because it gives one a hands-on experience with data analysis in Excel. Howerver, the instructor is not quite impressive. He needs to teach learners at a slower pace. The content provider has done a marvelous job.
Was this review helpful? Yes0
 Flag
John Mwangi profile image
John Mwangi profile image

John Mwangi

10/10 starsTaking Now
1 month, 3 weeks ago
The course is suberb as it equip one with necesary excel skills which I never knew existed. The instructor is perfect in his delivery. I believe I have acquire many helpful skills which I need in my work as well as my learning experience.
Was this review helpful? Yes0
 Flag
Edwin Kamau Mbugua profile image
Edwin Kamau Mbugua profile image

Edwin Kamau Mbugua

10/10 starsCompleted
1 month, 3 weeks ago
I have really enjoyed learning this course of analyzing and visualizing excel data. Excel is really a powerful tool. The content is really great and the instructor and providers have done a really great job preparing it.
Was this review helpful? Yes0
 Flag
Charlotte Shahmani profile image
Charlotte Shahmani profile image

Charlotte Shahmani

6/10 starsTaking Now
4 months ago
This course has added value to me as i am able to understand data analytics better now. The step by step guide made it easier to navigate and keep track of the work completion as well as knowledge gained.
Was this review helpful? Yes0
 Flag
lawrence raj samuvel profile image
lawrence raj samuvel profile image

lawrence raj samuvel

6/10 starsCompleted
4 months, 1 week ago
the course is sufficient for the beginners to start work in a real world.the instructor is good and very clear in explanation,Very complete course about Pivot Tables, Pivot Charts, Data models and Visualization.i have learned alot more than what i know about excel.in this course
Was this review helpful? Yes0
 Flag
Janet Naison profile image
Janet Naison profile image

Janet Naison

10/10 starsCompleted
4 months, 1 week ago
Thank you for a great course. It has widened my knowledge if data visualization. I will be able to work better on my charts and present good visual reports. The instructor was very good and i understood all the aspects that he taught.
Was this review helpful? Yes0
 Flag
Cecilia Torsu profile image
Cecilia Torsu profile image
10/10 starsCompleted
  • 0 reviews
  • 0 completed
4 months, 1 week ago
The course content was educative and informative. It enabled me build upon my knowledge with regards to pivot tables and chart. The instructor was awesome. Thank you Dany Hoter and Microsoft.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 0 reviews
  • 0 completed
4 months, 1 week ago
The content of this course is very informative. I hope to put the knowledge gained to use at work and in general. I found the Power Query the most useful. Reminds me of Web Query which was a feature of Excel in the past.
Was this review helpful? Yes0
 Flag
Manuel Vidal profile image
Manuel Vidal profile image

Manuel Vidal

8/10 starsCompleted
4 months, 2 weeks ago
This introductory course was very informative and introduced me to techniques that could improve my Excel experience and, I'm sure would benefit anyone who I worked for. The course had a good format. I had Excel 2010 and 365 versions, but the technical requirements of the course and lab became a distraction from learning the core topic. This was particularly difficult in Module 4 with Azure.. Quiz questions had it's difficulties, some answers I felt in the right about. This can be attributable to Dany the instructor, who memorably coughed at the last minutes of the last video. In seriousness, it seemed that the wording of questions and terminology (financial terms) could have been better.
Was this review helpful? Yes0
 Flag
MANIMARAN J KUMAR profile image
MANIMARAN J KUMAR profile image

MANIMARAN J KUMAR

10/10 starsTaking Now
4 months, 2 weeks ago
Good 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? Yes0
 Flag
Gonzalo Gomez profile image
Gonzalo Gomez profile image

Gonzalo Gomez

10/10 starsCompleted
4 months, 3 weeks ago
Very good instructor, must be updated the content, but keep it the online courses. more practical examples by download templates to solves and be able to practice
Was this review helpful? Yes0
 Flag
Mohammed Iftekhar profile image
Mohammed Iftekhar profile image
10/10 starsCompleted
  • 0 reviews
  • 0 completed
4 months, 3 weeks ago
It was wonderful never thought that with Excel we can perform these many functions.Thanks to Microsoft Team. Before standing this course, i have little bit knowledge for visualization but after seen, i have a great experience about visualization
Was this review helpful? Yes0
 Flag
Rohit Bhola profile image
Rohit Bhola profile image

Rohit Bhola

10/10 starsCompleted
5 months ago
Very complete course about Pivot Tables, Pivot Charts, Data models and Visualization, I have leant a lot. Thanks to Microsoft Team. Before standing this course, i have little bit knowledge for visualization but after seen, i have a great experience about visualization.
Was this review helpful? Yes0
 Flag
Vishaldeep Agrawal profile image
Vishaldeep Agrawal profile image

Vishaldeep Agrawal

8/10 starsCompleted
5 months ago
I'm utterly amazed by the course. Very useful knowledge. I hope to implement for my job all the capabilities showed along the course. Definitely, I rather recommend this course.
Was this review helpful? Yes0
 Flag
Jaime Corral profile image
Jaime Corral profile image

Jaime Corral

10/10 starsCompleted
5 months ago
I'm utterly amazed by the course. Very useful knowledge. I hope to implement for my job all the capabilities showed along the course. Definitely, I rather recommend this course.
Was this review helpful? Yes0
 Flag
K Masthan Vali profile image
K Masthan Vali profile image

K Masthan Vali

10/10 starsCompleted
5 months, 1 week ago
The Course has given me an opportunity to gain my skills and become a Professional in using the Excel by using Pivot Charts, tables and other functions as well. The Instructor has nicely facilitated in a manner to understand smoothly and enable me to deal the assignments very successfully. Study material was also really good that can be kept for future reference. I'm looking forward to be part of this kind of courses that are associated with Microsoft and Edx.
Was this review helpful? Yes0
 Flag
U Hameed profile image
U Hameed profile image

U Hameed

10/10 starsCompleted
5 months, 1 week ago
Really interactive and great learning experience. Learn and practise made is really fun and challenging at the same time. Explore new areas where I can develop my expertise using these skills. Tutor was good and provided material are really useful.Many Thanks
Was this review helpful? Yes0
 Flag
Sattvik Goel profile image
Sattvik Goel profile image

Sattvik Goel

8/10 starsCompleted
5 months, 2 weeks ago
The course is really interesting and fun to complete. It got a little complicated at some points but taking the first part of this course before helped. The instructor could not have been more competent , proves his knowledge at more than enough points and delivered all the content with great comprehension. The EdX platform was also easy to navigate.
Was this review helpful? Yes0
 Flag
Hendrik profile image
Hendrik profile image

Hendrik

10/10 starsCompleted
5 months, 2 weeks ago
Great course! One of the best online courses I've experience so far. The course slowly explains features and builds on them until you start using relatively advanced functionalities. The presenter was clear and he always kept my attention. Danny discussed some real world examples that I can immediately start using at my place of work. The reason why this course is so good, is because it manages to strike a fantastic balance between teaching theory, doing practicals and using real-world scenarios (headaches that I'm sure most of us have struggled with in the past). I wish I came across this course years ago.
Was this review helpful? Yes0
 Flag
Vignesvaran Krishnamoorthy profile image
Vignesvaran Krishnamoorthy profile image

Vignesvaran Krishnamoorthy

8/10 starsCompleted
5 months, 3 weeks ago
I think this course is really helpful especially for people who wish to gain more knowledge of Excel, particularly in tables, formulas, and visualizations. It is definitely recommended for all the people who are in the corporate world especially for data analyst and market analyst.
Was this review helpful? Yes0
 Flag
Charu Ashini Krishna Rao profile image
Charu Ashini Krishna Rao profile image

Charu Ashini Krishna Rao

10/10 starsCompleted
5 months, 3 weeks ago
The instructor having a very clear instruction and the structure of the model explaining on step by step. This will be very helpful for my career enhancement
Was this review helpful? Yes0
 Flag
Ozgur Celik profile image
Ozgur Celik profile image

Ozgur Celik

10/10 starsCompleted
5 months, 3 weeks ago
I think it's a very helpful course if you are new to excel. DAX functions, pivot table and charts with all the visualization tools it really helped me a lot.
Was this review helpful? Yes0
 Flag
Rogers Kimutai profile image
Rogers Kimutai profile image

Rogers Kimutai

10/10 starsCompleted
6 months ago
Very detailed course on how we can use excel to create reports using pivot tables, pivot charts. I loved the course and i learnt a lot given that i only had a little knowledge on excel. it was awesome.
Was this review helpful? Yes0
 Flag
Nompumelelo Macabela profile image
Nompumelelo Macabela profile image

Nompumelelo Macabela

10/10 starsCompleted
6 months ago
This was a great course, lot of information provided in a very short space of time. I cannot wait to apply this knowledge and improve my reporting. Thank you edX and Microsoft. I am looking forward to more Data Analysis related courses.
Was this review helpful? Yes0
 Flag
Shuli profile image
Shuli profile image

Shuli

8/10 starsCompleted
6 months ago
Not suitable for me. This course is a bit difficult for me as i have no experience and also it's not necessary for me to use it. I just selected wrong course.
Was this review helpful? Yes0
 Flag
Mary Campbell profile image
Mary Campbell profile image

Mary Campbell

8/10 starsCompleted
6 months ago
The course was very good for me and I was able to immediately apply the information I learn to my work environment. Seeing data visualized differently can make a huge difference and have a greater impact on delivery. I would recommend this to anyone who constantly present information that requires greater analysis.
Was this review helpful? Yes0
 Flag
Mike Müller profile image
Mike Müller profile image

Mike Müller

8/10 starsCompleted
6 months, 1 week ago
It was a really good course! I learnt a lot about Pivot Tables, import data from other programs, and also visualization of data. I recommend it! If you don't remember much about tables in Excel I would suggest first to do the Introduction Course in Excel about Visualizing Data. It's great too!
Was this review helpful? Yes0
 Flag
Febin Roy profile image
Febin Roy profile image

Febin Roy

10/10 starsCompleted
6 months, 1 week ago
Thank you, Microsoft for such a wonderful course and Edx for providing me this opportunity. Something that I loved the most was the Lab exercises, these exercises helped to analyze myself where I am and how good I am at this.
Was this review helpful? Yes0
 Flag
Sumiya Malik profile image
Sumiya Malik profile image

Sumiya Malik

10/10 starsCompleted
6 months, 1 week ago
Thank you for this great course where I was able to brush up my knowledge on Excel and learnt new tools and techniques for data analysis and visualization using Data Models, Power Pivot and Power Queries. The course was very organized and easy to understand and the resources were really informative and helpful. Please keep up the great work! Thank you EDX and Mr. Dany and the Microsoft company for this great course where we not only gain knowledge but the lab trainings that helped us in gaining some analytical skills to use in real life. We would really appreciate if you can make the DAT207x course available so that we can learn about the Power BI and its uses in analysis and visualization of data. Thank you !
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.