Microsoft Tools
Professional Development
Offered through Continuing Education
@ Corporate College | Online
Develop your computer skills in Microsoft Word, Excel, PowerPoint and Access. Quickly learn the basics with our In-A-Day classes.
Quick Navigation
Class schedules provided below may change.
Click the orange button above to view the most up-to-date class details, including dates, classrooms, etc.
Classes offered in-person may be rescheduled, canceled or transitioned to an online format based on COVID-19 guidelines. Students are required to follow COVID-19 guidelines for classroom participation, which includes, but is not limited to, use of masks and social distancing requirements.
Unless otherwise specified in the course description, registration for online classes closes three business days prior to the class start date.
Access®
Microsoft® Access® In a Day
Learn the basics of Access in a single session! Examine how to plan and design a database
system; add, change and delete information; and create simple reports and query the
database to find display data. Prerequisite: Windows® Introduction class or equivalent
experience. Class textbook and files will be mailed to registered students. Registration
closes five business days prior to the start date.
COMP-725 | 1 session | $96.50 AGE 60+ | $129 REG
P01 Sa 9 a.m.-4 p.m. | Cris Heffernan
March 27 | Online
Microsoft® Access® for Business: Part I
Learn the basics of database design with Microsoft Access. You’ll discover how to
create, manage and maintain tables and table relationships. Leverage sorting and filtering
records within tables. Prerequisite: Windows® Introduction class or equivalent experience.
COMP-725 | 1 session | $96.50 AGE 60+ | $129 REG
P02 F 9 a.m.-4 p.m. | Cris Heffernan
April 23 | STLCC-Corp, 208
Microsoft® Access® for Business: Part II
Gain the skills necessary to enhance your database designs. Work with data normalization,
table relationships, and inner and outer join techniques. Learn to query multiple
tables for customized reports. Create more complex queries using parameters and action
queries. Explore more advanced reporting techniques. Prerequisite: Windows® Introduction
class or equivalent experience and Microsoft Access 2016 for Business Part I or equivalent
experience.
COMP-726 | 1 session | $96.50 AGE 60+ | $129 REG
P01 F 9 a.m.-4 p.m. | Cris Heffernan
April 30 | STLCC-Corp, 208
Microsoft® Access® for Business: Part III
Take your Access database to the next level using macros, VBA coding, switchboards
and other similar tools to give your user base a fluid experience. Secure your database
through the use of such as front- and back-end splitting, link tables and import/export
data techniques. Create forms to intuitively navigate and organize your data. Prerequisite:
Access for Business: Parts I and II or equivalent experience.
COMP-727 | 1 session | $96.50 AGE 60+ | $129 REG
P01 F 9 a.m.-4 p.m. | Cris Heffernan
May 7 | STLCC-Corp, 208
Excel®
Microsoft® Excel® In a Day
Learn the basics of Microsoft Excel in one session! During this introductory course,
you’ll learn how to create spreadsheets for all accounting, expense analysis, budgeting
and other applications. Topics include: worksheet set-up, labeling, entering values,
editing cells, copying content, saving, and other commands. Participants are encouraged
to bring a flash drive. Prerequisite: Windows® Introduction class or equivalent experience.
Class textbook and files will be mailed to registered students. Registration closes
five business days prior to the start date.
COMP-720 | 1 session | $96.50 AGE 60+ | $129 REG
P03 Sa 9 a.m.-4 p.m. | Cris Heffernan
Feb. 13 | Online
Microsoft® Excel® for Business: Part I
Tackle tips and tricks to efficiently navigate and create spreadsheets in Excel. Build
basic formulas and functions with an emphasis on relative and absolute referencing.
Learn to make your sheets and printouts easier to read with special formatting techniques.
This class is ideal for beginners and self-taught Excel® users. Prerequisite: Windows®
Introduction class. Participants encouraged to bring a flash drive. Registration closes
five business days prior to the start date.
COMP-720 | 1 session | $96.50 AGE 60+ | $129 REG
P01 F 9 a.m.-4 p.m. | Cris Heffernan
Feb. 5 | STLCC-Corp, 208
COMP-720 | 2 sessions | $96.50 AGE 60+ | $129 REG
P02 Th/F 9 a.m.-noon | Cris Heffernan
March 4-5 | Online
Microsoft® Excel® for Business: Part II
Add to your knowledge and enhance your spreadsheet skills. In this class, you’ll create
more complex formulas using a variety of functions. Learn data management techniques
and analysis using lists, tables, common charts, pivot tables and pivot charts. Discover
the ease of using range names and conditional formatting. Prerequisite: Microsoft
Excel 2016 For Business: Part I class or equivalent experience. Participants are encouraged
to bring a flash drive. Registration closes five business days prior to the start
date.
COMP-721 | 1 session | $96.50 AGE 60+ | $129 REG
P01 F 9 a.m.-4 p.m. | Cris Heffernan
Feb. 19 | STLCC-Corp, 208
COMP-721 | 2 sessions | $96.50 AGE 60+ | $129 REG
P02 W/Th 9 a.m.-noon | Cris Heffernan
March 10-11 | Online
Microsoft® Excel® for Business: Part III
Expand your Excel expertise as you manage multiple workbooks and worksheets, build
3D calculations and add file linking. Explore the power of the all-important lookup
functions and become adept at using formula auditing tools, data validation, and sharing
and protecting workbooks. Uncover the productivity of scenarios, data tables and other
major data analysis tools. Create and edit macros to save time and create consistency
across workbooks. Prerequisite: Microsoft Excel 2016 for Business: Part II or equivalent
experience. Participants are encouraged to bring a flash drive. Class textbook and
files will be mailed to registered students. Registration closes five business days
prior to the start date.
COMP-722 | 1 session | $96.50 AGE 60+ | $129 REG
P01 F 9 a.m.-4 p.m. | Cris Heffernan
Feb. 26 | STLCC-Corp, 208
COMP-722 | 2 sessions | $96.50 AGE 60+ | $129 REG
P02 W/Th 9 a.m.-noon | Cris Heffernan
March 24-25 | Online
Microsoft® Excel®: Power Pivots®
Discover one of the most robust data analysis tools within Excel: Power Pivots. Power
Pivots help you create reports, or Data Models, from multiple data sources both in
and outside of Excel. Learn to create and manage relationships, hierarchies, Power
Pivot tables and charts. You will also be introduced to creating Calculated Columns,
Calculated Fields (Measures) and Key Performance Indicators. Prerequisite: Microsoft
Excel 2016 for Business Part II or equivalent experience with creating single source
Pivot Tables. Participants are encouraged to bring a flash drive.
COMP-722 | 1 session | $81 AGE 60+ | $99 REG
P04 W 9 a.m.-noon | Cris Heffernan
April 7 | Online
P03 F 9 a.m.-noon | Cris Heffernan
May 14 | STLCC-Corp, 208
Outlook®
Outlook® and Outlook® Calendars
Learn the ins and outs of Microsoft Outlook and maximize efficiency as you use the
best features of this popular email service. Gain tips and tricks for successful and
straightforward calendar scheduling.
COMP-742 | 1 session | $34 AGE 60+ | $45 REG
P01 Th 5:30-8:30 p.m. | Rhonda Cross
Feb. 18 | Online
Word®
Microsoft® Word® for Business: Part I
Create professional-looking business documents, clean up formatting, change styles
and fonts, cut and paste content, and import text with confidence. Prerequisite: Windows®
Introduction class or equivalent experience. Class textbook and files will be mailed
to registered students. Registration closes five business days prior to the start
date.
COMP-715 | 1 session | $96.50 AGE 60+ | $129 REG
P01 F 9 a.m.-4 p.m. | Cris Heffernan
Jan. 22 | Online
P02 Sa 9 a.m.-4 p.m. | Cris Heffernan
April 17 | Online
Microsoft® Word® for Business: Part II
If you are familiar with the basics of Microsoft Word, here’s your opportunity to
learn the more advanced features. Learn to customize the Word environment, use advanced
formatting techniques, work with styles, incorporate advanced table features, create
and manage large documents, and use auto text, macros and templates. Prerequisite:
Microsoft Word for Business: Part I class or equivalent experience. Participants are
encouraged to bring a flash drive.
COMP-716 | 1 session | $96.50 AGE 60+ | $129 REG
P01 F 9 a.m.-4 p.m. | Cris Heffernan
Jan. 29 | STLCC-Corp, 208
Résumé Formatting in Microsoft® Word®
Create a professional-looking résumé using Microsoft Word. As this course will focus
on formatting (as opposed to building a résumé,) please bring the information you
wish to format to class. The instructor will guide you on how to best format using
alignment, columns, font and spacing. Prerequisite: Microsoft Word for Business: Part
I class or equivalent experience.
COMP-715 | 1 session | $34 AGE 60+ | $45 REG
P03 M 6-8 p.m. | Cris Heffernan
April 26 | Online
Microsoft, Windows, Access, Excel, Word, Power Pivots and Outlook are trademarks of Microsoft Corporation. STLCC’s Continuing Education courses are independent seminars and are not affiliated with, or authorized, sponsored or approved by Microsoft Corporation. All other trademarks are the property of their respective owner.
You May Also Enjoy:
Helpful CE Links:
My CE Account | Registration Options | General Information | Class Locations | Contact Us