Blog & Excel Tips
Free Tips & Tricks Newsletter Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!
Blog entries covering the latest Excel tricks and tips based on queries from clients and practical knowledge from our consultants.
If you have tried to change the data source for a Pivot Table and received a message saying 'to change the data source first disconnect the filter controls' you may have struggled to understand what it is saying.
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%.
How to resize all columns to fit text in Excel at once October 2, 2017
If you are familiar with resizing columns or rows to fit the text in Excel, but do the step to each individual row or column, this is a quick way to resize all columns to fit text in Excel at the same time.
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...
Make the cursor start on the same cell in each sheet August 24, 2017
How to make the cursor start on the same cell in each sheet to avoid you scrolling up, down, left and right each time you are looking for a particular cell.
We aim to provide the ultimate, one stop shop for all Excel users requirements, within South Africa and worldwide.
"Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude."