Category: Intermediate Excel

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

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.

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 Excel 3-31-2015 a Merrick Intermediate Excel 3-31-2015 b

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)

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 7-26-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) Intermediate Excel 6-14-2014 (b) Gantt-Chart Intermediate Excel 6-14-2014 (c)

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…

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 11-9-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 10-12-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-7-21-2013 part a Intermediate-Excel-7-21-2013 part b

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 6-15-2013