RESOURCE CENTRE
liveclassess

 

17/05/17 Setting Up Your Books Using Xero Cloud Accounting Software Members Only
24/05/17 Lookup Methods in Excel Members Only
31/05/17 Create Beautiful Presentations in PowerPoint Members Only

7th December 2016

Excel Advanced Formulas and Functions – with Deborah Ashby

23rd November 2016

Excel Hacks to Boost Accuracy and Productivity – with Todd Brannon

9th November 2016

How to Learn HTML/CSS – with Chris Misterek

28th September 2016

Top 10 Excel Formulas You Need to Know – with Deb Ashby

7th September 2016

How to Make Better Business Decisions – with Cathy Presland

24th August 2016

Wellbeing for Energy – with Ruth Tongue

10th August 2016

Financial Reports & Decision Making – with Lita Epstein

3rd August 2016

7 Ways to Promote Your Business on Facebook – with Chris Kyriacou

27th July 2016

Managing Outlook Email – with Deb Ashby

21st July 2016

Better Business Writing – with Andreas Louizou

29th June 2016

How To Get The Most Out Of Microsoft Word – with Deborah Ashby

22nd June 2016

Copywriting: How To Create Customer Profiles For Successful Marketing Campaigns – With Doru Catana

18th May 2016

Introduction To Excel – With Deborah Ashby

14th April 2016

10 Tips For Making Your Company More Visible On Social Media – With Chris Kyriacou

3rd February 2016

VLOOK UP – Excel’s Most Dangerous Function And How To Avoid It – With Simon Hurst

VLOOKUP is one of Excel’s most popular functions and many see its use as the mark of an Excel expert. However, VLOOKUP hides a dark secret that can lead to financial disaster and reputational catastrophe.

Find out what can go wrong, how to stop it going wrong and how to use Match and Index to do more than VLOOKUP could even dream of. Then find out how to avoid lookups altogether.

Download the worksheet
(The speed test exercise has been removed because of file size issues)

Useful Links

 

An internet connection is required to view all live webinars. They are hosted through the ‘GoToWebinar’ platform. Users who are new to ‘GoToWebinar’ will require a quick install, which includes trouble shooting and installs on all platforms. Find out more at the links below:

Download GoToWebinar (All platforms)

Attendees Video Quick Start

GoToWebinar Mobile Version (Apple)

GoToWebinar Mobile Version (Android)

Coming soon…