1-516-468-9465 " class="button button_default large" target="_self">Give us a Call!

Posts filed under: Name range

Intermediate Excel 4-16-2016

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....
Continue Reading →

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 6-14-2015 part a Intermediate Excel 6-14-2015 part b...
Continue Reading →

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....
Continue Reading →

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. Merrick Intermediate...
Continue Reading →

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...
Continue Reading →

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...
Continue Reading →

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...
Continue Reading →

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...
Continue Reading →

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...
Continue Reading →

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,...
Continue Reading →

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...
Continue Reading →

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...
Continue Reading →

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...
Continue Reading →

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...
Continue Reading →

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...
Continue Reading →

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...
Continue Reading →

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....
Continue Reading →

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....
Continue Reading →

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....
Continue Reading →