School of Professional and Continuing Studies

About | Classes

Excel is arguably one of the world’s most widely used software applications. Its ability to create simple spreadsheets, combined with powerful automation, graphing, and data manipulation features, make Excel an essential business tool that can be used at a variety of skill levels.  

This certificate is designed for anyone using Excel to input and manage data—from daily budgets and expense accounts to long-range planning documents—and who wants to find new ways to be more efficient and productive. Whether you are an administrative assistant looking for quicker and more consistent ways to log in expenses, a data analyst wanting more sophisticated formulas to analyze your organization's budget, or a CFO needing ways to project for future expenditures, you can benefit from this certificate program. Learn the Excel features that automate your work, prevent errors, make data entry easier, and visually present your spreadsheet for the greatest understanding and impact. If you are an Excel beginner, you will learn the right way to set up your spreadsheets and manage your data. If you are a more advanced user, you will discover the powerful design, analysis, and automation features that will increase your effectiveness.

Our certificate courses cover a wide range of topics and dozens of Excel techniques, from basic spreadsheet design concepts to advanced training in formulas and macros. The certificate's four areas—core classes, data analysis, visualizing data, and electives—cover the basic Excel features. The choice of courses in each category lets you take those that apply to your experience level and job category. Together, these courses will allow you to use Excel to its full potential and make you more effective in setting up, formatting, and analyzing your data.

You can learn the valuable skills that will help you:

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. You are required to complete any prerequisites listed for certificate classes. The prerequisite classes will not count toward the required 36 hours.

Course Requirements

You can earn this certificate in one of these two ways:

  1. Complete a minimum of 36 hours in the classes specified below – 12 hours from the Core Classes, 6 from Data Analysis, 6 from Visualizing Data, and 12 from Electives.
  2. Complete the Chancellor’s Certificate in Business Applications and then take just 18 additional hours from any of the four categories shown below.

Special note: You can earn the Chancellor’s Certificate in Business Applications by taking just 54 hours more (24 from Database, 18 from Office Productivity, 12 from any category) after you have earned the Chancellor’s Certificate in Excel. See the Business Applications certificate information for a course listing.

Classes

Core Classes

(minimum 12 hours required)

Data Analysis

(minimum 6 hours required)

Visualizing Data

(minimum 6 hours required)

Electives

(minimum 12 hours required)

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