To do the useful thing, to say the courageous thing, to contemplate the beautiful thing: that is enough for one man’s life.

T. S. Eliot (1888-1965) American Poet

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

 

Unless you try to do something beyond what you have already mastered, you will never grow.

Ralph Waldo Emerson

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…)

It takes less time to do a thing right, than it does to explain why you did it wrong.

Henry Wadsworth Longfellow (1807-1882) American Poet

The happy people are those who are producing something; the bored people are those who are consuming much and producing nothing.

William Ralph Inge (1860-1954 ) English Theologian