Microsoft Tools
Professional Development
Offered through Continuing Education
@ Online
Develop your computer skills in Microsoft Word, Excel, PowerPoint and Access. Quickly learn the basics with our In-A-Day classes.
Quick Navigation
Please call 314-984-7777 to register for classes by phone, or click the button above to register and pay online.
Class schedules provided below may change.
It happens every so often: classes are rescheduled, moved to a different classroom,
etc. Want to see the most up-to-date information? Simply follow the orange button
above to view current class details.
Unless otherwise specified in the course description, registration for online classes
closes three business days prior to the class start date.
Word®
Microsoft® Word® 2016 for Business: In a Day
Learn to create professional-looking business documents using this powerful word processing
software. Discover how editing and formatting tools are at your fingertips as you
work with the toolbar ribbon. Leave with the skills to create a document, format,
change styles and fonts, cut/paste, import text and edit a document with confidence.
Prerequisite: Windows® Introduction class or equivalent experience. Class textbook
and files will be mailed to each registered student. Registration closes five days
prior to class start date.
COMP-715 | 1 session | $93 AGE 60+ | $129 REG
F01 F 9 a.m.-4 p.m. | Cris Heffernan
Sept. 4 | Online
F02 W 9 a.m.-4 p.m. | Cris Heffernan
Sept. 23 | Online
F03 Sa 9 a.m.-4 p.m. | Cris Heffernan
Nov. 7 | Online
Access®
Microsoft® Access® 2016 for Business: In a Day
Learn the basics of Access® in one day! Learn 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 each registered student. Registration closes
five days prior to class start date.
COMP-725 | 1 session | $93 AGE 60+ | $129 REG
F02 Sa 9 a.m.-4 p.m. | Cris Heffernan
Oct. 10 | Online
Microsoft® Access® 2016 for Business: Part I
Explore the foundations to plan and design a database system. Learn to create, manage
and maintain tables and table relationships. Discover sorting and filtering records
within tables. Prerequisite: Windows® Introduction class or equivalent experience.
Class textbook and files will be mailed to each registered student. Registration closes
five days prior to class start date.
COMP-725 | 1 session | $93 AGE 60+ | $129 REG
F01 F 9 a.m.-4 p.m. | Cris Heffernan
Nov. 20 | Online
Microsoft® Access® 2016 for Business: Part II
Gain the skills necessary to enhance your database designs. Work with data normalization,
table relationships and join techniques, including inner and outer joins. Learn to
query multiple tables for customized reports. Create more complex queries using parameters
and action queries. Learn to use more advanced reporting techniques. Prerequisite:
Windows® Introduction class or equivalent experience and Microsoft Access 2016 for
Business Part I or equivalent experience. Class textbook and files will be mailed
to each registered student. Registration closes five days prior to class start date.
COMP-726 | 1 session | $93 AGE 60+ | $129 REG
F01 F 9 a.m.-4 p.m. | Cris Heffernan
Dec. 4 | Online
Microsoft® Access® 2016 for Business: Part III
Take your Access databases to the next level by implementing tools such as macros,
VBA coding and switchboards to give your user base a fluid Access experience. Discover
features to secure your database through options such as front- and back-end splitting,
link tables and import/export data. Create forms to intuitively navigate and organize
your data. Prerequisite: Access for Business: Parts I and II or equivalent experience.
Class textbook and files will be mailed to each registered student. Registration closes
five days prior to class start date.
COMP-727 | 1 session | $93 AGE 60+ | $129 REG
F01 F 9 a.m.-4 p.m. | Cris Heffernan
Dec. 18 | Online
Excel®
Microsoft® Excel® 2016 for Business: In a Day
Learn the basics of MS Excel in one day! In this introductory course, learn how to
create spreadsheets for all kinds of applications including accounting, expense analysis,
budgeting, and more. Topics include setting up worksheets, labeling, entering values,
editing cells, copying, saving, and other commands. Recommended to bring a flash drive.
Prerequisite: Windows® Introduction class or equivalent experience. Class textbook
and files will be mailed to each registered student. Registration closes five days
prior to class start date.
COMP-720 | 1 session | $93 AGE 60+ | $129 REG
F03 Sa 9 a.m.-4 p.m. | Cris Heffernan
Aug. 29 | Online
Microsoft® Excel® 2016 for Business: Part I
Learn tips and tricks to efficiently 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. Learn to make your sheets and
printouts easier to read with special formatting techniques. An important class for
beginners and for self-taught Excel users. Prerequisite: Windows® Introduction class.
Recommended to bring a flash drive. Class textbook and files will be mailed to each
registered student. Registration closes five days prior to class start date.
COMP-720 | 2 sessions | $93 AGE 60+ | $129 REG
F01 MTu 12:30-4 p.m. | Cris Heffernan
Sept. 14 – Sept. 15 | Online
COMP-720 | 1 session | $93 AGE 60+ | $129 REG
F02 F 9 a.m.-4 p.m. | Cris Heffernan
Oct. 16 | Online
Microsoft® Excel® 2016 for Business: Part II
Build on previous knowledge and further your spreadsheet skills by creating more complex
formulas with a variety of functions. Learn techniques of data management and analyzing
your data with 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. Recommended to bring
a flash drive. Class textbook and files will be mailed to each registered student.
Registration closes five days prior to class start date.
COMP-721 | 1 session | $93 AGE 60+ | $129 REG
F01 M 9 a.m.-4 p.m. | Cris Heffernan
Sept. 21 | Online
F02 F 9 a.m.-4 p.m. | Cris Heffernan
Oct. 23 | Online
Microsoft® Excel® 2016 for Business: Part III
Continue to expand your Excel® expertise as you manage multiple workbooks and worksheets
and build 3D calculations and file linking. Explore the power of the all-important
lookup functions and related concepts. Become adept at using formula auditing tools,
data validation, and sharing and protecting workbooks. Also, explore the use of major
data analysis tools such as scenarios and data tables. Create and edit macros to save
you time and create consistency across workbooks. Prerequisite: Microsoft Excel 2016
for Business: Part II or equivalent experience. Recommended to bring a flash drive.
Class textbook and files will be mailed to each registered student. Registration closes
five days prior to class start date.
COMP-722 | 1 session | $93 AGE 60+ | $129 REG
F01 F 9 a.m.-4 p.m. | Cris Heffernan
Oct. 30 | Online
Microsoft® Excel® 2016 for Business: Power Pivots
This class will set you on the course to take advantage of one of the most robust
Data Analysis tools that Excel® includes. Power Pivots® enable you to 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 your own 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. Class textbook
and files will be mailed to each registered student. Registration closes five days
prior to class start date.
COMP-722 | 1 session | $44.50 AGE 60+ | $59 REG
F04 M 9 a.m.-noon | Cris Heffernan
Oct. 12 | Online
F03 F 9 a.m.-noon | Cris Heffernan
Nov. 6 | Online
Microsoft®, Access®, Excel®, PowerPoint®, Windows® and Word® are trademarks of Microsoft Corporation. STLCC Continuing Education courses are independent seminars and are neither affiliated with, nor 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