FREE Excel Webinar – Excel Yourself 2016

My next free webinar will be held this month – Excel Yourself 2016. I will cover 5 of my magazine articles from the year and include some extra content.

There are two dates to choose from 15 & 19 Dec. Content is the same on both days.

The sessions start at 1pm AEDST (10am AWST) and run for an hour.

Click here to see more details and register.

FREE Webinar Recording – Chapter 5 of My Book

The latest and fourth webinar for my book has just been uploaded.

Advanced Excel Reporting Cover

It covers Chapter 5 and the topics include data cleansing and the Format as Table feature and getting external data.

Webinar Recordings

 

FREE Recording – Recorded Macros – tips, trick and traps

I have posted the video link of my most recent free Excel webinar – Recorded Macros Tips, Tricks and Traps. This is the first session in my macro series. This first session is now free. It covers recording macros, the terminology, and background – what you need to know before starting with macros. Also how to make more flexible and re-usable macros.

Recording Macros

FREE Recording – More Excel Financial Functions

I have posted the video link of my most recent free Excel webinar – More Excel Financial Functions. I cover four functions plus answers to two question from the previous free webinars. Average feedback score was over 88% from over 130 responses.

Latest Free Excel Webinar Recording.

Live Excel Training

Full Day Excel Training Courses

I am excited to offer my first set of public Excel training courses in October 2015.

I will be running two, full day sessions. Follow the links below to see more details and to register.

Each is priced at $595 including GST and has 8 hours of CPD.

Tuesday, 13th October Arrival – 8:15AM Start – 8:30AM Essential Excel Functions

Monday, 19th October Arrival – 8:15AM Start – 8:30AM Master Macros Made Easy

 

Free Excel Webinar Recording

Excel  2013 Conditional Formats

Conditional formats allow you to have cell formats automatically change based on the value in the cell and other cells. This is great for exception reporting. For example when you open a file all the overdue dates could have a red fill colour based on the today’s date and the dates for the coming week will be coloured orange. Some of the techniques covered can also be applied to dashboards. (more…)

Free Excel Webinar Recording

FREE – Excel Mouse Shortcuts

Following up from my keyboard shortcuts session in February. This month we will look at quick ways to do common tasks with the mouse. Some of the topics and techniques I will cover include:

  • the various cursor shapes and how to use them correctly
  • right clicking options you may not know exist
  • copying anything quickly with the mouse, even sheets
  • drawing perfect circles and squares
  • lining up charts and other shapes perfectly
  • cool techniques with the Fill Handle
  • something you may never have tried with the right mouse button
  • using the the Office clipboard

This session will demonstrate lots of techniques using the mouse and also using the mouse with the keyboard. Even if you prefer using the keyboard you might learn a few useful new techniques.

Latest Free Excel Webinar Recording.