How to create a table in excel


If you want to make your data easier to work with then why not place it into a table format. To do this select the data and go to the Insert tab. Next, select Table on the Ribbon and this will open the Create Table window. In this window it will have the range of cells you want to convert to a table and a box that says My Table has Headers. If your table has headers, make sure that box is ticked. Then click ok.



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

How to create a named range?


You can give a cell or range of cells a unique name which can then be used in formulas or to find cells.

To create a named range, select the cell(s) that you want to apply a name to. Then click in the Name Box and type in the name you want to give the cell(s). Once you have done that press enter. 

Named ranges must have a unique name.



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

How to edit a named range?


If you want to edit a named range, go to the Formulas tab and select the Name Manager in the Defined Names group. 

In Name Manager select the named range you want to edit and select Edit. You can then change the name of the range, any comments about the named range and the range of cells that the name range covers.


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