Basic Excel Operators (+, -, *, /)

Basic Excel Operators (+, -, *, /) This quick video explains the different Basic Operators in Excel ( + , – , * , / ) Learn to work with Excel’s basic operators – including the +, -, * and / operators – essential for all Excel users. Learn the difference between...

Format Painter

The Format Painter This quick video explains The Format Painter If you have created a format including the colour, font and background colour and border of a cell and wish to copy it to another cell or range of cells – you can do so using the Format Painter tool....

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