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

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 Advanced Training Course

On this Microsoft Excel training course you will work with advanced database management, database functions, data validation & protection. You will learn how to work with PivotTables and...

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

This course is for new or users with little Excel experience. The course is designed to introduce the basic concepts of an excel spreadsheet. We look at spreadsheet terminology and become familiar...