In this course, you will get hands-on instruction of advanced Excel 2013 functions. You鈥檒l learn to use PowerPivot to build databases and data models. We鈥檒l show you how to perform different types of scenario and simulation analysis and you鈥檒l 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鈥檒l 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.
Introduction to Week 4
Loading...
Skills You'll Learn
Databases, Spreadsheet Software, Data Analysis, Pivot Tables And Charts, Data Storytelling, Microsoft Excel, Data Presentation, Simulation and Simulation Software, Graphing, Data Modeling, Excel Formulas, Data Visualization, Dashboard, Data Visualization Software
Reviews
4.8 (2,987 ratings)
- 5 stars80.38%
- 4 stars16.63%
- 3 stars1.97%
- 2 stars0.53%
- 1 star0.46%
KK
Mar 22, 2023
It has been an amazing journey in the last 3 courses. I really enjoyed this course in particular as it delves deeper into advanced functionalities of excel and helps learn about dashboards.
RM
Oct 2, 2019
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.
From the lesson
Dashboarding
Taught By
Alex Mannella
Alumni / Former Principal