Data Visualization with Advanced Excel by PwC (Coursera)
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