Excel PivotTables Training: Building Dashboards

Course 4611

  • Duration: 1 day
  • Labs: Yes
  • Language: English
  • Level: Intermediate

Microsoft Excel features a powerful set of tools for analysing data and creating dashboards. In this Excel PivotTable training course, you learn to visualise 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

  • Unlimited annual access to a library of on-demand courses
  • Unlimited retakes of our 1-day class for a year
  • Exclusive LinkedIn group membership for peer and SME community support

Excel PivotTables Training: Building Dashboards Course Benefits

Design a dashboard to improve data visualisations with Excel PivotTablesAnalyse data with PivotTables and PivotChartsExpress KPIs with conditional formattingSynchronise 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

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

Course FAQs

Learning Tree provides Private Team Training that can save time and travel costs by training your entire team at once, at a convenient location of your choice. We handle all the details including instructor travel, tailored content, comprehensive course materials, shipping and equipment setup and teardown.