Excel training webinar
|
|
WHAT YOU GET
|
Course manual
& Excel files
|
10 minutes’
hotline time
|
Excel expertise
28 years’
specialisation
|
|
|
Graphical reporting and presentation
Charts introduction, conditional formatting and dashboards
Series of 3 training webinars (attend any or all)
Duration: 60 minutes each
|
|
Format: Interactive webinar
|
|
|
Communicate your Excel data persuasively. Employ colour and images to convey key
information clearly. Combine tables and charts into a compact dashboard report.
Review key performance indicators at a glance.
|
YOUR POWER-PACKED AGENDA
|
Charts introduction
Excel makes it easy to present data in a chart. Learn the tricks to create various
chart types that Excel has to offer.
- Create and format a simple Column chart.
Quiz
- Know how to customise charts in a wide variety of ways.
- Add data quickly to a chart.
- Combine different chart types to striking effect.
Quiz
- Add a Pie chart to your charting diet.
- Need more pie? Create a Pie of Pie chart.
Quiz
Conditional formatting
Need to add some punch to your Excel reports? Discover the Excel features that make
your worksheets come alive.
- 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.
Quiz
- Add conditional ticks and crosses, up and down arrows and traffic lights.
Quiz
- Set up conditional formatting so you can turn it on or off at will.
- Use to shade duplicates.
Quiz
Dashboards
Step back from the detail and gain a bird's-eye view of your dept/company's health.
Discover the tools and methodology you need to create dashboard reports in Excel.
- Learn the essential rules for good dashboard design.
- Easily combine tables into a single report, tables that have differing column widths.
Quiz
- Reformat multiple charts quickly (no really!).
- Make multiple charts automatically have the same X-axis maximum.
Quiz
- Discover the power of conditional picture links for your KPI reporting.
- Add traffic light charts.
Quiz
|
Prerequisites
No prerequisites other than rudimentary Excel skills are required to attend the
charting or conditional formatting webinars. To attend the dashboards and KPIs webinar,
you should already be familiar with chart creation and conditional formatting.
Applies to Excel versions including 2013, 2010, and 2007.
|
|
PRESENTATION FORMAT
|
|
|
|
Live webinar format
See the presentation on your PC screen and hear the presenter either from your PC
speakers/headphones or on the telephone.
Type questions on the chat line during the presentation. Questions will be answered
by the co-presenter.
Stay engaged with multiple-choice quizzes.
Test out the webinar technology with one of the free Excel 10-minute tips webinars.
|
Presenters
Each webinar has a main presenter and a co-presenter, who share the presentation
and question-answering. Having two makes it more engaging, and different viewpoints expressed makes it clearer.
There are a number of different AbleOwl presenters, all of whom are Excel specialists.
|
|
Excel versions
Unless specified otherwise, all webinars cover all current Excel versions from 2007 onwards. Any differences among versions are pointed out.
|
|
|
COMPARISON OF ABLEOWL WEBINARS TO OTHERS'
|
|
Webinar characteristics
|
AbleOwl
|
Others
|
|
Two presenters share the teaching, so one can answer queries, and the dialogue between
makes the webinar more engaging.
|
*****
|
*
|
|
You’re encouraged to interact with the presenters through quizzes and chat-box discussions:
you’re not a passive observer.
|
****
|
**
|
|
Presenters are Excel specialists, can give additional insight and answer any queries.
|
*****
|
****
|
|
Each different presenter brings his/her own personality and humour(?).
|
****
|
**
|
|
You discover not only Excel parts, but also how to structure and standardise, like
learning not only words, but grammar too.
|
*****
|
*
|
|
You get a step-by-step PDF manual sent in advance to preview and review.
|
*****
|
*
|
|
You can take advantage of expert post-webinar email support to help you get the
full benefit from your new skills.
|
*****
|
*
|
|
You are provided a clear and consistent learning path, without duplication, by the
depth and breadth of webinar series topics.
|
*****
|
***
|
|
You can purchase multiple vouchers at considerable savings. |
****
|
**
|
|
|
TESTIMONIALS
|
|
|
"Great. I was able to follow really easily and it flowed along logically. Good pace.
Good to have the 2 presenters i.e. who can “chat’ about what’s being done, giving
2 points of view etc."
Debbie, Financial Accountant, Hamilton, New Zealand
"I would like to send you a thank you for the clearly presented and well paced webinar
I took part in yesterday. This was my first ever webinar and also my first interaction
with your company and found it to be a beneficial and enjoyable experience. I look
forward to my next webinar and your tips etc."
Fiona, Office Manager, Brisbane, Australia
"The rapport between Paul and Grant was great and makes it more interesting than
a one way presentation."
Maureen, Accountant, Taupo, New Zealand
|
|
COURSE CANCELLATION POLICY
|
| |
|
Cancel up to five working days before the webinar and receive a full refund. All
cancellations must be notified in writing, that is, by email, fax or post.
Another delegate may be substituted at any time.
|
|