CONTINUING EDUCATION

Read more

In this course, learners build on basic Microsoft Excel skills. They examine advanced text formatting options. Learners investigate order of operations, differentiate between absolute and relative references, and practice using formulas and functions to perform calculations. Learners explore basic Excel functions (logical, date and time, statistical) used to analyze and manipulate data. Upon completion of the course, learners will be able to perform a variety of intermediate level spreadsheet functions to format, manipulate, and analyze data.

 

Instructor Arlene Roche
Tuesdays, 10/5/21 & 10/12/21
4:00 pm - 8:00 pm
Room 263 - iMET Center

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
Thursdays, 10/19/21 & 10/26/21
4:00 pm - 8:00 pm
Room 263 - iMET Center

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
Tuesdays, 9/7, 9/14, 9/21 & 9/28/21
8:00 am - 10:00 am
Via Zoom
Instructor will contact you with the Zoom information

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
Tuesday, 10/12/21
8:00 am - 10:00 am
Via Zoom
Instructor will contact you with the Zoom information

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, October 7, 2021
9:00 am - 11:00 am
Room 267 - 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
Tuesday, 10/5/21
8:00 am - 10:00 am
Via Zoom
Instructor will contact you with the Zoom information

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
Tuesdays, 10/19/21 & 10/26/21
8:00 am - 10:00 am
Via Zoom
Instructor will contact you with the Zoom information

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-2WDC
Tuesdays, 9/7/21 - 11/30/21
8:00 am - 10:00 am

Hide

Read more

RC Workshop With Bridgehomeschool Group

Drive and learn session. Experience the Fab Lab while you practice your driving skills, work on remote control cars, and participate in challenges.

Pandemic Requirements
You are required to wear a mask while on any Gateway Campus. Gateway also requires you to social distance whenever possible. There will be hand sanitizer, and visual aids for Social Distancing available.

 

Wednesday, November 3, 2021
5:30 PM - 7:30 PM
S.C. Johnson iMET Center
2320 Renaissance Blvd
Room 117
 

Hide

Read more

RC Workshop With Bridgehomeschool Group

Drive and learn session. Experience the Fab Lab while you practice your driving skills, work on remote control cars, and participate in challenges.

Pandemic Requirements
You are required to wear a mask while on any Gateway Campus. Gateway also requires you to social distance whenever possible. There will be hand sanitizer, and visual aids for Social Distancing available.

 

Wednesday, December 1, 2021
5:30 PM - 7:30 PM
S.C. Johnson iMET Center
2320 Renaissance Blvd
Room 117

Hide