Excel Dashboards Made Easy 2 Day Course

Frog SoftwareTraining Ltd

Short course

In Cambridge

Save 4%
£ 465 + VAT

The best Excel courses

See all

See all

Description

  • Type

    Short course

  • Level

    Advanced

  • Location

    Cambridge

  • Duration

    2 Days

Description

Excel dashboards enable visualisation of data to produce high level management reports. Dashboards often have user interactivity to convey the most important information at a glance.

At the end of this course, delegates will be able to manipulate tables of data & use relevant functions; structure data efficiently in order to create Dashboards; use advanced charting techniques to visualise data and create interactive dashboards; understand the use of basic macros/VBA for automation.

Target Audience

Designed for users who need to interpret and communicate large quantities of information clearly by summarising it into easy-to-read tables and graphs.

Facilities

Location

Start date

Cambridge (Cambridgeshire )
See map
4 Station Court, Great Shelford, CB225 NE

Start date

On request

About this course

Delegates should attend Excel Advance Validate and Summarise and Formulae and Functions courses or have equivalent knowledge.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • MS Excel
  • Microsoft Excel
  • Microsoft Office
  • Database
  • Dashboards
  • Advanced
  • Microsoft
  • Macros
  • ActiveX

Teachers and trainers (1)

TBA TBA

TBA TBA

Trainer

Course programme

Overview

  • Excel Dashboards, what they can do for you?
  • Dashboard Design - consideration & tips

Preparing data for the dashboard

  • Connecting to data sources
  • A review of essential functions
    • Logical functions: IF, AND, OR
    • Dealing with Errors
    • Statistical functions: AVERAGE/IF, COUNT/IF, MEDIAN, TREND, FORECAST
    • Look up functions: VLOOKUP, INDEX, MATCH, OFFSET
    • Date functions: TODAY, DATE, EDATE
    • Text functions: CLEAN, TRIM, LEFT, MID, RIGHT
  • Importance of range names and Name Manager
  • Data validation:
    • Data integrity issues
    • Setting validation
    • Cleaning invalid data
    • Protecting your Data
    • Working with sheets

Essential tools for dashboards

  • Conditional formatting:
    • Manager
    • Tips and tricks
  • Excel Tables
  • Pivot Tables - Advanced features
    • Comprehensive overviews
    • Grouping fields
    • Using slicers
  • Pivot Charts
  • Charts and chart types
    • Overview of chart types and their suitability to dashboards
    • Bar, Line, Bubble charts
  • Advanced Charting:
    • Combining different chart types within one plot area
    • Creating user defined charts
    • Saving and using chart templates
  • Interactive charts
  • Chart tips and tricks

Adding ActiveX controls

  • Why use ActiveX controls:
    • Dropdown lists
    • Check boxes
    • Spin buttons

Macros

  • Macro basics:
    • Automating with useful macros
    • Creating navigation tools through protected workbooks

User Defined Functions

  • Importance of user defined functions
  • VBA functions basics

See related categories

Excel Dashboards Made Easy 2 Day Course

£ 465 + VAT

The best Excel courses

See all

See all