Data Visualization with Advanced Excel

This Coursera curriculum was designed to provide hands-on instruction for advanced uses of Excel 2013. It gets beyond Excel basics and covers simulation analysis and more advanced Excel applications. It also goes deep into data visualization, helping to distinguish it from the multitude of introductory and overview classes in Excel.

Created by: Alex Mannella

Produced in 2018

icon
What you will learn

  • Developing databases and data models.
  • Advanced scenario analysis.
  • Data visualization.
  • Dashboarding.

icon
Course Description

In this course, you will get hands-on instruction of advanced Excel 2013 functions. You'll learn to use PowerPivot to build databases and data models. We'll show you how to perform different types of scenario and simulation analysis and you'll have an opportunity to practice these skills by leveraging some of Excel's built in tools including, solver, data tables, scenario manager and goal seek. In the second half of the course, will cover how to visualize data, tell a story and explore data by reviewing core principles of data visualization and dashboarding. You'll use Excel to build complex graphs and Power View reports and then start to combine them into dynamic dashboards.Note: Learners will need PowerPivot to complete some of the exercises. Please use MS Excel 2013 version. If you have other MS Excel versions or a MAC you might not be able to complete all assignments.This course was created by PricewaterhouseCoopers LLP with an address at 300 Madison Avenue, New York, New York, 10017.

icon
Pros

icon
Cons

    • Course gets far beyond the introductory basics. Instead of learning shortcuts to edit cells, you will learn how to do powerful analytics with Excel features.
    • Practical sessions ensure that you aren't loosely following along with lectures. You will have to master these lessons to complete the curriculum.
    • Course focuses on creating unique Excel outputs. You aren't just drawing basic scatter plots. You'll be crafting your own approach to using Excel analytics.
    • This course is not for beginners. A strong background in Excel is assumed.
    • The course was built from Excel 2013. There are subtle changes to newer versions and it can cause confusion and minor roadblocks to completing tasks if you aren't on Excel 2013.
    • The course is challenging even for experienced Excel users.

icon
Instructor Details

Alex Mannella

Alex Mannella was a founding member and Partner in PwC's Information and Analytics Practice and is a seasoned professional on the issues of customer value management (CVM), response modeling, database marketing, and data mining. He has extensive experience in developing response and segmentation algorithms for organizations of varying sizes, database development, and the use of artificial intelligence for data mining studies. Prior to joining PwC, Alex was head of research at Econometrics, Inc.. He was instrumental in the redesign of their national database of more than 180 million records for response modeling, data mining and direct marketing campaigns. In addition, Alex played a key role in the development of the life-stage variable at Econometrics, a variable that is a key component in CRM and market basket analysis. Alex is an active member of the American Statistical Association (Chicago Chapter) and the Chicago Association of Direct Marketing. Alex is a guest lecturer at UCLA, Stanford, ITAM (Mexico), Universidad de los Andes (Colombia), IIM-B, and ISB. In addition, Alex sits on an advisory board at the University of Chicago Graham School.

icon
Reviews

4.7

219 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Debdattaa K on 7-Jul-19

I am very grateful to the Coursera and PWC for this course. This course gives me new learning which will help to boost my carrier and productivity as well as increase the thirst of my knowledge about data analysis and finance.

By Gatan G on 23-Mar-19

This course took me from Basic level knowledge of Excel to a really advanced level. Course practice exercises are developed in a very appropriate way to teach the advanced level.

By DjidoulaAkolly on 4-Dec-18

Simple and effective guidance on the more advanced Excel functions like PowerPivot, scenario analyses and the developer tools were really helpful.The examples were given in a business context, hence making it easier to visualise the real world applications.

By Zhang G on 10-Jan-19

One can excel in excel!

By Lucio C on 18-Jan-19

Excellent course with EXTREMELY thought-provoking and hands-on exercises that shed a new light on classic Excel functions such as Goal Seek, Scenario Manager (scenario analysis), Simulation (simulation analysis), and Data Tables (sensitivity analysis). The most intense and interesting course I've taken thus far on the topic of data analytics!

By Jorge A on 18-Feb-19

Very easy way to explain some key functions of excel that can help a lot in the art of visualization, thanks!

By Kavin P on 25-Jan-19

excellent course

By Purvam M on 19-Feb-19

Dashboards are extremely useful and effective as well as impressive, I really appreciate the course for insights on how to build them and use in real life

By Pratyush S on 22-Feb-19

course is very nice plese give the link for certificate it does not show my certificate

By Alejandro L C on 24-Feb-19

Nicely planned course with good practice cases which gives hands-on experience of working with data.

By Aayush T on 28-Feb-19

Incredible all these functionalities of excel that can be applied on my daily work.

By Anton R on 27-Mar-19

this course is really good and helpful.