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.

Virtual Classes: 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.

In-person classes are also available at our West County facility with limited enrollments to promote social distancing. When you register, choose your class section based on how you want to attend the class: virtual or in-person.

  • Choose "West County In-Person" if you want to attend a class at our West County location.
  • Select "Live Online" if you want to attend virtually from your workplace or home.

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
E1430 Fri., Jan. 22Virtual/WCDawn 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
E1260 Fri., Nov. 20Virtual/WCDawn Robinson

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.)