EX2013L5-001 Excel Dashboards Level 5
£360
EX2013L5-001 Excel Dashboards Level 5

EX2013L5-001 Excel Dashboards Level 5

Event Information

Share this event

Date and Time

Location

Location

Imagine Training Ltd

Marches Growth Hub

University of Wolverhampton, Priorslee Campus

Telford

TF2 9FT

United Kingdom

View Map

Friends Who Are Going
Event description

Description

Dashboards in Microsoft Excel give you the opportunity to present important data in a graphical way to help focus attention on key trends, comparisons and exceptions. This course is to help you establish what data you can access, how to capture it and various ways of displaying it in a visual manner. You will understand dashboard design principles and learn additional formulas which will be useful in calculating values for the dashboard.


The differences between Dashboards and Reports
Questions before you start
Dashboard design principles


Golden Rules

Formatting numbers effectively

Custom Number formats

Useful Formulas for Dashboards

Data tables

Charts

  • Sparklines

  • Charts that show trending

  • Side-by-side comparison charts

  • Secondary axis

  • Conditional Formatting

  • Using Symbols to enhance Reporting

  • Camera Tool

Pivot Tables

  • Creating

  • Sorting

  • Filtering

  • Re-arranging

  • PivotCharts

  • Issues with file size

  • Pivot Table reports

  • Interactivity with slicers

  • Dynamically rearranging pivot table data

Grouping & bucketing data

Showing performance against target

Macros

Useful macros for dashboards

Navigation buttons

Form Controls

Time slicers

People graphs

Protecting your dashboards

10 Questions before distributing your dashboard

Pre-requisites

Delegates should have completed up to and including Level 3 Excel skills, or equivalent experience.

Share with friends

Date and Time

Location

Imagine Training Ltd

Marches Growth Hub

University of Wolverhampton, Priorslee Campus

Telford

TF2 9FT

United Kingdom

View Map

Save This Event

Event Saved