It was nice working with everyone in the Continuing Education workshop. Here is the link to the file we developed in class: Advanced Excel 5-20-2012. It has been provided so you can practice the materials created in class.
Author: admin
-
Intermediate Excel 7-15-2012 for Windows workshop
Below is the link to the Intermediate Excel 7-15-2012 spreadsheet that was developed in class. It has been provided so you can practice the materials created in class.
-
Using Name Manager to expand your Name Range.
Use Name Manager to expand your Name Range. See the steps below:
1. Open Name Manger by clicking on Formulas->Name Manager (or by using the shortcut CTL + F3).
2. Select the Name Range that you would like to edit.
3. Then you can delete the information in the text box “Refers to:” and update that cell reference by selecting the appropriate cells.
-
Name Range
Name Ranges use the Name Box to name a cell or a group of cells. This can help organize and index important parts of your spreadsheet.