Excel Dashboards for Business Intelligence Training Course
Versions 2013, 2010, 2007
Who is this course for?
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.
Completion of our Excel Intermediate course or equivalent knowledge.
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.
What is a dashboard?
Common features of a dashboard
PivotTables and PivotCharts
Understanding the different controls
Working with Charts
Working with Sparklines
Creating & modifying Sparklines
Design & Layout
Gridlines & outlines
Appendix I: Sample Dashboard Projects
Worldwide Salary Index
Training venues & dates – to book please call or complete an enquiry form
|2010||Fri 15 Apr 2016||Bloomsbury||Book now|
|2010||Thu 23 Jun 2016||Limehouse||Book now|
|2010||Fri 15 Jul 2016||Limehouse||Book now|
|2010||Mon 8 Aug 2016||Bloomsbury||Book now|
|2010||Thu 8 Sep 2016||Limehouse||Book now|
|2010||Mon 10 Oct 2016||Limehouse||Book now|
|2010||Thu 10 Nov 2016||Limehouse||Book now|
|2010||Mon 12 Dec 2016||Bloomsbury||Book now|
|2010||Mon 16 Jan 2017||Limehouse||Book now|
|2010||Mon 20 Feb 2017||Limehouse||Book now|
|2010||Mon 20 Mar 2017||Bloomsbury||Book now|
|2010||Fri 14 Apr 2017||Bloomsbury|
What you get
|Training is held in our modern, comfortable, air-conditioned suitesModern-spec IT, fully networked with internet access|
“What do I get on the day?”
Courses start at 9:30am.
Contains unit objectives, exercises and space to write notes
Available throughout the day:
Available online. 100+ pages with step-by-step instructions
Lunch is provided at a local restaurant or pub. Browse the sample menus: