-
Introduction to Access 11-16-2013
Below is a link to the database developed in class. Introduction to Access 11-16-2013 To access the database, download the zip file and then right click that “zip” file to extract it. You can use this file to review: Tables Queries Relationships Sorting with a table Filtering with a table Sorting with a query Filtering…
-
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 Microsoft Access Workshop 7-20-2013
Below is the link to the Access database file developed in class: Advanced Access 7-20-2013 It has been provided so you can review Make Table query, Append query, Update query, Crosstab query, Delete query, Union query, basic SQL manipulation, and the Expression Builder.
-
Intermediate Access 7-13-2013 forms (subforms), reports, macros
It was a nice working with the group on Saturday July 13. Below is a copy of the database developed during the workshop. You can use it to practice and review the activities covered in class. Creating a one to many relationship Creating a form Creating a form with a subform Creating a report Adding…
-
Introduction to Access 6-29-2013
Below is a link to the database developed in class. Introduction to Access 6-29-2013 To access the database, download the zip file and then right click that “zip” file to extract it. You can use this file to review: Tables Queries Reports
-
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 Microsoft Access 2010 (5-4-2013)
Below is the link to the Access database file developed in class: Advanced Access 5-4-2013 It has been provided so you can practice the exercises with setting up relationships, designing a database, using SQL to create a union query, creating subforms, and to review the report tool.
-
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…
-
Advanced Microsoft Access 2010 (4-27-2013)
Below is the link to the Access database file developed in class: IceCreamHeaven 4-27-2013 (Small business Ice Cream Store Staff) It has been provided so you can practice the exercises with update, make table, and append queries. I look forward to seeing you all in the next class!
-
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 Access 4-13-13 (Movies)
It was nice working with the group on Saturday April 13th. Below is a copy of the database developed during the workshop. You can use it to practice and review the activities covered in class. Intermediate Access 4-13-13
-
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
-
I can’t wait to use Excel 2013 with my students!
Change video quality to HD mode to see most detail.
-
Intermediate Access 4-6-13
Below is the link to the “Movie List” database developed in class. It has been provided so you can practice the activities done in class. It contains tables, a report, a data form, and macros developed in class. To access the database: Download the zip file below. Open the folder containing the zip file from…
-
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.