Blog entries covering the latest Excel tricks and tips based on queries from clients and practical knowledge from our consultants.
Request info on training dates, prices and venue
A popular feature in Excel is the ability to double click an Excel cell and it will take you to the first link in the formula i.e. where did the cell get its information from. This will show you how to switch this feature on (or back on if it has stopped working)
Where has the text import wizard in Excel gone and how to get it back to use the legacy methods instead of using Get&Transform
Waterfall charts are a very useful chart to see the impact of various movements on a single number. Download an Excel waterfall chart template to use in your spreadsheets.
You have switched on your data filter and tried to use it but you find that the Excel filter is not working after a certain row.
You can spell check Excel documents but there are a couple of tips and tricks you need to use to make it act more like a Word spell check.
How to change the 'invert if negative' colour in Excel to a colour of your choosing and not the white fill with black border default.
A common difficulty with spreadsheet users is how to find a space from the right in an Excel cell. These spaces often result in VLOOKUP's and other functions not working correctly.
Surprisingly, there is no start of month formula in Excel. There is an end of month formula (EOMONTH) but no formula that gives you day 1 of a month based on any date given.
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."
Free Excel Tips & Tricks delivered straight to your mailbox. Sign up today.
All content copyright AuditExcel 2020
