2021 Excel Training Dates, Trick Excel into using multiple characters for Text to Column, Compare 3 cells, Conditional Format based on another sheet.

How to use multiple characters as delimiters in Excel’s Text to Column tool, when Excel only allows a single character entry.

Forward to a friend

Upcoming Public Live and Virtual MS Excel Courses

Forward to a friend

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).

Forward to a friend

Conditional formatting is a great tool for dashboards and data visualisation. A common query is whether you can have conditional formatting based on another sheet e.g. in Sheet 1 you want cells to black out based on what has been input on Sheet 2.

Forward to a friend

An example of  recent consulting jobs we have completed.

Forward to a friend

An online Excel charting/ graphing course covering how to understand charts and how to get them to do what you want.

Forward to a friend

There will be times when you need to compare 3 or more cells in MS Excel to generate a desired outcome. 

Forward to a friend

Feedback from recent courses

Missed a newsletter? Look at the Archive