course-premium

Advanced Excel Dashboards

STL
4.3
34 reviews
  • Cherished that the course was stuffed with subject material. Significantly more to really get your teeth into and learn than your normal work environment training.
    ← | →
  • A decent course, it gives you a more profound comprehension of viewpoint - from making guidelines to classifying approaching messages instantly.
    ← | →
  • Dough is a great teacher and provides an excellent training. He is very talented and patient. Thanks to him I have gained new Excel skills.
    ← | →

Course

In London

£ 201-500

Become the Master of Excel with this Advanced Course!

  • Start date

    Different dates available

Rated excellent on Trustpilot!

Learn many of the advanced and complicated features of Excel! Dashboards are awaiting your challenge!

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.

Why not ask for more information? An assessor will get in touch with you and solve all your doubts!

Facilities

Location

Start date

London
See map
12 Bloomsbury Square, WC1A 2LP

Start date

Different dates availableEnrolment now open
London
See map
2nd Floor, Cruising Association House 1 Northey Street, E14 8BT

Start date

Different dates availableEnrolment now open

About this course

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.

Completion of our Excel Dashboards for Business Intelligence course or equivalent knowledge.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.3
fantastic
  • Cherished that the course was stuffed with subject material. Significantly more to really get your teeth into and learn than your normal work environment training.
    ← | →
  • A decent course, it gives you a more profound comprehension of viewpoint - from making guidelines to classifying approaching messages instantly.
    ← | →
  • Dough is a great teacher and provides an excellent training. He is very talented and patient. Thanks to him I have gained new Excel skills.
    ← | →
100%
4.3
fantastic

Course rating

Recommended

Centre rating

Matt

5.0
14/10/2016
What I would highlight: Cherished that the course was stuffed with subject material. Significantly more to really get your teeth into and learn than your normal work environment training.
What could be improved: Nothing.
Would you recommend this course?: Yes

Michael

4.0
08/10/2016
What I would highlight: A decent course, it gives you a more profound comprehension of viewpoint - from making guidelines to classifying approaching messages instantly.
What could be improved: Nothing bad.
Would you recommend this course?: Yes

Amanda

5.0
21/09/2016
What I would highlight: Dough is a great teacher and provides an excellent training. He is very talented and patient. Thanks to him I have gained new Excel skills.
What could be improved: Everything was OK.
Would you recommend this course?: Yes

Emma

4.5
09/09/2016
What I would highlight: Great guide and subject matter of skill enhancement programme.
What could be improved: Everything OK.
Would you recommend this course?: Yes

Zoe

4.5
01/03/2016
What I would highlight: I felt the course was incredible. It is exceptionally clear that the mentor was greatly educated about Excel and Dashboards. I realized the course to a great degree valuable and would suggest it. I do however feel this could without much of a stretch be a 2 day course giving the representatives time to practice what they are realizing. There was a great deal to cover in the one day and now and again it felt rushed - this was not because of the mentor but rather more the sum about the subject matter.
What could be improved: Nothing.
Would you recommend this course?: Yes
See all
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2017

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 7 years

Subjects

  • MS Excel
  • Dashboard
  • Excel
  • Managing Dashboards
  • Source data for reporting
  • PowerPivot
  • Waterfall Chart
  • Speedometer Chart
  • Forecasts
  • Statistical formulas
  • PowerView
  • Source Managing
  • Macro Features
  • Report Writing
  • Report editing

Course programme

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 & 2016)

Advanced charts for Dashboards

Waterfall Chart
Speedometer Chart
Gantt Chart

Forecasts & Trend analysis in Dashboards

Linear & seasonal data sources

Statistical formulas for Dashboards

Slope, Variance,

Multiple page Dashboard

Creating interactivity using macros

PowerView (2013 & 2016)


Additional information

We include hot restaurant lunch in all training courses. In addition to that, our courses are never cancelled.

See related categories

Advanced Excel Dashboards

£ 201-500