Analyzing and Visualizing Data with Excel

Provided by:
9/10 stars
based on  1643 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
22630 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
1643 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
When I started this course I was not sure that I would be seeing so much new and Excel is capable of doing so much for me in a work environment. The course and its excersices are very well designed which guide the student at each step and enhance the learning experience.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

2/10 starsCompleted
4 years ago
Very useful imformation, also is a good form to introduce in a new version. I like a lot the new version because we can do faster than before the tasks to analyze information.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
Excellent! Easy to follow and pace is just about right. It is great to learn some useful tricks in the course. Good overall coverage of new technologies in Excel.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

6/10 starsCompleted
4 years ago
Knowledge all based on simple business example. Multiple choice 4 questions with 2 attempts is too easy. The language choices in the question did not match the presenters language choices. Examining by which menu to select is not the point of this?
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

6/10 starsCompleted
4 years ago
The course could be more explanatory in some aspects, mainly in the new features. I missed a better teaching in some subjects, that is, I could do what was requested but not clearly understood why I was doing it.
Was this review helpful? Yes0
 Flag
Juraj Ozimy profile image
Juraj Ozimy profile image
10/10 starsCompleted
  • 1 review
  • 1 completed
4 years ago
This course is very good start for people, who already use Excel, but want to take it to higher level. Especially useful for people doing analysis on the daily basis. This is not course for absolute beginners, because it jumps directly on topic and if you are not familiar with at least pivot tables, you can have really hard time. Materials provided are excellent and lectures are very well organized. Tests are well aimed on topic. Labs are not simple and force you to think. Instructions are mostly clear and for the hardest parts there are always hints included. Also there are source files for different versions of Excel, so don't worry if you don't have the newest one. Whole videos are made in one cut, so presenter sometimes thinks or misclicks, but I think it looks more natural this way. Overal quality is really good, I have learned a lot and strongly recommend this course.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
This was an excellent course. I learned the new features that come with excel. I would recommend it to everyone who has a little experience with excel 2016 and with BI. The exercises with excel 2013 were a little difficult, but that was de challenge!
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
The presenter needs to be more organized when orally presenting the material. Very often he goes into circles or repeats himself which makes it hard to follow the presentation resulting in having to repeat the listening. It also hampers the information uptake. However, I realize that English is not his first language and give him kudos for doing this in English. He also needs to keep water by his side because he gets really dry in his throat and coughs into the listeners’ ears.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

6/10 starsCompleted
4 years ago
It is a good starter course on this material. Maybe segregate the questions for the class by difficulty level or add bonus questions that are more difficult that may or may not graded.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
Content was really enjoyable, particularly as we got towards the end of the course. Would definitely enjoy a part 2 with more challenging questions. Students will benefit from questions that are not just repeating what was shown on the course video (but perhaps solving a similar problem). Instructor was good, despite an unorthodox and somewhat unnatural presenting skills. On some occasions (for example, the hierarchies in the data model), more clarity is needed with the explanation. Edx are very good. Would like to see two buttons to allow you to check and do a final check withoot having to press check 3 times when you know your answer was right the first time.
Was this review helpful? Yes0
 Flag
Md Shujon Alam profile image
Md Shujon Alam profile image
8/10 starsCompleted
  • 1 review
  • 1 completed
4 years ago
Overall, I enjoyed the course very much. I got to know exactly what I wanted to know and an intro to Power BI is just what i needed to end with. Would have loved to see some more branches of progression from this course closing chapter e.g. hints on how we can learn SQL and some other advanced data analysis and visualization tools. Thanks to all the organizers and to the instructor, for arranging this course.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
The course is mainly for premium business users of office 2016. You still can follow the course through a trial version for a month. But you will not be able to use part of the knowledge after the end of the trial version. However, If you intend to use the knowledge in a professional way in professional organizations, this course is PERFECT!!
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
i thank you for this course because it provided data model and good examples to play with and interact. it has been the occasion for me to approach the new way of analyzing and visualizing data that now is available even if my company is not using it yet in finance organization.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
The course is a demonstration of the capabilities and features of Excel. It might not be that much into any subject, but, if you use Excel for your day to day work and reports, you have got to take this course. It is awesome what Excel can do and the course guides you through. Kudos to the team and Microsoft and edX, nonetheless.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

2/10 starsCompleted
4 years ago
the course was excellent overall. few things I would like to highlight 1. would be great if you can make the entire course compatible with MAC (IOS system). I had to borrow someone else's Laptop in order to finish the course 2. would also appreciate providing the solution for the lab as i was missed few and did't know how to get right 3. if you could share with me the model type of the Laptop the instructor was using. or maybe any windows device that you recommend 4. I would also appreciate if you could share with us the workbook the instructor was using of the entire module thank you so much.. I truly loved the course. Especial thanks to Dany Hoter
Was this review helpful? Yes0
 Flag
 profile image
 profile image

8/10 starsCompleted
  • 1 review
  • 1 completed
4 years ago
The cours was excellent: but one thing: the questions was not clear, not well explained. specially I made a lot of time to understand questions and to do the labs and quiz instead of 2 or 4 hours dedicated on a week. For the next, please make 1 module per week.
Was this review helpful? Yes0
 Flag
José Becerra Rivera profile image
José Becerra Rivera profile image
10/10 starsCompleted
  • 1 review
  • 1 completed
4 years ago
It is an interesting course but I think it is a little complex so it needs more detailed work. More explanations of uses of DAX expressions, OLAP functions,.... I know it is for a more complex course but it’s a bit difficult to follow the course without understanding well the uses of DAX expressions.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
There are a few issues with the course material and it needs some polish, but if you are looking for more information about Excel 2016 and how to work with Power Pivots and the Data Model, this class does a good job at introducing the topic.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
Excellent beginner level course for Excel users to understand business data visualization and manipulation. I had no previous experience in using Pivot tables and charts, but this course showed powerful a tool they are for analyzing data.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
Este curso me dio mas conocimiento en el mundo del excel,, Las actividades y ejemplos son muy buenos para aprender en cada modulo.Muchas gracias a EDX por dar esos cursos y al Instructor.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

8/10 starsCompleted
  • 1 review
  • 1 completed
4 years ago
Its my first course when everything is so important for our professional life and also very easy to understand the content, Best thing of this course is, no money for such a valuable knowledge, Salute to the organizers !!!
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 1 review
  • 1 completed
4 years ago
It is a wonderful course and it was designed in an excellent way. But we need more exercises and contents. The quiz were necessary to understand the concept and felt satisfied scoring it correctly.
Was this review helpful? Yes0
 Flag
Jorge L. Mena G. profile image
Jorge L. Mena G. profile image
6/10 starsCompleted
  • 1 review
  • 1 completed
4 years ago
Must be more dinamic and include more exercise for each module in order to gain more knowledge and experience. Must be more clear in explications. So, the course was interesting for know another functionalities in excel, maybe not used
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
Content is very interesting. Exercises are well thought of. Instructor has mastery of the subject. The community members were very helpful. Staff are very professional. I recommend this course to anyone who would like to get an overview of Data Analysis and Visualization.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
I am pleasantly surprised by the quality and depth of the course. It is difficult to find material that covers these concepts in a simple and attractive form users . Thank you very much for providing this knowledge users on this platform.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
Realy great course! Information is very useful, espessially about PowerPivot and Power Query.It's not only lectures but practical expirience also. But it's only the beginig of the Data Vizualization in Excel.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
In order to follow the course you must have a minimal knowledge in Excel, but everything is explained very well and clearly. I loved the course because it's very useful to improve your knowledge in Excel.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 1 review
  • 1 completed
4 years ago
This is my first training with EDX and Microsoft. The training is very informative and reveals all the upcoming features in Excel 2016 w.r.t. data analysis and visualization. I found a lot of the new features as solutions to some of the hurdles I face at work. The content of the training is well framed. The lab exercises help in understanding the concepts better. The instructor seems well-experienced and knowledgeable. The text along with the audio narration is very helpful to understand the explanation. With Microsoft and EDX, we know that the training is up to date and reliable.
Was this review helpful? Yes0
 Flag
Gustavo Bernardi Pereira profile image
Gustavo Bernardi Pereira profile image
8/10 starsCompleted
  • 1 review
  • 1 completed
4 years ago
The course itself was great! I just want to point out some things: - At the very beginning could be made a better explanation about the main advantages of using DataModel instead of an Excel table as well as their uses. It wasn't that clear why I'd use the DataModel. -One think that could be made as well, would be a linked course about how to insert data in a SQL, creating a simple database. It is because this taught course seemed to be dependant on some other features (that I was not aware nor were taught along the course). -And even though the instructor was easy to understand, he didn't look very enthusiastic. So maybe work a bit on it.
Was this review helpful? Yes0
 Flag
Amoghavarsha B profile image
Amoghavarsha B profile image
10/10 starsCompleted
  • 1 review
  • 1 completed
4 years ago
Absolutely amazing! One of those worthy courses. The content of the course is very well defined and it just is perfectly provided to all the students. The supporting reading material is very well put together. The instructor was on the point, and helped a lot. Thanks a lot to all the people involved in putting this course together.
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.