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
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 94 / 100

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

placeholder

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
More courses by Alex Mannella

Data-driven Decision Making

Free

Problem Solving with Excel

Free

icon
Reviews

4.7

219 total reviews

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

By Vipul G on 7-Jul-19

bad quality

By Ajeetkumar V on 27-Sep-19

First of, PowerPivot is not available on Mac which was not made known from the start of the course. If this course is going to use PowerPivot (a feature unavailable on Mac), it should have been stated the pre-requisites. Unresponsive instructors - students are troubleshooting and speaking amongst ourselves. Many threads are left without any replies at all, most were common issues. Some threads are as old as 3 years ago and still without replies from the instructors. I understand there is a lot of thread to go through but it is an expectation that tutors reply to most (if not, all) threads similar to course expectations on other platforms like Udemy. The course content sequence is illogical - Why is the student workbook section comes before the video section explaining the instructor's exercises? If that is the plan then you should have included instructions telling students to watch the rest of the videos before attempting the exercise. Also, answer sheet errors and incorrect answers should be rectified ASAP because it is very misleading for students (especially those newer to the subject matter) to understand whether they are getting the correct answer or not i.e. Week 1 Pivot 3b. There is a thread about this issue from 3 YEARS AGO and the answer sheet is still not revised.

By Ahmed E on 27-Aug-19

The information provided within is very useful and laid out with helpful tools, however it relies entirely on the PowerPivot function that is not available on a MAC platform, which was not listed in the course description and which made the course totally useless for my needs.

By Dmitriy K on 14-Feb-18

Для самых маленьких

By Eleftheria T on 22-Feb-18

The course covers a lot on Power Pivot of Excel, yet MS has a long list of Excel versions that do not have access to Power Pivot funciton. The instructor does not offer any guidance on this, not does anybody try to solve the problem in forum. Have to skip the course.

By Georgy G on 13-Aug-19

A lot of the functions are outdated and due to the countless versions of Excel that are now available, not all of the different functions necessary to do this course are not potentially plausible.

By Jörg S on 18-May-19

helpful

By Jose V D on 5-Feb-18

Moves too quickly and doesn't give an idea of what you're really trying to accomplish. Dashboards are fantastic, but I think this needs a more hands-on touch.

By Peng Z on 25-Sep-17

Some interesting tools were presented, some were a little too mainstream/obvious.

By Matthew A on 1-Jan-18

Well structured but a bit too simple.

An insightful course that introduces the student to some key tools of excel and helps understand the utility and applicability of the software. Certain demonstrations are sketchy and tend to being a tad bit superfluous. I would have liked some more practice material or at least a reference to where quality practice spreadsheets can be found. Nonetheless, I benefited from the course and would recommend it to anyone initiating herself towards excel.

By Vladimir O on 17-Apr-18

I expected something about VBA