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.Lee mas.
Este recurso es ofrecido por un socio afiliado. Si paga por la capacitación, podemos ganar una comisión para respaldar este sitio.
Las técnicas y herramientas cubiertas en Data Visualization with Advanced Excel son muy similares a los requisitos que se encuentran en los anuncios de trabajo de Analista de datos.
Data Visualization with Advanced Excel is a part of uno structured learning path.
5 Courses
6 Months
Data Analysis and Presentation Skills: the PwC Approach
