Data Visualization with Advanced Excel by PwC (Coursera)
This course has been created by PricewaterhouseCoopers (PwC) and is part of their Data Analysis and Presentation Skills: the PwC Approach Specialization. This goal of this course is to help learners expand their analytical skills by answering questions and telling a story with their data. It uses Excel to develop data visualization skills as Excel is the most widely used software tool and is easily available to most learners.
This Data Visualization with Excel course is loaded with hands-on instruction of advanced Excel 2013 functions. It is structured as 4 weekly modules, each requiring around 4 hours of effort to complete. These modules cover the following topics:
- Week1 – This is all about linking data and data models. It covers components of data sets and relational database models and shows how to create databases and data models within Excel using PowerPivot.
- Week 2 – In this week learners will use data to perform various types of scenario and simulation analysis. They will get to practice these skills in Excel by leveraging some of Excel’s built in tools including solver, data tables, scenario manager and goal seek.
- Week3 – This week’s modules focus on data visualization. They cover the basics, outlining the theory and concepts behind data visualization. Also teach how to create detailed graphs and charts to effectively tell a story about your data.
- Week 4 – This week’s lectures use excel to build complex graphs and Power View reports and discuss how to combine them into dynamic dashboards using tools such as form control, slicers and conditional formatting.
The course contains several practice exercises and quizzes at the end of each module. The popularity of this course can be gauged from the fact that it enjoys a handsome rating of 4.8 with more than 65K students enrolled in the course.
Key Highlights
- Understand how to develop a data model using PowerPivot
- Understand the difference between effective and ineffective charting
- Learn to selecting the right type of chart to tell your data story
- Learn how to create column chart, combo chart, stacked column chart, heatmap, gantt project plan and power view reports
- Learn to create your own functional dashboard in Excel
Duration : 4 weeks, 4 hours per week
Sign up Here