Webinars

These courses are for you if you:

• Only have a bit of time to spare but want expert Excel upskilling.
• Need a quick refresher on key aspects of Excel.
• Learn best at your desk, rather than in a group training environment.
• Have a limited budget but an unlimited interest in Excel’s capabilities.

Course content overview:

Excel formulas

• Introduction to VLOOKUP, SUMIF, SUMIFS, range names, traps, best practice and tips.
  VLOOKUP is a much-used and most-useful function. This webinar is an introduction to VLOOKUP and covers a number of its common traps and solutions. SUMIF is another powerful function you should have in your arsenal. Use it to total data that meets certain criteria.
• Advanced lookups: VLOOKUP, INDEX, MATCH, ISNA, T, traps, array formulas
  VLOOKUP is much used, but even advanced users fall into its many traps. This webinar covers the many problems and provides the solutions.
• Beyond SUM: SUBTOTAL, IF, AND, OR, AVERAGE, COUNT, MIN, MAX and more
  A survey revealed that 99% of Excel users know only one function: SUM. Move well into the top 1% by learning 9 more functions: SUBTOTAL, IF, AND, OR, AVERAGE, COUNT, COUNTA, MIN and MAX.

Macros introduction

• Macros introduction – Part 1
  Create simple macros in Excel to automate common tasks. Learn how to record, edit, and understand macro code. Add buttons and shortcut keys to run the macros.
• Macros introduction – Part 2
  Create an import application by breaking a complex problem into three steps. For each of the steps, see how to record, edit, and debug the macro code, plus how to prompt the user to enter required details.
  
• Macros introduction – Part 3
  Improve the import application. Prompt the user. Use If… Then… Else logic. Loop to process data.
  

Course structure

Duration: 60 minutes

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.
• To ensure you will have no connection difficulties on the webinar date, free 15 minutes practice sessions are conducted every (working) Monday and Friday at 3:45NZT and 1:45 AEDT.

What you get for each webinar:

• The best possible advice and training from international company AbleOwl, who have specialised solely in Excel and spreadsheets for over twenty years.
• Assimilation of good spreadsheet design practices. All AbleOwl courses apply ESP (Excel Standardisation Programme) conventions. That means you will more quickly understand and navigate the workbooks used, whichever AbleOwl courses you attend.
• Emailed PDF of the full-colour, fully-indexed course manual, which explains each of the webinar agenda items in detail.
• Emailed files of all spreadsheets covered in the webinar. You can modify the spreadsheets for your own use.
• 1 month free of full-functionality Excel Genie, with 10 minutes’ hotline time.
  (If you already have Excel Genie, you can designate another person to receive this bonus month. We will still add 10 minutes to your Genie hotline time.)
• Multiple-place discount: 10% off for three or more places booked on the same webinar.

All webinars cover Microsoft Excel releases XP (2002) through 2010 unless otherwise specified (e.g. the PivotTables 2007/2010 webinar does not cover 2002/2003). Where there are differences among the covered releases, they are pointed out.

Webinar cancellation policy:

Test out the technology at one of the free practice sessions prior to the webinar(see Format above for days/times). If for any reason during the test, you cannot get the technology to work to your satisfaction, you can cancel and get a full refund. A webinar booking is considered final when received in writing (online, email, fax or post) by AbleOwl , and can be cancelled up to five working days before the webinar. After that, payment is expected in full and no refund will be given. All cancellations must be notified in writing by email, fax or post. Another delegate may be substituted at any time.