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: Vlookp function
-
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 3-24-2015
It was a pleasure working with the class! Below is a link to the Excel workbook developed during the workshop.
Merrick Intermediate Excel 3-24-2015You can use the file to review the activities covered in class: pivot table/pivot chart, sorting, filtering, and creating a Gantt chart.
-
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 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-21-2013
It was nice working with the group on Sunday April 21th. Below is a copy of the worksheet developed during the workshop. You can use it to practice and review the activities covered in class: vlookup, pivot table, sorting, and filtering.
-
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.
-
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.