-
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 Microsoft Excel Intermediate 3-25-2014…
-
Introduction to Excel 3-24-2014
I’m pleased to announce below is the link to the worksheet developed during the Monday workshop on 3-24-2014. You can use it to review the activities covered in class: autofill cell border vLookup database function recording and playing macros Introduction to Excel 3-24-2014
-
Advanced Excel 3-15-2014
I’m pleased to announce below is the link to the worksheet developed during the Saturday workshop on 3-15-2014. You can use it to review the activities covered in class: Creating a customized drop down list menu Using normal view, page layout view, page break view Saving as PDF Recording a Macro to automate repetitive tasks…
-
Introduction to Excel 3-11-2014
I’m pleased to announce below is the link to the worksheet developed during the Tuesday workshop on 3-11-2014. You can use it to review the activities covered in class: autofill cell border formulas bold format cell color fill cell number format normal view, page layout view, page break view print preview save as PDF cell…
-
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…
-
Introduction to Excel 2-25-2014 and 3-5-2014
I’m pleased to announce below are links to the worksheets developed during the Wednesday workshops on 2-26-2014 and 3-5-2014. You can use it to review the activities covered in class: autofill column/pie chart formulas functions [sum(), now(), average()] Introduction to Excel 2-26-2014 Introduction to Excel 3-5-2014
-
Introduction Excel 2-25-2014 and 3-4-2014
I’m pleased to announce below are links to the worksheets developed during the Tuesday workshops 2-25-2014 and 3-4-2014. You can use them to review the activities covered in class: autofill column/pie chart formulas functions [sum(), now()] using formulas to covert to Euros using functions to create a shipping calculator using autofill with formulas to calculate…
-
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 11-9-2013
-
Advanced Excel 10-19-2013
Below is the link to the file developed in the advanced excel class: Advanced Excel 10-19-2013 It has been provided so you can review the work done in class. Recording a Macro Summarizing data with Pivot Tables Formulas and functions Linking with cell references: absolute, relative, name range Nested conditional functions
-
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 10-12-2013
-
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-7-21-2013 part a Intermediate-Excel-7-21-2013 part b
-
Advanced Excel 6-22-2013
Below are links to the three files developed in the advanced excel class: Advanced Excel 6-22-2013 vehicle, shoes, grade book Advanced Excel 6-22-2013 scuba ratings in pivot table Advanced Excel 6-22-2013 links They have been provided to review the work done in class. Recording a Macro Review vlookup Summarizing data with Pivot Tables Links using…
-
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 6-15-2013
-
Advanced Excel 5-5-2013
Below are two files developed in the second class. advanced excel 5-5-2013 macro and what if analysis advanced excel 5-5-2013 various examples They have been provided to review the work done in class. Recording a Macro Review vlookup What if analysis pmt( ) function
-
Advanced Excel 4-28-2013
Below is the file developed in class. Advanced Excel 4-28-2013 It has been provided so you can practice the exercises done in class: Working with a pivot table Showing details Using name ranges Grouping Filtering pivot table results Interpreting pivot table results Nested functions Shortcuts Linking worksheets Pasting name range Refreshing pivot table and chart…
-
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 4-21-2013
-
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
-
Advanced Excel 4-7-2013
Below is the link to the file developed in class: Advanced Excel 4-7-2013 It has been provided so you can practice the exercises done in class. It contains macros, a pivot table, and a custom Excel function created with VBA.
-
Advanced Microsoft Excel 2010 (3-17-2013)
I am pleased to announce below is the link to the “30 Year Interest Rate” file developed in class: Advanced Excel 3-17-2013 It has been provided so you can practice the exercises done in class. It contains macros, a pivot table, conditional formatting, date and conditional functions.
-
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
