Microsoft® Tools
Professional Development
Offered through Continuing Education
@ Meramec | 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 subject to change.
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 may include, but is not limited to, use of masks and social distancing requirements. For the latest requirements, review STLCC’s COVID-19 Information page.
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. Create simple reports and query the database
to find display data. Prerequisite: Windows Introduction class or equivalent experience.
Participants are encouraged to bring a flash drive.
COMP-725 | 1 session | $96.50 AGE 60+ | $129 REG
F01 F 9 a.m-4 p.m. | Cris Heffernan
Oct. 1 | STLCC-Corp 208
Microsoft® Access®: Part I
Grasp the basics of database design with Microsoft Access. 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.
Participants are encouraged to bring a flash drive.
COMP-725 | 1 session | $96.50 AGE 60+ | $129 REG
F02 F 9 a.m-4 p.m. | Cris Heffernan
Oct. 22 | STLCC-Corp 208
Microsoft® Access®: 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. Participants are encouraged to bring a flash drive.
COMP-726 | 1 session | $96.50 AGE 60+ | $129 REG
F01 F 9 a.m-4 p.m. | Cris Heffernan
Nov. 5 | STLCC-Corp 208
Microsoft® Access®: Part III
Take your Access database to the next level using macros, VBA coding, switchboards
and other 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. Participants are encouraged
to bring a flash drive.
COMP-727 | 1 session | $96.50 AGE 60+ | $129 REG
F01 F 9 a.m-4 p.m. | Cris Heffernan
Nov. 19 | STLCC-Corp 208
Excel®
Microsoft® Excel® In a Day
Learn the basics of Microsoft Excel in one session! Learn how to create spreadsheets
for accounting, expense analysis, budgeting and other applications. Topics include:
worksheet set-up, labeling, entering values, editing cells, copying content, and saving.
Participants are encouraged to bring a flash drive. Prerequisite: Windows Introduction
class or equivalent experience.
COMP-720 | 1 session | $96.50 AGE 60+ | $129 REG
F01 ◊ W 9 a.m-4 p.m. | Cris Heffernan
Nov. 17 | Online
Microsoft® Excel®: Part I
Glean tips and tricks to successfully navigate and create effective spreadsheets in
one of Microsoft’s most powerful programs. Learn to build basic formulas and functions
with an emphasis on relative and absolute referencing. Make your sheets and printouts
easier to read with special formatting techniques. This important class is ideal for
beginners and for self-taught Excel users. Prerequisite: Windows Introduction class.
Participants are encouraged to bring a flash drive.
COMP-720 | 1 session | $96.50 AGE 60+ | $129 REG
F03 F 9 a.m-4 p.m. | Cris Heffernan
Sept. 3 | STLCC-Corp 208
COMP-720 | 2 sessions | $96.50 AGE 60+ | $129 REG
F02 ◊ W Th 9 a.m.-12:30 p.m. | Cris Heffernan
Oct. 6-7 | Online
Microsoft® Excel®: Part II
Expand your spreadsheet skills and create complex formulas through functions. Master
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.
COMP-721 | 1 session | $96.50 AGE 60+ | $129 REG
F02 F 9 a.m-4 p.m. | Cris Heffernan
Sept. 10 | STLCC-Corp 208
COMP-721 | 2 sessions | $96.50 AGE 60+ | $129 REG
F01 ◊ W Th 9 a.m.-12:30 p.m. | Cris Heffernan
Oct. 13-14 | Online
Microsoft® Excel®: Part III
Expand your expertise as you manage multiple workbooks and worksheets, build 3D calculations,
add file links, and explore the power of lookup functions. Master formula auditing
tools, data validation and sharing, and workbook protection. Use scenarios, data tables
and other major data analysis tools to increase productivity. Create 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.
COMP-722 | 1 session | $96.50 AGE 60+ | $129 REG
F02 F 9 a.m-4 p.m. | Cris Heffernan
Sept. 17 | STLCC-Corp 208
COMP-722 | 2 sessions | $96.50 AGE 60+ | $129 REG
F01 ◊ W Th 9 a.m.-12:30 p.m. | Cris Heffernan
Oct. 27-28 | Online
Microsoft® Excel®: Power Pivots
Discover one of Excel’s most robust data analysis tools: Power Pivots. Power Pivots
can create reports and models from multiple data sources—both in and out of Excel.
Create and manage relationships, hierarchies, Power Pivot tables and charts. Explore
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
F03 W 9 a.m.-12:30 p.m. | Cris Heffernan
Sept. 29 | STLCC-Corp 208
F04 Th 9 a.m.-12:30 p.m. | Cris Heffernan
Nov. 11 | STLCC-Corp 208
Outlook® and Windows®
Outlook® and Outlook® Calendars
Master one of the most popular business email applications: Microsoft Outlook. Explore
the many features of Outlook Calendar that can assist in creating appointments, organizing
meetings. Save time and increase your workplace productivity. Prerequisite: Windows
Introduction class or equivalent experience.
COMP-742 | 1 session | $24 AGE 60+ | $35 REG
F05 ◊ Th 5:30-8:30 p.m. | Rhonda Cross
Oct. 14 | Online
Microsoft® Windows® 10 for Beginners
Explore Windows® 10 and all of its user-friendly features, including start screen,
live tiles, hot corners, charm bar and OneDrive. Please note: This course is not for
tablets or touch screen devices; you will use a mouse to navigate. Prerequisite: Personal
Computers Introduction class or equivalent experience.
COMP-705 | 1 session | $77.50 AGE 60+ | $99 REG
F01 Sa 9 a.m.-4 p.m. | James Prater
Sept. 18 | MC-BA 208
Word®
Microsoft® Word® For Business: Part I
Produce professional-looking business documents using Microsoft Word. Create documents,
clean up formatting, change styles and fonts, cut and paste content, and import text
with confidence. Prerequisite: Windows® Introduction class or equivalent experience.
Participants are encouraged to bring a flash drive.
COMP-715 | 1 session | $96.50 AGE 60+ | $129 REG
F02 Th 9 a.m-4 p.m. | Cris Heffernan
Aug. 26 | STLCC-Corp 208
F01 ◊ F 9 a.m-4 p.m. | Cris Heffernan
Dec. 3 | Online
Tableau®
Introduction to Tableau®
Tableau is one of the fastest evolving Business Intelligence (BI) and data visualization
tools. Learn its foundations, discover how to navigate its interface, explore how
to import data, and create your first dashboard.
COMP-727 | 4 sessions | $149 AGE 60+ | $199 REG
F02 Tu 6-9 p.m. | Lee Douankeomany
Aug. 31-Sept. 21 | Online
Advanced Tableau®
Learn how to group and sort data from a single or multiple data sources, effectively
use parameters, work with logical and conditional calculations, combine calculated
fields and parameters, manipulate table calculations, and choose the right visualization
for your type of data. Discover how to switch dimensions to measures and vice versa.
Learn how to manipulate data using Boolean fields and context filters.
COMP-765 | 4 sessions | $156 AGE 60+ | $199 REG
F04 Th 6-9 p.m. | Joseph Richey
Sept. 9-30 | Online
Storytelling With Tableau®
Build on skills from Introduction to Tableau, and create dashboards to tell the story
within your data. Learn best practices for formatting and presenting data to tell
data-driven stories.
COMP-727 | 4 sessions | $149 AGE 60+ | $199 REG
F03 Tu 6-9 p.m. | Lee Douankeomany
Oct. 5-26 | Online
NEW! Analytics With Tableau®
Learn to create new data from existing data by leveraging the functionality of calculated
fields, aggregations and parameters. The limitless choice you make will influence
your analysis with Tableau visualizations.
COMP-727 | 4 sessions | $149 AGE 60+ | $199 REG
F04 Tu 6-9 p.m. | Lee Douankeomany
Nov. 9-Dec. 07 | Online
• NOTE: No class Nov. 23.
◊ Registration for online classes marked above closes five business days before class start date. Textbooks will be mailed to registered students.
You May Also Enjoy:
Helpful CE Links:
My CE Account | Registration Options | General Information | Class Locations | Contact Us