Analyzing and Visualizing Data with Excel

Provided by:
9/10 stars
based on  1852 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
24255 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
1852 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
Ayodeji Ayeni profile image
Ayodeji Ayeni profile image

Ayodeji Ayeni

8/10 starsCompleted
10 months, 3 weeks ago
Interesting course content. I like the Lab questions as they are require you to understand the videos. I expect a bit more on power BI and SQL. I also would like to learn more about DAX and Max.
Was this review helpful? Yes0
 Flag
CARLOS ORTEGA JIMENEZ profile image
CARLOS ORTEGA JIMENEZ profile image

CARLOS ORTEGA JIMENEZ

10/10 starsCompleted
10 months, 3 weeks ago
Very useful course to introduce the EXCEL DATA MODEL and the way of working useful to get advantage of it. Thanks . The examples used in the labs are very useful as templates for reference in case you need to apply the knowledge later and to secure the right appliance. The references provided by the course are also very interesting to expand the knowledge. THANKS
Was this review helpful? Yes0
 Flag
Erwin Welbergen profile image
Erwin Welbergen profile image

Erwin Welbergen

10/10 starsCompleted
10 months, 4 weeks ago
Very clear content, well built up, as a 'novice' to Power Query and Power pivots I had no problem keeping up and answering most quizz questions correctly. The host has a very pleasant en patient way of delivering the material. I particularly like the 'natural feel' of the course. As a basis for follow up courses I will surely continue with it. I actually enrolled to solve a few problems I had with making reports for a company, and I am now confident I can solve these problems with what I have learned.
Was this review helpful? Yes0
 Flag
Kevin Holston profile image
Kevin Holston profile image

Kevin Holston

10/10 starsCompleted
11 months ago
I enjoyed the course and learned more about features/functionality (Pivot tables, pivot charts, slicers), data models and DAX. I liked Mr. Dany Hoter as an instructor.
Was this review helpful? Yes0
 Flag
Olusegun Oladejo profile image
Olusegun Oladejo profile image

Olusegun Oladejo

10/10 starsCompleted
11 months ago
A very complete and comprehensive course, easy to learn and follow as well. Mr. Dany Hoter was a good presenter and the Lab environment was seamless and conducive for learning. Great job for those who put these resources together.
Was this review helpful? Yes0
 Flag
JIN SUNG CHOI profile image
JIN SUNG CHOI profile image

JIN SUNG CHOI

8/10 starsCompleted
11 months ago
I had seen Pivot table from someone, however I had poor knowledge of Pivot table before taking this course "Analyzing and Visualizing Data with Excel"
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

8/10 starsCompleted
11 months ago
This course is highly recommended for beginners and people with basic Excel knowledge and provides useful tools to upgrade your Excel reports. I did not know Power Query and Power Pivot before, and they can really make your life easier.
Was this review helpful? Yes0
 Flag
Azizbek Mamajonov profile image
Azizbek Mamajonov profile image

Azizbek Mamajonov

8/10 starsCompleted
11 months ago
I have learnt a lot from this course. It was useful for me in terms of structuring data and its visualizing. Also, there were some parts which were not clearly explained in detail. Overall I have acquired a lot of essential skills in working with Excell.
Was this review helpful? Yes0
 Flag
Satyam Tripathi profile image
Satyam Tripathi profile image

Satyam Tripathi

10/10 starsCompleted
11 months ago
Attending this course was a seamless experience for me. Although I am new to data analysis, but learning got easier because of the way this course was delivered.
Was this review helpful? Yes0
 Flag
Satyam Tripathi profile image
Satyam Tripathi profile image

Satyam Tripathi

10/10 starsCompleted
11 months ago
Attending this course was a seamless experience for me. Although I am new to data analysis, but learning got easier because of the way this course was delivered.
Was this review helpful? Yes0
 Flag
Daniel Aliu profile image
Daniel Aliu profile image

Daniel Aliu

10/10 starsCompleted
11 months, 1 week ago
This is a very useful course; the lectures with practical material and lab exercises and instructions to help students practice what was thought, Microsoft Excel is very packed. All these delivered for free! Thank you Microsoft, thank you EdX.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsTaking Now
11 months, 1 week ago
Quizzes and labs instructions are important to fully understand the content of the modules. You learn important tools to analyse data. I highly recommend to take the course.
Was this review helpful? Yes0
 Flag
Student SG profile image
Student SG profile image

Student SG

10/10 starsCompleted
11 months, 1 week ago
A very good starting point for learning excel. Quizzes and labs instructions are so simple for people without prior experience to follow. It is also a good way to check in whether your current excel knowledge Would highly recommend me to take this.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
11 months, 2 weeks ago
I learnt a lot from this course!! The speed is alright nut appreciate if the volume is made much higher. I have maxed my desktop's volume, yet it is not loud enough at times. Love this course!
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
11 months, 2 weeks ago
Very good, clear and concise explanation of the Power features within Excel. Saves a great deal of time compared to other inconcise internet tutorials
Was this review helpful? Yes0
 Flag
Martin Abramson profile image
Martin Abramson profile image

Martin Abramson

10/10 starsCompleted
11 months, 2 weeks ago
I very much liked the instructor. Very informative videos. Good start to be able to proceed with Excel and visualization of data. Will return to other courses in this subject
Was this review helpful? Yes0
 Flag
wongsakorn watcharananunt profile image
wongsakorn watcharananunt profile image

wongsakorn watcharananunt

8/10 starsCompleted
11 months, 2 weeks ago
Now, The office 365 is using. This course a bit out of date from the current feature. However, it is a good knowledge and foundation. I am ok with this course
Was this review helpful? Yes0
 Flag
S Chavan profile image
S Chavan profile image

S Chavan

8/10 starsCompleted
11 months, 3 weeks ago
Very well explained and demonstrated and advanced course.Instructor is really good and has clear speech and didn't hurry.Detail Explanation and lab materials.
Was this review helpful? Yes0
 Flag
Mazin Mohammed Roof profile image
Mazin Mohammed Roof profile image

Mazin Mohammed Roof

6/10 starsCompleted
11 months, 3 weeks ago
it have a lot of material but we need more example to keep everything in mind the instructor was good in coveting most of staff but the number of material is not enough.
Was this review helpful? Yes0
 Flag
Ronald Castillo profile image
Ronald Castillo profile image

Ronald Castillo

10/10 starsCompleted
11 months, 4 weeks ago
I have learned a lot from this course and the instructor did a very good job. The only minor challenger I have is the downloading of database in SQL server.
Was this review helpful? Yes0
 Flag
Sanglap Basu profile image
Sanglap Basu profile image

Sanglap Basu

10/10 starsTaking Now
12 months ago
Using this course, I got to learn many new dimensions of MS Excel which I have never heard or seen before. Now I feel Excel is a very powerful tool for data analysis and visualization. this will help me in a great way in the near future. Thanks to edX for providing such great learning online and also free to access.
Was this review helpful? Yes0
 Flag
Jerilyn Loria profile image
Jerilyn Loria profile image

Jerilyn Loria

10/10 starsCompleted
12 months ago
Even as a veteran Excel user, I learned many new things taking this course. Well constructed and easy to get through. For me it was worth the money. There are several items I will be putting directly to use in my job. Thank you!
Was this review helpful? Yes0
 Flag
Sridar Kannan profile image
Sridar Kannan profile image

Sridar Kannan

10/10 starsCompleted
1 year ago
A very useful course for lawyers who want to diversify into data and financial analysis. The course was cheap, and thus helped me finally obtain an excel certificate. The skills imparted are also very useful for presentations, and for corporate functions; the visualizations are a powerful tool.
Was this review helpful? Yes0
 Flag
Mohamad Shoshara profile image
Mohamad Shoshara profile image

Mohamad Shoshara

8/10 starsCompleted
1 year ago
The course is great, but it should have some videos or some notes about the financial measurements (pointers). As an economist, everything was clear to me but I think it could make some confusion if the student does not have any background in economics or accounting. Thanks Danyy you wear great.
Was this review helpful? Yes0
 Flag
Max profile image
Max profile image

Max

8/10 starsCompleted
1 year, 1 month ago
The content was great introduction into data analysis and visualizations. The lab experience is well structured and easy to follow allowing for one to grasp how to apply the techniques practically in the work place and business.
Was this review helpful? Yes0
 Flag
Qi Chu profile image
Qi Chu profile image

Qi Chu

10/10 starsCompleted
1 year, 1 month ago
Good interaction with the speaker. Pivot Tables, Pivot Charts, Data models and Visualization. It is a good complement if you already have some knowledge of Excel (tables, formulas).
Was this review helpful? Yes0
 Flag
Davide Pavan profile image
Davide Pavan profile image

Davide Pavan

8/10 starsCompleted
1 year, 1 month ago
With Excel 2016, you can publish your Excel workbooks right to your Power BI site, where you can create highly interactive reports and dashboards based on your workbook’s data. You can then share your insights with others in your organization.
Was this review helpful? Yes0
 Flag
Jesvine Patric profile image
Jesvine Patric profile image
8/10 starsCompleted
  • 1 review
  • 1 completed
1 year, 1 month ago
Informative and systematically explained. Data models, Pivots and visualizations explained in detail. Content is simple and easy to understand. Rather than just academic level theories, it's more into the practical level and can be applied to daily work modules. Modules on data models was way beyond informative and ease to go. It had been better if we could have got solutions to the exercises.
Was this review helpful? Yes0
 Flag
Hugo Sundqvist profile image
Hugo Sundqvist profile image

Hugo Sundqvist

8/10 starsCompleted
1 year, 1 month ago
Good explanations in the lectures, easy to follow, good content.It had been better if we could have got solutions to the exercises. Good if you have some basic knowledge of excel before starting this course.
Was this review helpful? Yes0
 Flag
Kingsley Nwachukwu profile image
Kingsley Nwachukwu profile image

Kingsley Nwachukwu

10/10 starsCompleted
1 year, 1 month ago
Great course, simple to understand, concise and straight to the point. The advanced features of Excel I learnt in this course will always be useful in my work and personal life. Quiz questions were quite interesting also.
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.