Excel training courses
Related Courses
Dashboards next step
|
|
WHAT YOU GET
|
Course manual
& Excel files
|
20 minutes’
hotline time
|
Excel expertise
30 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.
|
|
|
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.
|