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:

  • Save time by learning to properly set up and format spreadsheets, using effective design techniques. Beginning with a well-designed spreadsheet means easier data entry and fewer entry errors.
  • Add visual impact to your data through charts and PivotTables. Take a spreadsheet full of numbers and convert it to easy-to-understand graphs and summary tables to share with others through reports or presentations. 
  • Learn such formulas and built-in functions as maximum, minimum, average, and count to quickly calculate your data and perform statistical analysis.
  • Get an overview of your company's finances by combining multiple lists or tables from different departments into one consolidated table. Have Excel calculate the tables, creating a summary table. 
  • Increase your efficiency by creating macros. Macros can automate data entry and cell formatting to make your spreadsheets consistent across your organization.

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)

  • Introduction to Excel
  • Intermediate Applications of Excel
  • Advanced Applications of Excel

Data Analysis

(minimum 6 hours required)

  • Special Topics in Excel: Data Manipulation
  • Special Topics in Excel: Formulas and Functions

Visualizing Data

(minimum 6 hours required)

  • Creating Charts with Excel
  • Accelerated Topics in Excel: Introduction to PivotTables (3 hours)
  • Accelerated Topics in Excel: Intermediate PivotTables (3 hours)

Electives

(minimum 12 hours required)

  • Excel Macros (12 hours)
  • Or 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.