CONTINUING EDUCATION

Read more

In this course, learners build on intermediate Microsoft Access skills. They investigate complex reports, switchboards, macros, mail merge and data normalization. Upon successful completion of the course, learners will be able to apply advanced concepts to useful database design and to skillfully analyze database content and design using a variety of database tools.

Instructor Arlene Roche
Thursdays - 11/12/20 & 11/19/20
4:00 pm - 8:00 pm
Room 110 - iMET Center

Hide

Read more

In this course, learners explore basic features of Microsoft Excel. They examine spreadsheet terminology and editing. Learners explore Excel formatting functions and the features to create simple charts. Learners practice using spreadsheet printing options, page setup options, and a variety of shortcut techniques. Upon completion of the course, learners will be able to create, edit, and navigate a basic spreadsheet and create simple charts associated with a spreadsheet.

 

Instructor Arlene Roche
Saturdays, 11/14/20 & 11/21/20
8:00 am - 12:00 pm
Room A210 - Kenosha Campus

Hide

Read more

In this course, learners build on intermediate level Microsoft Excel skills. They explore the purpose and function of three-dimensional (3D) and external references. Learners apply sorting, filtering, grouping, and subtotaling features to spreadsheet data and its validation. They examine more advanced logical functions used to test for the presence of and various combinations of data (if, and, or). Learners consider special formatting features that enhance tables and charts. Upon completion of the course, learners will be able to analyze, manipulate, organize, and visualize data.

Instructor Arlene Roche
Wednesdays, 11/4/20 & 11/11/20
8:30 am - 12:30 pm
Room S241 North Building- Elkhorn Campus

 

Hide

Read more

In this course, learners build on basic Microsoft Excel skills to investigate the process of finding specific values within a data set. They examine Excel's lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX, CHOOSE) and practice applying them to specific scenarios. The simplicity and flexibility of Excel's XLOOKUP function is presented. Upon completion of the course, learners will be able to use reference functions to search for specific information in a data set and use it to retrieve, combine, and categorize data.

 

Instructor Arlene Roche
Thursday - 10/29/20
6:15 pm - 8:15 pm
Room 227 - iMET Center

Hide

Read more

In this course, learners build on basic Microsoft Excel skills to investigate the process of finding specific values within a data set. They examine Excel's lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX, CHOOSE) and practice applying them to specific scenarios. The simplicity and flexibility of Excel's XLOOKUP function is presented. Upon completion of the course, learners will be able to use reference functions to search for specific information in a data set and use it to retrieve, combine, and categorize data.

 

Instructor Arlene Roche
Wednesday, 11/18/20
10:30 am - 12:30 pm
Room S241 North Building - Elkhorn Campus

Hide

Read more

In this course, learners use advanced Microsoft Excel skills to analyze complex data. They examine how to build PivotTables that summarize large data sets and how to apply conditional formatting and filtering to the PivotTables they create. Learners investigate how to create a visual representation (PivotChart) of a PivotTable , and they explore the relationship between them. Upon completion of the course, learners will be able to summarize, visualize, and analyze complex data and present it in an effective and efficient, interactive visual format to meet the needs of business planners.

 

Instructor Arlene Roche
Thursday - 10/29/20
4:00 pm - 6:00 pm
Room 227 - iMET Center

Hide

Read more

In this course, learners use advanced Microsoft Excel skills to analyze complex data. They examine how to build PivotTables that summarize large data sets and how to apply conditional formatting and filtering to the PivotTables they create. Learners investigate how to create a visual representation (PivotChart) of a PivotTable , and they explore the relationship between them. Upon completion of the course, learners will be able to summarize, visualize, and analyze complex data and present it in an effective and efficient, interactive visual format to meet the needs of business planners.

 

Instructor Arlene Roche
Wednesday, 11/18/20
8:00 am - 10:00 am
Room S241 North Building - Elkhorn Campus

Hide

Read more

In this course, learners build on basic Microsoft Excel skills to automate a task or set of tasks. Using Visual Basic for Applications (VBA) available in Excel, learners develop custom actions designed to streamline data and spreadsheet-related tasks. They practice planning, recording, editing, running, debugging, and saving a macro of their creation. Upon completion of the course, learners will be able to design, create, edit, and save custom actions that enhance the efficiency of spreadsheet tasks.

 

Instructor Arlene Roche
Thursday - 11/5/20
4:00 pm - 8:00 pm
Room 227 - iMET Center

Hide

Read more

In this course, learners build on basic Microsoft Excel skills to automate a task or set of tasks. Using Visual Basic for Applications (VBA) available in Excel, learners develop custom actions designed to streamline data and spreadsheet-related tasks. They practice planning, recording, editing, running, debugging, and saving a macro of their creation. Upon completion of the course, learners will be able to design, create, edit, and save custom actions that enhance the efficiency of spreadsheet tasks.

 

Instructor Arlene Roche
Wednesday, 11/25/20
8:30 am - 12:30 pm
Room S241 North Building - Elkhorn Campus

Hide

Read more

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-3WDC
Fridays - 1/8/21 - 4/2/21
8:00 am - 10:00 am.

Hide

Read more

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-3WDC
Fridays, 1/8/21 - 4/2/21
12:00 PM - 2:00 PM

Hide

Read more

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-3WDC
Fridays,1/8/21 - 4/2/21
2:00 pm - 4:00 pm

Hide

Read more

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-3WDC
Fridays, 1/8/21 - 4/2/21
10:00 am - Noon

Hide

Read more

In this course, learners explore the features and functions of the diagramming tool, Microsoft Visio. They use stencils and shapes to design and create a variety of diagrams (flow chart, organizational chart, floor plan, network diagram). Learners customize drawings using themes, variants, and special effects and apply containers and callouts to add structure to drawings. They print and share diagrams in a variety of formats. Upon completion of the course, learners will be able to create visually compelling diagrams, maps and drawings with integrated, structured business graphics.

 

Instructor Arlene Roche
Wednesdays - 12/2/20 & 12/9/20
1:00 pm - 5:00 pm
Room 227 - iMET Center

Hide

Read more

In this course, learners explore basic features of QuickBooks Desktop. They examine the features and functions and navigate the software's desktop. Learners investigate everyday transactions (selling, buying, inventory, taxes, banking) and explore special transactions (processing refunds, managing voided and deleted checks, applying credit memos). They examine the accounting cycle and analyze common financial statements. Learners investigate the payroll function and use lists and reports to manage data. Upon completion of the course, learners will be able to organize business finances productively using QuickBooks software.

 

Instructor Arlene Roche
Wednesdays - 11/4/20 & 11/11/20
4:00 pm - 8:00 pm
Room 110 - iMET Center

Hide