About | Classes

As software applications continue to become more integrated and compatible, you must be proficient in a variety of these applications to be successful in today's office environment. You may need to use a database file to check inventory, create a spreadsheet to organize and analyze financial data, design slides for a meeting, or communicate your progress to your work group. Through this certificate program, you will develop these computer skills and learn to use spreadsheet, database management, and office productivity software.

You’ll learn to:

  • Design databases that efficiently store, analyze, and retrieve information. Learn the proven techniques to increase the usefulness of your database in looking for summary information and generating reports.
  • Create spreadsheets to input and organize data. Learn how to automate your work, prevent errors, and make data entry easier. Discover the design and analysis features that will increase your efficiency.
  • Work with software that covers a range of productivity functions. Manage complex projects, create diagrams and slides for presentations, pursue advanced word-processing skills, or convert files into Web-ready documents.

Prerequisites

You should be proficient with the Windows environment and be able to find files, create folders, organize and manage files and folders, work with multiple windows, and share data between applications via the Clipboard.

Course Requirements

You can earn this certificate in one of these two ways:
  1. Complete a minimum of 72 hours in the classes specified below—24 hours from Database, 18 hours from Spreadsheet, 18 hours from Office Productivity, and 12 additional hours from Electives.
  2. Complete the Chancellor’s Certificate in Excel and then take an additional 54 hours—24 hours from Database, 18 hours from Office Productivity, and 12 additional hours from Electives.

Special note: You can earn the Chancellor’s Certificate in Excel by taking just 18 hours more after you have earned the Chancellor’s Certificate in Business Applications. See the Excel certificate information for course offerings.

Classes

Database

(minimum 24 hours required):
  • Introduction to Access
  • Intermediate Applications of Access
  • Advanced Applications of Access
  • Advanced Topics in Access: Database Design
  • Advanced Topics in Access: Macros
  • Programming Applications of Access: Level 1
  • Programming Applications of Access: Level 2
  • Programming Applications of Access: Level 3
  • Introduction to FileMaker Pro
  • Intermediate Applications of Filemaker Pro
  • Advanced Applications of FileMaker Pro

Spreadsheet

(minimum 18 hours required):

  • Introduction to Excel
  • Intermediate Applications of Excel
  • Advanced Applications of Excel
  • Creating Charts with Excel
  • Special Topics in Excel: Data Manipulation
  • Special Topics in Excel: Formulas and Functions
  • Accelerated Topics in Excel: Introduction to PivotTables (3 hours)
  • Accelerated Topics in Excel: Intermediate PivotTables (3 hours)

Office Productivity

(minimum 18 hours required):

  • Introduction to Project
  • Intermediate Applications of Project
  • Introduction to Outlook
  • Intermediate Applications of Outlook
  • Introduction to Word
  • Intermediate Applications of Word
  • Advanced Applications of Word
  • Introduction to PowerPoint
  • Intermediate Applications of PowerPoint
  • Advanced Applications of PowerPoint
  • Introduction to Visio
  • Intermediate Applications of Visio
  • Introduction to QuickBooks
  • Intermediate Applications of QuickBooks
  • Accelerated Topics in Acrobat: Converting Office Files (3 hours)
  • Transitioning to Office 2007 (3 hours)

Electives

(minimum 12 hours required.)

Complete 12 additional hours from the classes listed within this certificate.

For specific course schedules, please visit the CETC Catalog.  For more information, visit our Web site at http://www.cetc.umsl.edu.