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: Introduction to Windows or equivalent experience.) 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 2007  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G5445 Tues., Oct. 21West CountyDick Koerper
Excel 2010  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G5271 Mon., Aug. 18West CountyMark Ratliff
G5351 Wed., Sept. 3West CountyNancy Haupt
G5393 Thurs., Sept. 25West CountyJodi Andersen
G5407 Tues., Oct. 7West CountyNancy Haupt
G5483 Wed., Oct. 29West CountyJodi Andersen
G5567 Mon., Nov. 17West CountyJodi Andersen
G5641 Thurs., Dec. 11West CountyJodi Andersen
Two-Evening Class Meets 6:30-9:30pm (6 hours)
Code Date Location Instructor
T5158 Tues., Oct. 14 & 21West CountyDick Koerper
Excel 2013  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G5262 Thurs., Aug. 28West CountyMark Ratliff
G5527 Fri., Nov. 14West 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 2007  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G5446 Tues., Oct. 28West CountyDick Koerper
Excel 2010  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G5272 Mon., Aug. 25West CountyJodi Andersen
G5352 Tues., Sept. 9West CountyNancy Haupt
G5394 Tues., Sept. 30West CountyJodi Andersen
G5408 Wed., Oct. 8West CountyNancy Haupt
G5484 Wed., Nov. 5West CountyJodi Andersen
G5568 Mon., Nov. 24West CountyJodi Andersen
G5642 Fri., Dec. 12West CountyJodi Andersen
Two-Evening Class Meets 6:30-9:30pm (6 hours)
Code Date Location Instructor
T5159 Tues., Nov. 4 & 11West CountyDick Koerper
Excel 2013 
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G5263 Thurs., Sept. 4West CountyMark Ratliff
G5528 Fri., Nov. 21West CountyMark Ratliff

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 2007  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G5447 Mon., Nov. 3West CountyDick Koerper
Excel 2010  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G5273 Tues., Sept. 2West CountyJodi Andersen
G5353 Wed., Sept. 17West CountyJodi Andersen
G5409 Tues., Oct. 14West CountyNancy Haupt
G5485 Thurs., Nov. 13West CountyJodi Andersen
G5569 Mon., Dec. 1West CountyJodi Andersen
G5643 Thurs., Dec. 18West CountyJodi Andersen
Excel 2013 
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G5274 Thurs., Sept. 11West CountyMark Ratliff
G5529 Tues., Nov. 25West 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.