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.
Ce cours fait partie de la Spécialisation Data Analysis and Presentation Skills: the PwC Approach
Offert par

À propos de ce cours
Compétences que vous acquerrez
- Dashboard (Business)
- Microsoft Excel
- Data Virtualization
- Data Visualization (DataViz)
Offert par
Programme de cours : ce que vous apprendrez dans ce cours
Preparing a Professional Excel
Advanced Scenario Analysis
Data Visualization
Dashboarding
Avis
- 5 stars80,73 %
- 4 stars16,38 %
- 3 stars1,96 %
- 2 stars0,49 %
- 1 star0,42 %
Meilleurs avis pour DATA VISUALIZATION WITH ADVANCED EXCEL
Just so much to learn... With the lessons here, an activity that would cost 30min time to execute should take 10min or less if the tools are utilized... Excel has lots of magic hidden wands!
Very insightful and practical. Lots of different exercises and tools for everyday visualization. Could be somewhat more challenging but learned a whole lot of new tricks and tips. Highly recommended
Nice, especially part with dashboards.
I was pretty familiar with all techniques, but it good to have an understanding of what big company is expecting from you.
Amazing course! I love excel so for me the 'learning by seeing and doing' - demo approach really resonated. The workbook shared are also detailed for guidance and future reference.
À propos du Spécialisation Data Analysis and Presentation Skills: the PwC Approach

Foire Aux Questions
Quand aurai-je accès aux vidéos de cours et aux devoirs ?
À quoi ai-je droit si je m'abonne à cette Spécialisation ?
Une aide financière est-elle possible ?
D'autres questions ? Visitez le Centre d'Aide pour les Étudiants.