Analyzing and Visualizing Data with Excel

Provided by:
9/10 stars
based on  1849 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
24049 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
1849 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, 11 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
Charlotte Shahmani profile image
Charlotte Shahmani profile image

Charlotte Shahmani

6/10 starsTaking Now
3 days, 10 hours 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
6 days, 19 hours 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
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
1 week, 1 day 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
1 week, 3 days 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
1 week, 4 days 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
2 weeks, 1 day 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
2 weeks, 5 days 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
2 weeks, 6 days 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
3 weeks, 5 days 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
3 weeks, 5 days 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
3 weeks, 5 days 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
1 month 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
1 month 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
1 month, 1 week 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
1 month, 1 week 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
1 month, 2 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
1 month, 2 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
1 month, 2 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
1 month, 3 weeks 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
2 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
2 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
2 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
2 months 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
2 months 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
2 months 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
Silvana Porcio profile image
Silvana Porcio profile image

Silvana Porcio

10/10 starsCompleted
2 months ago
This is an excellent course, I found it really interesting and very complete. The explanations are very clear. I think it's a good complement for people who already have some knowledge of Excel. On the other hand, for those who don't have an advance level of Excel, I would recommend starting with another kind of course.
Was this review helpful? Yes0
 Flag
Ramy Latif profile image
Ramy Latif profile image

Ramy Latif

8/10 starsCompleted
2 months, 1 week ago
very useful i advice all people how use the excel to take it thanks Microsoft after i have finished this course now i can make a lot of things in Excel now i think i will be more perfect in my job
Was this review helpful? Yes0
 Flag
Chere From Nigeria profile image
Chere From Nigeria profile image

Chere From Nigeria

8/10 starsCompleted
2 months, 1 week ago
Honestly this course is amazing Though I could only afford to audit it, I gained a good skill However, the Instructor was not always explaining well how he was able to create the visuals he got from the data models well enough Many thanks to Microsoft for this Chere from Nigeria
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.