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 Look-up functions course, students will learn the use of the following functions:

• V-look up and H-look up functions
• 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
Thursday - 4/23/20
1-3pm
Room S239 - Elkhorn campus
 

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
Thursdays - 4/16/20
1-3pm
S239 - Elkhorn campus
 

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
• 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
Wednesday- 3/25/20
8:00 am - 12:00 pm
Room S242 - Elkhorn campus
 

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 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-3WDB
Fridays - 5/1/20 - 7/24/20
8:00 am - 10:00 am.

This 12-week course is designed to certify participants with Lean Six Sigma Green Belt credentials. Lean Six Sigma is the standard for world-class quality based on continuous improvement through identifying and eliminating waste. Blending on-line instruction with online modules and a work project with 6 hours of individual coaching. The first half of this course (623-497) is comprised of Lean enterprise and Six Sigma organizational structure, and the elements of define and measure in the DMAIC process. The second half of the course (623-428) will cover the Analyze, Improve, and Control elements of the DMAIC Process with report outs of individual workplace improvement projects. You must be registered in both the Part A (623-497) and Part B (623-498) courses to participate.

Instructor Rick Lofy
623-497E-3WDB
Fridays, 5/1/20 - 7/24/20
12:00 PM - 4:00 PM

This 12-week course is designed to certify participants with Lean Six Sigma Green Belt credentials. Lean Six Sigma is the standard for world-class quality based on continuous improvement through identifying and eliminating waste. Blending on-line instruction with online modules and a work project with 6 hours of individual coaching. The first half of this course (623-497) is comprised of Lean enterprise and Six Sigma organizational structure, and the elements of define and measure in the DMAIC process. The second half of the course (623-428) will cover the Analyze, Improve, and Control elements of the DMAIC Process with report outs of individual workplace improvement projects. You must be registered in both the Part A (623-497) and Part B (623-498) courses to participate.

Instructor Rick Lofy
623-498E-3WDB
Fridays, 5/1/20 - 7/24/20
12:00 pm - 4:00 pm

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-3WDB
Fridays, 5/1/20 - 7/24/20
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 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
Wednesdays - 4/22/20 & 4/29/20
12:30 pm - 4:30 pm
Room 110 - Burlington campus
 

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