COURSE INFORMATION

This course covers a variety of options that Excel can give you to display summarised data in a Dashboard. It takes you through the steps of preparing your data to the final visual display of the data.

  • Preparing and shaping your data
  • Introduction to Power Query
  • Power Pivot
  • Dashboard Creation with Pivot Tables, Charts and Slicers
  • Overview of 3D mapping
  • A sound knowledge of Excel Formula and Functions
  • Named Ranges
  • Conditional Formatting
  • Sorting data
  • Filtering data
  • Tables
  • Subtotals and Data Consolidate is recommended
  • A knowledge of Database relationships is beneficial
  • 1 Day Course
  • Delivery at Carnegie Conference Centre 
  • 9.30am - 4.30pm 

£295 Includes: 

  • All course materials
  • Refreshments 
  • 2 course lunch