Analyzing and Visualizing Data with Excel

Provided by:
9/10 stars
based on  1635 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
22552 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
1635 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
Vrinda B profile image
Vrinda B profile image

Vrinda B

8/10 starsCompleted
8 months, 2 weeks ago
Course material, video, and assignments were very helpful and in line with the course description. As a student, I would have liked more assignments and heavier lab work covering more content in the course. Thank you!
Was this review helpful? Yes0
 Flag
Vrinda B profile image
Vrinda B profile image

Vrinda B

8/10 starsCompleted
8 months, 2 weeks ago
Course material, video, and assignments were very helpful and in line with the course description. As a student, I would have liked more assignments and heavier lab work covering more content in the course. Thank you!
Was this review helpful? Yes0
 Flag
Vrinda B profile image
Vrinda B profile image

Vrinda B

8/10 starsCompleted
8 months, 2 weeks ago
Course material, video, and assignments were very helpful and in line with the course description. As a student, I would have liked more assignments and heavier lab work covering more content in the course. Thank you!
Was this review helpful? Yes0
 Flag
Edwin Kamau profile image
Edwin Kamau profile image

Edwin Kamau

10/10 starsCompleted
8 months, 3 weeks ago
The instructor is very interactive, detailed and elaborate. The content is rich in practical examples and the site is easy to navigate back-and-forth through exercises. I would highly recommend the course to anyone interested in data and analysis.
Was this review helpful? Yes0
 Flag
Eugene Asiedu profile image
Eugene Asiedu profile image
10/10 starsCompleted
  • 0 reviews
  • 0 completed
8 months, 3 weeks ago
The content was good, the instructor explained the modules very well and provided some external links where I could learn more about the topics. I think it was awesome and I learnt a lot of new things
Was this review helpful? Yes0
 Flag
Kalengo Phiri profile image
Kalengo Phiri profile image

Kalengo Phiri

10/10 starsCompleted
9 months ago
I loved the way I only had to watch one video and everything else was in text. It is a well rounded course with regular quizzes to keep you up to speed.
Was this review helpful? Yes0
 Flag
Nandan Kumar Gupta profile image
Nandan Kumar Gupta profile image

Nandan Kumar Gupta

10/10 starsCompleted
9 months, 1 week ago
I found the course very interesting and the way tutor taught us is really a nice way. Content and Instructor are very well structured, I would highly recommend this course to everyone interested to learn Excel.
Was this review helpful? Yes0
 Flag
Jordi Montaner profile image
Jordi Montaner profile image

Jordi Montaner

10/10 starsCompleted
9 months, 1 week ago
Content and Instructor are very well structured, I would really recommend this course as it it very interactive and can give you a quite detailed overview of the different tools available in Excel for Data Analysis.
Was this review helpful? Yes0
 Flag
Anuar Tulezhanov profile image
Anuar Tulezhanov profile image

Anuar Tulezhanov

10/10 starsCompleted
9 months, 1 week ago
This course motivated and gave me ideas how to improve my reports in my company. I was an advanced user but I realized that I do not know the course material.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
9 months, 1 week ago
Very good Course and good tips/answers from the instructor when participants ask questions. I would recommend this for all professionals working in Excel.
Was this review helpful? Yes0
 Flag
Rinat Gazikhanov profile image
Rinat Gazikhanov profile image

Rinat Gazikhanov

8/10 starsCompleted
9 months, 1 week ago
I think it would be good if you could provide a one-point authorization for all the Microsoft services, so users could switch between different interfaces without signing in and out under different accounts. This suggestion relates to the online Power BI environment where users forced to create an alternative account (maybe I missed something, but I am stuck on trying to connect using my gmail email address, which I can successfully use when connecting to the Microsoft account).
Was this review helpful? Yes0
 Flag
Kenneth Waynescott profile image
Kenneth Waynescott profile image

Kenneth Waynescott

8/10 starsCompleted
9 months, 1 week ago
Lessons could have been more detailed and better organized. That said, I feel it was overall a good course. I have already taken a couple of courses online so I already had a good understanding but there were things here and there that added to my knowledge base. Thanks for creating and sharing!
Was this review helpful? Yes0
 Flag
Alex Melgar profile image
Alex Melgar profile image

Alex Melgar

10/10 starsCompleted
9 months, 1 week ago
Great example files to work with! I wish this course explained a little bit more about how the data in the Excel Model is stored within the file and whether I can create "stand alone" excel files with the complete data within the file.
Was this review helpful? Yes0
 Flag
NAVANEETH S profile image
NAVANEETH S profile image

NAVANEETH S

8/10 starsCompleted
9 months, 2 weeks ago
The course was very informative. Most of the operations in the Excel was not known to me. I generally used to see the operations but never used it at all. Also, the theory part was helpful in understanding the working and the application of the software itself.
Was this review helpful? Yes0
 Flag
Marlena Nowak profile image
Marlena Nowak profile image

Marlena Nowak

10/10 starsCompleted
9 months, 2 weeks ago
Overall very good, amazing support from TA. The content of the lectures was very well explained. great introduction to explore more - and for that there were also provided links to study further. I have to admit some of the lectures were a little bit chaotic lectures, also some questions in the quizzes were confusing.
Was this review helpful? Yes0
 Flag
Kwasi Awuah profile image
Kwasi Awuah profile image

Kwasi Awuah

10/10 starsCompleted
9 months, 2 weeks ago
The course is very involving. I enjoyed the data cleaning and visualisation levels I learnt with excel. Most importantly how to use data from different sources.
Was this review helpful? Yes0
 Flag
Ankit Kumar profile image
Ankit Kumar profile image

Ankit Kumar

10/10 starsCompleted
9 months, 2 weeks ago
Very good Course about pivot table, Pivot Table , Data models with different visualizations, The Lab Overview is a very good thing they have attached so in order to complete the course you have to go through it and it will give you hands on experience on the things, The Content and it's delivery is very good, So in sort I can Say Everything is more than perfect.
Was this review helpful? Yes0
 Flag
اسلام محمد profile image
اسلام محمد profile image

اسلام محمد

6/10 starsCompleted
9 months, 2 weeks ago
i was looking forward to going in depth, presenting more topics, more materials, more videos.i wished to get the material of this course(the whole course ) in one PDF file rather than in paragraphs
Was this review helpful? Yes0
 Flag
Tanaya Seth profile image
Tanaya Seth profile image

Tanaya Seth

6/10 starsCompleted
9 months, 3 weeks ago
Some more exercises could have been provided at the end of the course. Also, links to related courses can be provided at the end. Overall it was a great introduction to the level of data manipulation that can be done with excel and the course gets you really enthused about using these powerful features to solve actual business problems and implement these in real business scenarios.
Was this review helpful? Yes0
 Flag
Chun-Ta Kung profile image
Chun-Ta Kung profile image
10/10 starsCompleted
  • 0 reviews
  • 0 completed
9 months, 3 weeks ago
Good introduction to the advanced Excel, which is definitely deliver more contents than school excel class. As far as business user concerned, this would be great enough to begin your career with this course together. To technical track people, it would be nice introduction.
Was this review helpful? Yes0
 Flag
Nikhil Jalan profile image
Nikhil Jalan profile image

Nikhil Jalan

8/10 starsCompleted
9 months, 3 weeks ago
It was a very nice course. Studying more about pivot tables and Excels formulas make our work very easy to do. Also I felt that the course was complete and will help all the students to learn very easily and rapidly. All the modules were good. Starting from the first module to the eighth module, all were having quizzes and labs which helps the student to grow very fast. The quizzes helps to boost the concepts and the labs helps to implement all the concepts learnt. Also the instructor was helping in the video and teaching very nicely. I will also appreciate the Discussions forum where all the queries of all the students are being solved. This was really a nice experience learning from the Microsoft course about Analyzing and Visualizing the Data with Excel. Thus we learnt here about analyzing and visualizing the data in a very nice manner.
Was this review helpful? Yes0
 Flag
Justice Agbadu profile image
Justice Agbadu profile image

Justice Agbadu

10/10 starsCompleted
9 months, 3 weeks ago
Great content, instructor and provider. I have learnt a lot from this course. Excel shouldn't be underrated in any way because it is indeed powerful. Oh! I like that DAX stuff, the Cube Functions and the Treemap chart.
Was this review helpful? Yes0
 Flag
Mandar Dhavale profile image
Mandar Dhavale profile image

Mandar Dhavale

6/10 starsCompleted
9 months, 4 weeks ago
There was importing data into excel and getting tat connection to work was not working. The quiz should be tested, else offer a quick alternative solution.
Was this review helpful? Yes0
 Flag
Jignesh Patel profile image
Jignesh Patel profile image

Jignesh Patel

8/10 starsCompleted
10 months ago
Content 7 & 8 could have been made more interesting by providing more quiz questions. Exercise were designed well to test and use the understating of excel learning throughout.
Was this review helpful? Yes0
 Flag
Matthew Wolf profile image
Matthew Wolf profile image

Matthew Wolf

8/10 starsCompleted
10 months ago
I thought I had a good grasp on Excel, but I still learned some new things about queries and the Excel data model in this course. Worth the time for that alone.
Was this review helpful? Yes0
 Flag
Mathews Chiza Nyirongo profile image
Mathews Chiza Nyirongo profile image

Mathews Chiza Nyirongo

10/10 starsCompleted
10 months ago
Very easy to follow and extremely practical with the labs and the end of each module. The fact that I get to check my understanding of the material with quizes is amazing. I'd take more courses on Microsoft given opportunity. Thank you Microsoft.
Was this review helpful? Yes0
 Flag
Cem Bugra ALKAN profile image
Cem Bugra ALKAN profile image

Cem Bugra ALKAN

8/10 starsCompleted
10 months ago
Some lab questions were not well understandable.However the course was good enough to understand and follow for one does not have any idea or prejudice against excel. I did not have that much idea what excel capable of.
Was this review helpful? Yes0
 Flag
Cameron de Bruyn profile image
Cameron de Bruyn profile image

Cameron de Bruyn

10/10 starsCompleted
10 months ago
I thought it was a really great course. I work for a bank and I can really see how useful these analytical tools can be used in business intelligence scenarios.
Was this review helpful? Yes0
 Flag
Manuel Urbina profile image
Manuel Urbina profile image

Manuel Urbina

10/10 starsCompleted
10 months ago
Multiple options within Excel that you normally do not interact with, but they could be very useful to manage data. I definitely recommend this course as an Introduction to DAX and other elements.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 0 reviews
  • 0 completed
10 months ago
It is a fairly comprehensive course on data analysis using excel with step by step approach on how to build an interactive analytical model for a business/function with data drill down option as required. It also covers the visualization of data using excel and Power BI. Overall a great course for anybody who works with a lot of data in making effective data analysis and visualization.
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.