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.
VLOOKUP Tutorials Apr 5, 2013
Learn how to use VLOOKUP in Microsoft Excel. Once you've mastered the concept see how to use it in your models and what to watch out for. This command is extremely useful when trying to extract data out of lists of information. Below are links to the Excel video tutorials touching on this lookup command.
How to remove grouping from Excel Cells Apr 1, 2013
A common query we have is how to remove the Grouping feature from rows or columns in Excel spreadsheets. Simply highlight the rows or columns that you want to change, click on the DATA tab and then look for the UNGROUP button in the OUTLINE section.
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."