-
Intermediate Excel 4-14-2013 (Scuba Diving)
It was nice working with the group on Sunday April 14th. Below is a copy of the worksheet developed during the workshop. You can use it to practice and review the activities covered in class. Intermediate Excel 4-14-2013
-
Intermediate-Excel-03-10-2013 (Party List)
It was nice working with the group today. Below is a copy of the database developed during the workshop. You can use it to practice the activities done in class. Intermediate-Excel-03-10-2013
-
Intermediate Excel 03-03-2013, day 1 of 2
I am pleased to announce that below is the link to the workbook that was developed in the workshop today, 3/3/2013. Intermediate Excel 03-03-2013 It has been provided so you can practice the features covered in class. I am looking forward to our next class!
-
Intermediate Microsoft Excel (11-18-2012)
I am pleased to announce that below is the spreadsheet developed in class: Intermediate Excel 11-18-2012 It has been provided so you can review the activities done in class.
-
The vlookup function
The vlookup function searches for the value in the left-most column of a table. The vlookup function pulls information from a table (i.e. Name Range). It enables the user to find relevant information systematically.
-
Intermediate Excel 6-10-2012 for Windows workshop
Below is the link to the workbook that was developed in the workshop. It has been provided so you can practice the features developed in class. Intermediate Excel 6-10-2012
-
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.
