UMSL logo

Computer Education & Training Center

Excel

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, Formulas and Functions, PivotTables, Data Manipulation, and VBA. [More on Excel Classes]

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.
Fee: $199

Excel 2013  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E9304 Thurs., Nov. 29West CountyTina Wolk Hefner
E9417 Fri., Jan. 4West CountyTina Wolk Hefner
E9493 Thurs., Feb. 14West CountyTina Wolk Hefner
Excel 2016 
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E9264 Wed., Nov. 14West CountyTina Wolk Hefner
E9381 Tues., Dec. 4West CountyNancy Haupt
E9439 Wed., Jan. 16West CountyNancy Haupt
E9487 Mon., Feb. 4West CountyNancy Haupt
E9511 Fri., Mar. 1West CountyTina Wolk Hefner
E9527 Thurs., Mar. 21West CountyTina Wolk Hefner

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.
Fee: $199

Excel 2013  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E9225 Tues., Nov. 13West CountyMark Ratliff
E9305 Thurs., Dec. 6West CountyTina Wolk Hefner
E9418 Fri., Jan. 11West CountyTina Wolk Hefner
E9494 Thurs., Feb. 21West CountyTina Wolk Hefner
Excel 2016 
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E9265 Wed., Nov. 28West CountyNancy Haupt
E9382 Tues., Dec. 11West CountyNancy Haupt
E9440 Wed., Jan. 23West CountyNancy Haupt
E9488 Tues., Feb. 12West CountyNancy Haupt
E9512 Fri., Mar. 8West CountyNancy Haupt
E9528 Thurs., Mar. 28West CountyTina Wolk Hefner

Advanced Applications of Excel

(Prerequisite: Intermediate Applications of Excel or equivalent experience.) Learn advanced functions and database management techniques, including sorting and filtering data, 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.
Fee: $199

Excel 2013  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E9306 Thurs., Dec. 13West CountyTina Wolk Hefner
E9419 Thurs., Jan. 17West CountyTina Wolk Hefner
Excel 2016 
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E9383 Tues., Dec. 18West CountyNancy Haupt
E9441 Wed., Jan. 30West CountyNancy Haupt
E9489 Tues., Feb. 19West CountyTina Wolk Hefner
E9513 Wed., Mar. 13West CountyNancy Haupt
E9529 Thurs., Apr. 4West CountyTina Wolk Hefner

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.