Microsoft Excel specialists

Excel training courses

See dates of all courses
Contact us

  


Related Courses
Dashboards next step




  WHAT YOU GET

Course manual
& Excel files

20  minutes’
hotline time

Excel expertise
28 years’
specialisation

Charts & Dashboards

     Duration: 1 day  
     Format: Fully hands-on  
   Arrival and refreshments: 8:45am  
   Start 9:00am  
   Finish: 4:30pm  

What is the most effective way to present your data? Learn to communicate persuasively. Use colour and graphics to draw attention to key points. Combine charts, tables, and other elements in compact dashboard reports, and review key performance indicators at a glance.

  YOUR POWER-PACKED AGENDA

Create charts

  • Navigate the new Formatting Task pane in Excel 2013 and later
  • Create and format charts
  • Quickly add new data to a chart
  • Combine chart types for striking effect

Learn charts conventions

  • Determine whether a chart, table, or both is the best way to communicate
  • Decide which chart type best represents your data
  • Know which chart types to use and which to avoid
  • Learn how to use colour
  • Format and arrange chart elements in the best way
  • Remove distractions

Conditional Formatting

  • Colour cells according to the band they fall within
  • Colour entire rows according to the band they fall within
  • Learn which colours should be used
  • Add conditional ticks and crosses, up and down arrows and traffic lights
  • Set up conditional formatting so you can turn it on or off at will
  • Use to shade duplicates

Dashboards

  • Learn the essential rules for good dashboard design
  • Easily combine tables into a single report, tables that have differing column widths
  • Reformat multiple charts quickly (no really!)
  • Make multiple charts automatically have the same X-axis maximum
  • Discover the power of conditional picture links for your KPI reporting
  • Add traffic light charts

Prerequisites

No prerequisites other than rudimentary Excel skills are required.


  LEARN IN A POSITIVE ENVIRONMENT
 
  • Be assured the advice you get is well-proven and utilised.
  • Feel free to ask questions.
  • Get time away from the office and constant interruptions.
  • Enjoy a friendly environment where you don’t feel you’re holding others up.
  • Instantly apply what you’ve learned on return to work.

Presenters

AbleOwl has a number of different presenters, all of whom are Excel specialists.

See dates of all courses  

  COURSE CANCELLATION POLICY
 
A course booking is considered final when received in writing (online, email, fax or post) by AbleOwl, and can be cancelled up to ten working days before the course. After that, payment is expected in full and no refund will be given. All cancellations must be notified in writing, i.e. post, fax or email. Another delegate may be substituted at any time.


Learn in a positive environment



  • Be assured the advice you get is well-proven and utilised.
  • Feel free to ask questions.
  • Get time away from the office and constant interruptions.
  • Enjoy a friendly environment where you don’t feel you’re holding others up.
  • Instantly apply what you’ve learned on return to work.

The courses cover Microsoft Excel releases 2010 through 2016 and Office365.
Where there are differences among the covered releases, they are pointed out.


Course cancellation policy:



A course booking is considered final when received in writing (online, email, fax or post) by AbleOwl, and can be cancelled up to ten working days before the course. After that, payment is expected in full and no refund will be given. All cancellations must be notified in writing, i.e. post, fax or email. Another delegate may be substituted at any time.