Analyzing and Visualizing Data with Excel

Provided by:
9/10 stars
based on  1650 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
22650 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
1650 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
Adeniyi Gbadebo profile image
Adeniyi Gbadebo profile image

Adeniyi Gbadebo

10/10 starsCompleted
12 months ago
Great learning experience. I never knew Excel could do this much. Even though I have used Excel for a very long time, this is my first time of knowing about the Excel Data Model.The instructor was good, and the practices helped a lot in the learning process.
Was this review helpful? Yes0
 Flag
Pedro Villagrasa profile image
Pedro Villagrasa profile image

Pedro Villagrasa

10/10 starsCompleted
1 year ago
The course has been very interesting, I have learned a lot. For me the level of difficulty of the quizzes as well as the labs is correct, they make you to work hard. Very pleased with the experience.
Was this review helpful? Yes0
 Flag
Genadi Koychev profile image
Genadi Koychev profile image

Genadi Koychev

10/10 starsCompleted
1 year ago
I find the cours very helpful. The video lectures are very interesting and easy to follow. The exercises are not easy, but very well organized and it is hard to get stuck.
Was this review helpful? Yes0
 Flag
Willians Bernardino profile image
Willians Bernardino profile image

Willians Bernardino

10/10 starsCompleted
1 year ago
When you work with tools that need to be mastered, beyond the previous knowledge we achieved, courses like this provide serious and structured advances on the capability to manage the data and bring ideas based on real world numbers to express reality.
Was this review helpful? Yes0
 Flag
Moushumi Jani profile image
Moushumi Jani profile image

Moushumi Jani

10/10 starsCompleted
1 year ago
Very detailed instructions. The course and the labs are very structured, making the learning an enjoyable experience. I particularly like the way the same data set and industry scenario has been used from the beginning to the end, building on up on the basic analysis to complex dashboards. I now have a new level of respect for the instructor and Excel.
Was this review helpful? Yes0
 Flag
Mutlu IRIS profile image
Mutlu IRIS profile image

Mutlu IRIS

10/10 starsCompleted
1 year ago
I am actively using the information gained in this course and they are shorten my tasks and saving time leads me new courses like this. It is really great to know that and shocked by the capacity of the excel "wow is this also available in excel"
Was this review helpful? Yes0
 Flag
JI CHEN profile image
JI CHEN profile image

JI CHEN

10/10 starsCompleted
1 year ago
Very useful course and illustrates a lot most up to date tools. like the materials they provided and very close to real life.Guiding the way to learn all sophisticated DAXs/Models
Was this review helpful? Yes0
 Flag
Cao Quynh Tam profile image
Cao Quynh Tam profile image

Cao Quynh Tam

10/10 starsCompleted
1 year ago
Very useful course about the most recent powerful tools provided by Excel, such as Pivot Tables, Pivot Charts and Data Models. Very useful course about the most recent powerful tools provided by Excel, such as Pivot Tables, Pivot Charts and Data Models.
Was this review helpful? Yes0
 Flag
Marco Borges profile image
Marco Borges profile image

Marco Borges

10/10 starsCompleted
1 year ago
Very useful course about the most recent powerful tools provided by Excel, such as Pivot Tables, Pivot Charts and Data Models. Very useful course about the most recent powerful tools provided by Excel, such as Pivot Tables, Pivot Charts and Data Models.
Was this review helpful? Yes0
 Flag
Richard Davies profile image
Richard Davies profile image

Richard Davies

10/10 starsCompleted
1 year ago
Excellent course, learnt far more than I expected. Overall the course content was straight forward and easy to understand and follow. As an excel user for many years I was extremely surprised as to how many useful functions this program has that I never knew existed
Was this review helpful? Yes0
 Flag
Gourav Patnaik profile image
Gourav Patnaik profile image

Gourav Patnaik

10/10 starsCompleted
1 year ago
Overall it was a great experience for me to learn and i would recommend the providers to start off with some basics so that one can really grasp from the beginning. And towards the end when things were getting a bit heavy, kindly elaborate it a bit more as whenever someone learns something new it feels a bit surreal to sink everything at once. Thank You !!
Was this review helpful? Yes0
 Flag
veerendra bhadrachalam profile image
veerendra bhadrachalam profile image
10/10 starsCompleted
  • 0 reviews
  • 0 completed
1 year ago
The instructor seems to be an expert but, age factor influencing his way of communicating with the content to be taught. this course is very intrusting as visualization is made easy and made fun.
Was this review helpful? Yes0
 Flag
Chenjerai Madziwa profile image
Chenjerai Madziwa profile image

Chenjerai Madziwa

10/10 starsCompleted
1 year ago
Very interesting course, esp if you want to get an overview of the subject. To get most of the depth you will require to thoroughly review the additional resources that are provided in links for this course.
Was this review helpful? Yes0
 Flag
Reginald profile image
Reginald profile image

Reginald

6/10 starsCompleted
1 year ago
The course has much to improve. The presenter speaks in a dull manner and not engaging. Presentation is often not clear to the point - a MOOC environment requires clearer speech and organisation than in a classroom setting. I often felt left behind when the instructor just continues clicking something on his computer, or things are pre-configured in his computer but not accessible to others. Then we become mere watchers. DAT101x course was far better delivered in these regards.
Was this review helpful? Yes0
 Flag
Ian Davies profile image
Ian Davies profile image

Ian Davies

10/10 starsCompleted
1 year ago
My first EDX course. Very good covering Pivot Tables and Charts, Data models and Visualisation. Needs advanced Excel skills as a pre-requisite before starting. Well designed and well presented.
Was this review helpful? Yes0
 Flag
Shakeel Ahmad profile image
Shakeel Ahmad profile image

Shakeel Ahmad

8/10 starsCompleted
1 year ago
The course content: It was very well-prepared, well sequenced so that we could easily follow the gradual difficulty levels of the training. The Instructor: As always, Sir Dany delivered the lectures in a very easy-to-understand language which helped us learn all the skills and technologies of the course in limited time. The efforts of the provider also were very professional and up to the mark. Thanks Sir Dany and all other team members for the wonder learning experience provided to us in this course.
Was this review helpful? Yes0
 Flag
Muhammad Haleem-ud-din Farooqi profile image
Muhammad Haleem-ud-din Farooqi profile image
10/10 starsCompleted
  • 0 reviews
  • 0 completed
1 year, 1 month ago
Very good learning experience. I have learn some new techniques which make my work easier. Pivot charts and tables are amazing and Dany taught very well
Was this review helpful? Yes0
 Flag
Marcin B profile image
Marcin B profile image

Marcin B

10/10 starsCompleted
1 year, 1 month ago
Very great course regarding the interesting topic. Starting from data analysis, through dashboard, data cubes, up to Power BI functionalities. Now I have more knowledge regarding data visualization in Excel - and this is what I was looking for.
Was this review helpful? Yes0
 Flag
Aziz Wadi profile image
Aziz Wadi profile image

Aziz Wadi

10/10 starsCompleted
1 year, 1 month ago
I was surprised of things we can do in Excel. It is really a rich course. Now I have the competence and confidence to start diving in data and mining for decisions, trends and relations.
Was this review helpful? Yes0
 Flag
Kevin Vandal profile image
Kevin Vandal profile image

Kevin Vandal

10/10 starsCompleted
1 year, 1 month ago
I think the course instructor display incredible knowledge of the course and delivered it well. As for the content, it was fairly introductory but provides a solid foundation. I look forward to future courses through EDX/Microsoft.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
1 year, 1 month ago
Very complete course about Pivot Tables, Pivot Charts, Data models and Visualization. It is a good complement if you already have some knowledge of Excel (tables, formulas). Very good way of learning and same is provide very relevant information about excel and power Bi in details.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 0 reviews
  • 0 completed
1 year, 1 month ago
Very good way of learning and same is provide very relevant information about excel and power Bi in details Very good way of learning and same is provide very relevant information about excel and power Bi in details
Was this review helpful? Yes0
 Flag
Mauro Acuña profile image
Mauro Acuña profile image

Mauro Acuña

6/10 starsCompleted
1 year, 1 month ago
An eye-opening course super help full to get in to modeling data, data analysis and data science. Will definitely help in on business analysis and academic reaserch
Was this review helpful? Yes0
 Flag
Leela Thota profile image
Leela Thota profile image

Leela Thota

8/10 starsCompleted
1 year, 1 month ago
It is simply great, It gave me more tips and tricks to play data as part of regular work. Instructor is shared valuable information. Support is great. Thank you
Was this review helpful? Yes0
 Flag
Luis Mok profile image
Luis Mok profile image

Luis Mok

10/10 starsCompleted
1 year, 1 month ago
It is a great course, it is a great complement to my previous Excel knowledge and it will help me to make better presentations and to analyze data in a better and easy ways.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 0 reviews
  • 0 completed
1 year, 1 month ago
It is an excellent , with so much valuable information. If you need to about all the alternatives to see data in excel this is an excellent to that, also to introduce you to the query world in excel.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 0 reviews
  • 0 completed
1 year, 1 month ago
This is a great source of enhancing your data analytics and visualizing, specially with data models, queries, pivots and power BI. I would recommend this course for those who wish to start a fresh journey in analytics in their career.
Was this review helpful? Yes0
 Flag
Juan Izurieta profile image
Juan Izurieta profile image

Juan Izurieta

10/10 starsCompleted
1 year, 1 month ago
If you are a basic Excel user, this course would get you one step further, it's worthy! Basically it covers two major components: importing and visualizing data, but in the way a lot of nice all-purpose features are reviewed. I would recommend this if you're starting your steps into data analysis. Very nice course!
Was this review helpful? Yes0
 Flag
Andrew Babb profile image
Andrew Babb profile image

Andrew Babb

8/10 starsCompleted
1 year, 1 month ago
Great course to supplement previous knowledge of Excel. My only issue is that some of the sections were difficult and/or confusing, especially if you don't have access to Power Pivot. Would recommend more examples in the future.
Was this review helpful? Yes0
 Flag
Gema Hernandez-Milian profile image
Gema Hernandez-Milian profile image

Gema Hernandez-Milian

8/10 starsCompleted
1 year, 1 month ago
It was pretty interesting but at the very sometimes I got lost because I have some knowledge gaps. Doing the DAT205x course sometimes is not enough. However, is relatively easy to get supplementary information thanks to information provided. The instructor is clear in his explanations
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.