Learn Microsoft Excel 2016, Classes Start Jan. 31

By on January 9, 2018
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 http://www.stlcc.edu/Continuing-Education/classes/index.asp?Cat=XCMP.

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

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. Please bring a flash drive to class.
COMP:720 | $149
005 | W 6:00-9:00 p.m. | Cris Heffernan
January 31-February 21 | Corporate College 208

Microsoft Excel 2016 for Business: 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. Please bring a flash drive to class.
COMP:720 | $129
004 | F 9:00 a.m.-4:00 p.m. | Cris Heffernan
February 16 | Corporate 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. Please bring a flash drive to class.
COMP:721 | $129
002 | F 9:00 a.m.-4:00 p.m. | Cris Heffernan
March 2 | Corporate 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. Please bring a flash drive to class.
COMP:722 | $129
001 | F 9:00 a.m.-4:00 p.m. | Cris Heffernan
March 9 | Corporate College 208

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. Please bring a flash drive to class.
COMP:721 | $149
001 | W 6:00-9:00 p.m. | Cris Heffernan
March 21-April 11 | 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

You must be logged in to post a comment Login