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: $189

Excel 2007  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
H4134 Wed., Mar. 12West CountyDick Koerper
H4171 Mon., May 5West CountyDick Koerper
Excel 2010  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
H4137 Tues., Mar. 4West CountyJodi Andersen
H4161 Thurs., Mar. 27West CountyNancy Haupt
H4260 Fri., Apr. 11West CountyMark Ratliff
H4281 Wed., Apr. 23West CountyJodi Andersen
H4388 Wed., May 14West CountyNancy Haupt
H4395 Thurs., June 5West CountyJodi Andersen
R4571 Tues., June 24West CountyNancy Haupt
Two-Evening Class Meets 6:00-9:00pm (6 hours)
Code Date Location Instructor
T4555 Thurs., June 5 & 12West CountyDick Koerper
Excel 2013  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
H4151 Thurs., May 29West 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: $189

Excel 2007  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
H4135 Wed., Mar. 19West CountyDick Koerper
H4172 Tues., May 6West CountyDick Koerper
Excel 2010  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
H4138 Mon., Mar. 10West CountyJodi Andersen
H4162 Wed., Apr. 2West CountyNancy Haupt
H4382 Thurs., May 1West CountyMark Ratliff
H4389 Tues., May 20West CountyNancy Haupt
H4396 Wed., June 11West CountyJodi Andersen
R4572 Mon., June 30West CountyNancy Haupt
Two-Evening Class Meets 6:00-9:00pm (6 hours)
Code Date Location Instructor
T4352 Tues., Mar. 4 & 11West CountyDick Koerper
T4556 Thurs., June 19 & 26West CountyDick Koerper
Excel 2013 
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
H4152 Fri., June 6West 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: $189

Excel 2007  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
H4136 Wed., Mar. 26West CountyDick Koerper
H4173 Mon., May 12West CountyDick Koerper
Excel 2010  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
H4139 Mon., Mar. 17West CountyJodi Andersen
H4163 Wed., Apr. 9West CountyNancy Haupt
H4384 Fri., May 9West CountyJodi Andersen
H4391 Tues., May 27West CountyNancy Haupt
H4397 Thurs., June 19West CountyJodi Andersen
R5573 Tues., July 1West CountyNancy Haupt
Excel 2013 
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
H4153 Fri., June 13West 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.