HOME
 

Microsoft Excel Dashboards

Activia Training
Course summary
1 day
199 - 249 GBP excl. VAT
English
Open / Scheduled
Next available date: 03/04/2020 09:15 - Bristol
Course Dates
Bristol
03/04/2020 09:15  (English)
249 GBP
26/06/2020 09:15  (English)
199 GBP
Leeds
06/04/2020 09:15  (English)
249 GBP
20/05/2020 09:15  (English)
232 GBP
Reading
08/04/2020 09:15  (English)
249 GBP
18/05/2020 09:15  (English)
232 GBP

Course description

Our Microsoft Excel Dashboards course will push your Microsoft Excel skills to a new level.

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.

Do you have questions about COVID-19 in relation to this course?

At findcourses.co.uk we are committed to helping everyone who wants to learn, to learn. So are our trusted partner providers.

Get in touch on this page to find out whether there are any changes to this course in light of COVID-19.

Training Course Content

Introduction to Dashboards
  • Overview of how dashboards are so useful
Inserting Graphics for a Dashboard
  • Inserting a Simple Chart
  • Using Sparklines with Dashboards
  • Using Tables to Dynamically Link Charts & Lists
  • Linking Charts Across Worksheets
Specialist Functions and Formulas
  • The OFFSET Function
  • Nested IF Statements Using the AND and OR Operators
  • VLOOKUPs
  • The MATCH Function
Dashboard Navigation
  • Creating Bespoke Navigation Bars
  • Creating Dashboard Links
  • Using Named Objects
Preparing your Workbook's Layout and Structure
  • 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
Using Excel Objects for Specialist Dashboard Views
  • Adding a Data Bar into your Dashboard
  • Creating a Window Chart
  • Creating an Advanced Comparison Chart
  • Creating a Timeline Chart
Using Macros and VBA with Dashboards
  • Looking at Macros and the Visual Basic Interface
  • Configuring Controls using Macros
  • Ironing out Minor Issues in your Dashboard with VBA
  • The Select Case

Why choose Activia Training

25 years of training businesses

10 centers nationwide

278 active courses

Get Inspired! Watch the Video

   

About provider

Activia Training

Activia Training

When you organise your training, you need a partner who is able to deliver the skills improvements you need, and Activia have grown into a major UK provider on the strength of excellence in key areas. Whether it's competitive prices,...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Microsoft Excel Dashboards.

  Contact the provider

  Get more information

  Register your interest

Contact info

Activia Training

Berkshire
Regus House, 268 Bath Road
SL1 4DX Slough

 Show phone number
www.activia.co.uk Course homepage


Reviews

Average rating 4.5

Based on 13 reviews

Samantha
(4)
The trainer was great: he was very calm, friendly, approachable, explained everything well, assisted my colleague who had a limited knowledge of Excel.
Victoria
(5)
Tony was a great trainer, very knowledgeable, patient and approachable - thanks!
Victoria
(5)
Thanks to Tony, who was an excellent trainer.
Request information

Find out more about this Microsoft Excel Dashboards course - simply fill out your details:

What do you want to know more about?
Do you offer this course online/virtually
I want to know more about this course
Do you offer discounts on more than one applicant?
I have another question
U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!

uk-ld-report-2019

Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here