Manchester Office Tel:  0161 408 0435

London OfficeTel: 0203 693 3945 

 

Interactive Dashboards Using Microsoft Excel

Microsoft  Excel Training Courses

An Excel Dashboard provides analysis and insight into what is happening in your business. They summarise large data sets in real time. If you are required to report complex information such as management information, financial reports or sales and marketing statistics, a Dashboard Report using Microsoft Excel can simplify this task. A dashboard report allow you to obtain a high-level and accurate overview of your business, enabling you to speedily make the right decisions.

 

 

 

Course Type

In-House Instructor led.

 

Duration:

1 Day

 

Overview and objectives

At the end of this course you will be able to

  1. Summaries complex information in a quick and easy-to-read way
  2. Create a professional image to colleagues and customers
  3. Communicate information in a concise and clear manner
  4. Reduce time spent interrogating and investigating detailed data

 

Course Content

Module 1: Dashboard Theory

Dashboard Creation Process

Dashboard design tips & techniques

 

Module 2: Creating Dashboards

Business Dashboard

KPI Dashboard

Website Dashboard

Simple KPI Dashboard

Employee Holiday Dashboard

Dashboard with Maps

Sports Dashboard

 

Related Courses

In House Training Courses

MS Excel 2010 MOS

Learn Microsoft Excel 2010 in the comfort of your own home and at a pace that suits you. Gain the internationally recognised Microsoft Office Specialist certification.  ...

In House Microsoft Excel VBA Training Course

By learning to write Excel VBA code, repetitive and tedious tasks in Microsoft Excel can be performed quickly and accurately. The result is increased efficiency, performance & productivity which...

Microsoft Excel Intermediate Training Course

This Microsoft Excel Intermediate training course is intended for individuals who are self taught and wish to formalise and expand their knowledge of Excel or for those who have completed the Excel...

Microsoft Excel Introduction Training Course

After completing this Microsoft Excel training course you will become familiar with spreadsheet terminology and the Excel interface. You will learn to navigate worksheets and workbooks and how to...