Learn Microsoft Excel 2016, Classes Start September

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

Related Posts

• 

  Learn Facebook, Twitter, Instagram, and Social Media
  Learn Facebook, Twitter, Instagram, and Social Media
• 

  Apply Now: No-Cost Environmental Job Training Program Starts January 2018
  Apply Now: No-Cost Environmental Job Training Program Starts January 2018
• 

  Apply Now for CDL-A Commercial Truck Driver Training, Starts October 23
  Apply Now for CDL-A Commercial Truck Driver Training, Starts October 23
• 

  Workforce Development News – Sept. 18, 2017
  Workforce Development News – Sept. 18, 2017