×

Search our courses

Course Duration:

1 day

Prerequisites:

Delegates must have an excellent knowledge of Excel, be familiar with Pivot Tables and using various functions

Target Students:

Users who wish to produce front end user Dashboards that are interactive and eye catching

Objectives:

On successful completion of the course, delegates will be able to work with various functions, use Pivot Tables, Slicers and Timelines, use advanced techniques to present data graphically including conditional formatting, objects, graphs, images.

Subject Areas:

Overview of how dashboards are so useful

Various Functions

  • IF, AND, OR
  • SUMIF / AVERAGEIF / COUNTIF / COUNTIFS
  • SUMIFS / AVERAGEIFS
  • IFERROR
  • VLOOKUP
  • MATCH
  • Names Ranges

Conditional Formatting

  • Icon sets
  • Data Bars
  • Colour Scales
  • High and Low

Graphical Images

  • Inserting Shapes
  • Using the Snipping Tool
  • Images from the Internet

Creating Graphs

Representing data using various graph options:

  • Donut, Waterfall
  • Pie, Line, Column
  • Sparklines

Pivot Tables

  • Storing data as Tables
  • Creating Pivot Tables
  • Using Slicers
  • Slicer Options and formats
  • Using Timelines
  • Timeline Options and formats

Using the Camera

Macros – To Automate and Navigate

  • Creating, Editing and Running Macros
  • Running Macros to buttons

General Excel Options

  • Hiding Sheets
  • Hiding Formula Bar
  • Sheet displays
  • Password Protecting
  • Column, Row Headings – Hiding
  • Scroll Bars – Hiding

Bringing it all together

If you would like to book onto a course or find out more information please fill out our contact form or call us on 01454 203 355.