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

Margins, Orientation and Page size

Margins, Orientation and Page size This quick video explains how you alter the margins, orientation and page size in the Excel worksheet. Within the page layout tab – there is a section called Page Setup which allows us to alter the margins, orientation and page size....

How to use Headers and Footers in Excel

How to use Headers and Footers in Excel This quick video explains sorting how to use Headers and Footers in Excel. When printing a long spreadsheet is useful to include headers and footers to display page numbers, dates and the document’s filename. The headers and...