Analyzing and Visualizing Data with Excel

Provided by:
9/10 stars
based on  1837 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
23989 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
1837 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
Luis Rodriguez profile image
Luis Rodriguez profile image

Luis Rodriguez

10/10 starsCompleted
9 months, 1 week ago
Totally loved this course and how it expanded my knowledge in the use of Excel, but most particularly to handling the data model and its capabilities.
Was this review helpful? Yes0
 Flag
Nicole Chan profile image
Nicole Chan profile image

Nicole Chan

8/10 starsCompleted
9 months, 1 week ago
Very useful course in database management. Like the lab section so that we can really try and see if we understand the lecture. The most difficult part would be using the DAX language in the query, but there are sufficient support from the related link for us to self-study.
Was this review helpful? Yes0
 Flag
HAPPY IBE profile image
HAPPY IBE profile image

HAPPY IBE

10/10 starsCompleted
9 months, 2 weeks ago
Analyzing and Visualizing Data with Excel is an inspiring course, excellently delivered by Dany Hoster. Though I have been very familiar with all the components of the course - Pivot table, Pivot Chart, Data Models, Visualization and Power BI, the certificate is an added value.
Was this review helpful? Yes0
 Flag
Juan José Medina profile image
Juan José Medina profile image

Juan José Medina

10/10 starsCompleted
9 months, 2 weeks ago
Excellent and very useful content. And a great job is done by the instructor, whose lessons are quite well explained. The extra resources provided are useful along the course.
Was this review helpful? Yes0
 Flag
Mathew Abraham profile image
Mathew Abraham profile image

Mathew Abraham

8/10 starsCompleted
9 months, 3 weeks ago
Very good content and great instructors. I really liked that fact that I learned so much about how to use Excel and the PowerPivot and Query editor. I am going to look at the POwer BI course next.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
9 months, 4 weeks ago
I enjoyed the course thoroughly. The lectures set the stage nicely, the quizzes do a good job of checking for understanding, and then the labs help solidify the learning. I'm looking forward to doing the Power BI training next.
Was this review helpful? Yes0
 Flag
Geerhard Reink profile image
Geerhard Reink profile image

Geerhard Reink

8/10 starsCompleted
10 months ago
Excellent course to show what is possible, touching upon relevant subjects and presented in a quiet instructive method. Motivates to dive further into the possibilities.
Was this review helpful? Yes0
 Flag
JULIO RODRIGUEZ profile image
JULIO RODRIGUEZ profile image

JULIO RODRIGUEZ

10/10 starsCompleted
10 months, 1 week ago
Excellent very well presented and structured, the model and the example used in this course allows me to have a clear understanding of what I can do with such a powerful tool
Was this review helpful? Yes0
 Flag
Ikem Daniel profile image
Ikem Daniel profile image
10/10 starsCompleted
  • 0 reviews
  • 0 completed
10 months, 1 week ago
I found the course to be very interactive and it was presented in a simplified format. The content was good enough to position each learner to go deeper and learn further with other links and tools provided. I will recommend this course to aspiring Data Analyst and individuals seeking to have a basic grasps of interpreting and making meaning out of data. I am sure going to take associated courses and develop my skills in Analytics.
Was this review helpful? Yes0
 Flag
Mercy Ugwu profile image
Mercy Ugwu profile image

Mercy Ugwu

8/10 starsCompleted
10 months, 1 week ago
Fairly good content. A 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
Kazeem Omotosho profile image
Kazeem Omotosho profile image

Kazeem Omotosho

10/10 starsCompleted
10 months, 1 week ago
This is a very comprehensive course taught at the professional level. I was able to lay my hands on all The Lab Questions and Exercises and very comfortable scoring above 90%.its indeed a very wonderful experience.this is one of a very few online courses with clarity of purpose and ease of navigating through the course contents.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

10/10 starsCompleted
10 months, 1 week ago
Comprehensive course taught at the right level. Plenty of great hands-on labs to do. If you are not familiar with Excel, it would be a good idea to complete a foundational level course first.
Was this review helpful? Yes0
 Flag
Shaurya Singh profile image
Shaurya Singh profile image

Shaurya Singh

10/10 starsCompleted
10 months, 1 week ago
Great learning experience! The type of material provided helped me a lot, its not just spoon-feeding i actually learned on my own by making errors and overcoming them.
Was this review helpful? Yes0
 Flag
HABEEB profile image
HABEEB profile image

HABEEB

10/10 starsCompleted
10 months, 1 week ago
The course content is top notch as well as the delivery. Loads of information to take in at a time. Key Take Aways: Creating relationships between tables, creating measures, writing DAX expressions. All these make it possible for one to tell a story with DATA.
Was this review helpful? Yes0
 Flag
Yewande profile image
Yewande profile image

Yewande

10/10 starsCompleted
10 months, 1 week ago
The course content was really good and practical. I had no idea how to use Pivot Tables or Charts before I started. The Data models are still a bit confusing but this has really helped in analyzing data at work.
Was this review helpful? Yes0
 Flag
Chhingchhing HEM profile image
Chhingchhing HEM profile image

Chhingchhing HEM

10/10 starsCompleted
10 months, 2 weeks ago
It very good course which I can improve skill on Excel in pivot table, Pivot Chart, Data models and visualization data. It really good to get such knowledge of Excel.
Was this review helpful? Yes0
 Flag
Ahmed ALASIRI profile image
Ahmed ALASIRI profile image

Ahmed ALASIRI

8/10 starsCompleted
10 months, 2 weeks ago
Really, it was a helpful, and useful subjects in the data analyzing scope especially for beginners. I'll start the implementation right now on my work. Thanks all.
Was this review helpful? Yes0
 Flag
hari profile image
hari profile image

hari

6/10 starsCompleted
10 months, 2 weeks ago
Pedagogy and content of the course suits for the beginners and able to get few insights from the instructor (own style of teaching). Example files stimulates to practice and get insights further. Download video files, scripts and txt files options from the provider further helps to make habit of practice
Was this review helpful? Yes0
 Flag
Chandra Batchu profile image
Chandra Batchu profile image

Chandra Batchu

10/10 starsCompleted
10 months, 3 weeks ago
I am very happy and satisfied with the Analyzing and Visualizing Data with Excel course, I have done the Introduction to DA with Excel course before and felt very comfortable with Dany's teaching. I can start seeing the power of Data Analytics and this course has given good foundation to think in terms of Data, thanks to edX and Dany for his wonderful teaching. When Dany speaks I feel like one of my family member is explaining so patiently, like a father to a son, his style is unique. edX is such a revolutionary online platform that it is changing the fate and career if middle aged students like me, who never dreamt of learning such great material online, my sincere thanks to edX. Being a father of 2 girls and from a middle class family here in India, I couldn't afford to pay for this certificate, so edX had given me financial aid as well, once again sincere thanks to edX. Hope many such opportunities are given for aspiring uncles li... I am very happy and satisfied with the Analyzing and Visualizing Data with Excel course, I have done the Introduction to DA with Excel course before and felt very comfortable with Dany's teaching. I can start seeing the power of Data Analytics and this course has given good foundation to think in terms of Data, thanks to edX and Dany for his wonderful teaching. When Dany speaks I feel like one of my family member is explaining so patiently, like a father to a son, his style is unique. edX is such a revolutionary online platform that it is changing the fate and career if middle aged students like me, who never dreamt of learning such great material online, my sincere thanks to edX. Being a father of 2 girls and from a middle class family here in India, I couldn't afford to pay for this certificate, so edX had given me financial aid as well, once again sincere thanks to edX. Hope many such opportunities are given for aspiring uncles like me who are looking to change their fate and career through edX.....hahahahahahaha I am sooooooooooo HAPPY HAPPY HAPPY LOVE YOU edX...you ROCKKKKK.
Was this review helpful? Yes0
 Flag
Guangyao Shen profile image
Guangyao Shen profile image

Guangyao Shen

10/10 starsTaking Now
11 months ago
Very complex course about Excel and Pivot function for no experience people. But it is a rich course, it could make me know more function about excel. Very useful function and it is like a magic if you know how to use it. After the course, we need take more exercise with it in case we forgot it. The course content is very rich, maybe we have better divided them into more small course. The course teacher is very good, if there is a classroom training, it will be more wonderful!
Was this review helpful? Yes0
 Flag
Chiamaka Okoye profile image
Chiamaka Okoye profile image

Chiamaka Okoye

10/10 starsCompleted
11 months ago
The course was a great overview of how to use Excel for data analysis. The flow was logical and the instructor was clear and easy to understand. One would require further practice and research to get deepen the skills learnt, but overall it covers the basics and is a great introduction. I only wish it had covered cube formulas a bit more. The section on it was a little too high-level.
Was this review helpful? Yes0
 Flag
Alex profile image
Alex profile image

Alex

10/10 starsCompleted
11 months, 1 week ago
A very interesting program that gives additional insights into how to use data modelling in Excel with a quick reference to Power BI. I particularly like the fact that the course includes data models/sample data.
Was this review helpful? Yes0
 Flag
Lee Jinwoo profile image
Lee Jinwoo profile image

Lee Jinwoo

8/10 starsCompleted
11 months, 1 week ago
Write a Review: Analyzing and Visualizing Data with Excel Very good course. Thanks a lot. Very complete course about Pivot Tables, Pivot Charts, Data models and Visualization.
Was this review helpful? Yes0
 Flag
Xavier Richert profile image
Xavier Richert profile image

Xavier Richert

8/10 starsCompleted
11 months, 2 weeks ago
It's a good course- but you'll encounter difficulty with the lab section if using older versions of Excel. I recommend taking the Introduction course first. Best of all was to me, the personality of the teacher.
Was this review helpful? Yes0
 Flag
Vince Kin profile image
Vince Kin profile image

Vince Kin

6/10 starsCompleted
11 months, 3 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
oluwatobi akanni profile image
oluwatobi akanni profile image

oluwatobi akanni

10/10 starsCompleted
11 months, 3 weeks ago
the course content suits a novice in data analytics, surely an eye-opener, the instructor's communication throughout the course is benign, twill make it possible for anyone to learn. Also, i would thank Microsoft for establishing these programs, even though getting the certificate costs a lots due to currency values, yet they give one a leap in pursuit of a life-long career, thank you once again.
Was this review helpful? Yes0
 Flag
Fidelis Chalokwu profile image
Fidelis Chalokwu profile image

Fidelis Chalokwu

10/10 starsCompleted
11 months, 3 weeks ago
Great course on DAX, Excel Data modelling, Power pivot, Power BI, etc, Wonderful Instructor (Dany Hoter), Excellent support (from WLitzenberg) in the discussion forum. Microsoft is worthy of commendations with it's innovations, support and training provided especially with this course on Analyzing and Visualizing Data with Excel. It's highly recommended.
Was this review helpful? Yes0
 Flag
Prudence Rathotse profile image
Prudence Rathotse profile image

Prudence Rathotse

8/10 starsCompleted
12 months ago
this course is interesting, i got to use features like data models, pivot tables and charts, power query. this course taught me a lot. i am now able to visualize data in different aspects and also view my excel reports in power bi desktop.
Was this review helpful? Yes0
 Flag
Francesca Dicati profile image
Francesca Dicati profile image

Francesca Dicati

10/10 starsCompleted
1 year ago
Really good advanced Excel course. It taught me many interesting Excel features that I didn't know before. I experienced some problem in Module 1 because, if you don't have a Excel version with Power Pivot (that was my case), Module 1 Lab is a bit difficult.
Was this review helpful? Yes0
 Flag
Akpevwe Otobo profile image
Akpevwe Otobo profile image

Akpevwe Otobo

10/10 starsCompleted
1 year ago
Course content was great and challenging. The instructor was easy to follow and understand although at some points he seemed to mix things up. The provider did a good job of putting this content together
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.