Blog & Excel Tips

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

Identify positive and negative numbers in excel October 13, 2017

A common requirement in Excel is to identify positive and negative numbers. This is usually to apply a different calculation to it e.g. a positive (credit) bank balance earns say 5% but a negative bank balance (debit or overdraft) incurs an interest charge of 10%.

Close workbook but not Excel (2013, 2016 and up) October 1, 2017

...In earlier versions you could close the workbooks in such a way that you end up with a grey screen (Excel open but no open workbooks) and you could open a new workbook from there. Two ways to achieve the same things in Excel 2013 and up i.e. close the workbook but not Excel...

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