-
Advanced Excel 6-28-2014
Below is a link to the file 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 Advanced-Excel-6-28-14
-
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) Intermediate Excel 6-14-2014 (b) Gantt-Chart Intermediate Excel 6-14-2014 (c)
-
Introduction to Access 4-12-2014
Below is a link to the database developed in class. Introduction to Access 4-12-2014 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…
-
Microsoft Excel Intermediate 4-9-2014 Day 3
I’m pleased to announce below is the link to the worksheet developed during the Wednesday workshop on 4-9-2014. You can use it to review the activities covered in class: Name Ranges Date & Time functions Date & Time shortcuts Conditional Format Goal Seek Intermediate Excel 4-9-2014
-
Microsoft Excel Intermediate 4-8-2014
I’m pleased to announce below is the link to the worksheet developed during the Tuesday workshop on 4-8-2014. You can use it to review the activities covered in class: creating a gantt chart sorting using formulas with dates creating actual and expected gannt charts Files: Gantt Chart 4-8-2014 (xlsx) Gantt Chart 4-8-2014 (1) (pdf) Gantt Chart 4-8-2014 (2) (pdf)…
-
Microsoft Excel Intermediate 4-2-2014 Day 2
I’m pleased to announce below is the link to the worksheet developed during the Wednesday workshop on 4-2-2014. You can use it to review the activities covered in class: creating a bar chart and pie chart sorting filtering Intermediate Excel 4-2-2014
-
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…
-
Advanced Access 12-7-2013
Below is the link to the Access database file developed in class: Advanced Access Vacation List 12-7-2013 It has been provided so you can review the action queries: Make Table, Append, Delete query, and Update query. You can also use it review the Crosstab query, Union query, SQL manipulation, and the Expression Builder. Have a…
-
Advanced Access Vacation List 12-7-2013
Advanced Access Vacation List To access the database, download the zip file and then right click downloaded zip file to select extract.
-
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
