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
G7834 Tues., May 2West CountyNancy Haupt
G7915 Fri., June 2West CountyHeather Vogt
G7999 Thurs., June 29West CountyHeather Vogt
E8044 Tues., July 18West CountyNancy Haupt
E8104 Wed., Aug. 23West CountyHeather Vogt
Excel 2013  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G7875 Fri., May 12West CountyHeather Vogt
G7964 Mon., June 12West CountyHeather Vogt
E8058 Wed., July 12West CountyHeather Vogt
E8061 Tues., Aug. 1West 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 2010  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G7835 Tues., May 16West CountyNancy Haupt
G7916 Fri., June 9West CountyHeather Vogt
G8000 Thurs., July 6West CountyHeather Vogt
E8045 Wed., July 26West CountyNancy Haupt
E8105 Tues., Aug. 29West CountyHeather Vogt
Excel 2013  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G7876 Thurs., May 18West CountyHeather Vogt
G7965 Mon., June 19West CountyHeather Vogt
E8059 Wed., July 19West CountyHeather Vogt
E8062 Tues., Aug. 8West 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
G7836 Tues., May 23West CountyNancy Haupt
G7917 Fri., June 16West CountyHeather Vogt
G8001 Thurs., July 13West CountyHeather Vogt
E8046 Tues., Aug. 1West CountyNancy Haupt
E8106 Wed., Sept. 6West CountyHeather Vogt
Excel 2013  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G7839 Wed., May 3West CountyHeather Vogt
G7966 Mon., June 26West CountyHeather Vogt
E8060 Thurs., July 27West CountyHeather Vogt
E8063 Tues., Aug. 15West CountyHeather Vogt

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.