Microsoft Office

Microsoft Word 2016: In a Day

Learn the basics of MS Word in one day! You'll create and save documents; enter and edit text; learn to indent, set tabs, and enhance documents; make block moves, deletes, and copies; use spell checker; find and replace text; use shortcut keys; and print. Prerequisite: Windows Introduction class or equivalent experience.
COMP:715 | $99 | Age 60+: $68
F04 | Sa 9 am-4 pm | Rachel Bufalo | Sep 29 | MC - BA, 203
F02 | Sa 9 am-4 pm | Rachel Bufalo | Nov 10 | MC - BA, 203

Microsoft Word 2016 for Business 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 | $129 | Age 60+: $79.50
F01 | F 9 am-4 pm | Cris Heffernan | Sep 7 | Corp. College, 208

Microsoft Word 2016 for Business 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, 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:716 | $129 | Age 60+: $79.50
F01 | F 9 am-4 pm | Cris Heffernan | Sep 14 | Corp. College, 208

Microsoft Excel 2016: In a Day

Learn the basics of MS Excel in one day! In this introductory course, you'll learn how to create spreadsheets for all kinds of applications including accounting, expense analysis, budgeting, etc. 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.
COMP:720 | $99 | Age 60+: $68
F04 | Sa 9 am-4 pm | Cris Hefferenan | Sep 8 | MC - BA, 203
F02 | Sa 9 am-4 pm | Cris Heffernan | Oct 20 | Corp. College, 208
F03 | Sa 9 am-4 pm | Cris Heffernan | Nov 17 | Corp. College, 208

Microsoft Excel 2016: Introduction

Create spreadsheets using Microsoft Excel. Learn Excel terminology, to navigate the Excel window, 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. Recommended to bring a flash drive. Prerequisite: Windows Introduction class or equivalent experience.
COMP:720 | $149 | Age 60+: $99
F05 | W 6 pm-9 pm | Mike Borawski | Sep 5-Sep 26 | STLCC-SC, 207

Microsoft Excel 2016: Intermediate

Further your spreadsheet skills by managing multiple sheet workbooks, creating more complex formulas and functions, enhancing the appearance of your document, and by creating custom reports with pivot charts. Prerequisite: Microsoft Excel Introduction class or equivalent experience.
COMP:721 | $149 | Age 60+: $99
F02 | W 6 pm-9 pm | Mike Borawski | Oct 3-Oct 24 | STLCC-SC, 207

Microsoft Excel 2016 for Business I

Learn tips and tricks to navigate efficiently and create effective spreadsheets. 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 | $129 | Age 60+: $79.50
F01 | F 9 am-4 pm | Cris Heffernan | Sep 28 | Corp. College, 208

Microsoft Excel 2016 for Business 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 Introduction class or equivalent experience. Recommended to bring a flash drive.
COMP:721 | $129 | Age 60+: $79.50
F01 | F 9 am-4 pm | Cris Heffernan | Oct 5 | Corp. College, 208

Microsoft Excel 2016 for Business III

Continue to expand your Excel expertise as you manage multiple workbooks and worksheets, and build 3-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: Introduction to Excel or equivalent experience. Recommended to bring a flash drive.
COMP:722 | $129 | Age 60+: $79.50
F01 | F 9 am-4 pm | Cris Heffernan | Oct 12 | Corp. College, 208

Microsoft PowerPoint 2016: In a Day

Learn the basics of MS PowerPoint in one day! This is an introductory course in using PowerPoint to create effective graphic presentations. Learn to use word processing and drawing tools to create and edit text, logos, and artwork. Additional topics include importing clip art, using templates, and rearranging your presentation. Prerequisite: Windows Introduction class or equivalent experience.
COMP:730 | $99 | Age 60+: $67
F01 | Sa 9 am-4 pm | Rachel Bufalo | Sep 15 | MC - BA, 203

NEW! Microsoft PowerPoint Animations

It's not all about looks! PowerPoint's effects and animations can help you control the pace of your presentation and help your audience follow along. Find out how to use builds, transitions, animations, and effects to relay information and add interest, without going overboard. Learn how to transition between slides, set custom timing for animations, control playback of audio and video, and more. Prerequisite: PowerPoint 2016 or equivalent experience. Must know how to create a basic slide-show. Knowledge of the ribbon commands helpful.
COMP:730 | $35 | Age 60+: 22.50
F02 | Sa 9 am-12 pm | Rachel Bufalo | Oct 13 | MC - BA, 203

Microsoft Access 2016 for Business 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. Bring a flash drive.
COMP:725 | $129 | Age 60+: $79.50
F01 | F 9 am-4 pm | Cris Heffernan | Nov 2 | Corp. College, 208

Microsoft Access 2016 for Business II

Get the skill you need 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 Access for Business I or equivalent experience. Recommended to bring a flash drive.
COMP:726 | $129 | Age 60+: $79.50
F01 | F 9 am-4 pm | Cris Heffernan | Nov 9 | Corp. College, 208

Microsoft Access 2016 for Business 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 your user's involvement. Prerequisite: Access for Business Parts I and II, or equivalent experience. Recommended to bring a flash drive.
COMP:727 | $129 | Age 60+: 79.50
F01 | F 9 am-4 pm | Cris Heffernan | Nov 16 | Corp. College, 208