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!
Category: Excel Review Materials
-
Advanced Microsoft Excel 2010 (12-2-2012)
I am pleased to announce below is the link to the “Baseball Stats” file developed in class:
It has been provided so you can practice the exercises done in 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.
-
Advanced Microsoft Excel 2010 (11-10-2012) – Day 2 of 2
I am pleased to announce below are the links to the files developed in class during “Day 2 of 2”:
- Advanced-Excel 11-10-2012-a (day 2 of 2)
- Advanced-Excel 11-10-2012-b (day 2 of 2)
- Advanced Excel 11-10-2012 custom function and two macros (day 2 of 2)
They have been provided so you can practice the exercises done in class.
-
Advanced Microsoft Excel 2010 (10-27-2012) – Day 1 of 2
It was nice working with everyone in the Continuing Education workshop. Below are the links to the files developed in class:
It has been provided so you can practice the exercises done in class.
-
Advanced Microsoft Excel 2010 for Windows workshop (7-29-2012)
It was nice working with everyone in the Continuing Education workshop. Here is the link to the file we developed in class: Advanced Excel 7-29-2012. It has been provided so you can practice the materials created 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.
-
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.
-
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.
