I’m pleased to announce the file created during the Intermediate Excel workshop on 4-16-2016 is now available to practice with. Here is the link: Intermediate Excel 4-16-2016.
Category: Name range
-
Intermediate Excel 6-14-2015
I’m pleased to announce the files created during the Intermediate Excel workshop on 6-14-2015 are now available to practice with:
-
Intermediate Excel 4-18-2015
I’m pleased to announce the file created during the Intermediate Excel workshop on 4-18-2015 is now available to practice with. Here is the link: Intermediate Excel 4-18-2015.
-
Intermediate Excel 3-31-2015
It was a pleasure doing PivotTables, vLookups, name range, and conditional formatting with the class. Below is a link to the Excel workbooks developed during the workshop. Use them to practice some of the activities covered in class.
-
Intermediate Excel 10-18-2014
Below are the two workbooks developed during Saturday’s 10/18/2014 Intermediate Excel workshop. You can use the files to review the activities covered in class: autofill, formulas, functions [vlookup(), now()], name range, pivot table/pivot chart, sorting, filtering, and conditional formatting.
intermediate-excel-10-18-2014 (1)
intermediate-excel-10-18-2014 (2) -
Intermediate Excel 7-26-2014
Below is the workbook developed during Saturday’s 7/26/2014 Intermediate Excel workshop. You can use the file to review the activities covered in class: autofill, formulas, functions [if(), vlookup(), countif], name range, pivot table/pivot chart, sorting, filtering, and conditional formatting.
-
Intermediate Excel 6-14-2014
Below are workbooks developed during Saturday’s 6/14/2014 Intermediate Excel workshop. You can use the files to review the activities covered in class: autofill, formulas, functions [sum(), vlookup()], name range, pivot table/pivot chart, sorting, filtering, and conditional formatting.
Intermediate Excel 6-14-2014 (a)
-
Microsoft Excel Intermediate 4-9-2014 Day 3
I’m pleased to announce below is the link to the worksheet developed during the Wednesday workshop on 4-9-2014. You can use it to review the activities covered in class:
- Name Ranges
- Date & Time functions
- Date & Time shortcuts
- Conditional Format
- Goal Seek
-
Microsoft Excel Intermediate 3-25-2014 Day 1
I’m pleased to announce below is the link to the worksheet developed during the Tuesday workshop on 3-25-2014. You can use it to review the activities covered in class:
- creating a bar chart and pie chart
- creating and using name ranges
- setting up the vLookup database function
- recording and playing macros
-
Intermediate Excel 3-8-2014
I’m pleased to announce below is a link to the worksheet developed during Saturday’s 3/8/2014 workshop. You can use it to review the activities covered in class: autofill, column/pie chart, formulas, functions [sum(), now(), vlookup()], name range, pivot table, sorting, filtering, and conditional formatting.
This was a great class. Thank you for letting me know you found it fun and interesting!
-
Intermediate Excel 11-9-2013
Below is a copy of the worksheet developed during Saturday’s 11/9/2013 workshop. You can use it to review the activities covered in class: autofill, formulas, functions [sum(), now(), vlookup()], name range, pivot table/pivot chart, sorting, filtering, and conditional formatting.
This was a great class!
-
Intermediate Excel 10-12-2013
Below is a copy of the worksheet developed during Saturday’s 10/12/2013 workshop. You can use it to review the activities covered in class: autofill, formulas, functions [sum(), now(), vlookup()], name range, pivot table/pivot chart, sorting, filtering, and conditional formatting.
The group did a great job!
-
Intermediate Excel 7-21-2013
Below is a copy of the worksheet developed during Sunday’s 7/21/2013 workshop. You can use it to review the activities covered in class: autofill, formulas, functions [sum(), countif(), now(), vlookup()], name range, pivot table, sorting, filtering, and conditional formatting.
The group did a great job!
-
Intermediate Excel (6-15-2013)
Below is a copy of the worksheet developed during Saturday’s 6/15/2013 workshop. You can use it to review the activities covered in class: vlookup, pivot table, sorting, name range, conditional formatting and filtering.
The group did a nice job!
-
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-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 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.
-
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.
