Text to Columns

Text to Columns This quick video will explain how to split contents of a cell across multiple cells. Regularly when importing a text file – multiple pieces of data will end up in one cell – the Text to Columns option allows to us to split the contents of a cell across...

Freeze panes

How to Freeze Panes in Excel This quick video will show you how you can Freeze a Row or a Column. As you scroll through your spreadsheet is often hard to know which row or column you are looking at. Freezing a row or column or both is a useful way to keep them...

Arranging Workbooks

Switch and Arrange Workbooks This quick video explains how to Switch and Arrange your Workbooks in Excel. Switching and Arranging workbooks allows us to work with multiple worksheets and workbooks at the same time. This is useful when comparing values on different...

Adding text to a number format

Adding Text to a Number Format This quick video explains how to add Text to a Number Format in Excel. Sometimes it is useful to be able to create a custom number format that displays units in the same cells as the number – e.g. 100Kgs, 100 units and ask Excel to treat...