Learn Microsoft Office 2016 Applications: Word, Excel and Access

By on January 18, 2017
Learn Microsoft Access 2016

Learn to create professional looking business documents in Microsoft Word. Create spreadsheets and reports with Microsoft Excel. And plan and design a database system using Microsoft Access.

Register by calling 314-984-7777 or online at https://classes.stlcc.edu/CE_Registration/.

More information on the Corporate College is available on the STLCC website.

Introduction to Microsoft Word 2016 for Business

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.
COMP:715 | $129
C01 | F 9:00 a.m.-4:00 p.m. | Cris Heffernan
February 3 | Corporate College 206

Intermediate Microsoft Word 2016 for Business

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, advanced table features, create and manage large documents, and use auto text, macros, and templates. Prerequisite: Microsoft Word Introduction class or equivalent experience.
COMP:716 | $129
C01 | F 9:00 a.m.-4:00 p.m. | Cris Heffernan
February 10 | Corporate College 206

Introduction to Microsoft Excel 2016 for Business

Build on previous knowledge and further your spreadsheet skills by managing multiple workbooks, creating more complex formulas and functions, enhancing the appearance of your reports, using the benefits of Range Names and working with Tables and Structured Referencing. Prerequisite: Microsoft Excel Introduction class or equivalent experience. Recommended to bring a flash drive.
COMP:720 | $129
C01 | F 9:00 a.m.-4:00 p.m. | Cris Heffernan
February 24 | Corporate College 206

Intermediate Microsoft Excel 2016 for Business

Build on previous knowledge and further your spreadsheet skills by managing multiple workbooks, creating more complex formulas and functions, enhancing the appearance of your reports, using the benefits of Range Names and working with Tables and Structured Referencing. Prerequisite: Microsoft Excel Introduction class or equivalent experience. Recommended to bring a flash drive.
COMP:721 | $129
C01 | F 9:00 a.m.-4:00 p.m. | Cris Heffernan
March 3 | Corporate College 206

Advanced Microsoft Excel 2016 for Business

Continue to expand your Excel expertise as you work with advanced functions (including Lookups, Conditionals, financial and Date functions), create Pivot Tables/Charts, use Data Analysis tools and validation, create and edit macros and explore more of Excel’s advanced features. Prerequisite: Windows Introduction class and Introduction to Excel or equivalent experience. Recommended to bring a flash drive.
COMP:722 | $129
C01 | F 9:00 a.m.-4:00 p.m. | Cris Heffernan
March 10 | Corporate College 206

Introduction to 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. Explore field properties, including Input Masks and Data Validation. Prerequisite: Windows Introduction class or equivalent experience. Bring a flash drive.
COMP:725 | $129
C01 | F 9:00 a.m.-4:00 p.m. | Cris Heffernan
March 31 | Corporate College 206

Introduction to Microsoft Access 2016 for Business Part II

Learn to get the most from your data collection by building Select Queries, including BooLean logic and calculations. Create data entry and date retrieval forms; manage form layout, including Conditional Formatting. Summarize your data by building reports using the Report Wizard and incorporate subtotal and grand total calculations. Prerequisite: Microsoft Access 2013 for Business: Introduction, part 1. Bring a flash drive.
COMP:725 | $109
C02 | F 9:00 a.m.-4:00 p.m. | Cris Heffernan
April 7 | Corporate College 206

Intermediate Microsoft Access 2016 for Business

Get the skill you need to enhance your database designs. Learn to query multiple tables for customized forms and reports, create more complex queries, and customize forms. Prerequisite: Windows Introduction class or equivelant experience and Introduction to Access or equivalent experience.
COMP:726 | $129
C01 | F 9:00 a.m.-4:00 p.m. | Cris Heffernan
April 21 | Corporate College 206

About Richard Schumacher

Richard Schumacher is the technology manager for the Workforce Solutions Group of St. Louis Community College. He connects, designs, and applies technology to meet business user needs with eLearning, training, web content, instructional design, IT system, and performance improvement solutions. Richard is a Microsoft Certified Trainer (MCT) and has held Microsoft Certifications since 1993. Learn more about Richard by following him: LinkedIn - Twitter - Google+ - Articles - Email

Leave a Reply

Your email address will not be published. Required fields are marked *