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
H5312 Tues., May 12West CountyDick Koerper
G6208 Tues., Aug. 18West CountyDick Koerper
Excel 2010  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
H5287 Wed., Apr. 22West CountyNancy Haupt
H5351 Wed., May 20West CountyJodi Andersen
H5389 Fri., June 5West CountyJodi Andersen
G5163 Tues., June 23West CountyJodi Andersen
G6147 Wed., July 15West CountyJodi Andersen
G6253 Mon., Aug. 3West CountyJodi Andersen
G6265 Tues., Aug. 25West CountyJodi Andersen
Excel 2013  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
H5233 Fri., Apr. 17West CountyMark Ratliff
H5595 Mon., June 15West CountyMark Ratliff
G6278 Thurs., July 30West 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
H5313 Wed., May 13West CountyDick Koerper
G6209 Wed., Aug. 19West CountyDick Koerper
Excel 2010  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
H5288 Tues., Apr. 28West CountyJodi Andersen
H5352 Thurs., May 21West CountyJodi Andersen
H5390 Thurs., June 11West CountyJodi Andersen
G5164 Tues., June 30West CountyJodi Andersen
G6148 Wed., July 22West CountyNancy Haupt
G6254 Mon., Aug. 10West CountyJodi Andersen
G6266 Wed., Aug. 26West CountyJodi Andersen
Excel 2013  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
H5234 Thurs., Apr. 23West CountyMark Ratliff
H5596 Mon., June 22West CountyMark Ratliff
G6279 Thurs., Aug. 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: $199

Excel 2007  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
H5314 Thurs., May 14West CountyDick Koerper
G6210 Thurs., Aug. 20West CountyDick Koerper
Excel 2010  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
H5264 Thurs., Apr. 16West CountyJodi Andersen
H5289 Wed., May 6West CountyJodi Andersen
H5391 Fri., June 12West CountyJodi Andersen
G6165 Wed., July 8West CountyJodi Andersen
G6250 Tues., July 28West CountyJodi Andersen
G6267 Thurs., Aug. 27West CountyDick Koerper
Excel 2013  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
H5235 Fri., May 1West CountyMark Ratliff
H5597 Mon., June 29West CountyMark Ratliff
G6280 Thurs., Aug. 13West 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.