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.
Category: Intermediate Excel
Intermediate Microsoft Excel for Windows
-
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-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.
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:
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 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.
-
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.
