Analyzing and Visualizing Data with Excel

Provided by:
9/10 stars
based on  1635 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
22549 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
1635 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
Siew Tien Low profile image
Siew Tien Low profile image

Siew Tien Low

10/10 starsCompleted
6 months, 2 weeks ago
Very informative and useful course contents. Now I have better understanding about Power Pivot, Power Query, DAX Language and Power BI. Thank you for such an amazing program.
Was this review helpful? Yes0
 Flag
Helen Morrison profile image
Helen Morrison profile image

Helen Morrison

10/10 starsCompleted
6 months, 3 weeks ago
Very useful information, directly and immediately applicable to my work. I enjoyed taking Excel to the next level - it is quite surprising how versatile this program is.
Was this review helpful? Yes0
 Flag
Tayyab Jan profile image
Tayyab Jan profile image

Tayyab Jan

8/10 starsCompleted
6 months, 3 weeks ago
I am very pleased to have completed this fruitful course. I found it really helpful as this was mostly related to our daily tasks. The features available in MS Excel such as Power View, Power Pivot and Power Query are those that have made easier the job of a data scientist/ data analyst.
Was this review helpful? Yes0
 Flag
Bogdan Cristurean profile image
Bogdan Cristurean profile image

Bogdan Cristurean

8/10 starsCompleted
6 months, 3 weeks ago
I really enjoyed the course. It was very interesting and enjoyable. It also conviced me to dig deeper into this field! I would highly reccomend the course to my friends and colleagues. Thank you!
Was this review helpful? Yes0
 Flag
Cesar Geovanny Aguilar Martinez profile image
Cesar Geovanny Aguilar Martinez profile image

Cesar Geovanny Aguilar Martinez

10/10 starsCompleted
6 months, 3 weeks ago
I really enjoy the course. I think it is very useful for all environments and I am trying to apply what I have learned into my daily work. I appreciate the spend time in the course creation, I really learned a lot. Thank you so much and best regards!
Was this review helpful? Yes0
 Flag
Ibrahim Badwey profile image
Ibrahim Badwey profile image

Ibrahim Badwey

10/10 starsCompleted
6 months, 3 weeks ago
Great content and Great Instructor. I have learned a lot from analyzing and visualizing data with excel. The content was organized very well as it will level you up gradually if you go with its sequence. Also examples are provided for all information given in the course. The instructor Mr. Dany Hoter is perfect. His voice and language are very clear. I want to thank him and Microsoft very much for this course.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
6 months, 3 weeks ago
Thank you, great course DAT206x, learned a lot! This proved to be very useful and hopefully will all culminate in the next course, DAT207x when incorporating into Power BI. Thanks again!
Was this review helpful? Yes0
 Flag
Anton guerrero profile image
Anton guerrero profile image
10/10 starsCompleted
  • 0 reviews
  • 0 completed
6 months, 3 weeks ago
It was a great course by the content. I find interesting the way in which the course was approached and the main themes that were chosen. the experience and mastery of the team that taught the course was noted
Was this review helpful? Yes0
 Flag
Francesca A profile image
Francesca A profile image

Francesca A

10/10 starsCompleted
6 months, 4 weeks ago
Really helpful and interesting course. Dany the instructor was very clear with his directions and a really good teacher (the optional modules with the robotic voice were a little annoying but still good content). I know feel much more comfortable using some of the more advanced features of excel.
Was this review helpful? Yes0
 Flag
PRAVEENA K profile image
PRAVEENA K profile image

PRAVEENA K

10/10 starsCompleted
7 months ago
Thank you so much for this opportunity. The content provided in this course was very knowledgeable. An instructor has delivered the content in a most understandable way. Meanwhile, the Quiz & lab session was interesting. Overall, I have gained more experience on Analyzing and Visualizing Data with Excel.
Was this review helpful? Yes0
 Flag
Kou Mphuthi profile image
Kou Mphuthi profile image

Kou Mphuthi

10/10 starsCompleted
7 months ago
The knowledge I gathered is amazing. I started the course with a little knowledge of Pivot table & chart but after completion I know more about the capabilities of MS excel as a tool together with the ad ons.
Was this review helpful? Yes0
 Flag
anand nettem profile image
anand nettem profile image

anand nettem

8/10 starsCompleted
7 months ago
Thanks you so much. This course really help me to the enhanced visualization techniques Excel has adopted over the years andI Learn lot on excel analyzing and visualizing.
Was this review helpful? Yes0
 Flag
Jason Oser profile image
Jason Oser profile image

Jason Oser

10/10 starsCompleted
7 months ago
This course really opened my eyes to the enhanced visualization techniques Excel has adopted over the years. I initially took the Edx course on PowerBI visualization and was pleasantly surprised to find many of the same data manipulation and presentation techniques available in Excel. It is very helpful for me to know that I can report on data where the rows exceed the Excel maximum >~1m. I highly recommend the course.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 0 reviews
  • 0 completed
7 months ago
This course provided me with a much greater understanding of the many practical ways of utilizing Excel in data visualization and analysis. I was able to apply many of the ideas I learned about in this course within the context of my current employment almost immediately.
Was this review helpful? Yes0
 Flag
Virginie Damoiseaux profile image
Virginie Damoiseaux profile image

Virginie Damoiseaux

10/10 starsCompleted
7 months ago
With some knowledge through Introduction to Data Analysis using Excel, all the courses are perfectly clear and documented, I learn a lot and go further, at own pace Labs are very well, and motivating.
Was this review helpful? Yes0
 Flag
Socheat Chea profile image
Socheat Chea profile image

Socheat Chea

10/10 starsCompleted
7 months, 1 week ago
I love learning from Deny. He provides good content and clear explanation. I want to continue all the related courses on data analysis and I look forward to enrolling the last course which is on the X series of Microsoft.
Was this review helpful? Yes0
 Flag
Saurabh Sippy profile image
Saurabh Sippy profile image

Saurabh Sippy

8/10 starsCompleted
7 months, 1 week ago
The content is very interesting the videos are way more helpful to understand the context better. I recommend this course even if you don't have knowledge about data models.
Was this review helpful? Yes0
 Flag
Jou profile image
Jou profile image

Jou

10/10 starsCompleted
7 months, 1 week ago
The content is very interesting and the course material is complete and easy to understand. I recommend this course even if you don't have knowledge about data models.
Was this review helpful? Yes0
 Flag
tingyu lin profile image
tingyu lin profile image

tingyu lin

8/10 starsCompleted
7 months, 2 weeks ago
First of all,thanks for providing the course.The content is interesting,and the instructor arranged very well.The content is very complete,and easy to understand.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
7 months, 2 weeks ago
Es un excelente curso con un completísimo contenido. Los ejemplos son muy reales de empresas y se puede aplicar a cualquier sector. Me gustaría profundizar en Power BI.
Was this review helpful? Yes0
 Flag
Nduta Thairu profile image
Nduta Thairu profile image

Nduta Thairu

10/10 starsCompleted
7 months, 3 weeks ago
Its amazing! I can finally apply what I've learned into my daily routine at work. It is very engaging and I hope more people get to do it. I learned about Dax something I'd never heard of and i hope my visualization and analysis skills will improve
Was this review helpful? Yes0
 Flag
DEERAJ PANNAM profile image
DEERAJ PANNAM profile image

DEERAJ PANNAM

10/10 starsCompleted
7 months, 3 weeks ago
I felt good about this course, that how can we analyze the data and visualize it according to the way we needed. The quiz is good. when I started the course I am an absolute beginner in excel but now I learned a lot and the extra notes were very helpful. I think the course is Good overall.
Was this review helpful? Yes0
 Flag
Oluwaseyi Adeliyi profile image
Oluwaseyi Adeliyi profile image

Oluwaseyi Adeliyi

10/10 starsCompleted
8 months ago
The second course offered in the series, well taught. Looking forward to the next one. Students are advised to take the previous course on Introduction to Data Analysis in order not to get lost in some terms and lessons in this course.
Was this review helpful? Yes0
 Flag
Dilip Kumar Yadav profile image
Dilip Kumar Yadav profile image

Dilip Kumar Yadav

8/10 starsTaking Now
8 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.
Was this review helpful? Yes0
 Flag
Hamed Ebadi Ghader profile image
Hamed Ebadi Ghader profile image
10/10 starsCompleted
  • 3 reviews
  • 3 completed
8 months, 1 week ago
Marvelous stuff! This course covers fascinating features of Excel and guide you for further learning if you wish. I enjoyed every second of it and recommend this course to anyone who wants to grasp a sound ground in data analysis with Excel. Thank you Microsoft team for providing us such great course.
Was this review helpful? Yes0
 Flag
Mohamed Alsisi profile image
Mohamed Alsisi profile image

Mohamed Alsisi

10/10 starsCompleted
8 months, 1 week ago
It's really very useful course, it can give you a good brief with reach materials about data analysis to help navigating into that interesting field of data science.
Was this review helpful? Yes0
 Flag
Arsalan Masood profile image
Arsalan Masood profile image

Arsalan Masood

8/10 starsCompleted
8 months, 1 week ago
This course was a very in-depth course which explains Pivot tables, pivot charts, DAX and Power Bi. I personally think that the DAX part of the course should have been covered with more details and with some more labs.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
8 months, 2 weeks ago
The course was very practical and it gave industry related examples. I would recommend it. However, I suggest they add more modules on DAX. Well i'm off to try the power BI course
Was this review helpful? Yes0
 Flag
Vrinda B profile image
Vrinda B profile image

Vrinda B

8/10 starsCompleted
8 months, 2 weeks ago
Course material, video, and assignments were very helpful and in line with the course description. As a student, I would have liked more assignments and heavier lab work covering more content in the course. Thank you!
Was this review helpful? Yes0
 Flag
Vrinda B profile image
Vrinda B profile image

Vrinda B

8/10 starsCompleted
8 months, 2 weeks ago
Course material, video, and assignments were very helpful and in line with the course description. As a student, I would have liked more assignments and heavier lab work covering more content in the course. 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.