Analyzing and Visualizing Data with Excel

Provided by:
9/10 stars
based on  1654 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
22694 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
1654 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
3 years, 10 months ago
Not difficult to understand and interacting. I enjoyed the course and got an interest fast. Thank you for the course and keep it up! ****************************************************************
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
3 years, 10 months ago
I'm a student from Beijing,This is the first class I took in edX, and it's also my first class from Microsoft, the instructor presented many useful Excel functions in a very interesting, fun, and attractive way.This course helped me working more efficient,I hope Microsoft would provide more Excel relevant training, like Excel VBA. Thanks very much Mr Hoter.
Was this review helpful? Yes0
 Flag
Junior Rodriguez profile image
Junior Rodriguez profile image

Junior Rodriguez

10/10 starsCompleted
3 years, 10 months ago
Excellent course, the contents are very clear and well taught. I spent 4 days taking it and just wish it would have more content about the DAX functions and the power BI capabilities.
Was this review helpful? Yes0
 Flag
Juan Lopez Meyer profile image
Juan Lopez Meyer profile image

Juan Lopez Meyer

8/10 starsCompleted
3 years, 10 months ago
The course is an introduction of a very powerful tool. I highly recommend this course! I am from Argentina but I did not have any problems with the language
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
3 years, 10 months ago
The content was sales data from a company. We analyzed this sales data and created visualization based on it. I think the course should have showed more on how to create several other models from other sources, like USA energy consumption, just to really understand how this data models are built.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 1 review
  • 1 completed
3 years, 11 months ago
Much better than reading a book. It is suitable for those of us that have some experience in the BI area but need to update to new ways of doing our businness.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
3 years, 11 months ago
Great way of learning the nuances in Excel which were not known to me till then. Also good to learn that Mictosoft has planned this course and executed flawlessly.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

6/10 starsCompleted
3 years, 11 months ago
the new features are cool and powerful, but I wonder how many companies can afford office 2016 in 2016, I mean the ones I worked in are in general 6 years later than office. I am also glad to know that MS is providing cloud BI solution---with the little BI solution providers accusing Excel of being slow and limited, I once wondered whether people should still bother learning Excel, given it seems it is no longer in the trend. Now I am assured.
Was this review helpful? Yes0
 Flag
Wally Jamaica profile image
Wally Jamaica profile image

Wally Jamaica

10/10 starsCompleted
3 years, 11 months ago
This course was like so mentally enriching that I had to switch to a different mental bank that insured deposits in full! I would greatly recommend this for Excel power users that have Windows computers.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
3 years, 11 months ago
highly recommend! took the course more out of curiosity as we'd just upgraded our ms office apps & was VERY pleasantly surprised! instructor was engaging & touched upon some very interesting new features that i'd read about but hadnt yet found the time to look into. another great course by ms & well worth the time; many thxs!!
Was this review helpful? Yes0
 Flag
Mateusz Owczarek profile image
Mateusz Owczarek profile image
8/10 starsCompleted
  • 1 review
  • 1 completed
3 years, 11 months ago
I'm glad to learn new things about Excel. I didn't know about most of presented functionalities. Well prepared exercises and assignments. I can recommend this course to semi-advanced users.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
3 years, 11 months ago
Course is amazing, thorough, and well done. I am glad I took this class. Thank-you!
Was this review helpful? Yes0
 Flag
George Grammenidis profile image
George Grammenidis profile image
10/10 starsCompleted
  • 1 review
  • 1 completed
3 years, 11 months ago
It really helps you take Excel one step further! Really interesting. The instructor is understandable and there is a lot of help in order to complete the lab work.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsTaking Now
  • 1 review
  • 0 completed
3 years, 11 months ago
This course is very use full for every user of Microsoft Office. I am thankful to Microsoft and edx.org for providing me the opportunity to enhance my skills through this course. Thank a lot. Muhammad Irfan from Karachi Pakistan
Was this review helpful? Yes0
 Flag
Dario Chirinos profile image
Dario Chirinos profile image

Dario Chirinos

10/10 starsCompleted
4 years ago
Great course! really useful and practical! and the Excel sheets that the instructor provides helps you underteand the material as you watch the videos.
Was this review helpful? Yes2
 Flag
Roberto Vargas profile image
Roberto Vargas profile image

Roberto Vargas

10/10 starsCompleted
4 years ago
I did this course, and I have to say, of all the MOOC's I have enrolled, it's one of the est. More so, right now I made a presentation for my company of this subject using Power BI, and purchased Excel 2016 Pro to keep investigating.
Was this review helpful? Yes2
 Flag
Magaly Hidalgo profile image
Magaly Hidalgo profile image

Magaly Hidalgo

10/10 starsDropped
4 years, 1 month ago
Please could you give this same course in spanish?. I have taken the course, but I left it because is a bit difficult understand in english.
Was this review helpful? Yes1
 Flag
Ghada Waleed profile image
Ghada Waleed profile image

Ghada Waleed

9/10 starsTaking Now
3 years, 11 months ago
Woow I do really like this idea cuz we already know that Excel iz a huge well_known program used widely in analyzing data. .great an goooo ahead. .
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
3 years, 11 months ago
Everything was fine. The instructor used plain English in a way that you could understand even the most difficult part of the course. On the other hand I had some difficulties between the different versions of excel and some times I prayed for one universal version of excel. My valuation is ten to ten for this course and I expect more like this. Thank you. Konstantinos Erotokritakis
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
3 years, 11 months ago
I would like to send a sincere thank to Mr.Dany Hoter and other people that help provide this course to learners like me. The course is well-organized and I have improve my Excel skill a lot.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

6/10 starsCompleted
3 years, 11 months ago
Had some experience with Excel, self taught most of it. The course is simple, it provides a lot of material. The instructor went through the course and explained it well enough. My critic is to the content. It was good, but the testing part of it was way too facilitated. The questions were either too easy or done in the videos.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
3 years, 11 months ago
I recommend this course. The content focuses mainly on showing new functionality of Excel 2016, but also provides nice examples and data. The course is not really difficult and after the course you will be not able to use some really advanced techniques, but the course is perfect for introduction to new Excel functionalities and also you will learn some good practices.
Was this review helpful? Yes0
 Flag
Sergey Zakharov profile image
Sergey Zakharov profile image

Sergey Zakharov

2/10 starsCompleted
3 years, 11 months ago
This course relies so much on PowerPivot add-on, but it doesn't come with the Office 365 home version. And there's no info about this fact. Not in this course, not even on microsoft.com. I had to ask for refund after buying. You need the ProPlus version to use PowerPivot but it is much less affordable.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

6/10 starsCompleted
3 years, 11 months ago
I would advise you to diversify a little bit the questions, and have more "fun" questions by looking for values, and not only 10 questions about "How many rows were imported" (it was better on the last modules).
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
3 years, 11 months ago
The course was perfect. The toucher was clear, and each example was explained really clearly. I learned a lot. I particularly liked labs. Although sometimes the exercises were a little too simple.They were perfect as review. But two levels of exercises for each module (simple - complex), would have been perfect.
Was this review helpful? Yes0
 Flag
Mauricio Sáez profile image
Mauricio Sáez profile image
10/10 starsCompleted
  • 1 review
  • 1 completed
3 years, 12 months ago
Great course, if a have time i will take another microsoft course.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

6/10 starsDropped
3 years, 12 months ago
Using Excel 2013 with addins, but functionality was not compatible with the course material. The instructor was good, but sometime went too quickly and ran sentences together or was unclear when speaking - transcripts were helpful.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
3 years, 12 months ago
Very nice course, new features and capabilities in ms excel for data analysis. I was really impressed about the advancements. course is delivered in a very easy to understand format.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
3 years, 12 months ago
This course was really a good stuff for the working guys who prepares and presents data before audience. Thanks Edx and Microsoft for this course and hope there will be more contents for us in future. Thanks for Dany for his good presentation.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

6/10 starsCompleted
4 years ago
The provider was very good. There could have been more content. However the quizzes and the lab content was very fun. However I felt that the instructor could have taught us more content , drilling in to the nitty gritties of excel and more over instructor could have been more clear in his commuincations. However overall the course was fun.
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.