Branding

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

Excel Look-up Functions (103-828AE)

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.

Start date

06/20/2019

End date

06/20/2019

Location

Burlington Center

$ 29.00

Buy

Not Available

Excel Pivot Tables & Charts (103-817AE)

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.

Start date

06/20/2019

End date

06/20/2019

Location

Burlington Center

$ 29.00

Buy

Not Available

Excel Simple Macros (103-804RE)

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.

Start date

06/20/2019

End date

06/20/2019

Location

Burlington Center

$ 49.00

Buy

Not Available

Microsoft Excel Advanced (103-466E)

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 and better analyze and organize large amounts of data as well as be able to set data entry restrictions.

Start date

06/06/2019

End date

06/13/2019

Location

Burlington Center

$ 99.00

Buy

Not Available

Microsoft Excel Intermediate (103-432CE)

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.

Start date

05/16/2019

End date

05/23/2019

Location

Burlington Center

$ 99.00

Buy

Not Available

Rocketry in the Classroom (SC19 CLASSROOM)

Teacher Summer Camp

This is outside the normal summer camp; BUT similar to introduction to Rocketry but for Middle and HS Teachers. Camper would build and fly a rocket and we'd add in resources and tips for using rocketry as a classroom project to promote STEM learning.

Room: TBD

Days: W

Time: 10:00-3:00

Instructor: Kenneth Dotzler

Recommended Age Range: Teachers

Start date

08/21/2019

End date

08/21/2019

Location

Imet

$ 25.00

Buy

Not Available

row(s) 1 - 6 of 6