Blog & Excel Tips

2021 dates for our MS Excel training courses. These dates are for the public live and virtual Excel courses for Johannesburg and Cape Town (for the live- virtual can attend from anywhere).

Determining the difference between 2 dates in Excel is a very common requirement. From a straight number of days, to workdays, to months/ years or fraction of a year, all the date difference options

If you regularly import CSV's into Excel you may find that sometimes the Excel CSV opens in one column instead of in separate columns as you would expect.

Recent news articles are showing that even COVID is not immune to spreadsheet errors.

If you are having date format or sort issues in Excel (dates sort by months instead of day of month, you can't change the date format of a cell), it is because Excel does not recognise the date you gave it as a valid date.

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.