Excel Dashboards for Business Intelligence
Instructor led classroom based course, regular London dates, courses never cancelled
STL
Summary
Credit/debit card
Company invoice
All pricing is ex VAT
- Certificate of completion - Free
- Tutor is available to students
Location & dates
Central London
London
WC1A2LP
United Kingdom
East London
London
E148BT
United Kingdom
Overview
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.
Course media
Description
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
Requirements
Completion of our Excel Advanced course or equivalent knowledge.
Questions and answers
Certificates
Certificate of completion
Digital certificate - Included
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.