Blog & Excel Tips

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.

Working with ‘Big Data’ in Excel Apr 1, 2013

We have recently completed an assignment which involved applying formula to 4 columns on over 500 000 rows of data (in Excel’s terms this is Big Data). For various reasons we ended up having to use Excel 2010.

Counting Coloured Cells in Excel Apr 1, 2013

If you are manually going in and changing the colors based on something other than a formula, you could create some columns/ rows to help make this easier. These can be used to input a word or number that means the same as the color.

Consulting

We aim to provide the ultimate, one stop shop for all Excel users requirements, within South Africa and worldwide.

Find Out More

Live Training

"Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude."

Find Out More