Branding

Cart

Message

CONTINUING EDUCATION

Gateway is committed to serving not only our students but our communities as a whole. In addition to in-demand career education, we offer a number of continuing education courses. Continuing education courses provide training in specific areas for personal or professional development.

Browse our professional development offerings below. Begin the registration process by selecting an offering.

Access your student portal to view messages, your calendar and previous registration activity.

Courses

Access Advanced (103-838E)

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
Start date

12-Nov-2020

End date

19-Nov-2020

Location

Imet

$ 99.00

Buy Buy

Not Available

-

Access Beginning (103-832E)

Read more

In this course, learners explore basic features of Microsoft Access. They examine tables, forms, reports, and queries. Database management vocabulary is introduced, and learners practice its use. Upon completion of the course, learners will be able to create and navigate a simple database and develop simple queries.

 

Instructor Arlene Roche
Saturdays - 10/3/20 & 10/17/20
8:00 am - 12:00 pm
Room A210 - Kensosha Campus

Hide
Start date

03-Oct-2020

End date

17-Oct-2020

Location

Kenosha Campus

$ 99.00

Buy Buy

Not Available

-

Access Intermediate (103-837E)

Read more

In this course, learners build on basic Microsoft Access database skills. They examine data validation, database relationships, and the design and purpose of more complex queries and forms. Learners practice using calculations in tables, queries, and forms. Upon completion of this course, learners will be able to build a report using conditional formatting, build a navigation form to help users find their way around a database, and present data using basic macros to automate common tasks.

 

Instructor Arlene Roche
Saturdays, 10/24/20 & 11/7/20
8:00 am - 12:00 pm
Room A210 - Kenosha

Hide
Start date

24-Oct-2020

End date

07-Nov-2020

Location

Kenosha Campus

$ 99.00

Buy Buy

Not Available

-

Excel 1 (Beginning) (103-845E)

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
Start date

14-Nov-2020

End date

21-Nov-2020

Location

Kenosha Campus

$ 99.00

Buy Buy

Not Available

-

Excel 1 (Beginning) (103-845E)

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
Wednesdays - 10/7/20 & 10/14/20
8:30 am - 12:30 am
Room S241 North Building- Elkhorn Campus

Hide
Start date

07-Oct-2020

End date

14-Oct-2020

Location

Elkhorn Campus

$ 99.00

Buy Buy

Not Available

-

Excel 2 (Intermediate) (103-833E)

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
Wednesdays - 10/21/20 & 10/28/20
8:30 am - 12:30 pm
Room S241 North Building - Elkhorn Campus

Hide
Start date

21-Oct-2020

End date

28-Oct-2020

Location

Elkhorn Campus

$ 99.00

Buy Buy

Not Available

-

Excel 2 (Intermediate) (103-833E)

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
Thursdays - 10/1/20 & 10/8/20
4:00 pm - 8:00 pm
Room 227 - iMET Center

Hide
Start date

01-Oct-2020

End date

08-Oct-2020

Location

Imet

$ 99.00

Buy Buy

Not Available

-

Excel 3 (Intermediate) (103-840E)

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/15/20 & 10/22/20
4:00 pm - 8:00 pm
Room 227 - iMET Center

Hide
Start date

15-Oct-2020

End date

22-Oct-2020

Location

Imet

$ 99.00

Buy Buy

Not Available

-

Excel 3 (Intermediate) (103-840E)

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
Start date

04-Nov-2020

End date

11-Nov-2020

Location

Elkhorn Campus

$ 99.00

Buy Buy

Not Available

-

Excel Look-Up Functions (103-844E)

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
Start date

29-Oct-2020

End date

29-Oct-2020

Location

Imet

$ 29.00

Buy Buy

Not Available

-

Excel Look-Up Functions (103-844E)

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
Start date

18-Nov-2020

End date

18-Nov-2020

Location

Elkhorn Campus

$ 29.00

Buy Buy

Not Available

-

Excel Pivot Tables and Charts (103-839E)

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
Start date

29-Oct-2020

End date

29-Oct-2020

Location

Imet

$ 29.00

Buy Buy

Not Available

-

Excel Pivot Tables and Charts (103-839E)

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
Start date

18-Nov-2020

End date

18-Nov-2020

Location

Elkhorn Campus

$ 29.00

Buy Buy

Not Available

-

Excel Simple Macros (103-841E)

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
Start date

05-Nov-2020

End date

05-Nov-2020

Location

Imet

$ 49.00

Buy Buy

Not Available

-

Excel Simple Macros (103-841E)

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
Start date

25-Nov-2020

End date

25-Nov-2020

Location

Elkhorn Campus

$ 49.00

Buy Buy

Not Available

-

Shopping Cart

Excel Look-Up Functions

18-NOV-20 - 18-NOV-20

$  29.00
$ 29.00

Back Checkout