Microsoft Excel specialists


Excel training webinar

See dates for all webinars
Cut price 50-70% with passport
Contact us






  WHAT YOU GET

Course manual
& Excel files

10 minutes’
hotline time

Excel expertise
28 years’
specialisation

Tips

Everyday Excel you should know

Series of 2 training webinars (attend any or all)

     Duration: 60 minutes each  
      Format: Interactive webinar  

Excel has a lot of simple features to make your everyday Excel work much more productive, some of which you may know, but there are also many that will have escaped your attention. Some have more depth than you might suspect. Even if you are an advanced user, you are bound to discover one or two new features, which will repay your investment rapidly.

  YOUR POWER-PACKED AGENDA
Everyday Excel you should know – part 1

Operate at maximum efficiency

  • Use keys for common tasks.
  • Navigate rapidly.
  • Freeze panes instantly.
  • Display two sheets of the same workbook.
  • Synchronise the display of two sheets.
    Quiz

Enter, edit and manipulate data skilfully

  • Create dropdown lists for error-free data entry.
  • Group sheets for multiple changes.
  • Select only cells of a specified type (eg constants, formulas).
  • Make the most of Find and Replace.
  • Know the copy and paste capabilities.
  • Use modes to edit formulas and cells with ease.
  • Learn what different errors mean and how to find and fix them.
    Quiz

Document workbooks effectually

  • Add and work with Comments.
  • Hide and display objects.
    Quiz
Everyday Excel you should know – part 2

Format rapidly and consistently for a professional look

  • Learn to use Styles and create custom formats.
  • Discover meaningful formatting conventions.
    Quiz

Protect and preserve your data

  • Apply worksheet, workbook, and file protection.
  • Retain a full version history and restore deleted files.
    Quiz

Optimise display for on-screen viewing or printing

  • Use Zoom and full screen view effectively.
  • Understand page setup possibilities and use page breaks.
  • Create a PDF from an Excel worksheet.
    Quiz

Customise Excel options to suit your needs

  • Understand different Excel file types and specify the default.
  • Create and use Favourite folders and Recent workbooks.
  • Perform common tasks quickly with the Quick Access Toolbar.
    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.