CONTINUING EDUCATION

In the Look-up fucntions course, students will learn the use of the following functions:

• V-look up and H-look up fucntions
• Match and Index functions

Upon completion of this 2-hour course, students will be able to look-up and retrieve pieces of data from a dataset, combine data from 2 or more tables and classify/categorize data all through the use of look-up functions.

Instructor Arlene Roche
Saturday - 4/4/20
8:00 am - 10:00 am
Room 227 - iMET Center

In the Pivot Table course, students will learn the following:

• creating and modifying PivotTables
• creating and modifying PivotCharts
• filtering data using timelines and slicers

Upon completion of this 2-hour course, student will be more efficient in analyzing and organizing data through PivotTables and PivotCharts.

Instructor Arlene Roche
Saturday - 3/28/20
8:00 am - 10:00 am
Room 227 - iMET Center

In the MS Excel Macros course, students will learn the following:

• recording and saving macros for a variety of simple tasks
• performing basic edits of a macro
• debuging simple macro errors
• adding simple form controls to help run macros

Upon completion of this 4-hour course, students will better understand the purpose and function of macros. In addition, students will have a simple understanding of how macros are designed through coding.

Instructor Arlene Roche
Thursday - 4/25/20
8:00 am - 12:00 pm
Room 227 - iMET Center

In the MS Excel Macros course, students will learn the following:

• recording and saving macros for a variety of simple tasks
• performing basic edits of a macro
• debugging simple macro errors
• adding simple form controls to help run macros

Upon completion of this 4-hour course, students will better understand the purpose and function of macros. In addition, students will have a simple understanding of how macros are designed through coding.

Instructor Arlene Roche
Thursday, 1/30/20
8:00 am - 12:00 pm
Room 227 - iMET Center

In the PC Basics course, students will learn the following:

• identify, define and use common computer hardware devices (i.e. keyboard, mouse, Flash drive, etc..)
• navigate in Microsoft Windows and manage applications windows
• manage folders and files in File Explorer
• save and share files in numerous types and locations
• compose a professional email message

Upon completion of this 8-hour course, students will have learned some very basic and useful concepts to better understanding how computers operate. Students will be more efficient in navigation and organization of files, folders and applications. In addition, students will be able to better communicate via email in a professional manner.

Instructor Arlene Roche
Saturdays- 8:00 am - 12:00 pm
Room 227 - iMET Center

This 12-week course is designed to introduce participants to the essentials of Lean Operations. Lean training is one of the most valuable skills in business today. Businesses of all types are utilizing lean principles as the primary continuous improvement methodology. Lean changes businesses through techniques that create proven results that translate directly to the bottom-line. Blending on-line instruction with online modules, and a work project with 3 hours of individual coaching.

Instructor Rick Lofy
623-812E-3WDA
Fridays - 8:00 am - 10:00 am

This 12-week course is designed to take certified Green Belts to the Black Belt level. Participants will apply powerful problem solving tools and basic statistical techniques necessary for the Black Belt to lead strategic implementation of lean six sigma practices in the organization, as well as train and mentor black belts and green belts. This course blends on-line instruction with online modules and a work project with 6 hours of individual coaching.

Instructor Rick Lofy
623-817E-3WDA
Fridays, 10:00 am - Noon

Access Advanced – In the Access Advanced course, students will learn the following:

• design and purpose of more complex reports
• outlines and calculations on reports
• design and purpose of switchboards
• macro recording of simple tasks
• mail merging options
• data normalization

Upon completion of this 8-hour course, students will have learned some advanced concepts to help design useful databases in MS Access as well as better analyze data through a variety of database tools.

Instructor Arlene Roche
Thursdays - 4/2/20 & 4/9/20
8:00am - 12:00pm
Room 267 - iMET Center

In the Access Beginning course, students will learn the following:

• basic database management terminology and editing
• basic data entry rules
• design and creation of tables, including data entry of fields & records
• basic sorts, filters and calculations on data
• design and purpose of simple queries, forms, and reports

This course is designed for an individual with some basic and general computer skills Throughout the course, students will learn to be more efficient and use a variety of short-cuts. Upon completion of this 8-hour course, students will be efficient in creating, navigating and editing a simple database.

Instructor Arlene Roche
Thursdays - 8:00 am - 12:00 pm
Room 227 - iMET Center

In the Access Intermediate course, students will learn the following:

• data validation and restriction on fields and records
• database relationships including joining tables & queries
• design and purpose of subdatasheets
• object dependencies and object navigation tools
• design and purpose of more complex queries
• design and purpose of more complex forms
• calculations in many objects including tables, queries and forms

Upon completion of this 8-hour course, students will be more efficient in analyzing data and restricting data as well as better understand relationships among database objects.

Instructor Arlene Roche
Thursdays - 3/12/20 & 3/19/20
8:00am - 12:00pm
Room 267 - iMET Center
 

In the Excel 3 course, students will learn the following:

• purpose and functionality of 3D and external references
• grouping and subtotals
• sorting and applying filters on data
• data validation and restriction
• some logical functions such as AND, OR, nested IF functions and more
• special formatting such as table styles and sparklines
• paste special options

Throughout the course, students will learn to be more efficient and use a variety of short-cuts.
Upon completion of this 8-hour course, students will be able to better navigate and create relationships in larger and multiple worksheets. In addition, students will be able to better analyze and organize large amounts of data as well as be able to set data entry restrictions.

Instructor Arlene Roche
Thursdays - 4/2/20 & 4/9/20
5:00pm - 9:00pm
Room 267 - iMET Center

In the Excel 1 course, students will learn the following:

• basic spreadsheet terminology and editing
• basic functions such as Sum, Average, Min, Max and Count
• basic spreadsheet formatting, such as changing font, alignment, number and cell styles
• basic charting tools
• basic page setup & printing options

This course is designed for an individual with some basic and general computer skills. Throughout the course, students will learn to be more efficient and use a variety of short-cuts.
Upon completion of this 8-hour course, students will be more efficient in creating, editing and navigating a basic spreadsheet as well as performing simple calculations.

Instructor Arlene Roche
Thursdays - 2/27/20 & 3/5/20
5:00pm - 9:00pm
Room 267 - iMET Center

In the Excel 2 course, students will learn the following:

• functions to format text including Abs, Substitute, Upper, Lower, Trim, Concat, etc...
• calculations using absolute references and order of operation
• basic logical functions such as If, Sumif, Countif, etc…
• creation and purpose of named ranges
• basic statistical and date/time functions such as Small, Large, Rank, Now, Today, Days, etc…

Throughout the course, students will learn to be more efficient and use a variety of short-cuts.
Upon completion of this 8-hour course, students will be able to perform a variety of spreadsheet functions to be more efficient in formatting and analyzing data.

Instructor Arlene Roche
Thursdays - 3/12/20 & 3/19/20
5:00pm - 9:00pm
Room 267 - iMET Center

In the PowerPoint Beginning course, students will learn the following:

• basic presentation terminology and editing
• basic slide layout
• slide creation and insertion from other files
• basic presentation formatting using font, paragraph and drawing tools
• basic insertion and format of a variety of objects, such as shapes, pictures, WordArt, symbols, tables, arts, etc…
• basic slideshow settings such as transitions and animation
• basic page setup & printing options

This course is designed for an individual with some basic and general computer skills. Throughout the course, students will learn to be more efficient and use a variety of short-cuts. Upon completion of this 8-hour course, students will be more efficient in creating, editing and using professional looking presentations.

Instructor Arlene Roche
Thursdays, 12:30 pm - 4:30 pm
Room 267 - iMET Center

In the PowerPoint Intermediate course, students will learn the following:

• insertion and format of a variety of objects, such as audio, video, SmartArt, hyperlinks, etc…
• slide organization with sections
• more advanced slideshow settings
• the customization of templates and master slides
• more advanced saving and printing options
• insertion and linking of MS Word outlines & tables
• linking MS Excel spreadsheets to a slide
• adding action buttons to the slideshow

This course is designed for an individual with some basic knowledge of using MS Power Point.
Upon completion of this 8-hour course, students will be more efficient in creating, editing and using professional looking presentations.

Instructor Arlene Roche
Thursdays, 3/12/20 & 3/19/20
12:30 pm - 4:30 pm
Room 267 - iMET Center