Excel training webinar
|
|
WHAT YOU GET
|
Course manual
& Excel files
|
10 minutes’
hotline time
|
Excel expertise
28 years’
specialisation
|
|
|
Macros
Macros next step
Series of 3 training webinars (attend any or all)
Duration: 60 minutes each
|
|
Format: Interactive webinar
|
|
|
Take your macro development to the next level. Discover how to construct helpful
functions and forms, and create macros that control other applications. Learn about
features of the Visual Basic Environment that you are not able to access with recorded
macros.
|
YOUR POWER-PACKED AGENDA
|
Excel macros next step – part 1
Drawing on the skills learnt in the Excel macros introduction webinar series, develop
additional strategies to process worksheets and user entry.
- Use a For…Each loop to protect sheets.
- Understand object variables and variable types.
- Use a Do…Until loop to prompt the user until the input is acceptable.
Quiz
- Create a custom function (User Defined Function) to use in an Excel formula.
- Apply If…Then…Else logic to return the correct result.
- Test and observe the function code.
Quiz
Excel macros next step – part 2
Construct a UserForm and apply event procedures to enable drop-down lists, option
buttons, and command buttons. See how to transfer data into the UserForm and return
data to the spreadsheet.
- Arrange the controls by using the tools available in the Visual Basic Editor.
- Use event procedures to dynamically change the content of a drop-down list according
to the chosen option button.
Quiz
- Use range techniques to identify the data range on the spreadsheet.
- Transfer data from the spreadsheet into the UserForm.
- Check the entered values and prompt if entries are invalid.
- Transfer data from the UserForm to the spreadsheet.
Quiz
Excel macros next step – part 3
Use query techniques to get data from an external source. See how to interface to
another application by setting a reference and referring to application objects.
- Apply a query to a spreadsheet range.
- Alter the query to retrieve different data.
- Refresh PivotTables and charts to represent the changed data source.
Quiz
- Create a reference to Microsoft Outlook as an external application.
- Use the Object Model of Microsoft Outlook to create and send emails by using data
from an Excel spreadsheet.
Quiz
|
Prerequisites
Ideally, you should be able to write short macros that work with selected or specified
cells, as demonstrated in the previous Excel macros introduction webinar series.
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.
|
|