Analyzing and Visualizing Data with Excel

Provided by:
9/10 stars
based on  1800 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
23695 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
1800 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, 7 months 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). If not, maybe I would recommend taking one introduction course before (for example, Data Analysis: Take it to the MAX(), from DelftX University, provided also in edX, quite good).
Was this review helpful? Yes4
 Flag
 profile image
 profile image

2/10 starsCompleted
  • 0 reviews
  • 0 completed
13 hours ago
Hi, Marvels course course about Data models and Visualization. It is a good complement if you already have some knowledge of Excel (tables, formulas). If not, maybe I would recommend,There was a lot to learn about Pivot Tables & Charts, Data Modelling, Power Query, Data Analysis & Visualization, through videos, exercises and reading stuff. Anyone with the some previous knowledge of Excel. Thank you.
Was this review helpful? Yes0
 Flag
R Z profile image
R Z profile image

R Z

10/10 starsCompleted
3 weeks, 6 days ago
Great course. There was a lot to learn about Pivot Tables & Charts, Data Modelling, Power Query, Data Analysis & Visualisation, through videos, exercises and reading stuff. Anyone with the some previous knowledge of Excel can benefit from it.
Was this review helpful? Yes1
 Flag
MANISHCHANDRA PATLE profile image
MANISHCHANDRA PATLE profile image

MANISHCHANDRA PATLE

6/10 starsCompleted
1 week ago
Excellent Course for Beginner and for working in Excel for reports preparation & analysis. Course could have contained more detailed points for in-depth learning.
Was this review helpful? Yes0
 Flag
Andrea Villalobos profile image
Andrea Villalobos profile image

Andrea Villalobos

10/10 starsCompleted
1 week ago
Excelent course. The contentes were very well explained, the lectures were very usefull and gided so that you can complete the surveys by yourself. I was not an expert on the topic and I could complete all the modules with no difficulty. The labs were really usefull to wrap-up what was seen in the lecture and studied in the quiz.
Was this review helpful? Yes0
 Flag
Sam Williams profile image
Sam Williams profile image

Sam Williams

10/10 starsCompleted
1 week, 1 day ago
The content covered was an excellent introduction to using visualisation and analytic techniques using Excel and its partnering software. I felt the instruction was good with the exception of the instructor not being as prepared as he might have been in certain sections. Overall a brilliant course!
Was this review helpful? Yes0
 Flag
amos alayande profile image
amos alayande profile image
10/10 starsCompleted
  • 0 reviews
  • 0 completed
1 week, 1 day ago
The course is excellent as it touches on excel data model and it advantages over using Vlook up to link up tables. It also introduces us to the DAX language and it powerful capabilities just like the SAMEPERIODLASTYEAR Function. And of course the visualization and sharing tools that Power BI provides.
Was this review helpful? Yes0
 Flag
Harry Avila profile image
Harry Avila profile image

Harry Avila

8/10 starsCompleted
1 week, 1 day ago
This was a very nice course. I could learn a lot of different tools that are going to be very helpfull in my tasks and future work. The only thing is that should be updated to this year and also should review some activities because not all the programs of excel are able to perform what is said.
Was this review helpful? Yes0
 Flag
A G profile image
A G profile image

A G

10/10 starsCompleted
1 week, 3 days ago
Great course if you want to improve your data analysis and visualization skills with Excel. It mainly covers Pivot Tables & Charts, Data models and Visualization. The instructor is very competent and his explanations are very clear. Thanks for the great learning experience!
Was this review helpful? Yes0
 Flag
Larry Bokombe profile image
Larry Bokombe profile image

Larry Bokombe

8/10 starsCompleted
1 week, 4 days ago
Quite doubtful at the beginning, i must say that i am relieved to not have abandoned this course. Everything is interesting and knowledge-providing. All elements such as Pivot Charts, Data Model, DAX, Power Bi... are now assets i can improve (by practicing) in order to achieve my education.
Was this review helpful? Yes0
 Flag
Bhuvanesh Eshwar profile image
Bhuvanesh Eshwar profile image

Bhuvanesh Eshwar

10/10 starsCompleted
1 week, 5 days ago
Nice Content. In-depth knowledge by Instructor. Lot many new things learned in this course like,Table, Pivot table with slicer. calculated columns, data modeling. PowerBI. Import data from text, SQL, EXCEL into Excel Modeling. Creating measures in modeling. Using DAX language. Transforming data and Creating dashboards.
Was this review helpful? Yes0
 Flag
Ewelina profile image
Ewelina profile image

Ewelina

10/10 starsCompleted
1 week, 5 days ago
This course was excellent. Lots of useful knowledge and everything was explained in a very simple way. I would strongly recommend this course and will participate in similar trainings in the future.
Was this review helpful? Yes0
 Flag
Dolly Llagas profile image
Dolly Llagas profile image

Dolly Llagas

10/10 starsCompleted
1 week, 4 days ago
Very helpful course especially for Administrative Specialists like me. It would help me to make charts easier and database for massive information. I would love to share this to my officemates so they could also take an online course from edX.
Was this review helpful? Yes0
 Flag
Shamoon Lodhi profile image
Shamoon Lodhi profile image

Shamoon Lodhi

10/10 starsCompleted
1 week, 6 days ago
Overall found very good.ery 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). If not, maybe I would recommend taking one introduction course before (for example, Data Analysis: Take it to the MAX(), from DelftX University, provided also in edX, quite good
Was this review helpful? Yes0
 Flag
Helen profile image
Helen profile image

Helen

10/10 starsCompleted
2 weeks, 2 days ago
Great course - lots of content. Introduction to topics that you can dive deeper in (DAX, CUBE, Power BI). The instructor is knowledgeable and personable.
Was this review helpful? Yes0
 Flag
Israt Jahan profile image
Israt Jahan profile image

Israt Jahan

10/10 starsCompleted
2 weeks, 2 days ago
The course content was great, I really got to learn so many new ways of analyzing and visualizing data in Excel, it surely is making our tasks very easier for us. The instructor has complete knowledge about what he is teaching, his understanding is very clear, thus he was able to deliver the course perfectly.
Was this review helpful? Yes0
 Flag
Haitham Youssef profile image
Haitham Youssef profile image

Haitham Youssef

10/10 starsCompleted
2 weeks, 3 days 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
Was this review helpful? Yes0
 Flag
Ramen Pandey profile image
Ramen Pandey profile image

Ramen Pandey

10/10 starsCompleted
2 weeks, 4 days ago
a Comprehensive course on excel Analyzing and Visualizing skills. It justify the name. Great Content. Great trainer. extremely recommended for every professional.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
3 weeks, 3 days ago
Un curso muy completo y avanzado sobre Modelos de Datos, cómo trabajar con ellos y poder trabajar con los datos para tener un buen análisis de la información.
Was this review helpful? Yes0
 Flag
Andre Tng profile image
Andre Tng profile image

Andre Tng

10/10 starsCompleted
3 weeks, 6 days ago
Clear and detailed course, simple to follow as well. Lab exercises were stimulating and purposeful. I came in knowing nothing about Pivot Tables or data models but now have a good grasp of how to use them for visualisations.
Was this review helpful? Yes0
 Flag
Nur Abdul profile image
Nur Abdul profile image

Nur Abdul

10/10 starsCompleted
3 weeks, 6 days ago
The course very useful and complete for the beginner .Especially on the Pivot, charts. the Exercise is good to try what we have learn from the course. I would recommend the course to others taking one introduction course before (for example, Data Analysis: Take it to the MAX(), from DelftX University, provided also in edX, quite good). Very fruitful content.
Was this review helpful? Yes0
 Flag
Luis Pedro Insua profile image
Luis Pedro Insua profile image

Luis Pedro Insua

10/10 starsCompleted
4 weeks ago
Excellent course. Great if you already have intermediate or advanced Excel skills. As a sales analyst, it took my abilities to another level. I have already built multiple dashboards and managers are very impressed.
Was this review helpful? Yes0
 Flag
Surbhi Gupta profile image
Surbhi Gupta profile image

Surbhi Gupta

6/10 starsCompleted
1 month ago
the person who teaches is bit slow and and some part are less clear. Rest else was good and i really learnt something new from it. would love to practice it in my professional life and enhance my skills using it more and more. Thank You. Very complete course about Pivot Tables, Pivot Charts, Data models and Visualization
Was this review helpful? Yes0
 Flag
Ola Ade profile image
Ola Ade profile image

Ola Ade

10/10 starsCompleted
1 month ago
Awesome!!!!..now its time to practice more. Had basic functional knowledge in excel prior to the course but now feel a lot more different with valuable content I can speak to anywhere. It sure has opened doors to more learning on Data Analysis.
Was this review helpful? Yes0
 Flag
Taylor Pickup profile image
Taylor Pickup profile image

Taylor Pickup

6/10 starsCompleted
1 month ago
The instructor was great and the material he demonstrated was great. However, there is not enough content here to fully prepare someone for the 70-779 exam. The instructor needs to go into a lot more detail to cover the content that the exam will cover.
Was this review helpful? Yes0
 Flag
Laura Atieno profile image
Laura Atieno profile image

Laura Atieno

10/10 starsTaking Now
1 month ago
The course content was amazing. It gave me various ways of using, analyzing and visualizing data in Excel. The Lab lessons also gave me an opportunity to put into practice what I had learned from the videos. The instructor, Dany was amazing in explaining all the various functionalities in Excel. He took his time and took us step by step through the course. Thank you. The provider, EDX, is amazing to give us such a course and it was easy to navigate through the course.
Was this review helpful? Yes0
 Flag
Ayodeji Apampa profile image
Ayodeji Apampa profile image

Ayodeji Apampa

10/10 starsCompleted
1 month ago
The content of the course is suited to help gain a better understanding of the Excel tool. Mr Dany Hoyter does a great job to help break down what could have been an otherwise complex course. Thank you edX for providing this opportunity to help upgrade my skills
Was this review helpful? Yes0
 Flag
Samir Mehdiyev profile image
Samir Mehdiyev profile image

Samir Mehdiyev

10/10 starsCompleted
1 month ago
The course provides good grounds on the subject of data analyses using Excel. Good starting point for the one who plans to use this MS tool for the purpose.
Was this review helpful? Yes0
 Flag
Luisa Rodriguez profile image
Luisa Rodriguez profile image

Luisa Rodriguez

8/10 starsCompleted
1 month ago
The content is good and helpful, a great complement if you already have knowledge. The Instructor explains very clear all the modules. It would be good to have son free quizzes.
Was this review helpful? Yes0
 Flag
Seiban Mohammad profile image
Seiban Mohammad profile image

Seiban Mohammad

10/10 starsCompleted
1 month, 1 week ago
It was great in general. However I have some complaints about two quiz questions: For Module 7 – Quiz 1: I watched the videos and checked the script word by word but didn't see anything about the second option of question 1 . However, (unfortunately after I got it wrong) I checked the link provided for the lecture (which I thought is only for extra information about the topic) and found that the answer was written there. This is really unfair as I got all my previous answers correct and this one was the first one that I couldn't get it right because of this. I think from the very beginning you should have stated that the links are mandatory to study from. Otherwise, we shouldn't be punished for something we thought optional. As for Module 8 – Quiz1: (Question1): In the video, there is no single word about sharing the reports between users using BI. Again, I lost the mark for this question because of such unfair question that contain... It was great in general. However I have some complaints about two quiz questions: For Module 7 – Quiz 1: I watched the videos and checked the script word by word but didn't see anything about the second option of question 1 . However, (unfortunately after I got it wrong) I checked the link provided for the lecture (which I thought is only for extra information about the topic) and found that the answer was written there. This is really unfair as I got all my previous answers correct and this one was the first one that I couldn't get it right because of this. I think from the very beginning you should have stated that the links are mandatory to study from. Otherwise, we shouldn't be punished for something we thought optional. As for Module 8 – Quiz1: (Question1): In the video, there is no single word about sharing the reports between users using BI. Again, I lost the mark for this question because of such unfair question that contains an answer not mentioned in the video Also, I got one option correct (the one was mentioned in the video) but didn't get the score for this question because I had to get two options correct. I'm really disappointed I hope these two questions to be revised and not to deduct marks from me as I got at least the answers/options mentioned in the videos correct. I really aimed to get the full mark in all quizzes and Lab sections but I was frustrated and disappointed by losing two precious scores for the above mentioned reasons.
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.