Excel training webinar
|
|
WHAT YOU GET
|
Course manual
& Excel files
|
10 minutes’
hotline time
|
Excel expertise
28 years’
specialisation
|
|
|
Tips
Excel disasters
Series of 2 training webinars (attend any or all)
Duration: 60 minutes
|
|
Format: Interactive webinar
|
In Excel, there are certain errors that occur frequently,
and which are particularly insidious because they're easily overlooked.
This webinar series takes a hard look at some of the worst Excel calamities
and provides not only solutions, but also effective prevention techniques
that will help you to avert spreadsheet catastrophe.
|
YOUR POWER-PACKED AGENDA
|
Excel disasters 1-10…and the solutions
Formula disasters
- 1- Inserted rows do not get included in totals
- 2- Totals omit or double-count values
- 3- SUMIF ranges misaligned
- 4- File-link formulas no longer refer to the correct cells
Quiz
Editing disasters
- 5- Copy done before all insertions
- 6- Not all columns sorted
Formatting disasters
- 7- Hidden entries get accidentally deleted
Quiz
Reporting disasters
- 8- Reports compiled with old printouts
- 9- Reports printed without formulas calculated
- 10- Reports printed without PivotTables refreshed
Quiz
|
Excel disasters 11-20…and the solutions
Formula disasters
- 11- VLOOKUP returns the wrong result because of incorrect 4th argument
- 12- VLOOKUP returns the wrong result because of non-self-adjusting 3rd argument
- 13- IFERROR hides legitimate errors
- 14- VLOOKUP fails when numbers are stored as text
Quiz
Criteria disasters
- 15- Filtering fails when including text and numbers
- 16- DSUM adds extra items due to implicit wildcard
Editing disaster
- 17- Grouped sheets result in overwritten data
Quiz
Formatting disaster
- 18- Unused formatting makes massive files
Quiz
Date disasters
- 19- Month and day transposed
- 20- Inconsistent data entry stores dates as text
Quiz
|
|
Prerequisites
No prerequisites other than rudimentary Excel skills are required.
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.
|
|