Analyzing and Visualizing Data with Excel

Provided by:
9/10 stars
based on  1855 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
24287 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
1855 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
Mike Müller profile image
Mike Müller profile image

Mike Müller

8/10 starsCompleted
7 months, 2 weeks 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
7 months, 2 weeks 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
7 months, 2 weeks 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
7 months, 2 weeks 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
7 months, 3 weeks 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
7 months, 3 weeks 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
Taarshini Neelamoghan profile image
Taarshini Neelamoghan profile image

Taarshini Neelamoghan

10/10 starsTaking Now
7 months, 3 weeks ago
I am able to learn excel in details. ery 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? Yes0
 Flag
Tauseef Khan profile image
Tauseef Khan profile image

Tauseef Khan

8/10 starsCompleted
7 months, 3 weeks ago
Its good and clear..!! I feel very good because I learned new things in a very sophisticated way in excel and enjoy the videos with good clarity. Material also good
Was this review helpful? Yes0
 Flag
Rudy Figueroa profile image
Rudy Figueroa profile image

Rudy Figueroa

10/10 starsCompleted
7 months, 3 weeks ago
I think that this course is very useful, I feel very happy because I learned new things in a very sophisticated way in excel, this new knowledge will help me in my work, definitely I enjoy all the videos and material presented.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

8/10 starsCompleted
  • 0 reviews
  • 0 completed
7 months, 4 weeks ago
It would be more helpful, if the Course content provide instructions for excel 2010 and 2013 rather than using 2016. However i gained some knowledge which i never known about Excel.
Was this review helpful? Yes0
 Flag
Damien Lim profile image
Damien Lim profile image

Damien Lim

8/10 starsTaking Now
8 months ago
I think the content should provide instructions for excel 2010 and 2013 because steps provided for excel 2016 does not necessarily mean 2010 and 2013 provide the same, hence users might not experience the proper and full course structure. Overall, I still gained new knowledge about Excel that I've never known.
Was this review helpful? Yes0
 Flag
Nadeeka Muthumali profile image
Nadeeka Muthumali profile image

Nadeeka Muthumali

10/10 starsCompleted
8 months ago
First time I got to know about the power pivot and table formulas(DAX).To become familiar with the content I have to practice it more where this course provided me the foundation for that.
Was this review helpful? Yes0
 Flag
Joy Mokalo profile image
Joy Mokalo profile image

Joy Mokalo

8/10 starsCompleted
8 months ago
It was really insightful and interesting. i learnt new things in Excel (Data Model, Pivot Table and Charts, Slicers, Measures, a little DAX). To become really familiar with this a lot of practice has to be done and this course gives you the foundation that you need.
Was this review helpful? Yes0
 Flag
Jessica Arreola profile image
Jessica Arreola profile image

Jessica Arreola

8/10 starsCompleted
8 months ago
It was pretty difficult to do the exercises because many times the information was not clear as well as the intructions and there were times I could not do the exercises needed because my computer had the 32-bit version and not the 64-bit version. The content is good but you should have basic knowledge on Excel before taking it.
Was this review helpful? Yes0
 Flag
Bernardo Requena profile image
Bernardo Requena profile image

Bernardo Requena

10/10 starsCompleted
8 months, 1 week ago
Very useful course! The videos and labs were very interesting and I improved my knowledge of Excel. I consider myself an advanced Excel user but I didn't know so much about PowerQuery, PowerPivot and PowerBi.
Was this review helpful? Yes0
 Flag
Rosemary Wolf profile image
Rosemary Wolf profile image

Rosemary Wolf

10/10 starsCompleted
8 months, 1 week ago
The instructor did not explain what we were learning at the beginning of the lecture. He only summarized it at the end. Also, I had absolutely no way of completing the Lab in Module 4, not even with the extra guidance. I could not get past the firewall for the SQL server at all which seriously impacted my grade.
Was this review helpful? Yes0
 Flag
Yehuda Demayo profile image
Yehuda Demayo profile image

Yehuda Demayo

10/10 starsCompleted
8 months, 2 weeks ago
Course was good. It should have gone deeper and have more exercises on developing a data models and importing data from other sources. Also more example of DAX usage would have been welcome.
Was this review helpful? Yes0
 Flag
Divjyot Sethi profile image
Divjyot Sethi profile image

Divjyot Sethi

8/10 starsCompleted
8 months, 2 weeks ago
Course content gives good insights on Data Models, Pivot Tables, Pivot Charts, and Visualisation. The instructor explained it practically in Excel using hypothetical data from a company. I would recommend taking this course if you have basic knowledge in Excel as this will facilitate you in any kind of job role.
Was this review helpful? Yes0
 Flag
Vijay Gaikwad profile image
Vijay Gaikwad profile image

Vijay Gaikwad

10/10 starsCompleted
8 months, 2 weeks ago
Excellent course content and covered most of the useful industrial tools in Excel. 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
 profile image
 profile image

8/10 starsCompleted
  • 0 reviews
  • 0 completed
8 months, 2 weeks ago
hi it was a good course which I learnt a lot. but I need to trview it again to learn more deeply. unfortunatley I did not access to quizes. o it would be more helpful to give access to the whole materials like quizes and so on. in this situation evey one learn more but those who need a verified certificate could pay for it.
Was this review helpful? Yes0
 Flag
Linxuan Han profile image
Linxuan Han profile image

Linxuan Han

10/10 starsCompleted
8 months, 3 weeks ago
The course is really useful, and shows many function of Pivot chart, Query, database... Though it took me a lot of time to finish it and still have some confuse, I learnt a lot. Hope I could practice more in the future during the work.
Was this review helpful? Yes0
 Flag
Anuj Mishra profile image
Anuj Mishra profile image

Anuj Mishra

10/10 starsCompleted
8 months, 3 weeks ago
This course has a great range of content and the instructor is great. He explained each and every modules very easily and in a well presented manner. Now analyzing and visualizing data have become more easier for me.
Was this review helpful? Yes0
 Flag
Walter Chan profile image
Walter Chan profile image

Walter Chan

10/10 starsCompleted
8 months, 4 weeks ago
Video and exercise example help me to understand clearly. Content and example are good to me. Even though I do not have Excel 2016, video can help me a lot on understand features. Video
Was this review helpful? Yes0
 Flag
Mohamed Sameer profile image
Mohamed Sameer profile image

Mohamed Sameer

10/10 starsCompleted
8 months, 4 weeks ago
Content and Example is so good. The instructor taught well too but expected a little more detail. After doing this course, I really understood how powerful the excel is. Must do course who manages financings.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

8/10 starsCompleted
8 months, 4 weeks ago
Good course for the fundamentals and will definitely put you in the right path to become skilled in Excel. It is a good starting point to delve into the more advanced and technical aspects of Excel.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
9 months, 1 week ago
Course provides a good understanding of Data models and Visualization. The quiz & practical learning allows individuals to practice the lecture understanding. Overall, course provides a good understanding of the materials.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

2/10 starsCompleted
  • 0 reviews
  • 0 completed
9 months, 1 week ago
Hi, Marvels course course about 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,There was a lot to learn about Pivot Tables & Charts, Data Modelling, Power Query, Data Analysis & Visualization, through videos, exercises and reading stuff. Anyone with the some previous knowledge of Excel. Thank you.
Was this review helpful? Yes0
 Flag
R Z profile image
R Z profile image

R Z

10/10 starsCompleted
10 months ago
Great course. There was a lot to learn about Pivot Tables & Charts, Data Modelling, Power Query, Data Analysis & Visualisation, through videos, exercises and reading stuff. Anyone with the some previous knowledge of Excel can benefit from it.
Was this review helpful? Yes1
 Flag
MANISHCHANDRA PATLE profile image
MANISHCHANDRA PATLE profile image

MANISHCHANDRA PATLE

6/10 starsCompleted
9 months, 2 weeks ago
Excellent Course for Beginner and for working in Excel for reports preparation & analysis. Course could have contained more detailed points for in-depth learning.
Was this review helpful? Yes0
 Flag
Andrea Villalobos profile image
Andrea Villalobos profile image

Andrea Villalobos

10/10 starsCompleted
9 months, 2 weeks ago
Excelent course. The contentes were very well explained, the lectures were very usefull and gided so that you can complete the surveys by yourself. I was not an expert on the topic and I could complete all the modules with no difficulty. The labs were really usefull to wrap-up what was seen in the lecture and studied in the quiz.
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.