Subscribe for access to this FREE e-learning mini-course!


Your First Name:


Your Surname:


Your Email Address:



Subscribe
Close


Hamburger menu
Menu
bookings:   0333 6000 111
service:       0333 6000 555
    or           
Microsoft Excel Dashboards
Microsoft Excel Dashboards
 

EXCEL DASHBOARDS

The best solution for Training Courses Uk

A hands-on one-day course with free e-learning revision after your training and pre-course online skills testing
See Our Latest Reviews on TrustPilot:
CPD CERTIFIED COURSE
CPD accredited course

Note: this Excel Dashboards course is CPD certified.
This means that not only has it been rigorously assessed in terms of content and quality, but it comes with a FREE CPD Certification certificate, as well as an Activia diploma of completion.

COURSE OUTLINE

Full details of modules and topics covered in this one-day course

VERSIONS COVERED

This course covers 2007, 2010, 2013 and 2016 versions

Blended learning
FREE E-LEARNING REVISION

Note: Free e-learning revision is available with this course: 12 months of access for each delegate on scheduled public (open) classes and standard on-site/private classes (not available for bespoke courses) .

DURATION

This is a one-day training course structured into 7 modules

COURSE AIMS

This advanced one-day training course teaches delegates how to create interactive Excel dashboards, that update with the click of the Refresh button, or with a simple copy and paste of your new data into your spreadsheet.

TARGET AUDIENCE

Anyone with an advanced knowledge of Excel who wants to learn how to create dashboards which will enhance their spreadsheets with easily understood and interactive data displays.

Excel Dashboards provide insight, analysis and even alerts. They are interactive and dynamic, and have a wide range of applications, providing help with project management, customer service, KPI management, forecasting and so on.

They usually fit on one page, displaying key trends, comparisons and data in small graphs or tables. This makes them easy to read and digest the information.  They are also often interactive, which allows the user to filter data and switch views themselves.


Want to see prices and options for delivery of your training?

MODULE 1:  Introduction to Dashboards
Learning outcomes:
None
Topics covered:
  • Overview of how dashboards are so useful
MODULE 2:  Inserting Graphics for a Dashboard
Learning outcomes:
None
Topics covered:
  • Inserting a Simple Chart
  • Using Sparklines with Dashboards
  • Using Tables to Dynamically Link Charts & Lists
  • Linking Charts Across Worksheets
MODULE 3:  Specialist Functions and Formulas
Learning outcomes:
None
Topics covered:
  • The OFFSET Function
  • Nested IF Statements Using the AND and OR Operators
  • VLOOKUPs
  • The MATCH Function
MODULE 4:  Dashboard Navigation
Learning outcomes:
None
Topics covered:
  • Creating Bespoke Navigation Bars
  • Creating Dashboard Links
  • Using Named Objects
MODULE 5:  Preparing your Workbook's Layout and Structure
Learning outcomes:
None
Topics covered:
  • Organising Data in Data Tables using IFs
  • Using Table Formulas to Make Dynamic Charts
  • Using More Table Formulas with Conditional Formatting
  • Using OFFSETs, VLOOKUPs and Name Range Lists
MODULE 6:  Using Excel Objects for Specialist Dashboard Views
Learning outcomes:
None
Topics covered:
  • Adding a Data Bar into your Dashboard
  • Creating a Window Chart
  • Creating an Advanced Comparison Chart
  • Creating a Timeline Chart
MODULE 7:  Using Macros and VBA with Dashboards
Learning outcomes:
None
Topics covered:
  • Looking at Macros and the Visual Basic Interface
  • Configuring Controls using Macros
  • Ironing out Minor Issues in your Dashboard with VBA
  • The Select Case

Want to see prices and options for delivery of your training?

RELATED COURSES

Excel Introduction

COURSE OUTLINE
[Duration: one day]

Excel Introduction

  • Getting Started with Microsoft Excel
  • The Excel Interface
  • Microsoft Excel Basics
  • Editing your Workbook
  • Printing and Viewing your Workbook
  • Working with Charts in Excel

Excel Intermediate

COURSE OUTLINE
[Duration: one day]

Excel Intermediate

  • Advanced File Tasks
  • Working with Functions and Formulas
  • Managing Tables in Microsoft Excel
  • Data Tools in Excel
  • Doing More with Charts in Excel
  • Sparklines

Excel Advanced

COURSE OUTLINE
[Duration: one day]

Excel Advanced

  • Grouping & Outlining and Subtotals
  • What-If Analysis
  • PivotTables
  • Charting Pivoted Data
  • Advanced Excel Tasks
  • Creating HLOOKUP and VLOOKUP Functions
  • Introduction to Macros in Excel

Excel Professional

COURSE OUTLINE
[Duration: one day]

Excel Professional

  • Advanced Conditional Formatting
  • Using Form Controls and Templates
  • Advanced Lookup Functions
  • Advanced Functions in Excel
  • Advanced Pivot Table Tools
  • Introduction to User Defined Functions Using VBA

Excel VBA Introduction

COURSE OUTLINE
[Duration: one day]

Excel VBA Introduction

  • Recording and Running Macros in Excel
  • Introduction to the Excel VBA Editor
  • Creating Procedures and Functions
  • Working with the Excel Object Model
  • Controlling Program Flow

Excel VBA Advanced

COURSE OUTLINE
[Duration: one day]

Excel VBA Advanced

  • Advanced Procedures
  • Advanced Variables
  • Interacting with Office Applications
  • Debugging and Error Traps
  • Creating Custom User Forms
  • Workbook and Worksheet Events

Excel Business Intelligence (BI)

COURSE OUTLINE
[Duration: one day]

Excel Business Intelligence (BI)

  • Importing and Linking Data
  • Data Manipulation with Pivot Tables
  • Advanced Reporting Functions
  • Automating Reports with Controls
  • Advanced Charting Features

DELEGATE FEEDBACK FOR OUR
MICROSOFT EXCEL DASHBOARDS COURSE

AVERAGE REVIEW: 4.6 out of 5  BASED ON 12 REVIEWS

Samantha Hodson
, Sep 24 2018
"The trainer was great: he was very calm, friendly, approachable, explained everything well, assisted my colleague who had a limited knowledge of Excel."


 
Course rating of 4 stars
Victoria Steele
, Aug 20 2018
"Tony was a great trainer, very knowledgeable, patient and approachable - thanks!"


 
Course rating of 5 stars
Sandra Tucker
, Sep 21 2017
"Excellent course- thank you"


 
Course rating of 5 stars
Eva Pollard Svobodova
, Sep 18 2017
"Excellent trainer"


 
Course rating of 4 stars
Morag Robertson
, Jun 26 2017
"Jamies was helpful, professional and very knowlegible- I found the day both enjoyable and informative"


 
Course rating of 5 stars
Stephanie Roff
, Jun 22 2017
"excellent training once again simon is a great teacher"


 
Course rating of 5 stars
Anna Crane
, Jun 15 2017
"Very good training, our trainer was excellent."


 
Course rating of 4 stars
Timothy Basham
, Jun 15 2017
"Excellent, responsive, knowledgeable trainer."


 
Course rating of 4 stars
Chris Barnard
, May 18 2017
"Gareth is a great trainer and very knowledgeable in the subjects covered and very helpful in his suggestions and explanations when posed with examples from within my current position."


 
Course rating of 5 stars
Clare Glanvill
, Apr 24 2017
"The trainer (Wendy) was fabulous. Excellent course, really enjoyed it."


 
Course rating of 5 stars

MORE INFORMATION FOR
MICROSOFT EXCEL DASHBOARDS

Blended learning
FREE E-learning Revision

With our latest Microsoft Excel courses, you get free e-learning revision for a full 12 months after your class so you can reinforce the knowledge you have gained.

Access is simple: go to www.activia.co.uk/login/ and log in using your email address.   This will give you free access to our e-learning revision modules.

Note: These have been developed and written exclusively by Activia to maximise effectiveness, by matching the e-learning exactly to what you cover in class.   We hope you have fun, on the day of the course and with honing your knowledge afterwards!

General Information

All Activia training courses uk has been created, reviewed and developed to ensure up to date provision and constantly improving standards of content. Our Microsoft Excel training is interactive and classroom-based which maximises learning through the ability to ask questions and discuss specific issues.

Class Sizes

Maximum class size for Microsoft Excel courses is 8 delegates, which ensures that attendees get adequate time for personal attention from the instructor. At some of our centres, the maximum class size is 6 delegates.

Note that we never cancel our scheduled classes -- even if there are only one or two delegates -- so once you have booked, your place is assured.

For training at your offices, we can deliver classes of up to 10 delegates, though with bigger class sizes you must understand that there is less time for questions from delegates, and this may affect the quality of their experience.

How to book
Course, dates and delegate numbers
Decide on the Microsoft Excel course you want, the date(s) you can attend, and the number of delegates involved
Training location
Also decide whether you want training at your offices or at one of our centres
Speedy course booking
You can use the Speedy Quote option to contact us for a quick price, or you can book online from the schedule on this website
Call us
if at any time you want help or advice, or you want to book on the telephone, just call us on 0333 6000 111 to speak to one of our friendly training advisors

Note: With non-credit card bookings you must sign and return a Booking Form before we can confirm your training.

Also note: If you are a private individual you must pay by credit card at the time of booking.

The confirmation process
Course places allocated
Your place is allocated, along with the trainer, workbooks and exercise files if appropriate
Booking confirmation
You receive an official confirmation, with joining instructions (and directions if it's at our centre)
Training invoice
You receive a VAT invoice

Note: Please allow 1 - 2 working days for your confirmation and invoice.

What happens on the day

If you are coming to our centre, dress code is smart casual.   Refreshments in the form of tea/coffee will be provided for morning and afternoon breaks, but please note that we do not provide lunch.   The timetable is as follows:

9:15

ARRIVAL TIME

9:30

TRAINING STARTS

11:00

MID-MORNING BREAK



1:00

ONE HOUR LUNCH BREAK

3:15

MID-AFTERNOON BREAK

4:30

WRAP UP

Note: break times can vary according to the needs of the training, and course duration for smaller class sizes are usually shorter because fewer delegates have fewer questions !

For training at your offices, this itenerary can be varied by prior arrangement.

What you get

With every Microsoft Excel training course with Activia, you get a free workbook as well as downloadable exercises, which match the course content exactly, so you can review and revise afterwards to reinforce your knowledge. With all courses, you are also given 12 months access to free e-learning revision which will further help you to reinforce the lessons you have learned.

Every delegate on a Microsoft Excel course also gets an Activia Training Attendance Certificate.



GET IN TOUCH

Call us on:
0333 6000 111

   You can Email us direct (You'll usually get a response within 2-3 working hours)
   Or fill out the details below and we'll be in touch very soon:
SEND MESSAGE

Stay in touch
          TrustPilot
CPD
ILM
ISO9001


Back to top
Quick Links
More on This Page
Site Cookies
We have placed cookies on your device to help make this website better.

You can change your cookie settings in your browser. Otherwise, we’ll assume you’re OK to continue.

I'm fine with this