Save for later

Analyzing and Visualizing Data with Excel

This course is part of the Microsoft Professional Program Certificate in Big Data, Microsoft Professional Program Certificate in Data Science and Microsoft Professional Program in Data Analysis.

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.

edX offers financial assistance for learners who want to earn Verified Certificates but who may not be able to pay the fee. To apply for financial assistance, enroll in the course, then follow this link to complete an application for assistance.

Get Details and Enroll Now

OpenCourser is an affiliate partner of edX.

Get a Reminder

Not ready to enroll yet? We'll send you an email reminder for this course

Send to:

edX

&

Microsoft

Rating 4.1 based on 13 ratings
Length 6 weeks
Effort 2 - 4 hours per week
Starts Jan 1 (4 weeks ago)
Cost $99
From Microsoft via edX
Instructors Dany Hoter, Jonathan Sanito
Download Videos On all desktop and mobile devices
Language English
Subjects Business Data Science
Tags Business & Management Data Analysis & Statistics

Get a Reminder

Get an email reminder about this course

Send to:

What people are saying

We analyzed reviews for this course to surface learners' thoughts about it

azure or python in one review

Excel is versatile tool because of the ease of CVS manipulation which is a must with Azure or Python for me 1.

installing things than in one review

You spend more time on updating and installing things than on completing tasks (which are basically the repetition of lectures) Excitement overloaded........i have to complete this course thank u soo much edx for giving as a good better and professional opportunity to us

must with azure in one review

not extremely difficult in one review

The course is not extremely difficult to take, but some prior Excel usage would be recommended.

soo much edx in one review

spend more time in one review

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile.

Microsoft Azure $58k

Microsoft instructor $62k

Microsoft Business Intelligence Professional $63k

Microsoft CSR $81k

Microsoft Certified Professional $89k

Pre-Sales Solutions Architect, Microsoft Professional Services $90k

Microsoft | Solution Sales Professional - Application Platform $99k

SDE in Microsoft $106k

SDE @ Microsoft 5 $110k

Microsoft Active Directory/Microsoft Exchange Administrator. $114k

Microsoft Engineer 3 $126k

Microsoft Dynamics CRM Solution Sales Professional Manager $150k

Reviews

Sorted by most helpful reviews first

Guest says:

Good for anyone who wants to present their data in a cleaner and clearer format. This course challenges you to think before you do. You get a lot of good information and a lot of opportunities to try things yourself in Excel. I would especially recommend to someone who does analysis regularly and someone with at least some experience using Excel since the course does not cover basics.

Guest says:

This course covers everything from pivot tables and charts to data models and visualization and it's one of the only MOOCs I've taken that's given me a noticeable boost in my day-to-day job. Needless to say, I strongly recommend this course! I'm old hat so I'm still on Excel 2013. Ideally you have the 2016 version, but you can definitely get away using some add-ins (easy to install).

Guest says:

Excellent course. Really great to see what Power BI and Excel 2016 are capable of.

Write a review

Your opinion matters. Tell us what you think.

edX

&

Microsoft

Rating 4.1 based on 13 ratings
Length 6 weeks
Effort 2 - 4 hours per week
Starts Jan 1 (4 weeks ago)
Cost $99
From Microsoft via edX
Instructors Dany Hoter, Jonathan Sanito
Download Videos On all desktop and mobile devices
Language English
Subjects Business Data Science
Tags Business & Management Data Analysis & Statistics