Excel training webinar
|
|
WHAT YOU GET
|
Course manual
& Excel files
|
10 minutes’
hotline time
|
Excel expertise
28 years’
specialisation
|
|
|
Formulas
D-functions and criteria
Duration: 60 minutes
|
|
Format: Interactive webinar
|
If you need to total, say, the values of 50 different products, you could use 50 SUMIFS or 1 DSUM. This is the topic of D-functions (of which DSUM is one). SUMIFS has limited criteria, but the D-functions allow any. And with DGET, you can return, say, price list entries, but, unlike VLOOKUP, it warns you if the item located has a duplicate. Apply the same powerful criteria to filtering.
|
YOUR POWER-PACKED AGENDA
|
- Take advantage of DSUM’s powerful criteria.
- Discover the criteria you can create.
Quiz
- Set up robustly with Tables.
- Apply the same criteria in the Advanced Filter.
Quiz
- Create lookups that alert you to duplicates.
Quiz
|
Prerequisites
At a minimum, you should be able to create basic arithmetic formulas and use the SUM function.
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.
|
|