# Blog & Excel Tips

Blog entries covering the latest Excel tricks and tips based on queries from clients and practical knowledge from our consultants.

### TEXT functions in Excel TutorialsApr 5, 2013

Excel formula and functions that help with manipulating text in excel cells. Below are some video clips of extremely useful text functions built into Microsoft Excel.

### VLOOKUP TutorialsApr 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.

### Super 15 Rugby 2013 Spreadsheet (Update)Apr 1, 2013

The Super 15 Rugby 2013 spreadsheet is available. This spreadsheet allows you to predict the results of all the fixtures and will automatically update the actual results after the weekends matches.

### How to remove grouping from Excel CellsApr 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 ExcelApr 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 ExcelApr 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.

### IRR Calculator ExcelApr 1, 2013

An IRR Calculator that will assist you in determining the Internal Rate of Return on a series of cash flows.

## 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