Author: admin
-
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 macro for a specific purpose
-
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.
-
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
- Filtering with a query
- The overview of reports and subforms
-
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
-
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)
-
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 with a query
-
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
-
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)
- Gantt Chart 4-8-2014 (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
-
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
-
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
-
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
- Summarizing data with Pivot Tables
- Linking with cell references: absolute, relative, name range
- Applying nested conditional functions
File developed in the advanced excel class: Advanced Excel 3-15-2014.
-
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 reference
- SUM() function
-
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 you found it fun and interesting!
-
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 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 and explore interest compounding and the Rule of 72
-
MICROSOFT ACCESS – Introduction & Intermediate combined, Begins April 28, 2014
MICROSOFT ACCESS – Introduction & Intermediate combined
~New~
Prerequisite: Knowledge of Microsoft Windows 7.
Microsoft Access 2010 will be used, but several features covered can be used with earlier and later Microsoft Access versions.
Discover why Microsoft Access is used by small businesses and technical professionals to track company data, expenses, performance, inventory, as well as streamlining specific processes.
We will cover: Tables, Queries, Report Tool, Form Tool, Action Queries, Macros, and Structured Query Language.
(1) Access Table and Query topics include: examining the Access ribbon interface, creating an d editing database tables and queries; enhancing query functionality with runtime popups; basic formulas and functions; data tracking, data analysis, and calculations using tables and queries. Learn how to use the built -in tools to sort and filter your data.
(2) Access Reporting Tool topics include linking your tables and queries to the built-in report tool to create customized reports quickly.
(3) Access Form Tool topics include linking your tables and queries to the built-in form tool to streamline data and create custom forms.
(4) Other topics include Access Action Queries, Macros, and the Structured Query Language view, SQL view, to further enhance your understanding of your database.
Limit 15.
Monday, Apr. 28; May 5, 12; June 1 & 9
6:30 – 9:00 pm
Brookside Curriculum Library
Juan Hinojosa
5 Sessions
See page 8 of 19 for the course description in the Bellmore Merrick Adult Education Brochure – Spring 2014. Registration information can be found on page 3 of 19. Fee: $110.00 -
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 Happy Holiday and a Happy New Year!
-
Advanced Access Vacation List 12-7-2013
To access the database, download the zip file and then right click downloaded zip file to select extract.