Learn Microsoft Excel 2016, Classes Start Jan. 31

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

Related Posts

• 

  Yes, I Do Want to Come to Work…
  Yes, I Do Want to Come to Work…
• 

  Women In Aerospace Manufacturing Program with Boeing: A Modern “Rosie the Riveter” Opportunity
  Women In Aerospace Manufacturing Program with Boeing: A Modern “Rosie the Riveter” Opportunity
• 

  Why Do You Come to Work?
  Why Do You Come to Work?
• 

  STLCC and St. Luke’s Partnership Graduates 12 Students Prepared to Make An Impact in Health Care
  STLCC and St. Luke’s Partnership Graduates 12 Students Prepared to Make An Impact in Health Care

You must be logged in to post a comment Login