START
 

Excel - Dashboards

SquareOne Training
Course summary
Length: 1 day
Price: 220 GBP excl. VAT
Language: English
Course type: Open / Scheduled
Next available date: 24/07/2017 09:30 - Liverpool
Course Dates
Liverpool
24/07/2017 09:30 
220 GBP
Contact us for more information  (English)
Birmingham
Please enquire for dates & details  (English)
220 GBP
London
Please enquire for dates & details  (English)
220 GBP

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 - In-House IT & Computer Training

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


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
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:

 
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