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
E8372 Mon., Dec. 4West CountyMark Ratliff
E8406 Fri., Jan. 5West CountyNancy Haupt
E8453 Tues., Jan. 23West CountyNancy Haupt
E8547 Wed., Feb. 28West CountyMark Ratliff
E8605 Wed., Apr. 25West CountyNancy Haupt
Excel 2016 
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E8492 Tues., Feb. 6West CountyMark Ratliff
Excel 365 
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E8557 Mon., Mar. 19West CountyMark Ratliff

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
E8373 Mon., Dec. 11West CountyMark Ratliff
E8407 Thurs., Jan. 11West CountyNancy Haupt
E8454 Wed., Jan. 31West CountyNancy Haupt
E8548 Thurs., Mar. 8West CountyMark Ratliff
E8606 Wed., May 2West CountyNancy Haupt
Excel 2016 
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E8493 Tues., Feb. 13West CountyMark Ratliff
Excel 365 
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E8558 Tues., Mar. 27West CountyMark Ratliff

Advanced Applications of Excel


Fee: $199

Excel 2013  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E8374 Mon., Dec. 18West CountyMark Ratliff
E8405 Thurs., Jan. 18West CountyNancy Haupt
E8549 Wed., Mar. 14West CountyMark Ratliff
Excel 2016 
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E8494 Wed., Feb. 21West CountyMark Ratliff
Excel 365 
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E8559 Tues., Apr. 3West CountyMark Ratliff

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.