Advanced Excel Dashboards

Course summary
Length: 1 day
Price: 194 - 229 GBP excl. VAT
Language: English
Provider: STL plus
Course type: Open / Scheduled
Next available date: 24/11/2017 09:30 - London
Course Dates
24/11/2017 09:30  (English)
229 GBP
08/02/2018 09:30  (English)
219 GBP
11/05/2018 09:30  (English)
204 GBP
25/06/2018 09:30  (English)
194 GBP
10/08/2018 09:30  (English)
194 GBP
24/09/2018 09:30  (English)
194 GBP

Advanced Excel Dashboards

Courses never cancelled. Restaurant lunch. Last minute rescheduling. 24 month delegate support forum. And more... By the end of this course you will be able to:
Use advanced features to create dashboards in Excel.
Become proficient in the planning, creation and maintenance of advanced Excel dashboards.

Suitability - Who should attend?

This Advanced Excel Dashboards course is ideal for those looking to develop their existing dashboards skills in Excel. Roles that would benefit from this training include BI (business intelligence), data managers, data analysts, or Project Managers.

Training Course Content

Planning a Dashboard

Who is the audience?
Detail level
Time scale considerations

Managing Dashboards

Efficient dashboard updating
Managing sources

Source data for reporting

Prepare data (flat lists)
Link to external data sources
Multiple data sources dashboard (PowerPivot)
Reports based on data models (2013 and 2016)

Advanced charts for Dashboards

Waterfall Chart
Speedometer Chart
Gantt Chart

Forecasts and Trend analysis in Dashboards

Linear and seasonal data sources

Statistical formulas for Dashboards

Slope, Variance,

Multiple page Dashboard
Creating interactivity using macros
PowerView (2013 and 2016)


List price £350 per delegate. Promotional rates apply: see event listings for current prices. On-site training also available: Contact us.

Provider: STL

STL - Microsoft Training

Best in-class training - Be delighted, not just satisfied

We're here to help - from using Microsoft Excel for informed financial decisions, presentation skills for a winning sales pitch,  to leadership & development programmes. Other services include technical training, Microsoft, Oracle, Cisco, eLearning through to project management, Prince2, ITIL and more....

Read more and show all courses with Provider: STL

Request information - obligation free

Fill out your details to find out more about Advanced Excel Dashboards.

  Contact the provider

  Get more information

  Register your interest


Contact information for STL


Greater London
2nd Floor, Cruising Association House, 1 Northey Street
E14 8BT Limehouse Basin

 Show phone number
Enter & win £50 voucher


Take our survey and go in the draw to win a £50 Amazon Voucher

Take the survey

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Request information

Find out more about this Advanced Excel Dashboards course - simply fill out your details:

Similar courses

With Activia, IT User training comes the way you want it: at your place or ours; off-the-shelf or bespoke; scheduled public classes or closed private courses matched to your requirements.

Find more courses here