Excel Dashboards for Business Intelligence
- 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.
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 211,240 people .
- Over 14,223 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 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.
You may also wish to consider one of our VBA training courses.
Training Course Content
What is a dashboard?
Common features of a dashboardWhy use Excel?
PivotTables and PivotCharts
Creating PivotTablesFormatting a PivotTable
Refreshing a PivotTable
Grouping fields
PivotCharts
Slicers and Timelines
Useful functions
Nested IFsCOUNTIFS and SUMIFS
EDATE
INDEX and MATCH
OFFSET
CHOOSE
Conditional Formatting
Formatting valuesColour Scales to show heatmaps
Icon Sets to show at a glance performance
Form Controls
Understanding the different controlsUsing them on a dashboard
Working with Charts
Creating chartsFormatting charts
Secondary Axes
Combination charts
Creating chart templates
Working with Sparklines
Creating and modifying SparklinesCustomizing Sparklines
Design and Layout
Gridlines and outlinesLining up Excel objects
Theming a dashboard
Sample Dashboard Projects
Worldwide Salary IndexSales Performance Analysis
Helpdesk Efficiency
Expenses
Prices on application. Contact us for quote.
Request information - obligation free
Customer Outreach Award
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
I think the main issue is the connection and user checks as many colleagues didn't have a second screen or had technical issues. I would have liked a little more time on the das...
Great course and great instructor. Very knowledgeable and patient.
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...
Jens was great; good pace and very knowledgeable. I have learnt a lot and look forward to implementing it.