Analyzing and Visualizing Data with Excel

Provided by:
9/10 stars
based on  1776 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
23485 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
1776 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, 7 months 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, 7 months 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, 7 months 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, 7 months 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, 7 months 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, 7 months 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, 7 months 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, 7 months 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, 7 months 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, 7 months 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, 7 months 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, 7 months 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, 7 months 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
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 7 months ago
This is a great course for all the people who manage a lot of information from different sources. The instructor is the weak point in this course, but all the concepts are clear and you can understand them pretty well. Thanks!
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 7 months ago
Its a subject dear to my heart with tremendous capabilities which can be used in my organization. Course content and material coming from MS is rich. Instructors should have been better, as at times it appears they are matter-of-fact and casual in their approach.The class could have been made more lively.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 7 months ago
This course is very useful to keep up with the latest improvements in data analysis and Excel. Everything is clearly explained and further reference is provided for those who want to go further.
Was this review helpful? Yes0
 Flag
Andreea Imecs profile image
Andreea Imecs profile image
10/10 starsCompleted
  • 1 review
  • 1 completed
4 years, 7 months ago
Excellent introduction to the Excel Data Model and DAX for building Power Pivot Tables and Charts. The video lectures are some of the best I have seen on MOOCs, very clear examples, easy to follow and very well prepared instructor. The course covers the fundamentals thoroughly, building a strong foundation for anyone to explore further and become a more advanced user with confidence. I would love to see more "generalist" courses from Microsoft on edX. Top quality! Well done!
Was this review helpful? Yes0
 Flag
Suzzy Gasue profile image
Suzzy Gasue profile image

Suzzy Gasue

8/10 starsTaking Now
4 years, 7 months ago
the course is interesting, and the instructor is good, and i would like to appeal to the instructor to provide more of this lessons to broaden the minds of students.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 1 review
  • 1 completed
4 years, 7 months ago
This was my first time doing an online course and I really enjoyed it. It was very informative and delivery was quite comprehensive. This is such a good platform and I hope to get more interesting courses like this one.
Was this review helpful? Yes0
 Flag
Sreejith PONNEMPARAMBATH profile image
Sreejith PONNEMPARAMBATH profile image
10/10 starsCompleted
  • 1 review
  • 1 completed
4 years, 7 months ago
Everyday business = lot of spread sheets and often large ones with lot of look up queries. If you think your workbook it too big and slow with vlookup formulas everywhere, prone to errors and crash, here is the solution. Very interesting new capabilities of excel for data management. Course content is interesting, instructor is strait talking and competent, exercises are too easy, often solutions provided in front of eyes. Only drawback you need the latest version of excel to make it work. A new course on VBA would be very welcome from Microsoft.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 1 review
  • 1 completed
4 years, 7 months ago
A really interesting course, with a good development trough the subjects. Showing you enough to give you some base but also letting you with a willing to learn more and look for more functionalities.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years, 7 months ago
I liked everything. Thank you teacher Dan. Please provide more excel courses...................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsTaking Now
4 years, 7 months ago
Everything was great, but the instructor could have been better. His communication skills weren't the greatest which often made module confusing. Using terminology like "this and then that" or not completing sentences and having various running thoughts made it hard to grasp the material. The TA was great however :)
Was this review helpful? Yes0
 Flag
Arturo Aparicio profile image
Arturo Aparicio profile image
10/10 starsCompleted
  • 1 review
  • 1 completed
4 years, 7 months ago
The content for the course was pretty good, have good exercises and we can learn making the demos, but i think the instructor can provide the files in the different versions to use the whole potential of the softwares. The instructor is good but in some items he need to be more specific or be more retailer. The provider have good platform and like to have the access to this courses
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 7 months ago
I enjoyed this Excel course by EDx and Microsoft. The instructor ensured that he explained into details with the quiz and lab questions in place to improve you. Thanks Guys!!
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 7 months ago
I thought this was a great experience, and while I was skeptical at first that I would actually be able to apply things I've learned, I now believe I can apply many aspects of the class! Thank you!
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years, 7 months ago
Course was very interesting and fun to do. I really like the hands-on labs as well as the questions after each module. The instructor was serious but I wouldnt mind him to be a bt more enthusiastic. Finally, the course was professionaly delivered and I would like to see more courses like this one from Microsoft in the near future. Could you please create a part 2 of this course. I would definetely enrol.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 7 months ago
It was for the first time when I found out that I can use Excel to manage model data. I have followed the training labs on Excel 2010, it was a bit difficult to find correspondence for some options that in Excel 2016 seems to be improved or more manageable directly from the ribbon, but I did manage after all. Definitely I found interesting information that if I will have the opportunity I will use. Great presentation! Useful information! Thank you EDX.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years, 7 months ago
Great course! Packed with useful information and hands-on exercises. Very good instructor - professional, knowledgeable and good communicator. The course might be a bit challenging for some though because it covers quite a bit of material in a fast pace. Also note that there is a lot of emphasis on the Power Pivot feature, which is not included in the Personal and Home MS Office subscriptions, but you can very easily do without it (in Excel 2016, a bit less easily in Excel 2013).
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 7 months ago
Overall, excellent experience; some questions were a little misleading due to terminology used, however,satisfied with the learning experience. The data sets were easy to use and instruction was clear. The introduction to DAX and MDX languages was excellent. The features in Power BI are ground breaking and wish there was an easier way to present this technology to upper management.
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.