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.

The classes below are offered in Excel 2013. Students with either Excel 2010, 2016, or Office 365 could also take these classes since the versions are very similar.

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 2013  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E9500 Thurs., Dec. 20West CountyMark Ratliff

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 
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E9499 Tues., Feb. 5West 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.)