Analyzing and Visualizing Data with Excel

Provided by:
9/10 stars
based on  1855 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
24287 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
1855 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
Harshada Tapale profile image
Harshada Tapale profile image

Harshada Tapale

10/10 starsCompleted
10 months, 2 weeks ago
It was really good . I learned allot from this my excel knowledge was not so good earlier but now by this course i can definitly say i can do now. 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
Camilo Reyes profile image
Camilo Reyes profile image
10/10 stars
  • 0 reviews
  • 0 completed
10 months, 2 weeks ago
Good step by step and examples. It would be great to be able to check on the progress and answers of the quizzes when the course is done in audit mode
Was this review helpful? Yes0
 Flag
Juan Lopez profile image
Juan Lopez profile image

Juan Lopez

10/10 starsCompleted
10 months, 3 weeks ago
Very complete. Each topic explained in a general but interesting way which encourage us to continue learning more. Very clear and easy to learn. Thanks a lot
Was this review helpful? Yes0
 Flag
Mayursinh Rana profile image
Mayursinh Rana profile image

Mayursinh Rana

6/10 starsCompleted
10 months, 3 weeks ago
This Course is useful But I think, In Content more Hyperlink is there and feel like Boaring.In course, get the knowledge of Excel Function like power pivot,Power Query,Data Model etc.
Was this review helpful? Yes0
 Flag
ANUP GEDIYA profile image
ANUP GEDIYA profile image

ANUP GEDIYA

8/10 starsCompleted
10 months, 3 weeks ago
Course very helpful to touch the new horizon and understanding the detail concept of EXCEL data handling by using the features like Power Pivot, Power query, Data Model etc.
Was this review helpful? Yes0
 Flag
Thanigaivel MANIKANNAN profile image
Thanigaivel MANIKANNAN profile image

Thanigaivel MANIKANNAN

10/10 starsCompleted
10 months, 3 weeks ago
Very good course for Power Pivot, data import and pivot table features. Has required content and Lab exercises. Highly recommended for those interested to learn about Power Pivot and Excel Data Model
Was this review helpful? Yes0
 Flag
Sara profile image
Sara profile image

Sara

8/10 starsCompleted
10 months, 3 weeks ago
This course helped me to learn more about analyzing and visualizing data in Excel. The course was well-paced and I appreciated the step-by-step model that the instructor followed. I had relatively basic knowledge of the material and was able to follow along. would have enjoyed a few more labs/real world scenarios to practice my new skills, but I guess that's what my job is for?! Thanks to all for the experience!
Was this review helpful? Yes0
 Flag
Konyegwachie Chukwuma profile image
Konyegwachie Chukwuma profile image
10/10 starsCompleted
  • 2 reviews
  • 2 completed
10 months, 3 weeks ago
The course was a big eye-opener into data modeling, power query, pivot tables, and lots more. I never knew Excel could do so much and much more. I would recommend this course for anyone that wants to further his/her knowledge of Data Analysis. Thankyou Dany so much and Thankyou Microsoft.
Was this review helpful? Yes0
 Flag
Akash Kolge profile image
Akash Kolge profile image

Akash Kolge

8/10 starsCompleted
10 months, 4 weeks ago
It was very helpful although i am a beginner i was able to understand and learn much from it. The contents provided were new to me and difficult to grasp all of it, but it was understandable.
Was this review helpful? Yes0
 Flag
Akash Kolge profile image
Akash Kolge profile image

Akash Kolge

8/10 starsCompleted
10 months, 4 weeks ago
It was very helpful although i am a beginner i was able to understand and learn much from it. The contents provided were new to me and difficult to grasp all of it, but it was understandable.
Was this review helpful? Yes0
 Flag
PARTH PATEL profile image
PARTH PATEL profile image

PARTH PATEL

8/10 starsCompleted
10 months, 4 weeks ago
It was a very useful experience for upgrading self knowledge and learn advance technologies required in day today's continuous upgrading world. As excel is the must required for presenting reports and file
Was this review helpful? Yes0
 Flag
Maryam Junaid profile image
Maryam Junaid profile image

Maryam Junaid

8/10 starsCompleted
10 months, 4 weeks ago
perhaps add more theory for the DAX formulas etc however there are a lot of helpful aspects such as the visualization of data using reports and dashboards etc.
Was this review helpful? Yes0
 Flag
Wu Derek profile image
Wu Derek profile image

Wu Derek

8/10 starsCompleted
11 months ago
very helpful course. Let me learn more about how to analyze and visual data with Excel. I need to learn it and apply to my job. I spend a lot of time to collect and analyze data to present third party logistics performance. These tools can help me to work more efficiency. Thanks.
Was this review helpful? Yes0
 Flag
Mary Mohammad profile image
Mary Mohammad profile image

Mary Mohammad

10/10 starsCompleted
11 months 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
11 months 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
11 months 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
11 months 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
11 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
11 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
11 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
11 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
11 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
11 months, 1 week 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
11 months, 1 week 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
11 months, 1 week 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
11 months, 1 week 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
11 months, 1 week 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
11 months, 1 week 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
11 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
11 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

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.