Skip to content
Write a review
CourseraExcelFree courseAdvanced levelCertificate

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.

4.7
219 reviews

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.
Read More Advanced Advanced Level product length iconTime: 10h

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.

Read More

icon
More courses by Alex Mannella

Free

Free

All courses by Alex Mannella

icon
Reviews

4.7

219 reviews in total

Select a bar to show only those reviews.Select the bar again to show every rating.

Write a review

By Nawaz R A on 8-Nov-19

1) Please Try to include more Excercises. Explore more excel functionalities

By Chanchal on 2-Nov-19

Basic course, but provides good overall view on Excel visualization capabilities (charts, powerpivot, pivotchart, slicers, etc.)

By joaodavidcoelholuis on 15-Oct-19

one of the best courses .thankyou pwc! for inhancing my analyatical skills.

By Jose P on 14-Oct-19

Excellent, thanks!

By Héctor E G on 2-Oct-19

This course was really useful to learn how to use really useful tools for business in Excel. I feel that I am really satisfied with what I learned through this course. Widely recommended.

By Peter B on 2-Oct-19

This course really ticks
many important points, far exceeded my expectations!!!

By Rahul K J on 29-Sep-19

Valuable course,really interesting.

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 Juan M R on 26-Sep-19

Awesome course for anyone who wants to Excel at Excel!!

By Ajay S on 12-Sep-19

Worth to learn and comprehensive teaching method. Overall higher that my expectation and good investment on my time. Definitely from zero to hero. Thank you PwC and Coursera to allow me expose into this worshipful course.

By Daniel H on 5-Sep-19

Very helpful and super easy to apply skills for better visualizing data sets.

By Xiaoxuan W on 1-Sep-19

Course was very well organized. Each topic was explained adequately. I just wish that for certain tools like Scenario manager more examples could be incorporated.

Showing 12 of 219 reviews

Data Visualization with Advanced Excel
Visit course on Coursera Write a review
  • Video Duration: icon 10h
  • Price: Free
  • Provider: icon Coursera
  • Year: icon 2018
  • Level: Advanced Advanced
  • Language: icon English
  • Certificate: icon Yes

Coursera Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com