-
Advanced Microsoft Excel 2010 for Windows workshop
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.
-
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. Intermediate Excel 7-15-2012 (Vacation Spreadsheet)
-
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…
-
Conditional formatting
Conditional formatting formats cells according to specific conditions. It enables the user to quickly identify variances in a range of cells with a quick glance. For example, cells more than $35 are highlighted in spreadsheet below.
-
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.