Blog & Excel Tips
Free Tips & Tricks Newsletter Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!
Blog entries covering the latest Excel tricks and tips based on queries from clients and practical knowledge from our consultants.
Addressing a problem when using the Edit Links feature in Excel
How to remove unwanted characters in Excel spreadsheets through the Left, Right and Mid functions Jun 20, 2012
How to extract characters from the left, right or middle of a excel cell
How to use the AVERAGE formula in Excel to calculate the average of a set of numbers
How to use the trace precedents button in the Formula Auditing toolbar
How to avoid the RANK function finding equal results Jun 20, 2012
How to solve the problem of the rank function returning the same value.
Drop down cells and looking up related information Jun 20, 2012
How to base a drop down list on the outcome of another dropdown list
We aim to provide the ultimate, one stop shop for all Excel users requirements, within South Africa and worldwide.
"Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude."