Analyzing and Visualizing Data with Excel

Provided by:
9/10 stars
based on  1852 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
24255 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
1852 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

8/10 starsCompleted
5 years, 4 months ago
Overall it was a good course and quite enlightening. Kudos to the team for setting it up and for the engaging conversations. I'm looking forward to implement what I have learnt. Best, Wahome Victor | G.I.S Analyst
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

4/10 starsCompleted
5 years, 4 months ago
Should have been clearer that you needed the pro version of Excel. Could have made it easier for the rest of us if you had extra material for home editions. The presenter was too monotonous. Otherwise he did a good job.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
5 years, 4 months ago
Excellent course. The examples are closely related to the assessments, which give valuable practice. One or two of the assessment questions might be more carefully worded, though this is just nit-picking as I'm required to use 150 characters.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
5 years, 4 months ago
This gave a totally new perspective to power use of Excel and I hope that this can be used in my coming jobs. Unfortunately I do not have Excel 2016, but I did not have diffiuclties in using Excel 2013 when it was changed to 64 bit version.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
5 years, 4 months ago
Me ha parecido un gran curso para aproximarse al análisis de datos mediante las herramientas power pivot y power query. En mi opinión el poder tratar con excel datos es un gran acierto porque en las organizaciones es una de las aplicaciones más usadas y darle este tipo de funcionalidades lo hace mantenerse como aplicación fundamental El curso me ha parecido muy interesante, muy bien explicado para la gente que nos aproximamos a conocer estas funcionalidades y los ejercicios sugeridos también me parecen muy bueno porque nos hacen repasar todo lo visto en los videos En definitiva me ha parecido un excelente curso y enhorabueba
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

1/10 starsDropped
5 years, 4 months ago
Lectures not smooth hard to follow at times. Questions in discussion met with belittling the person inquiring about a topic as being stupid and should already know the answer to their question and wasting TA's time in following up
Was this review helpful? Yes0
 Flag
Claire Everett profile image
Claire Everett profile image

Claire Everett

5/10 starsDropped
5 years, 4 months ago
The course does not make it clear that you need a specific version of Excel to be able to complete the course. You need the professional version of Excel the home version does not work. It was very disappointing to find this out only after I paid for the home 2016 version of Excel. The software requirements should be stated clearly at the beginning to avoid software issues causing people to drop the course.
Was this review helpful? Yes0
 Flag
Andrew Aung profile image
Andrew Aung profile image

Andrew Aung

10/10 starsTaking Now
5 years, 4 months ago
Thanks Mr.Hoter. By your efforts and well-prepared lessons, we have a great chance to learn these lessons. Additionally, I would like to request to add the lessons for linking excel and access data vice versa.
Was this review helpful? Yes0
 Flag
Muhammad Fiaz profile image
Muhammad Fiaz profile image

Muhammad Fiaz

8/10 starsTaking Now
5 years, 5 months ago
good for this course initiative. If possible, please consider to include MS Access Database connections for data analyzing, as a topic within the course content.
Was this review helpful? Yes0
 Flag
Mbuyisa Manana profile image
Mbuyisa Manana profile image

Mbuyisa Manana

10/10 starsTaking Now
5 years, 5 months ago
I think this is one of the best way to refresh and gather more knowledge. In the Last month August 26-28. I took a Excel Dashboard learning and the possibility of using Excel applications on Financial DATA is endless. Excel is a must for all those that are in Finance.
Was this review helpful? Yes0
 Flag
Daniel Reynaldo profile image
Daniel Reynaldo profile image

Daniel Reynaldo

9/10 starsTaking Now
5 years, 5 months ago
Cogratulations for this course initiative. If possible, please consider to include MS Access Database connections for data analyzing, as a topic within the course content. Best regards,
Was this review helpful? Yes0
 Flag
constanza ceron profile image
constanza ceron profile image

constanza ceron

10/10 starsTaking Now
5 years, 5 months ago
Gestora de Conocimiento de un proyecto de investigación en educación, nesecito fortalecer habilidades para manejar excel
Was this review helpful? Yes0
 Flag
Md Mainuddin profile image
Md Mainuddin profile image

Md Mainuddin

10/10 starsTaking Now
5 years, 5 months ago
I think it would be great here prasiksanagana . So I am very keen to work here . Aami hope that you teach me to do this very well .
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years, 5 months ago
Course content: Was clear and understandable. Examples:Requires mores examples in few topic. Felt little difficulty in following the classes because the lecture was not delivered to the full potential.
Was this review helpful? Yes0
 Flag
dharmaperumal alagu ramakrishnan profile image
dharmaperumal alagu ramakrishnan profile image

dharmaperumal alagu ramakrishnan

1/10 starsDropped
4 years, 6 months ago
iam having macbook and ms office 2016 shall i able to take the course.if not what is the use of buying ms office for mac for 5000 rs.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years, 11 months ago
I found this course extremely well formatted. Content was very up-to-date. The instructor shares information with ease and clarity. I would recommend this course.
Was this review helpful? Yes0
 Flag
Destya Kusuma profile image
Destya Kusuma profile image

Destya Kusuma

8/10 starsTaking Now
5 years, 2 months ago
how the course is run? I am sorry, I am still a newbie here, it's my first time, but i want to follow this course very much, although I still have problems related to the time difference between countries, and I am still confused to follow and join in the discussion on this course. i hope and I look forward for guidance on how to use this course. Thankyou.
Was this review helpful? Yes0
 Flag
mian asim bashir profile image
mian asim bashir profile image

mian asim bashir

6/10 starsTaking Now
5 years, 3 months ago
when will it is going to be start and what time ,when we will see the course contents. is any one here for help us from our previous practices in excel.
Was this review helpful? Yes0
 Flag
Ginna Rozo profile image
Ginna Rozo profile image

Ginna Rozo

10/10 starsTaking Now
4 years ago
Necesito este curso en español. Por favor adaptarlo. Puede ser con subtitulos. Gracias.................¿.¿....¿........
Was this review helpful? Yes0
 Flag
Saumanshu Kaushal profile image
Saumanshu Kaushal profile image

Saumanshu Kaushal

7/10 starsTaking Now
5 years, 5 months ago
just wanted to share that nowdays we are in such an era where it is obvious we should know excel because every company you want to work with they assume that you know excel so certificate is of no use. Rest totaly depends on an indiviual.
Was this review helpful? Yes0
 Flag
kashif shabbir profile image
kashif shabbir profile image

kashif shabbir

2/10 starsTaking Now
5 years, 5 months ago
I think it is not misleading because EDX has already displayed the fee for certificate .If you do not interested to take certificate so it is free.
Was this review helpful? Yes0
 Flag
surendra singh profile image
surendra singh profile image

surendra singh

4/10 starsDropped
5 years, 5 months ago
It is misleading, they say its free but however they charge $49, I have seen and add saying that free excel training but when I enrolled its asking for checkout so I dropped to do the course, so why they say its free and they must not advertise like this and its really misleading
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.