HOME
 

Excel Dashboards for Business Intelligence

STL
Course summary
Length: 1 day
Language: English
Location: Nationwide
Provider: STL plus
Course type: Company-Specific / In-House

Excel Dashboards for Business Intelligence



Courses never cancelled. Last minute rescheduling. 24 month delegate support forum. And more... 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.

Suitability - Who should attend?



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.

Training Course Content



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 and SUMIFS
EDATE
INDEX and 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 and modifying Sparklines
Customizing Sparklines

Design and Layout

Gridlines and outlines
Lining up Excel objects
Theming a dashboard

Appendix I: Sample Dashboard Projects

Worldwide Salary Index
Sales Performance Analysis
Helpdesk Efficiency

Expenses



Prices from £748. Promotional rates often available the further ahead you book. Contact us for quote.

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 this provider

Request information - obligation free

Fill out your details to find out more about Excel Dashboards for Business Intelligence.

  Contact the provider

  Get more information

  Register your interest

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.

Contact information for STL

STL

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

 Show phone number
www.microsofttraining.net

Request information

Find out more about this Excel Dashboards for Business Intelligence course - simply fill out your details:

 
U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's first annual U.K. L&D Report!

UK L&D Report

Learn more

 
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

 
Find more courses here