Analyzing and Visualizing Data with Excel

Provided by:
9/10 stars
based on  1636 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
22557 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
1636 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

8/10 starsCompleted
4 years ago
It was simple course but very useful. i like format and timing. it was very useful for me. Instructor has very good prononce for easy understanding of english speaking for non english listeners.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
This class is a great class. I have learned so much and I am able to apply what I have learned directly to my work (K- Adult education). This course will even be better if we could see clearly what the instructor is doing on the screen. May be by detailing all steps and using the magnifier on formulas...just a suggestion.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
Great course and very great instructor. Very good insight in new features of Excel 2016 for data analysis and BI. Thank you Dany Hoter and the DAT206x Course staff
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
The content of the course was well-organized. The instructor is very knowledgeable about the topic on hand. After taking this course, you will be familiar with the functions of pivot table, pivot chart, power query. Aside from those things, you will learn basic knowledge of data analysis expression (DAX).
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
I would like different exercises that the instructor do. I thought you could offer a discount to people who take the certificate. The instructor was great. No more to say.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
The content is very important to me because it facilitate me to analyze the with excel. The Instructor, I thank him for his participation to give us the knowledge that will help us in our daily activities. To provider I thank to him about this fever of training.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
I think the content is good. However, I would like to learn in more details such as DAX. In the future, I will recommend this course to my friends. This course is for beginers but it is very helpful for who have worked in enterprises also.
Was this review helpful? Yes0
 Flag
Luigi Ribon profile image
Luigi Ribon profile image
8/10 starsCompleted
  • 1 review
  • 1 completed
4 years ago
I really appreciate this training course. At the beginning, I just wanted to have an overview of the new Excel functionalities for Data Visualisation, but I was glue by the content and I have finally completed the course. Congrats to all the team, it was... ...EXCEL- LENT! :-)
Was this review helpful? Yes0
 Flag
Matheus B. Guerrero profile image
Matheus B. Guerrero profile image
10/10 starsCompleted
  • 1 review
  • 1 completed
4 years ago
Excellent course. I learned many Excel features that were unknown to me. The knowledge acquired will be very useful in my professional day-to-day. The instructor was clear in all the explanations and pretty pragmatic, well done! It was my first course provided by Microsoft and by edX and I can assure that it was worth it! Thank you! And a special thank you to all people that used the discussion area, you helped me a lot! ;-)
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 1 review
  • 1 completed
4 years ago
Awesome!!!! This course would help me in the analysis. Now with the new features, the data analysis would be really easy. The Power BI option was new to me, I become really enthusiastic to use it more.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
to Provider: we need to click 3 times to verify the quiz answers even if the first time submitted answer is correct, I'd suggest to improve the quiz function of this part. Besides: the forum/discussion function better add "quote", "hastag", "tag user"(like: @matt_su), and auto-wrapping features... which will definitely improve the UX of edx.org. :))) / Matt
Was this review helpful? Yes0
 Flag
Ekwere Paul profile image
Ekwere Paul profile image
8/10 starsCompleted
  • 1 review
  • 1 completed
4 years ago
Well delivered. Rich content, Clear videos, visuals and sounds. Though I had serious challenge at Lab 5 because of not being able to get through with creating the date table which made me unable to proceed on that particular Lab exercise, but all the same I moved on and I did well.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 1 review
  • 1 completed
4 years ago
This course helps me realize how powerful MS Excel is and significantly improves my Excel skills. Previously, I just knew how to make some calculation and some static (not interactive) graphs.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
Introductory level, easy to fallow, will be easier with Excel 2013/2016 but also feasible with 2010 - in this case you'll have to have the latest version of "Power Pivot", SQL 2012 (Express) and "Power Query" (free add-ins, easy to install). I enjoyed doing it, and took me about 1-2h weekly (have some previous experience in Excel, but none on these topics). There was no weekly assignment date, so even if you don't have time on one week, you can join and do it after. There is a final/end date for all to be done, of coarse.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
Mr. Hoter made the course very enjoyable. The content was well planned and progression thoughtfully arranged. The provider made accessing the course easy. Overall I would recommend this course to a friend or colleague interested in the topic. Furthermore, the course has shown me other areas in which I can grow including DAX and PowerBI.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsTaking Now
4 years ago
I totally recommend it! was awesome i learned so much! Very clear classes and videos. Im using the things a learned. I would love a 2nd part! Thanks microsoft!
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

2/10 starsCompleted
4 years ago
instructor could not speak proper English. The screen resolution was poor. The Lab's did not always work.It seemed to be an advertisement for Excel 2016
Was this review helpful? Yes0
 Flag
Houssam Ch profile image
Houssam Ch profile image
8/10 starsCompleted
  • 1 review
  • 1 completed
4 years ago
Very good instructor organized and calm. The content was good. EDX awesome. I'm looking forward to pre-intermediate Excel course. h.chams@hotmail.com
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
The course has been very interesting, I have learnt a tool that makes easier to analyze data and I am sure that I am going to use it in my future job. Thanks for giving us the opportunity to receive this course.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

6/10 starsCompleted
4 years ago
The course is for beginers because it is very easy. The labs were the same than the videos before. It will be better if the subject is more accurate. I hope the will be a level 2.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
I loved the lessons, I have been using Excel for years and I did not know anything about some of the features described here. I think it would be great to have a set of lessons for every MS tool and for every new release with the changes...
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
Simply great! Thanks you very much A good origin point to get deeper in this topic Clear explications, many many examples and real world problems Simply great! Thanks you very much A good origin point to get deeper in this topic Clear explications, many many examples and real world problems Simply great! Thanks you very much A good origin point to get deeper in this topic Clear explications, many many examples and real world problems
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
The course has been very insightful, and I have learnt a lot. The Presenter is very a subject matter expert who presented the course in a way which made the course to look simple.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

4/10 starsCompleted
4 years ago
I thought it would be more in depth. The information presented in the course can be learned from any source like youtube. its very elementary and the instructor was not engaged as he is supposed to.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
Overall it was a good course and quite enlightening. Kudos to the team for setting it up and for the engaging conversations. I'm looking forward to implement what I have learnt. Best, Wahome Victor | G.I.S Analyst
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

4/10 starsCompleted
4 years ago
Should have been clearer that you needed the pro version of Excel. Could have made it easier for the rest of us if you had extra material for home editions. The presenter was too monotonous. Otherwise he did a good job.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
Excellent course. The examples are closely related to the assessments, which give valuable practice. One or two of the assessment questions might be more carefully worded, though this is just nit-picking as I'm required to use 150 characters.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
This gave a totally new perspective to power use of Excel and I hope that this can be used in my coming jobs. Unfortunately I do not have Excel 2016, but I did not have diffiuclties in using Excel 2013 when it was changed to 64 bit version.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
Me ha parecido un gran curso para aproximarse al análisis de datos mediante las herramientas power pivot y power query. En mi opinión el poder tratar con excel datos es un gran acierto porque en las organizaciones es una de las aplicaciones más usadas y darle este tipo de funcionalidades lo hace mantenerse como aplicación fundamental El curso me ha parecido muy interesante, muy bien explicado para la gente que nos aproximamos a conocer estas funcionalidades y los ejercicios sugeridos también me parecen muy bueno porque nos hacen repasar todo lo visto en los videos En definitiva me ha parecido un excelente curso y enhorabueba
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

1/10 starsDropped
4 years ago
Lectures not smooth hard to follow at times. Questions in discussion met with belittling the person inquiring about a topic as being stupid and should already know the answer to their question and wasting TA's time in following up
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.