Corporate Training for Teams
4.8 (8 Reviews)

Advanced Excel Dashboards

STL, Nationwide
Length
1 day
Length
1 day
Leave your details so the provider can get in touch

Advanced Excel Dashboards

STL courses


  • 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.

What to expect

  • 24 months post training support included .
  • Tailored and bespoke programme options .
  • Our experienced training and logistics team in the last 23 years have assisted 206,686 people .
  • Over 14,129 organisations trained .
  • We are rated 'Excellent' on Trustpilot and 98.7% of our customers recommend us .
  • Delivery UK wide and international (75+ countries delivered) .

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)


Expenses



Prices on application. Contact us for quote.

Request information - obligation free

Contact course provider

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

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Customer Outreach Award

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Reviews by course attendees

Average rating 4.8

Based on 8 reviews.
Reviews are published according to our review policy.
Write a review!
5/5
Veronica
16 Aug 2017

Brilliant course; Paul has saved us a lot of time with useful hints and tips. Paul explained many methods for making our dashboards flexible and easy to update so that it do...

Show more
5/5
Andries
16 Aug 2017

Most useful topic: Graphs; forecast

5/5
Chris
02 Jun 2017

This course was spot on; a great follow up to the previous BI/Dashboards one I did a few weeks ago. Its definitely worth booking these close to one another and puttin thiings i...

Show more
STL
1 Northey Street, 2nd Floor, CA House
E14 8BT London

STL

Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...

Read more and show all courses with this provider

Ads