Analyzing and Visualizing Data with Excel

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

10/10 starsCompleted
4 years, 1 month ago
Covering some of the complex elements in excel such as DAX, CUBE function, Dashboard, data visualization, pivot tables and data models, importing data from different sources, added a real value to my experience with Excel , whatever your experience with Excel it’s a must take course.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years, 1 month ago
Course covers new functionalities available in latest version of Excel which ease Data Analysis and Visualisation. Dany Hoter has done a great job to take us through the functionalities! Microsoft actually added the WOW factor by throwing in Power BI and Mobile App!
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 1 month ago
The Content was relevant and lab exercises provided good learning opportunities. Delivery was excellent. The quizzes provided good coverage of the material.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

6/10 starsCompleted
  • 1 review
  • 1 completed
4 years, 1 month ago
Assignments and the content in the video should not be same. If it is possible please try to provide a completely different set of data in the assignments. Overall really appreciative and it kindled a spark of interest to learn.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 1 month ago
Unfortunately I could not take most of labs since lots of functionalities were not supported by Mac so I suggest to develop a fully supported version since installing a Windows on my Mac would be expensive.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 1 review
  • 1 completed
4 years, 1 month ago
All is Perfect ! Thanks you Microsoft ! I learned a lot from this course and enjoy analyzing data with Excel ! The way the assignment are perfect hope there were more and more difficult one ! Thank you Greeeting from Tunisia
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 1 month ago
As a business analyst, I am mostly familiar with the subject. However, this course was very useful to me in order to learn the new features of Excel 2016. I usually build data models in MS Access and connect them to Excel. For small subsets of data, this can be done in Excel. I am interested to increase my knowledge in DAX and PowerBI. The course is very well organized and the labs provide hands-on which is a great way to remember what was explained. I would recommend it for people with some analytic experience.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years, 1 month ago
Course is a very impressive demonstration of new capabilities of Excel 2016 and attendant tools. And feeling of capabilities of the new version is mostly positive. Some negative impression take part at achieving of correct work of Excel 2016 together with Excel 2010. Instructor's materials was very clear. But some part of assestments have ambiguities in the explanations or answers. In the sum, course increased my love to the MS Excel.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 1 month ago
It was quite difficult, and time-consuming, to connect and upload some course files etc. This could cause people to drop out doing the course in frustration, so should be reviewed. I managed to hang-in there, so it turned out okay for me. Otherwise the course was very good.
Was this review helpful? Yes0
 Flag
Amy Nguyen profile image
Amy Nguyen profile image

Amy Nguyen

8/10 starsCompleted
4 years, 1 month ago
This course overaly is good but could be better. I am taking this course to equip myself with data manipulation and data analysis skill and most of my knowledge is from precious work experience and informal self-studying. I love the first 3 sets of modules from the course which provide me practical and effective approach to PowerView and PowerQuery and DAX (I am really excited to learn these!). The last part is a bit PR for Microsoft product which is not necessarily relevant to what I want (but good to know actually). I wish they had provided more difficult finger excercise or problem set to help enhance my learning experience. The example data provided in the course is excellent. I am able to keep all these files to play around with what I learned. I vote 4 star for the instructor because I feel like he is a really knowledgeable and data analyst and programmer, and 1 star lost is because of his style of narration (maybe he has a sor... This course overaly is good but could be better. I am taking this course to equip myself with data manipulation and data analysis skill and most of my knowledge is from precious work experience and informal self-studying. I love the first 3 sets of modules from the course which provide me practical and effective approach to PowerView and PowerQuery and DAX (I am really excited to learn these!). The last part is a bit PR for Microsoft product which is not necessarily relevant to what I want (but good to know actually). I wish they had provided more difficult finger excercise or problem set to help enhance my learning experience. The example data provided in the course is excellent. I am able to keep all these files to play around with what I learned. I vote 4 star for the instructor because I feel like he is a really knowledgeable and data analyst and programmer, and 1 star lost is because of his style of narration (maybe he has a sore throat or so???). Anyway, I highly recommend this course for people who has little or no experience with data analysis and visualization tools such as PivotChart/Table, PowerPivot, PowerQuery... This would be an inspiring start for you to work with advanced Excel tools and other data analysis apps from Microsoft.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 1 review
  • 1 completed
4 years, 1 month ago
Great course that opened up a whole world of Excel, (Power Pivot, Power Query) I was aware of but did not understand what it was or would be used for. Seeing a diagram view of a data model and recognising database like relationships, it dawned on me how powerful BI is and how much easier it is than using Excel front end, Access back end VBA driven tools. Also a great course showing off the capabilities of Excel 2016 and I will be looking to subscribe to Office 365
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years, 1 month ago
Fantastic course. I liked everything about it: pace, depth, instructor. I would recommend the same course to most of my colleagues. The examples were clear and the explanations fantastic. The instructor was clear in his presentation.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 1 month ago
Great class! Gives a great overview of Pivot Tables, Queries and Pivot Charts. I had only heard about those things but never got to use them and this class really opened up my eyes to the power of Excel. I can not wait to use the skills I learned in my work and to show off to colleagues.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 1 month ago
This course can provide new tools and skills for the advanced Excel user to add to their toolkit. The new functionalities incorporated into Excel effectively reduce the number of applications that users have to maintain in order to facilitate a seamless data collection, analysis, and visualization process- with outstanding results!
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years, 1 month ago
Very good one! Perhaps, a greater variety of exercises and examples (or applications) (other than sales) would enrich it. To make available additional material to explore in more detail the contents, is also a very good idea put in practice in the course that should be deepened.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 1 month ago
overall nice course to get start in data analytic. Content, modules, presentation well organized. I would recommend this course to business-data learners.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years, 1 month ago
Great topic, high relevance, could be providing more challanges and deep dives into DAX, Power BI etc. Edx.org is a great plattform, my first course there but already booked 3 more. Will continue using this side. The instructor seems sometimes a little sloppy with his speech but when you have done this kinds of screencast und audio shots yourself you realize how tough it is.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

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

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.