>

Excel Dashboards for Business Intelligence Training Course

Excel Advanced training 2010 Training CourseExcel Dashboards for Business Intelligence Training Course

Versions 2013, 2010, 2007

Benefits

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.

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.

Prerequisites

Completion of our Excel Intermediate course or equivalent knowledge.

Benefits

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.

Course Syllabus

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

 Training venues & dates – to book please call or complete an enquiry form

VersionDateLocationBook
2010Fri 15 Apr 2016BloomsburyBook now
2010Thu 23 Jun 2016LimehouseBook now
2010Fri 15 Jul 2016LimehouseBook now
2010Mon 8 Aug 2016BloomsburyBook now
2010Thu 8 Sep 2016LimehouseBook now
2010Mon 10 Oct 2016LimehouseBook now
2010Thu 10 Nov 2016LimehouseBook now
2010Mon 12 Dec 2016BloomsburyBook now
2010Mon 16 Jan 2017LimehouseBook now
2010Mon 20 Feb 2017LimehouseBook now
2010Mon 20 Mar 2017BloomsburyBook now
2010Fri 14 Apr 2017Bloomsbury

Book now

What you get

Training roomTraining is held in our modern, comfortable, air-conditioned suitesModern-spec IT, fully networked with internet access

“What do I get on the day?”

Learning tools

Breaks and TimingsBreaks and timing

Courses start at 9:30am.
Please aim to be with us for 9:15am.
Joining information (how to get to our venues)

In-course handbookIn-course handbook

Contains unit objectives, exercises and space to write notes

RefreshmentsRefreshments

Available throughout the day:

  • Hot beverages
  • Clean, filtered water
  • Biscuits
Reference materialReference material

Available online. 100+ pages with step-by-step instructions

LunchLunch

Lunch is provided at a local restaurant or pub. Browse the sample menus:

24 months forum access24 months access to Microsoft trainers

Your questions answered by Microsoft qualified trainers online.

 

Contact us now and talk to one of our advisers to ask any question you may have about our training.

Blue Find Out More

X
X

Send this to a friend