Learn Microsoft Office 2016: Word, Excel and Access

By on May 2, 2017
Learn Microsoft Office 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.

Microsoft Word 2016 for Business: Part I

Learn to create professional looking business documents using this powerful word processing software including implementing tables and graphics. 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. It is recommended to bring a flash drive to class.
COMP:715 | $129
C01 | F 9 a.m.-4 p.m. | Cris Heffernan
May 19 | Corporate College 208

Microsoft Excel 2016: In a Day

Learn the basics of Microsoft Excel in one day! You’ll 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. It is recommended to bring a flash drive to class.
COMP:720 | $99
C01 | Sa 9 a.m.-4 p.m. | Cris Heffernan
June 24 | Corporate College 208

Microsoft Excel 2016 for Business: Part I

You will 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. It is recommended to bring a flash drive to class.
COMP:720 | $129
C02 | F 9 a.m.-4 p.m. | Cris Heffernan
June 9 | Corporate College 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 Introduction class or equivalent experience. It is recommended to bring a flash drive to class.
COMP:721 | $129
C01 | F 9 a.m.-4 p.m. | Cris Heffernan
June 16 | Corporate College 208

Microsoft Excel 2016 for Business: Part 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. It is recommended to bring a flash drive to class.
COMP:722 | $129
C01 | F 9 a.m.-4 p.m. | Cris Heffernan
July 21 | Corporate College 208

Microsoft Access 2016: In a Day

Learn the basics of Access in one day! In this class you’ll learn how to plan and design a database system, add, change, and delete information as well as how to create simple reports and how to query the database to find display data. Prerequisite: Windows Introduction class or equivalent experience. It is recommended to bring a flash drive to class.
COMP:725 | $129
C80 | Sa 9 a.m.-4 p.m. | Cris Heffernan
July 22 | Corporate College 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. It is recommended to bring a flash drive to class.
COMP:725 | $129
C01 | F 9 a.m.-4 p.m. | Cris Heffernan
July 7 | Corporate College 208

Microsoft Access 2016 for Business: Part 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 Introduction to Access or equivalent experience. It is recommended to bring a flash drive to class.
COMP:726 | $129
C01 | F 9 a.m.-4 p.m. | Cris Heffernan
July 14 | Corporate College 208

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 *