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