START
 

Excel - Dashboards (In-House)

SquareOne Training
Course summary
Length: 1 day
Language: English
Location: United Kingdom
Next available date: Contact us for more information - United Kingdom

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

This training course will be delivered in the form of a closed course at your company's premises and can be custom tailored to meet the needs and requirements of your particular organisation.

SquareOne can come to you no matter where you are based throughout the UK or Europe. The cost of this training course is available upon request.

Please send an enquiry here

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 (In-House).

  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 (In-House) 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