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
G6681 Wed., Apr. 20West CountyDick Koerper
Excel 2010  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G6777 Wed., Feb. 10West CountyJodi Andersen
G6843 Tues., Mar. 8West CountyJodi Andersen
G6864 Thurs., Apr. 7West CountyJodi Andersen
H6585 Mon., Apr. 25West CountyJodi Andersen
H6637 Wed., May 11West CountyNancy Haupt
H6684 Tues., May 31West CountyJodi Andersen
H6735 Wed., June 29West CountyJodi Andersen
Two-Evening Class Meets 6:00-9:00pm (6 hours)
Code Date Location Instructor
T6462 Tues., Apr. 12 & 19West CountyDick Koerper
Excel 2013  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G6670 Tues., Feb. 2West CountyMark Ratliff
G6834 Thurs., Mar. 3West CountyMark Ratliff
G6895 Mon., Apr. 11West CountyMark Ratliff
H6771 Wed., May 25West 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
G6682 Wed., Apr. 27West CountyDick Koerper
Excel 2010  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G6706 Mon., Feb. 1West CountyJodi Andersen
G6778 Tues., Feb. 16West CountyJodi Andersen
G6844 Thurs., Mar. 17West CountyJodi Andersen
G6865 Wed., Apr. 13West CountyJodi Andersen
H6586 Tues., Apr. 26West CountyJodi Andersen
H6638 Wed., May 18West CountyNancy Haupt
H6685 Tues., June 7West CountyJodi Andersen
G7736 Thurs., July 7West CountyJodi Andersen
Two-Evening Class Meets 6:00-9:00pm (6 hours)
Code Date Location Instructor
T6463 Tues., Apr. 26 & May 3West CountyDick Koerper
Excel 2013  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G6671 Tues., Feb. 9West CountyMark Ratliff
G6835 Thurs., Mar. 10West CountyMark Ratliff
G6896 Mon., Apr. 18West CountyMark Ratliff
H6772 Fri., June 3West 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 2010  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G6707 Mon., Feb. 8West CountyMark Ratliff
G6779 Wed., Feb. 24West CountyJodi Andersen
G6845 Thurs., Mar. 24West CountyJodi Andersen
G6866 Tues., Apr. 19West CountyJodi Andersen
H6640 Wed., May 25West CountyJodi Andersen
H6686 Tues., June 14West CountyJodi Andersen
G7737 Thurs., July 14West CountyJodi Andersen
Excel 2013  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G6672 Wed., Feb. 17West CountyMark Ratliff
G6836 Wed., Mar. 16West CountyMark Ratliff
G6897 Mon., Apr. 25West CountyMark Ratliff
H6773 Fri., June 10West 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.