This post may contain affiliate links. If you buy through these links, we may earn a commission, which helps to support our website.
Sep 22, 2023
Data Visualization with Advanced Excel by PwC (Coursera)

Online Courses by PwC

This course is part of the Data Analysis and Presentation Skills: the PwC Approach Specialization on Coursera. It is the best course to learn Advanced Excel. It comprises of 4 modules where you will get hands-on instruction of advanced Excel 2013 functions and skills to use PowerPivot for building databases and models. You will learn Excel’s built in tools like Solver, Data Tables, Scenario Manager and Goal Seek. Finally, you will learn about Data Visualization, Graphs & Power View Reports and how to combine them into dynamic dashboards.

The Course modules are:
1. Preparing a Professional excel – Covers data models and databases, PowerPivot tool
2. Advanced Scenario Analysis – Explores different analytical methods and how to use them
3. Data Visualization – Covers elements of data visualization like charts and graphs in details
4. Dashboarding – Details design principles and requirements for building a dashboard

The course is taught by Alex Mannella and contains several graded quizzes and assignments with peer feedback. You will earn an electronic Certificate at the end of the course.

Key Highlights

  • Master Advanced Excel functions
  • Learn 3 different analytical methods – Scenario Analysis, Sensitivity Analysis and Simulation
  • Learn how to create detailed graphs and charts to effectively tell a story about your data
  • Perform different types of scenario and simulation analysis using Excel’s set of built in tools
  • Create your own functional dashboard in Excel

Duration : 4 weeks, 3-4 hours per week

Sign up Here

More Details

Leave a Reply

Your email address will not be published. Required fields are marked *

error: Content is protected !!