Blog & Excel Tips

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

How to export file names from a folder to excel August 22, 2017

Excel is extremely useful in working with lists, and in the modern world, a common listing requirement is the list of files and folders within a folder. So whether you are just indexing a folder for backup purposes, or you need the names of files in the folder to find missing items, Excel can easily do it. In this post a method of how to export file names from a folder to excel.

Explode one section of an Excel pie chart August 8, 2017

Pie Charts are a very popular method of visualising how much an item makes up of a total. Within Pie Charts you can make the 'slices' explode outwards. We don't find this very useful. We do however like to explode one section of an Excel pie chart to emphasise it.

How to safely delete sheets so there are no REF errors August 8, 2017

A common issue in Excel is the fear of deleting sheets that you feel are not required, but result in #REF! errors in the rest of the spreadsheet if you delete them. All to often these sheets are just left in. So the question is how to safely delete sheets so there are no REF errors.

Limit text length in Excel for ID and passport numbers July 24, 2017

You can use Data Validation to stop typo's when people are entering information. So perhaps you want to limit text length in Excel for ID and passport numbers. If it is an ID number then exactly 13 characters must be entered, but if it is another document type then you can allow more or less.

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