Microsoft Excel specialists

Excel training courses

See dates of all courses
Contact us

  


Related Courses
Charts & Dashboards
  WHAT YOU GET

Course manual
& Excel files

20  minutes’
hotline time

Excel expertise
30 years’
specialisation

Dashboards next step

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

Unleash your inner graphical designer: build snazzy graphical features into reports and dashboards. Manipulate Excel's charts to do your bidding, or create entirely new shapes. Be careful though: you can get lost in a cluttered report. Discuss how features help to communicate your message and think critically about what gets in the way.

  YOUR POWER-PACKED AGENDA
Build a chart that fills a shape. Use existing shapes or draw your own. Gender icons fill to compare the results for men with the results for women
Click on a chart or graphic to drill down to a detailed report. Click on a month's total to see a day-by-day line chart
Manipulate data for clarity: convert codes to meaningful text, group hours into shifts and more. A formula converts a date to the text Due Soon, Overdue or Up To Date
Use a slicer to filter two PivotTables or PivotCharts even when each uses a different source data table. When the user selects a Shift, they filter two different charts
Let the user’s selection determine which graphic to display on the dashboard. When the user selects a different work area, part of the report changes to a completely different chart

Prerequisites

Basics of formulas, charts and PivotTables.

  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.