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 2010  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G7138 Thurs., July 21West CountyJodi Andersen
G7206 Mon., Aug. 8West CountyJodi Andersen
G7265 Tues., Aug. 30West CountyJodi Andersen
G7343 Fri., Sept. 30West CountyJodi Andersen
G7377 Wed., Oct. 19West CountyJodi Andersen
G7459 Mon., Nov. 7West CountyJodi Andersen
G7493 Fri., Dec. 2West CountyJodi Andersen
Two-Evening Class Meets 6:00-9:15pm (6.5 hours)
Code Date Location Instructor
T7205 Tues., Nov. 8 & 15West CountyDick Koerper
Excel 2013  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G7257 Wed., Aug. 17West CountyMark Ratliff
G7326 Mon., Sept. 26West CountyMark Ratliff
G7418 Fri., Nov. 4West CountyMark Ratliff
G7506 Tues., Dec. 6West CountyNancy Haupt

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 2010  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G7139 Tues., July 26West CountyJodi Andersen
G7207 Mon., Aug. 15West CountyJodi Andersen
G7266 Wed., Sept. 7West CountyJodi Andersen
G7344 Thurs., Oct. 6West CountyJodi Andersen
G7378 Wed., Oct. 26West CountyJodi Andersen
G7460 Tues., Nov. 15West CountyJodi Andersen
G7494 Thurs., Dec. 8West CountyJodi Andersen
Two-Evening Class Meets 6:00-9:15pm (6.5 hours)
Code Date Location Instructor
T7206 Tues., Nov. 29 & Dec. 6West CountyDick Koerper
Excel 2013  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G7258 Tues., Aug. 23West CountyMark Ratliff
G7327 Tues., Sept. 27West CountyMark Ratliff
G7419 Thurs., Nov. 10West CountyMark Ratliff
G7507 Wed., Dec. 14West CountyJodi Andersen

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 2010  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G7140 Wed., Aug. 3West CountyJodi Andersen
G7208 Mon., Aug. 22West CountyJodi Andersen
G7267 Tues., Sept. 13West CountyJodi Andersen
G7345 Thurs., Oct. 13West CountyJodi Andersen
G7379 Wed., Nov. 2West CountyJodi Andersen
G7461 Tues., Nov. 22West CountyJodi Andersen
G7495 Fri., Dec. 16West CountyJodi Andersen
Excel 2013  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G7259 Tues., Aug. 30West CountyMark Ratliff
G7328 Wed., Sept. 28West CountyJodi Andersen
G7420 Fri., Nov. 18West CountyMark Ratliff
G7508 Wed., Dec. 21West CountyJodi Andersen

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.