Many moons ago, when I held one of my first accounts positions, I had a staff member who handed in her expenses claim form as an excel spreadsheet. Upon review, I could see that it didn’t add up, so I clicked on the “Totals” cell and found that the amount had been typed in. No formulas. I went to the girl concerned and asked why she had not summed the amounts? She turned to me and said quite innocently “Oh does it add it up for you?” With due restraint I explained, “yes it does and a whole lot more than that”, whilst I was rolling on the floor laughing my head off.
After last year’s successful advanced excel training course a number of participants approached me and said “well that’s all very well and good, but we have staff who don’t even get the basics”. I would have thought that people now entering the workforce, would have had at least a rudimentary understanding of this core skill. Pretty much all office staff, and even some traditional blue colour workers, are expected to know how to use this standard Microsoft product.

WHEN: Saturday, 22 September 2016 from 18:00 to 19:30 (BST)
WHERE: Kingston Hotel – Kingston Hill, Kingston upon Thames, KT2 7NP – View Map
Tickets for Excel Behaving Badly
To see what can be done with Excel, and for excellent Excel templates, visit our template section: Downloads
Yet in nearly every business I go to, spreadsheets are stored all over the place, no-one knows which is the right version and people aren’t even aware of standard core features. Even qualified accountants don’t have a full grasp of the program. If they are studying for their ACCA/CIMA qualifications, they only do a few introductory sessions before moving onto other modules. The worst case I heard of was a bank which had one formula error in a particular worksheet. That oversight cost them over 2 million pounds
With all that in mind, I went back to the drawing board and tried to understand this programing behemoth, as if I was using it for the very first time. What has been developed is a course that introduces some of the basic concepts behind excel, whilst still challenging those who are more experienced to delve a bit deeper into its functions. This is not just dry theory, as is based upon building a monthly cash flow planner from scratch. This has a practical application as it can be used in an everyday work environment.
The course will cover:
- How to use the formula builder.
- An introduction to date, text and mathematical functions.
- View options
- Paste special
- Conditional formatting.
- Fixed and relative references.
The first of these will be held at the Kingston Hotel (94 Kingston Hill, Kingston Upon Thames KT2 7NP) on Thursday the 22nd of Sept starting from 6 pm with the session starting from 6.30 for an hour. There is a £30 fee that includes wine, soft drink and savouries and people are welcome to stay later for general networking. For those who can’t make it, there will be further sessions at other location throughout London, later in the year.
To book, please use this Eventbrite link: Tickets for Excel Behaving Badly
To make the best use of the session please bring a laptop with excel pre-installed. Otherwise you’ll just be watching a screen.
WHEN: Saturday, 22 September 2016 from 18:00 to 19:30 (BST)
WHERE: Kingston Hotel – Kingston Hill, Kingston upon Thames, KT2 7NP – View Map
A bit about the presenter:
Mr Malcolm Ford has for the past seven years implementing enterprise level software to business’s all over the British Isles. His areas of speciality is accounting, excel and organised and ran this seminar.
This is what people had to say about the last seminars:
“5 out of 5 for the quality of materials provided at the session” – Richard Mullet (LegalPartners.com)
“5 out of 5 for the trainer and presentation” – K Chadwick


