-
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.
-
Advanced Excel 7-26-2015
I’m pleased to announce the two files from the Advanced Excel workshop on 7-26-2015 are now available to practice with: Advanced Excel 7-26-2015 a Advanced Excel 7-26-2015 b
-
Introduction to Access 6-28-2015
Below is a link to the databases developed in class. Introduction to Access 06-28-2015 Steps to access the databases in the zip file: Download the above zip file Right-click the “zip” file from step 1 above and select extract. Open the folder containing the extracted files. If you have Microsoft Access, the access files .accdb…
-
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
-
Advanced Excel 4-25-2015
I’m pleased to announce the file created during the Advanced Excel workshop on 4-25-2015 is now available to practice with. Here is the link: Advanced Excel 4-25-2015.
-
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. Merrick Intermediate Excel 3-31-2015 a Merrick Intermediate Excel 3-31-2015 b
-
Introduction to Access 3-28-2015
Below is a link to the two databases developed in class. VacationPlanning 03-28-2015 To access the databases download the above zip file, right-click the “zip” file and select extract. You can use the files to review: Tables Queries Relationships Sorting with a table Filtering with a table Sorting with a query Filtering with a query…
-
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-2015 You can use the file to review the activities covered in class: pivot table/pivot chart, sorting, filtering, and creating a Gantt chart.
-
Introduction to Access 3-10-2015
Below is a link to the two databases developed in class. Introduction to Access 3-10-2015 To access the databases download the zip file and then right-click that “zip” file and select extract. You can use the files to review: Tables Queries Relationships Sorting with a table Filtering with a table Sorting with a query Filtering…
-
Excel Pivot Table workshop 12-13-2014
I’m pleased to announce below is the link to the worksheet developed during the Saturday workshop on 12-13-2014. You can use it to review a few of the activities covered in class: creating pivot tables working with pivot table fields modifying pivot table layout linking a chart to your pivot table changing data values and…
-
Introduction to Excel 11-25-2014
I’m pleased to announce below is the link to the worksheet developed during the Tuesday workshop on 11-25-2014. You can use it to review a few of the activities covered in class: navigation and data entry sort and filter sum function autofill and formulas Introduction to Excel 11-25-2014
-
Intermediate Access 11-8-2014 forms, subforms, reports, macros
It was a nice working with the group on Saturday November 8. 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…
-
Advanced Excel 10-25-2014
Below are the files developed during Saturday’s 10/25/2014 Advanced Excel workshop. You can use the files to review the activities covered in class: nested if functions, pivot tables, name range references, pivot charts, mail merge, macros, pivot table sorting, filtering, and grouping. advanced excel 10-25-2014 (1) advanced excel 10-25-2014 (2) advanced excel 10-25-2014 (3) advanced…
-
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 10-18-2014 (chart)
intermediate excel 10-18-2014 (chart)
-
Intermediate Excel 10-18-2014
intermediate excel 10-18-2014
-
Advanced Excel 8-9-2014
Below are links to the files developed in the advanced excel class. It has been provided so you can review the work done in class. Summarizing data with Pivot Tables Group feature with Pivot Tables Formulas and nested functions Linking cells: name range/name box and hyperlinks Nested conditional functions Creating macros and buttons Creating a…
-
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 7-26-2014
-
Introduction to Access 7-12-2014
Below is a link to the three databases developed in class. Introduction to Access 7-12-2014 To access the databases, download the zip file and then right-click that “zip” file to extract the files. You can use the files to review: Tables Queries Relationships Sorting with a table Filtering with a table Sorting with a query…
