Facebook pixel Computers & Technology | Microsoft® Tools

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.

Program Contact

Continuing Education

Phone

314-984-7777

Register online now

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.


Helpful CE Links:

My CE Account | Registration Options | General Information | Class Locations | Contact Us

Back to top