Blog & Excel Tips

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

Pin your regularly used excel files March 20, 2017

If there are Excel files that you regularly use, it can be useful to always have them visible in the recently used list. Unfortunately, if you haven’t recently used them, they won’t be there and you will need to search for them again. From Excel 2007 upwards you can now ‘pin’ these commonly used files in your recent list.

How to delete formula in excel without deleting data March 20, 2017

You have created a spreadsheet with multiple sheets and now you need to send it out, but you want to remove all the formula, either because of size or you just don't want to have the recipients see the formula. This post will show you how to delete formula in excel without deleting data, on one sheet and on multiple sheets at the same time.

Entering Long Numbers in Excel February 1, 2017

A common problem is entering long numbers in Excel. You will know you have this problem if Excel - Replaces some of the last characters of the long number with zero's - Seems to round long numbers to zero- Refuses to accept the number you type- you enter numbers that have 15 or more characters (think credit card numbers, ID etc)

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