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.Read more.
This resource is offered by an affiliate partner. If you pay for training, we may earn a commission to support this site.
The techniques and tools covered in Data Visualization with Advanced Excel are most similar to the requirements found in Data Analyst job advertisements.
Data Visualization with Advanced Excel is a part of one structured learning path.
5 Courses
6 Months
Data Analysis and Presentation Skills: the PwC Approach
