Microsoft Excel features a powerful set of tools for analyzing data and creating dashboards. In this Excel PivotTable training course, you learn to visualize and glean critical insights from large data sets, and leverage Power Pivot for designing dashboards, creating sophisticated lookups across numerous datasets, and extending the capabilities of your Excel workbooks.
Knowledge at the level of Course 4610, Creating & Designing Excel Workbooks Training, is recommended.
Excel PivotTables Training: Building Dashboards Delivery Methods
Attend online or bring this course to your facility
After-course instructor coaching
Excel PivotTables Training: Building Dashboards Course Benefits
Design a dashboard to improve data visualizations with Excel PivotTablesAnalyze data with PivotTables and PivotChartsExpress KPIs with conditional formattingSynchronize multiple data views with slicers
Excel PivotTables Training Outline
Creating PivotTables and PivotCharts
Expressing KPIs with conditional formatting
Synchronising multiple data views with slicers
Connecting multiple tables of data