Blog & Excel Tips

How to switch off the PowerQuery Conditional Column wizard when you want to edit a formula in the Custom Column wizard.

You work often on CSV files in Excel and suddenly the CSV uses semicolon instead of comma, or comma instead of a semi colon. This sometimes happens when you have changed computers or if you receive the CSV file from a different source.

When using CSV files you may find that the CSV's are losing leading zeros when you open them. This is happening because Excel is assuming that if it is a number, it cannot having leading zeros so it just removes them.

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.