Excel training webinar
|
|
WHAT YOU GET
|
Course manual
& Excel files
|
10 minutes’
hotline time
|
Excel expertise
28 years’
specialisation
|
|
|
Excel formulas
File-linking and formula auditing
Duration: 60 minutes
|
|
Format: Interactive webinar
|
Formulas that refer from one workbook to another, otherwise known as file-links,
are something it seems that few people know how to set up correctly. The upshot
is wrong values referred to and spreadsheets that are a nightmare to audit. It doesn’t
have to be that way. This webinar shows you how to avoid these problems.
|
YOUR POWER-PACKED AGENDA
|
- Be aware of the many traps and the solutions.
- Know the best way to create file-link formulas.
- Link with a single range name instead of many.
- Structure for fast and simple auditing.
Quiz
- Trace dependents and precedents.
- Check and change files linked to.
Quiz
- Find the source of unwanted "update links" messages.
- Remove file-links.
Quiz
|
Prerequisites
You can create basic formulas.
Applies to all Excel versions including 2013, 2010 and 2007. Any differences are pointed out.
|
|
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.
|
|