Microsoft Tools
Professional Development
Offered through Continuing Education
@ Meramec | Wildwood | South County Education Center | Corporate College
Develop your computer skills in Microsoft Word, Excel, PowerPoint and Access. Quickly learn the basics with our In-A-Day classes.
Due to server maintenance, online registration will be down starting at 4 p.m. on Friday, Feb. 14. Online registration will become available again the morning of Tuesday, Feb. 18. Thank you for your patience.
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-date information? Simply follow the orange button above to view current class details.
Microsoft® Windows® 10 Introduction: In a Day
Explore Windows 10 and all its user-friendly features in this course. Topics include
using start screen, live tiles, hot corners, charm bar, OneDrive® and many others.
This course is not for tablets or touch screen; students will use a mouse to navigate.
Prerequisite: Personal Computers Introduction class or equivalent experience.
COMP:705 | 1 session | $67 AGE 60+ | $99 REG
P01 Sa 9 a.m.-4 p.m. | James Prater
April 18 | STLCC-Corp, 208
Quick Navigation
PowerPoint
NEW! Pizzazz With Microsoft® PowerPoint®
Are you looking for new ways to present dynamic PowerPoint presentations? Look no
more! In this course, you will master the features of PowerPoint to create engaging
and impactful presentations.
COMP:765 | 2 sessions | $49 AGE 60+ | $59 REG
P08 Tu 6:30-8:30 p.m. | Patrick McGuirk
March 3-March 10 | MC-BA, 212
P09 Tu 6:30-8:30 p.m. | Patrick McGuirk
March 24-31 | WW, 207
Word
Microsoft® Word® 2016 for Business: Part I
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. Recommended to
bring a flash drive.
COMP:715 | 1 session | $79.50 AGE 60+ | $129 REG
P01 F 9 a.m.-4 p.m. | Cris Heffernan
Jan. 24 | STLCC-Corp, 208
Microsoft® Word® 2016 for Business: Part II
If you are familiar with the basics, here’s your opportunity to learn the more advanced
features of Word. Learn to customize the Word environment, use advanced formatting
techniques, work with styles and advanced table features, create and manage large
documents, and use auto text, macros and templates. Prerequisite: Microsoft Word Introduction
class or equivalent experience. Recommended to bring a flash drive.
COMP:715 | 1 session | $79.50 AGE 60+ | $129 REG
P02 F 9 a.m.-4 p.m. | Cris Heffernan
Jan. 31 | STLCC-Corp, 208
Excel
Microsoft® Excel® 2016: In a Day
Learn the basics of Microsoft 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. Prerequisite: Windows®
Introduction class or equivalent experience. Recommended to bring a flash drive.
COMP:720 | 1 session | $67 AGE 60+ | $99 REG
P02 Sa 9 a.m.-4 p.m. | Cris Heffernan
March 7 | STLCC-Corp, 208
Microsoft® Excel® 2016: Introduction
Create spreadsheets using Microsoft Excel. Learn terminology, navigation tips and
the basic characteristics of a worksheet and workbook. Enter text values and formulas,
move and copy data, format worksheet appearance and work with charts. Prerequisite:
Windows® Introduction class or equivalent experience. Recommended to bring a flash
drive.
COMP:720 | 4 sessions | $99 AGE 60+ | $149 REG
P03 M 6-9 p.m. | Michael Borawski
Jan. 13-Feb. 10 | STLCC-South County, 207
• NOTE: No class 1/20.
Microsoft® Excel® 2016: Intermediate
Continue to build on your spreadsheet building skills and formula creation. Learn
Excel terminology, how to navigate the Excel window and the intermediate characteristics
of a worksheet and workbook. Enter text values and formulas, move and copy data, format
worksheet appearance and work with charts. Prerequisite: Microsoft Excel Introduction
or equivalent experience. Recommended to bring a flash drive.
COMP:721 | 4 sessions | $99 AGE 60+ | $149 REG
P02 M 6-9 p.m. | Michael Borawski
Feb. 24-March 23 | STLCC-South County, 207
• NOTE: No class 3/16.
Would you like to leverage Excel® for accounting or data analytics? Be sure to check out our “Accounting” section.
Microsoft® Excel® 2016 for Business: Part I
Learn tips and tricks to navigate efficiently 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
the beginner as well as for the self-taught Excel user. Prerequisite: Windows® Introduction
class. Recommended to bring a flash drive.
COMP:720 | 1 session | $79.50 AGE 60+ | $129 REG
P01 F 9 a.m.-4 p.m. | Cris Heffernan
Feb. 7 | STLCC-Corp, 208
Microsoft® Excel® 2016 for Business: Part II
Build on previous knowledge and further your spreadsheet skills by creating more complex
formulas using 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.
COMP:721 | 1 session | $79.50 AGE 60+ | $129 REG
P01 F 9 a.m.-4 p.m. | Cris Heffernan
Feb. 21 | STLCC-Corp, 208
Microsoft® Excel® 2016 for Business: Part III
Continue to expand your Excel expertise as you manage multiple workbooks and worksheets,
and build three-dimensional 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.
COMP:722 | 1 session | $79.50 AGE 60+ | $129 REG
P01 F 9 a.m.-4 p.m. | Cris Heffernan
Feb. 28 | STLCC-Corp, 208
Access
Microsoft® Access® 2016: In A Day
Learn the basics of Access in one day! In this class, you will learn 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. Recommended to bring a flash drive.
COMP:725 | 1 session | $79.50 AGE 60+ | $129 REG
P02 Sa 9 a.m.-4 p.m. | Cris Heffernan
May 2 | STLCC-Corp, 208
Microsoft® Access® 2016 for Business: Part I
Learn 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.
Recommended to bring a flash drive.
COMP:725 | 1 session | $79.50 AGE 60+ | $129 REG
P01 F 9 a.m.-4 p.m. | Cris Heffernan
April 10 | STLCC-Corp, 208
Microsoft® Access® 2016 for Business: Part II
Get the skill you need to enhance your database designs. Work with data normalization
as well as 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. Recommended to bring a flash drive.
COMP:726 | 1 session | $79.50 AGE 60+ | $129 REG
P01 F 9 a.m.-4 p.m. | Cris Heffernan
April 17 | STLCC-Corp, 208
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. We will
also use features to secure your database through options such as splitting it to
front and back-end parts, link tables and import/export data. Create forms for navigating
and organizing your data using a variety of features to enhance user involvement.
Prerequisite: Access for Business: Parts I and II or equivalent experience. Recommended
to bring a flash drive.
COMP:727 | 1 session | $79.50 AGE 60+ | $129 REG
P01 F 9 a.m.-4 p.m. | Cris Heffernan
April 24 | STLCC-Corp, 208
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