Learn Microsoft Excel 2016, Classes Start September

By on August 22, 2017
Microsoft Excel 2016 Training

Create effective spreadsheets, reports and charts with Microsoft Excel. Build basic formulas and functions, add formatting, create complex formulas, make data tables, and use functions and pivot tables.

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 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. Bring a flash drive to class.
COMP:720 | $129
C01 | F 9 a.m.-4 p.m. | Cris Heffernan
Sept. 8 | Corporate College 208

Micrsoft 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. Bring a flash drive to class.
COMP:721 | $129
C01 | F 9 a.m.-4 p.m. | Cris Heffernan
Sept. 22 | 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. Bring a flash drive to class.
COMP:722 | $129
C01 | F 9 a.m.-4 p.m. | Cris Heffernan
Sept. 29 | Corporate 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. Prerequisite: Windows Introduction class or equivalent experience.
COMP:720 | $149
650 | Th 6:30 p.m.-9:40 p.m. | Roy Lenox
Sept. 7-Oct. 5 | Meramec Campus CN 221

Microsoft Excel 2016: Intermediate

This course is a continuation of our Introduction to Excel class. 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
650 | Th 6:30 p.m.-9:40 p.m. | Roy Lenox
Oct. 12-Nov. 9 | Meramec Campus CN 221

Microsoft Excel 2016: In a Day

Learn the basics of Microsoft 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. Prerequisite: Windows Introduction class or equivalent experience.
COMP:720 | $99
C02 | Sa 9 a.m.-4 p.m. | Cris Heffernan
Sept. 16 | Corporate College 208
580 | Sa 9 a.m.-4 p.m. | Cris Heffernan
Sept. 23 | Florissant Valley Campus B 120
681 | Sa 9 a.m.-4 p.m. | Roy Lenox
Nov. 18 | Meramec Campus BA 203

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 *