UMSL logo

Computer Education & Training Center

Excel Formulas

Excel Data, Formulas, and Functions Classes

Advance your spreadsheet skills in Excel with in-depth training in formulas and functions as well as learning more about data manipulation and other advanced features of Excel.

Our Excel classes are now available online with an instructor present for the entire course. You will see the instructor's screen throughout the class and you can share your screen if you need individual help from the instructor. You will have time to practice, ask questions, and receive hands-on training. In addition, if you don't have Excel available on your machine, you can remote into one of our computers. For more information, email info@cetc.umsl.edu.

Excel Formulas and Functions

(Prerequisite: Intermediate Applications of Excel or equivalent experience.) This course concentrates on Excel functions and formulas. Look at commonly used text and data functions, including changing the case of text, combining text cell contents (e.g., first and last names), and comparing cell contents. Work with date and time functions and logical functions. Other topics will include using simple form fields to select items from a list (note that this will not cover creation of custom forms, as that requires VBA), using the formula editing toolbar to check your data and solve formula errors, and working with arrays.
Fee: $199

Excel 2016  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E0725 Fri., June 12West CountyDawn Robinson

Excel Data Manipulation

(Prerequisite: Intermediate Applications of Excel or equivalent experience.) Discover ways to save time and increase your efficiency, whether you are working with one large spreadsheet or multiple tables. Find out how you can combine portions of several lists or tables into one consolidated table. Learn how to navigate with hyperlinks through multiple sheets of a workbook, multiple workbooks, or even to other programs. Save valuable time by accessing custom-made views of your spreadsheet. Topics include how to eliminate repetitive typing by creating, modifying, and printing comments for compressed notations on spreadsheets; and use Group and Outline to quickly show and print totals in sections of your spreadsheet.
Fee: $199

Excel 2016  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E0796 Tues., June 23West CountyBill Barry
E1034 Thurs., Aug. 13West CountyBill Barry

If you would like to register for a course, call (314) 984-9000 or register online.

Beginning through advanced level Excel classes are available as well as classes in Excel Charts, PivotTables, and Excel VBA (Visual Basic for Applications.)