You may come across situations where you need to use a line break as the delimiter in Text to Columns in Excel. A line break is where, within a single cell, text appears on two seperate lines.
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
To make your drop down lists more visually appealing you may want to use a tick or a cross to indicate acceptance (or not) of an item. Below some tricks to add a tick into your Excel Data Validation.
Forward to a friend
An example of recent consulting jobs we have completed.
Forward to a friend
An online Excel course highlighting the common spreadsheet errors made and ideas on how to avoid them.
Forward to a friend
When working with MS Excel and using some of the tools or an add in, you may come across situations where your tool won’t run because of protected sheets. If you have lots of sheets it can be quite tedious to try and find the protected sheets manually.
Forward to a friend
Feedback from recent courses
Missed a newsletter? Look at the Archive