Put new skills into practice straight away
The course has been absolutely brilliant! Sharyn’s facilitation and teaching style is amazing as she teaches in a way that ensures the information is understood and the new skills are practiced straight away. Our guys were thrilled about the new skills they learnt and put them into practice straight away.
Katie Li, HR Manager, Apex Valves, Avondale
WE OFFER ONSITE TRAINING FOR
POPULAR BLOG POSTS
I have been asked twice in one week to please explain how to calculate GST at 15% using Excel formulas.
You can find information on how to calculate GST (Goods and Services Tax) on the NZ Inland Revenue website. I’ve taken this a step further and put together a tutorial on how to put these calculations into Excel formulas.
If you want to save yourself a huge amount of time when reconciling data, learn how to use VLOOKUP to compare two lists or columns of data.
Years ago the Training and Development manager of a large organisation invited me to spend some time in their Accounts department in order to observe how the Accounts team dealt with their day-to-day tasks. My job was to report on any process that could be improved using Microsoft® Excel. Read more
PROBLEM: when I use “Format as Table” to format a range the “Merge and Center” button becomes inactive and I can no longer merge cells. Why?
SOLUTION: the Table format will stop the merging of cells. However there is a work-around.
The Format as Table command can be used to quickly apply a professional format to a selected range. However, in applying the format you are also applying the functionality that Tables offer. As a result you will no longer be able to merge cells. Read more