How to apply a textbox to your spreadsheet


If you want to add a body of text to your spreadsheet that isn’t typed directly into a cell, then use a text box.

To insert a text box, go to the Insert tab and select Text. From the drop-down choose text box and then draw a text box onto your spreadsheet. 

To add text to your text box, click in it and start typing.  



This content is aimed at the Introduction level.   Click here to view our course overview.

Naming a single range using the Create from Selection tool


If you want to create a named range from a selection of cells, then a quick way of doing this is using the Create from Selection tool. Select the cells you want to name and then go to the formula tab and select Create from Selection. The Create Names from Selection options box will then appear. Choose the option of where the name for your range is located. For example, if the name for your range is in the first column, choose Left Column. 



This content is aimed at the Advanced level.   Click here to view our course overview.

Naming multiple range using the Create from Selection tool


If you want to create multiple named ranges from a selection of cells, then a quick way of doing this is using the Create from Selection tool. Select the multiple rows and columns you want to name and then go to the formula tab and select Create from Selection. The Create Names from Selection options box will then appear. Choose the option of where the name for your range is located. For example, if you want to create named ranges based on the headers at the top and the first column then select Top row and Left column. 



This content is aimed at the Advanced level.   Click here to view our course overview.

How to copy just the Subtotals


If you only want to copy subtotals from your data, then you can’t do a straight forward copy and paste as it will paste all the hidden data as well. Instead, select all the subtotals and press F5. This will then open the Go To window and in this window select Special. Next, in the Go to Special window select Visible Cells Only, then click OK. The final step is to copy the subtotals and paste it. This will now only copy and paste the subtotals and not all the data.



This content is aimed at the Introduction level.   Click here to view our course overview.

How do I find a specific word or phrase in Excel?


If you’re looking for a certain word or phrase in a spreadsheet, then how about using the Find tool. It’s a handy tool where you type the word you want to find and then Excel will find the word in your spreadsheet.

You will find the Find tool on the Home tab, in the Editing group.


This content is aimed at the Introduction level.   Click here to view our course overview.

How to Find and Replace text in Excel?


If you want to replace the values of cells with something else, why not give the Replace tool a go.

Just type in the word that you want Excel to replace and then type in the word you want to replace the text with.


This content is aimed at the Introduction level.   Click here to view our course overview.

How to identify invalid data in Excel?

If you want to find data that has been incorrectly inputted, then use the simple to use Circle Invalid Data Tool. This circles any incorrect data.


How to use the Circle Invalid Data tool

1. Go to the Data tab, Data Tools and select the Data Validation dropdown.

2. Select Circle Invalid Data.


This content is aimed at the Intermediate level.   Click here to view our course overview.

How to input a value in Excel that starts with a zero?


As you might have noticed, you can’t start a number in excel with a zero. There is way simple way of getting around this. Just place an apostrophe (‘) before your number. This will keep the zeros at the beginning of your number.


This content is aimed at the Intermediate level.   Click here to view our course overview.