Excel Dashboards for Business Intelligence

STL
4.5
15 reviews
  • I found the Tutor (Andrew) amazing. He connected with the learning understudies and it was one of the best instructional courses I have ever attended. I would exceedingly prescribe to anybody wishing to undertake this course.
    |
  • The course was awesome, all that I had trusted it would be and that's only the tip of the iceberg. The educators were exceptionally useful and proficient. I appreciated it and learnt a considerable measure.
    |
  • Booking my fundamental Visio Training course was simple after some awesome direction from Manoj, a devoted individual from the Best STL staff, on the phone. Efficient with great substance this course was well educated by an extremely eager, proficient and inviting mentor, Richard. I would suggest this course and Best STL.
    |

Course

In London

£ 201-500

Description

  • Start date

    Different dates available

Rated excellent on Trustpilot!

This course is best suited to anyone in Business Intelligence, data managers, data analysts, or Project Managers. This course would also suit anyone looking to extend their knowledge of Excel to understand some of the more advanced features and how they can be used to work together.

The downloadable post-course material also contains an expanded glossary of further ways to enhance your dashboards with Speedometer charts, Tornado diagrams, Waterfall charts and the Camera Tool. There are also further resources for connecting to external data sources.

This course is also offered as inhouse. STL may go to your premises or you can visit our venue in London.

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

At the end of this course you will understand what makes a dashboard.

You will learn how to build some of the most useful components when constructing your own dashboard reports.

During the course you will build three complete dashboard projects to give you inspiration for your own solutions.

Completion of our Excel Advanced 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.5
fantastic
  • I found the Tutor (Andrew) amazing. He connected with the learning understudies and it was one of the best instructional courses I have ever attended. I would exceedingly prescribe to anybody wishing to undertake this course.
    |
  • The course was awesome, all that I had trusted it would be and that's only the tip of the iceberg. The educators were exceptionally useful and proficient. I appreciated it and learnt a considerable measure.
    |
  • Booking my fundamental Visio Training course was simple after some awesome direction from Manoj, a devoted individual from the Best STL staff, on the phone. Efficient with great substance this course was well educated by an extremely eager, proficient and inviting mentor, Richard. I would suggest this course and Best STL.
    |
100%
4.3
fantastic

Course rating

Recommended

Centre rating

Charmaine

5.0
16/05/2015
What I would highlight: I found the Tutor (Andrew) amazing. He connected with the learning understudies and it was one of the best instructional courses I have ever attended. I would exceedingly prescribe to anybody wishing to undertake this course.
What could be improved: Nothing.
Would you recommend this course?: Yes

Genavieve

3.5
20/04/2015
What I would highlight: The course was awesome, all that I had trusted it would be and that's only the tip of the iceberg. The educators were exceptionally useful and proficient. I appreciated it and learnt a considerable measure.
What could be improved: No negative aspects.
Would you recommend this course?: Yes

Sophie Hutchinson

4.0
17/04/2015
What I would highlight: Booking my fundamental Visio Training course was simple after some awesome direction from Manoj, a devoted individual from the Best STL staff, on the phone. Efficient with great substance this course was well educated by an extremely eager, proficient and inviting mentor, Richard. I would suggest this course and Best STL.
What could be improved: Nothing.
Would you recommend this course?: Yes

Avnish Kana

4.5
16/04/2015
What I would highlight: An extremely enthusiatic approach with an unfathomable measure of tolerance. To a great degree exhaustive and natural course, covers ranges outside the extent of the course to take into account ALM prerequisites. I would by and by prescribe Best STL to companion, family and business contacts. Well done Jens.
What could be improved: Everything was positive.
Would you recommend this course?: Yes

Adele

4.5
15/04/2015
What I would highlight: Exceptionally enlightening course - incredible coach who was energetic and involving. Exceptionally Recommended
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
  • Business Intelligence
  • Dashboard
  • Excel
  • PivotTables
  • PivotCharts
  • Grouping fields
  • EDATE
  • Conditional Formatting
  • Icon Sets
  • Sparklines
  • Sample Dashboard Projects

Course programme

What is a dashboard?

Common features of a dashboard
Why use Excel?

PivotTables and PivotCharts

Creating PivotTables
Formatting a PivotTable
Refreshing a PivotTable
Grouping fields
PivotCharts
Slicers and Timelines

Useful functions

Nested IFs
COUNTIFS & SUMIFS
EDATE
INDEX & MATCH
OFFSET
CHOOSE

Conditional Formatting

Formatting values
Colour Scales to show heatmaps
Icon Sets to show at a glance performance

Form Controls

Understanding the different controls
Using them on a dashboard

Working with Charts

Creating charts
Formatting charts
Secondary Axes
Combination charts
Creating chart templates

Working with Sparklines

Creating & modifying Sparklines
Customizing Sparklines

Design & Layout

Gridlines & outlines
Lining up Excel objects
Theming a dashboard

Appendix I: Sample Dashboard Projects

Worldwide Salary Index
Sales Performance Analysis
Helpdesk Efficiency



Additional information

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

Excel Dashboards for Business Intelligence

£ 201-500