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

9/10 starsCompleted
4 years, 7 months ago
Fantastic course, easy to understand and lot of capabilities that can be implemented in the work environment.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 1 review
  • 1 completed
4 years, 7 months ago
It was my first but an awesome experience. I would love to go beyond and add on this learning experience. The content of the course was well balanced with desired rhythm and flow for a distant learner. The instructor was immensely powerful in delivering the intended objective of each module. I found very good connection between the modules in terms of content and logic. It was wonderfully designed. On top, the organization of the entire course was impressive. This was the first time i witnessed such a great logical and learning oriented module in terms of segments in each module i.e. video tutorial, quiz, additional content, ppt presentation, discussion forum and scenarios.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years, 7 months ago
For an absolute beginner, it's pretty difficult to understand the real word application in business analysis but it gives an exposure as to what you can do in excel. The content is straight forward and the lab exercises go hand in hand with the lecture videos. You can immediately put your skills to use in the lab module.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years, 7 months ago
I'm very satisfied. My knowledge of Excel was only with previous versions before 2010. The lectures were easy to understand and the lecturer Mr. Dany Hoter is very knowledgeable. I would suggest that more exercises would help people familiarize themselves with Excel 2016.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 7 months ago
Great class. I use Excel for work regularly, but only have a moderate level of proficiency. This class focused on more advanced topics, but also helped me gain experience with some of the intermediate level items that I haven't been as familiar with as I would have liked. Definitely can recommend it.
Was this review helpful? Yes0
 Flag
Branavi Balasingam profile image
Branavi Balasingam profile image
8/10 starsCompleted
  • 1 review
  • 1 completed
4 years, 7 months ago
The course was excellent.I got a chance to learn new things regarding Excel.The instructor gave us a clear understanding about the DAX expressions.Enjoyed the session.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years, 7 months ago
Satisfied. The content was good, assignments were real and real usage of Excel was applied. Very interactive. Could have skipped the last module no. 8 which was more of a advertisement of microsoft products but I guess that is part of the game:) thanks anyways I really enjoyed it.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 7 months ago
Dany and team provide a good introductory level course (intermediate level in places). I found it a very useful exploration of the Power Pivot and Power Query
Was this review helpful? Yes0
 Flag
 profile image
 profile image

8/10 starsCompleted
  • 1 review
  • 1 completed
4 years, 7 months ago
I improve my excel level. Good in general. May be I need to clarify the statements of some practices. But the rest is quite good.
Was this review helpful? Yes0
 Flag
Agus S'to profile image
Agus S'to profile image
8/10 starsCompleted
  • 1 review
  • 1 completed
4 years, 7 months ago
The content of this course was very good. The instructor was also have excelent ecperiences. Thanks for the course. I got a lot of experience from this course.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 7 months ago
Everything was great! The material about new features of Excel 2016 is just awesome, as features are by themselves. I really enjoyed studying course and i want such cool T SHIRT with "I simply Excel", as Dany has!)))
Was this review helpful? Yes0
 Flag
 profile image
 profile image

8/10 starsCompleted
  • 1 review
  • 1 completed
4 years, 7 months ago
Everything is great about this course. The content, the instructor and the providers have done a wonderful job. Although the course is not for beginners but the use of scenarios in the example have made it easier for all level of people to assimilate. I recommended this piece for everybody who need to learn or invest in the areas of data management and presentation.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsTaking Now
4 years, 7 months ago
The course content itself was excellent. There was a lot of useful information brought forth and a lot of tips and tricks for Excel users who do daily analysis. After module 4 it became difficult for me to follow though. I just couldn't make complete sense of some things that were being said. At some points I knew what to do but didn't fully understand what I was doing and at other points I understood what needed to be done but not really how to do it. I'd have to listen to the lectures more than once to pick up key things that were being asked in the quizzes. There was a lot of circle talk and unfinished sentences so I just couldn't follow sometimes but these are my own personal struggles with this course. It was a great course and I'd recommend it to Excel users.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years, 7 months 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, 7 months 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, 7 months 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, 7 months 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, 7 months 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, 7 months 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, 7 months 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, 7 months 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, 7 months 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, 7 months 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, 7 months 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, 7 months 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, 7 months 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, 7 months 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, 7 months 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, 7 months 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, 7 months 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

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.