Analyzing and Visualizing Data with Excel

Provided by:
9/10 stars
based on  1812 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
23843 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
1812 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
Mary Mohammad profile image
Mary Mohammad profile image

Mary Mohammad

10/10 starsCompleted
2 months, 4 weeks ago
It was amazing. It was described very well. Specially for a beginner like me. I did not realize that we can do a variety of works like that in EXCEL and I really surprized.
Was this review helpful? Yes0
 Flag
Juan Bengochea profile image
Juan Bengochea profile image

Juan Bengochea

8/10 starsCompleted
2 months, 4 weeks ago
The course was overall very good. They show us the capabilities of the new tools like power query and power pivot, this is a totally new aspect of excel.
Was this review helpful? Yes0
 Flag
Shuvro Kumar Paul profile image
Shuvro Kumar Paul profile image
10/10 starsCompleted
  • 0 reviews
  • 0 completed
2 months, 4 weeks ago
Really an informative course for DAX language and PowerPivot with Data Models and Visualization. This course has very good contents if you have the already some Excel skills. Its my recommendation to take Introduction to Data Analysis Course before taking that for someone who doesn't have basic Excel knowledge. Overall it is a very good course for Advance Users.
Was this review helpful? Yes0
 Flag
Parth Desai profile image
Parth Desai profile image

Parth Desai

6/10 starsCompleted
2 months, 4 weeks ago
It was difficult to me in begening of courese because I did not knot what is CSV, DAX, Database etc. All are IT terms and I am not from IT background. Formula or DAX are rational not in details like how it works. I think this is like introduction course.
Was this review helpful? Yes0
 Flag
Music on Single Strums profile image
Music on Single Strums profile image
8/10 starsCompleted
  • 0 reviews
  • 0 completed
3 months ago
I really liked the way the course was kept concise and to the point. The instructor had a thorough knowledge of the subject and it was clearly visible as well.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

8/10 starsCompleted
3 months ago
Good course though it is clearly getting a little dated. With the growth of PowerBI and other similiar tools it will be interesting to see whether the use of Pivottables and other BI capabilities in Excel will be supplanted by these newer tools which offer more flexibility.
Was this review helpful? Yes0
 Flag
Alpha profile image
Alpha profile image

Alpha

10/10 starsCompleted
3 months ago
it is very interesting in terms of content, actually it is the first time i felt that it's worth the money. however the instructor skipped some information that very important to know. like how to show the result with a underlined sentence.
Was this review helpful? Yes0
 Flag
Abhay Prakash Pandey profile image
Abhay Prakash Pandey profile image

Abhay Prakash Pandey

10/10 starsCompleted
3 months ago
This is really nice & helpful for me in the job, because I am very poor in excel. It is a good complement if you already have some knowledge of Excel (tables, formulas).
Was this review helpful? Yes0
 Flag
Harsh Joshi profile image
Harsh Joshi profile image

Harsh Joshi

10/10 starsCompleted
3 months ago
This is really nice & helpful for me in job, because i am very poor in excel. After completing this course i feel confident and comfortable to work in the Excel.
Was this review helpful? Yes0
 Flag
Nikunj Bagaria profile image
Nikunj Bagaria profile image

Nikunj Bagaria

8/10 starsCompleted
3 months ago
The course was a helpful to enhance and learn many features of MS Excel. It has been designed with all pre-loaded files which were used in training videos which further helped us to understand the trainer by doing the steps along with the video.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
3 months ago
Thank you very much to provide such a good course. I can explore more functions using of excel. Hope to see more advance excel course like this in the future.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
3 months ago
Thank you for the course! It was very interesting and inspiring. I explored very new world for me (incl beauty of pivot charts, pivot tables, data model, transformation of data to convenient forms, etc).
Was this review helpful? Yes0
 Flag
Chigozie Francis profile image
Chigozie Francis profile image
8/10 starsCompleted
  • 0 reviews
  • 0 completed
3 months ago
I have it very helpful and meaningfully re-skills ones abilities on Excel.I really love the idea that I could directly apply all the knowledge that I have acquired in this course in Power BI.I think going forward about getting the full benefits of using the power BI and sharing it with my friends and fellow staff.
Was this review helpful? Yes0
 Flag
Gaurav Goel profile image
Gaurav Goel profile image

Gaurav Goel

10/10 starsCompleted
3 months ago
It's the best way to learn visualizations, even Power BI looks quite easier now, after this training. It's quite comprehensive and exercised along with tips are quite useful to grasp the content of the video.
Was this review helpful? Yes0
 Flag
Michelle Earle profile image
Michelle Earle profile image

Michelle Earle

10/10 starsCompleted
3 months ago
This course was very informative! I use Power Query and Power Pivot in my job daily, this course has helped me in improving my skills and knowledge. I learned a lot from Dany! Thank you!
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

8/10 starsCompleted
3 months, 1 week 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).
Was this review helpful? Yes0
 Flag
C D profile image
C D profile image

C D

10/10 starsCompleted
3 months, 1 week ago
Excellent material and organisation, the only drawback is that some videos stopped from time to time and had to play 5 seconds forward to continue watching.
Was this review helpful? Yes0
 Flag
Eric Ndofor profile image
Eric Ndofor profile image

Eric Ndofor

10/10 starsCompleted
3 months, 1 week ago
Great content and videos; quite easy to follow. Looking forward to more courses. However, if possible please zoom in the Excel sheets for better visibility.
Was this review helpful? Yes0
 Flag
Catherine P profile image
Catherine P profile image

Catherine P

10/10 starsCompleted
3 months, 1 week ago
This class is very helpful! I learned loads that I can take back to my job and actually use in real world situations. If you're going to take it (which I fully recommend), be sure to take notes! This course prepares you for going on and learning more with PowerBI and makes you eager to learn more about Data Science in general!
Was this review helpful? Yes0
 Flag
Greg Hcs profile image
Greg Hcs profile image

Greg Hcs

10/10 starsCompleted
3 months, 1 week ago
Very useful course in order to start digging into excell capabalitites for analysing data. It helps a lot to create consistent dashboards. Thank you!
Was this review helpful? Yes0
 Flag
Aya Alsharafi profile image
Aya Alsharafi profile image

Aya Alsharafi

2/10 starsCompleted
3 months, 1 week ago
Honestly, I am not really satisfied. According to the objectives I thought that I will learn more and the content did not match the objectives. specially the first few modules. Power BI seems interesting but you did only advertise for the software rather than teaching. You should have mentioned that I won't be able to practice many of the modules because I am using a MacBook where I could not view many data sheets. Thus, I could not solve plenty of quizzes and I lost a lot of scores.
Was this review helpful? Yes0
 Flag
Aya Alsharafi profile image
Aya Alsharafi profile image

Aya Alsharafi

2/10 starsCompleted
3 months, 1 week ago
Honestly, I am not really satisfied. According to the objectives I thought that I will learn more and the content did not match the objectives. specially the first few modules. Power BI seems interesting but you did only advertise for the software rather than teaching. You should have mentioned that I won't be able to practice many of the modules because I am using a MacBook where I could not view many data sheets. Thus, I could not solve plenty of quizzes and I lost a lot of scores.
Was this review helpful? Yes0
 Flag
Asenowo Olumide profile image
Asenowo Olumide profile image
10/10 starsCompleted
  • 0 reviews
  • 0 completed
3 months, 1 week ago
The course is a complete package. Audible and well grounded tutor... The materials and the content of the course/series really made the course easier.
Was this review helpful? Yes0
 Flag
Alina Bukato profile image
Alina Bukato profile image
10/10 starsCompleted
  • 0 reviews
  • 0 completed
3 months, 1 week ago
This course is so cool and amazing! I 'm often work with excel due to my job. And i really learned things i never knew about excel and data analyzing. Dany, you are the best instructor ever.
Was this review helpful? Yes0
 Flag
Mina Hanna Mikhael profile image
Mina Hanna Mikhael profile image
10/10 starsCompleted
  • 0 reviews
  • 0 completed
3 months, 2 weeks ago
This is course is amazing, i learnt thing i never knew about excel and date analyzing, Dany is quite good and very presentable, and the content is such very rich.
Was this review helpful? Yes0
 Flag
SHK OS profile image
SHK OS profile image

SHK OS

8/10 starsCompleted
3 months, 2 weeks ago
The content was satisfactory, instructor was clear , natural and seem to have a full grasp on conveying the content. I recommend this course to anyone interested in enhancing their knowledge.
Was this review helpful? Yes0
 Flag
Abisola Ogunrinde profile image
Abisola Ogunrinde profile image

Abisola Ogunrinde

10/10 starsCompleted
3 months, 2 weeks ago
This is a great course for you to learn analyzing and visualizing data with Excel. Very practical as well. The course is well structured as well. I would recommend taking this course to everyone interested.
Was this review helpful? Yes0
 Flag
Nisha Verma profile image
Nisha Verma profile image

Nisha Verma

6/10 starsCompleted
3 months, 2 weeks ago
I had prior knowledge about Excel and this course helps to enhance my knowledge. I liked the way the course is structured, however i think few topics can be explained in more detail.
Was this review helpful? Yes0
 Flag
Eric Johnson profile image
Eric Johnson profile image

Eric Johnson

10/10 starsCompleted
3 months, 2 weeks ago
A fantastic class that I would recommend to other colleagues. I've already significantly reduced the amount of time I spend wrangling data. Thank you!
Was this review helpful? Yes0
 Flag
Onyeka Maduabum profile image
Onyeka Maduabum profile image

Onyeka Maduabum

6/10 starsCompleted
3 months, 2 weeks 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? 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.