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
Wednesday, 11/20/19
12:30 pm - 2:30 pm
Room S239 - Elkhorn Campus

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, 1/23/20
10:30 am - 12:30 pm
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
Thursday, 1/23/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
Wednesday - 12:30 pm - 4:30 pm
Room S239 - Elkhorn Campus

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

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-2W7A
Fridays, 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-2W7A
Fridays, 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-2W7A
Fridays, 10:00 am - Noon

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
Wednesday
12/18/19 8:00 am - 4:30 pm
Room S239 - Elkhorn Campus

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 , 1/9/20 & 1/16/20
8:00 am - 12:00 pm
Room 227- 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 - 11/14/19 & 11/21/19
8:00 am - 12:00 pm
Room TBD - 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
Wednesdays - 11/13/19 & 11/20/19
8:00 am - 12:00 pm
Room S239 - Elkhorn Campus

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
Tuesdays - 12/3/19 & 12/10/19
8:00 am - 12:00 pm
Room S239 - Elkhorn Campus
 

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
Wednesdays - 12/4/19 & 12/11/19
8:00 am - 12:00 pm
Room S239 - Elkhorn Campus

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 - 12/5/19 & 12/12/19
8:00 am - 12:00 pm
Room TBD - iMET Center