Excel Dashboards for Business Intelligence
-
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
Description
-
Type
Course
-
Location
-
Start date
Different dates available
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
Start date
Start date
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.
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 rating
Recommended
Centre rating
Charmaine
Genavieve
Sophie Hutchinson
Avnish Kana
Adele
This centre's achievements
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
Excel Dashboards for Business Intelligence