START
 

Excel - Dashboards

SquareOne Training
Course summary
Length: 1 day
Price: 220 - 250 GBP excl. VAT
Language: English
Course type: Open / Scheduled
Next available date: 13/12/2017 09:00 - Liverpool
Course Dates
Liverpool
13/12/2017 09:00  (English)
250 GBP
Contact us for more information  (English)

Course Description

This course is suitable for anyone in Business Intelligence, including Project Managers, or Data Analysts. On this course you will learn some of the more advanced features of Excel and how they can be sued to work together in an interactive and graphical way.

Suitability - Who should attend?

This course is suitable for anyone in Business Intelligence, including Project Managers, or Data Analysts. On this course you will learn some of the more advanced features of Excel and how they can be sued to work together in an interactive and graphical way.

Pre-Requisites

For more information on suitability, please send an enquiry here

Training Course Content

Dashboards 

  • What are they and why should we use them 
  • Examples and information sources 
  • Some Do’s and Don’ts 

Collecting Information

  • Lists versus Tables 
  • Advanced Pivot tables 
  • Advanced Charting 
  • 3d addressing 
  • Naming cells and ranges 
  • Using Offset, Index and Match to control data 
  • Using Goal seek and Scenario manager 
  • Using Combos for data selection 
  • Using VBA Forms 
  • Hyperlinks to other information 
  • Obtaining data from other sources 

Presenting Information

  • Using Windows vs Cells 
  • Using Multiple windows 
  • Protecting information 
  • Interactive dashboards 
  • Saving and loading dashboards 

Using Dashboards in PowerPoint

Creating a Speedometer

Expenses

For information on pricing for this open/scheduled course, please send an enquiry here

This course can also be delivered in-house and tailored to meet the particular requirements of your organisation. 

Provider: SquareOne Training

SquareOne Training

SquareOne Training

SquareOne Training is an internationally renowned IT Training company who create inspiring, motivational and cost effective training services which bring about tangible improvements in productivity. They specialise in providing classroom courses, Microsoft upgrade training, IT consultancy and large-scale rollout support...


Read more and show all courses with Provider: SquareOne Training

Request information - obligation free

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

  Contact the provider

  Get more information

  Register your interest

Errors
Optional
Optional
Optional

Contact information for SquareOne Training

SquareOne Training


2 Tower Road
CH41 1FN Birkenhead

 Show phone number
www.squareonetraining.com

Contact SquareOne Training

Reviews by course attendees

          (5)
Delegate   |   23/05/2017
I would like a bit more on VLOOKUP as I have not used it before - but everyone else was familiar
          (5)
Delegate   |   23/05/2017
I really enjoyed this course. I would like to do a Macro course also
          (5)
Delegate   |   23/05/2017
We recapped on IF statements and nested Ifs - I found this really useful
Enter & win £50 voucher

HOW DOES YOUR L&D STRATEGY COMPARE?

Take our survey and go in the draw to win a £50 Amazon Voucher

Take the survey

 
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

 
Request information

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

 
Similar courses

With Activia, IT User training comes the way you want it: at your place or ours; off-the-shelf or bespoke; scheduled public classes or closed private courses matched to your requirements.

 
Case Study
SquareOne Deliver IT Rollout Pro...

Read about SquareOne's global projects in New Hardware and Software Refresh and Microsoft Lync/Skype Rollout.

Read more
 
Find more courses here