UMSL logo

Computer Education & Training Center


Excel Classes

Take your skills to the next level with comprehensive Excel training. In addition to introductory through advanced level courses, classes are available in Excel Charts, Data Analysis, Formulas and Functions, PivotTables, Data Manipulation, and VBA. [More on Excel Classes]

Virtual Classes: All our Excel classes are now available online with an instructor present for the entire course. You will see the instructor's screen throughout the class and you can share your screen if you need individual help from the instructor. You will have time to practice, ask questions, and receive hands-on training. If you don't have Excel available on your machine, you can remote into one of our computers.

In-person classes are also available at our West County facility with limited enrollments to promote social distancing. When you register, choose your class section based on how you want to attend the class: virtual or in-person.

  • Select Live Online" if you want to attend virtually from your workplace or home.
  • Choose "West County In-Person" if you want to attend a class at our West County location.

Introduction to Excel

(Prerequisite: Experience with Windows.) Use Excel to create spreadsheets for accounting, budgeting, expense tracking, and other applications. Learn to set up and format worksheets and enter labels, values, and formulas. Discover how to select data, restrict data entry, adjust column widths, and move around the worksheet. Other topics include using simple statistical functions, editing and deleting data, moving and copying cell contents, understanding absolute and relative references, setting up worksheet pages, and printing. [Course Outline]
Fee: $199

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E3223 Tues., Sept. 13Virtual/WCDawn Robinson
E3258 Wed., Sept. 28Virtual/WCDawn Robinson
E3347 Fri., Oct. 14Virtual/WCDawn Robinson
E3380 Thurs., Nov. 10Virtual/WCDawn Robinson
E3411 Wed., Nov. 30Virtual/WCDawn Robinson
E3514 Tues., Jan. 10Virtual/WCDawn Robinson
E3526 Thurs., Jan. 26Virtual/WCDawn Robinson
E3557 Wed., Feb. 8Virtual/WCDawn Robinson
E3593 Fri., Feb. 24Virtual/WCDawn Robinson

Intermediate Applications of Excel

(Prerequisite: Introduction to Excel or equivalent experience. You should know how to create formulas using the formula bar and understand absolute and relative references.) Learn to design effective spreadsheets that others can use and interpret easily. Practice applying effective design techniques, including naming cells, protecting cells, and making your spreadsheets easy to read. Additional topics include working with multiple worksheets, creating templates, rounding data, using conditional functions, and applying conditional formatting.  [Course Outline]
Fee: $199

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E3224 Tues., Sept. 20Virtual/WCDawn Robinson
E3259 Wed., Oct. 5Virtual/WCDawn Robinson
E3348 Thurs., Oct. 27Virtual/WCDawn Robinson
E3381 Thurs., Nov. 17Virtual/WCDawn Robinson
E3412 Wed., Dec. 7Virtual/WCDawn Robinson
E3515 Tues., Jan. 17Virtual/WCDawn Robinson
E3527 Fri., Jan. 27Virtual/WCDawn Robinson
E3558 Thurs., Feb. 16Virtual/WCDawn Robinson
E3594 Fri., Mar. 3Virtual/WCDawn Robinson

Advanced Applications of Excel

(Prerequisite: Intermediate Applications of Excel or equivalent experience.) Learn advanced functions and database management techniques, including sorting, filtering data, and using database statistical functions. Get the most out of your Excel applications by linking data between worksheets and workbooks. Other topics include using lookup tables and performing what-if analysis using Goal Seek and scenarios. [Course Outline]
Fee: $199

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E3119 Wed., Sept. 7Virtual/WCDawn Robinson
E3225 Tues., Sept. 27Virtual/WCDawn Robinson
E3260 Wed., Oct. 12Virtual/WCDawn Robinson
E3349 Fri., Nov. 4Virtual/WCDawn Robinson
E3413 Wed., Dec. 14Virtual/WCDawn Robinson
E3516 Tues., Jan. 24Virtual/WCDawn Robinson
E3559 Wed., Feb. 22Virtual/WCDawn Robinson
E3595 Fri., Mar. 10Virtual/WCDawn Robinson

If you would like to register for a course, call (314) 984-9000 or register online.

Classes are available in Excel VBA that teach you how to use macros and customize your spreadsheets. Other Excel classes offered include Excel Charts, PivotTables, Formulas and Functions, and Excel Data Manipulation.

For more information, please email