Analyzing and Visualizing Data with Excel

Provided by:
9/10 stars
based on  1678 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
22777 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
1678 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, 2 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
Qi Chu profile image
Qi Chu profile image

Qi Chu

10/10 starsCompleted
1 day, 15 hours ago
Good interaction with the speaker. Pivot Tables, Pivot Charts, Data models and Visualization. It is a good complement if you already have some knowledge of Excel (tables, formulas).
Was this review helpful? Yes0
 Flag
Davide Pavan profile image
Davide Pavan profile image

Davide Pavan

8/10 starsCompleted
2 days, 3 hours ago
With Excel 2016, you can publish your Excel workbooks right to your Power BI site, where you can create highly interactive reports and dashboards based on your workbook’s data. You can then share your insights with others in your organization.
Was this review helpful? Yes0
 Flag
Jesvine Patric profile image
Jesvine Patric profile image
8/10 starsCompleted
  • 1 review
  • 1 completed
4 days, 19 hours ago
Informative and systematically explained. Data models, Pivots and visualizations explained in detail. Content is simple and easy to understand. Rather than just academic level theories, it's more into the practical level and can be applied to daily work modules. Modules on data models was way beyond informative and ease to go. It had been better if we could have got solutions to the exercises.
Was this review helpful? Yes0
 Flag
Hugo Sundqvist profile image
Hugo Sundqvist profile image

Hugo Sundqvist

8/10 starsCompleted
1 week ago
Good explanations in the lectures, easy to follow, good content.It had been better if we could have got solutions to the exercises. Good if you have some basic knowledge of excel before starting this course.
Was this review helpful? Yes0
 Flag
Kingsley Nwachukwu profile image
Kingsley Nwachukwu profile image

Kingsley Nwachukwu

10/10 starsCompleted
1 week, 1 day ago
Great course, simple to understand, concise and straight to the point. The advanced features of Excel I learnt in this course will always be useful in my work and personal life. Quiz questions were quite interesting also.
Was this review helpful? Yes0
 Flag
Alloyce Ochieng profile image
Alloyce Ochieng profile image

Alloyce Ochieng

10/10 starsCompleted
2 weeks ago
Excellent and very informative. Dany Hoter knows how to drive the message home. Until recently, I thought Excel was the master of data analysis and visualization. Appreciation to Dany and Microsoft.
Was this review helpful? Yes0
 Flag
B D profile image
B D profile image

B D

8/10 starsCompleted
2 weeks, 2 days ago
Not for beginners. Gets complex pretty quickly so be sure you budget enough time to thoughtfully go through the lessons and labs/exercises.You have to read between the lines a bit from what instructor says to answer quiz questions.
Was this review helpful? Yes0
 Flag
M B profile image
M B profile image

M B

10/10 starsCompleted
2 weeks, 2 days ago
Great for someone who is already good in Excel and wants to start learning DAX. Very clear and simple explanation of properly analyzing and visualizing data without making your file too large. Perfect stepping stone for learning advanced DAX.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
2 weeks, 5 days ago
The course content is relevant to my product management and monitoring job. and i will apply the skill set acquired to the analytical monitoring and reporting of the products i currently manage. The instructor did justice to the topic, delivering the needed information with simple and fluent English.
Was this review helpful? Yes0
 Flag
Doc Ragnarok profile image
Doc Ragnarok profile image
8/10 starsCompleted
  • 0 reviews
  • 0 completed
2 weeks, 5 days ago
This was overall a very complete course and the instructor and setup are good, however, if you're on Office 365, then be warned that they are teaching using Excel 2016, and some UI elements are outdated/different enough in Modules 4 and 5 that they can be a real problem if you aren't careful.
Was this review helpful? Yes0
 Flag
Angeline Vogel profile image
Angeline Vogel profile image

Angeline Vogel

10/10 starsCompleted
2 weeks, 6 days ago
Well presented and looking forward to the next course. Power BI is amazing and allows visibility of all data. This will definitely help in presenting to my clients now and in the future on their KPI requirements.
Was this review helpful? Yes0
 Flag
Bello Amudat profile image
Bello Amudat profile image
10/10 starsCompleted
  • 0 reviews
  • 0 completed
2 weeks, 6 days ago
I learnt a lot from this course. It has widened my knowledge of Excel. The instructor really helped by explaining even the simplest things.I didn't have any idea of data analysis before this course but this course has taught me a lot that will be ujseful in my work and everyday life.
Was this review helpful? Yes0
 Flag
Laura Rubio profile image
Laura Rubio profile image

Laura Rubio

8/10 starsCompleted
2 weeks, 6 days ago
Very complete course, I have learnt a lot. it is great having files to practice what we have learnt from the lectures. Some of them are quite challenging but it is great to ave to go dipper on the files to understand them.
Was this review helpful? Yes0
 Flag
Sharafa Sharafa profile image
Sharafa Sharafa profile image

Sharafa Sharafa

8/10 starsCompleted
2 weeks, 6 days ago
The instructor is very experienced in the course as well as lecturing on it, that's priceless. The course content was very useful and taught in proper hierarchy. Thanks for the opportunity.
Was this review helpful? Yes0
 Flag
Olga Matsulka profile image
Olga Matsulka profile image

Olga Matsulka

8/10 starsCompleted
3 weeks ago
Great and adequately challenging course. Would recommend to others as it provides an up-to-date review of Excel and its development. The new features are great as they provide for better efficiency. Also, some more difficult Excel features are replaced by more intuitive functions.
Was this review helpful? Yes0
 Flag
Vipindas K H profile image
Vipindas K H profile image

Vipindas K H

10/10 starsCompleted
3 weeks, 2 days ago
Great content, will be really helpful in the day to day professional life, we can stand out from others using these excel skills and make our professional life more successful. Power queries are new learning for me and i am sure i will be using it very soon in for creating new data models.
Was this review helpful? Yes0
 Flag
Valeria McGeer profile image
Valeria McGeer profile image

Valeria McGeer

10/10 starsCompleted
3 weeks, 3 days ago
I love this course, it was made easy to understand. It covers many aspects and tools of excel that I did not know existed. it is easy enough to follow along and Danny as an instructor is great! He explains all lectures clearly.
Was this review helpful? Yes0
 Flag
mohamed abdel aleem profile image
mohamed abdel aleem profile image

mohamed abdel aleem

6/10 starsCompleted
3 weeks, 5 days 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? Yes0
 Flag
Sam profile image
Sam profile image

Sam

10/10 starsCompleted
4 weeks ago
This course was very informative. I enjoyed learning about the various features in excel and how to utilized them. I am in the field of education and constantly tell my students, " There is more to excel than creating a formula". Excel is a component in presenting data to make business decision. How can I get an excel t-shirt? Sam
Was this review helpful? Yes0
 Flag
Micheal Ezenachukwu profile image
Micheal Ezenachukwu profile image

Micheal Ezenachukwu

10/10 starsCompleted
4 weeks ago
Excellent, This course has given me a platform to take on any form of data and try to make sense out of it... I have one particular data, already in my mind... Thank you Dany Hoter...
Was this review helpful? Yes0
 Flag
Luis Rodriguez profile image
Luis Rodriguez profile image

Luis Rodriguez

10/10 starsCompleted
1 month ago
Totally loved this course and how it expanded my knowledge in the use of Excel, but most particularly to handling the data model and its capabilities.
Was this review helpful? Yes0
 Flag
Nicole Chan profile image
Nicole Chan profile image

Nicole Chan

8/10 starsCompleted
1 month ago
Very useful course in database management. Like the lab section so that we can really try and see if we understand the lecture. The most difficult part would be using the DAX language in the query, but there are sufficient support from the related link for us to self-study.
Was this review helpful? Yes0
 Flag
HAPPY IBE profile image
HAPPY IBE profile image

HAPPY IBE

10/10 starsCompleted
1 month ago
Analyzing and Visualizing Data with Excel is an inspiring course, excellently delivered by Dany Hoster. Though I have been very familiar with all the components of the course - Pivot table, Pivot Chart, Data Models, Visualization and Power BI, the certificate is an added value.
Was this review helpful? Yes0
 Flag
Juan José Medina profile image
Juan José Medina profile image

Juan José Medina

10/10 starsCompleted
1 month, 1 week ago
Excellent and very useful content. And a great job is done by the instructor, whose lessons are quite well explained. The extra resources provided are useful along the course.
Was this review helpful? Yes0
 Flag
Mathew Abraham profile image
Mathew Abraham profile image

Mathew Abraham

8/10 starsCompleted
1 month, 1 week ago
Very good content and great instructors. I really liked that fact that I learned so much about how to use Excel and the PowerPivot and Query editor. I am going to look at the POwer BI course next.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
1 month, 2 weeks ago
I enjoyed the course thoroughly. The lectures set the stage nicely, the quizzes do a good job of checking for understanding, and then the labs help solidify the learning. I'm looking forward to doing the Power BI training next.
Was this review helpful? Yes0
 Flag
Geerhard Reink profile image
Geerhard Reink profile image

Geerhard Reink

8/10 starsCompleted
1 month, 3 weeks ago
Excellent course to show what is possible, touching upon relevant subjects and presented in a quiet instructive method. Motivates to dive further into the possibilities.
Was this review helpful? Yes0
 Flag
JULIO RODRIGUEZ profile image
JULIO RODRIGUEZ profile image

JULIO RODRIGUEZ

10/10 starsCompleted
1 month, 3 weeks ago
Excellent very well presented and structured, the model and the example used in this course allows me to have a clear understanding of what I can do with such a powerful tool
Was this review helpful? Yes0
 Flag
Ikem Daniel profile image
Ikem Daniel profile image
10/10 starsCompleted
  • 0 reviews
  • 0 completed
1 month, 4 weeks ago
I found the course to be very interactive and it was presented in a simplified format. The content was good enough to position each learner to go deeper and learn further with other links and tools provided. I will recommend this course to aspiring Data Analyst and individuals seeking to have a basic grasps of interpreting and making meaning out of data. I am sure going to take associated courses and develop my skills in Analytics.
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.