Analyzing and Visualizing Data with Excel

Provided by:
9/10 stars
based on  1648 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
22646 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
1648 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
Saurabh Yadav profile image
Saurabh Yadav profile image
8/10 starsCompleted
  • 1 review
  • 1 completed
4 years ago
First of all I would like to thank Microsoft for providing this course as it is very much helpful. Also the faculties , the way of explanation all's very good. Good Job by Microsoft .
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
A good knowledgeable course to use the advance functionality of the MS Excel. It was working fine with Excel 2010 with a little difficulty due to the difference in interface of the Instructor.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
The content was right on the money for what i was looking for, to get a better understanding of Pivot Tables. It was good to find out about new features in Excel.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
A really great course and easy to follow, I came in with basic knowledge of Excel and understood almost everything. Many thanks to professed Dany Hoter, The Microsoft and other who were involved in this course.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
It was a great experience, I really enjoy the course and learned a lot of techniques and importante topics in the area of BI. I hope they are more courses in the future like this.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
Great introduction to some features in Excel that I was not previously aware of and definitely will come in handy for creating Pivot tables and charts. Personally, I think it's a fun course because there are more videos showing examples and exercises than there are reading materials.
Was this review helpful? Yes0
 Flag
Domingo Cordero profile image
Domingo Cordero profile image
10/10 starsCompleted
  • 1 review
  • 1 completed
4 years ago
Let my analytical skill to another new level. ... without getting my brain exploded. The course uses a good example , very applicable to my work environment
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
Very good Course, the only thing i think that can be improved in the future is the zoom on to excel.The instructor is very good, he shows a lot of experience and when the things go wrong he shows that it's a thing that can happen during our development and can be undone safely. I've user Excel 2013 and taught the course without problems.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
The course content was very good and to analyze the data with the DAX method for me did not know and help from instructor and provider in the forums helped me understand my mistakes in some questions and exercises.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
I am very happy, i was a very professional online course, very well prepared, good examples, very good theory. A right balance between theroy and practice. Just Great!
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
Very satisfied. It's my first year in EDX, he had tried several times but for reasons of time not concreted other, so I'm very happy with this experience and grateful to the instructor. My intention with the course is to apply this tool in the area of consulting, I hope to hear soon of new courses.
Was this review helpful? Yes0
 Flag
Ievgen Ishchuk profile image
Ievgen Ishchuk profile image
6/10 starsCompleted
  • 4 reviews
  • 3 completed
4 years ago
I really like the course. Putting 3/5 because of the lack of content. The guys have to push new features of Excel 2016, it's obvious. But people would like it even more if they would make the content more informational, making this course longer. Recommended but not all of the features are detailed enough (at least for me) Thank you P.S. Mr. Hoter is a very good tutor
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
Course content was ideal and instructor's way of teaching was very nice because it helps me to learn new things about excel which I have not learn in past.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

6/10 starsCompleted
4 years ago
The course gave me a good insight into how vast Excel is. The Instructor did a wonderful job, was very clear with the instructions. Extremely helpful course. Thank you.
Was this review helpful? Yes0
 Flag
Abhijit Rastogi profile image
Abhijit Rastogi profile image
10/10 starsCompleted
  • 1 review
  • 1 completed
4 years ago
Everything was excellent. Specifically the questions and lab tutorials after each module were very well designed. Develop a curiosity to learn more about excel !!!
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
Well, the course was and is a fundamental experience for myself knowledge, also i think is a better option to people who is not able to go phisycally courses. the instructor seems like have pretty knowledge i think he can do it better than that, but above of the challenges he did pretty good, show you the necessary stuff to be more profesional and gain job experience.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
Really amazing course, During the training instructor was focused on a key subjects and useful topics. All explained things could be definitely used in real life work environment.
Was this review helpful? Yes0
 Flag
Ojikutu Abimbola profile image
Ojikutu Abimbola profile image
10/10 starsCompleted
  • 1 review
  • 1 completed
4 years ago
I am really glad I took this course because I have learnt a great deal on how to take my excel knowledge further. Thanks Dany Hoter for being a good instructor.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
The application of the content was not what I expected, I thought that the data analysis and presentation was general and not only focused on sales and business reports. However, it was interesting and I did it completely !!! I also consider that the last modules are useless because are only designed to show new tools from Microsoft that are not addressed in depth and, therefore, are not contributing to the main objective of the course.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsTaking Now
4 years ago
I am really satisfied, I have learned new interesting tools that will help me in my job. Thanks for your great work. I am sure I will enrol more courses in a future.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
This is a great course and everyone looking to enhance their skills in excel should take this up. The course is for those who have intermediate knowledge of excel.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

9/10 starsCompleted
4 years ago
Fantastic course, easy to understand and lot of capabilities that can be implemented in the work environment.
Was this review helpful? Yes0
 Flag
 profile image
 profile image

10/10 starsCompleted
  • 1 review
  • 1 completed
4 years ago
It was my first but an awesome experience. I would love to go beyond and add on this learning experience. The content of the course was well balanced with desired rhythm and flow for a distant learner. The instructor was immensely powerful in delivering the intended objective of each module. I found very good connection between the modules in terms of content and logic. It was wonderfully designed. On top, the organization of the entire course was impressive. This was the first time i witnessed such a great logical and learning oriented module in terms of segments in each module i.e. video tutorial, quiz, additional content, ppt presentation, discussion forum and scenarios.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
For an absolute beginner, it's pretty difficult to understand the real word application in business analysis but it gives an exposure as to what you can do in excel. The content is straight forward and the lab exercises go hand in hand with the lecture videos. You can immediately put your skills to use in the lab module.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
I'm very satisfied. My knowledge of Excel was only with previous versions before 2010. The lectures were easy to understand and the lecturer Mr. Dany Hoter is very knowledgeable. I would suggest that more exercises would help people familiarize themselves with Excel 2016.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
Great class. I use Excel for work regularly, but only have a moderate level of proficiency. This class focused on more advanced topics, but also helped me gain experience with some of the intermediate level items that I haven't been as familiar with as I would have liked. Definitely can recommend it.
Was this review helpful? Yes0
 Flag
Branavi Balasingam profile image
Branavi Balasingam profile image
8/10 starsCompleted
  • 1 review
  • 1 completed
4 years ago
The course was excellent.I got a chance to learn new things regarding Excel.The instructor gave us a clear understanding about the DAX expressions.Enjoyed the session.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

8/10 starsCompleted
4 years ago
Satisfied. The content was good, assignments were real and real usage of Excel was applied. Very interactive. Could have skipped the last module no. 8 which was more of a advertisement of microsoft products but I guess that is part of the game:) thanks anyways I really enjoyed it.
Was this review helpful? Yes0
 Flag
Student profile image
Student profile image

Student

10/10 starsCompleted
4 years ago
Dany and team provide a good introductory level course (intermediate level in places). I found it a very useful exploration of the Power Pivot and Power Query
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.