UMSL logo

Computer Education & Training Center

Excel Analysis

Excel Data Analysis Classes

Advance your skills in Excel with in-depth training in using Excel for Data Analysis by attending a class at the Computer Education & Training Center.

Virtual Classes: Our Excel Data Analysis 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 the Excel software and data tools 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.

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

Excel Data Analysis

(Prerequisite: Advanced Applications of Excel or equivalent experience.) Learn to use the included Excel Data Analysis ToolPak to make informed data-driven decisions. Understand how to do correlation, moving average, histogram, and exponential smoothing. Learn how to do regression, sampling, and rank/percentile in Excel. Create new visualizations including a tree map, box and whisker plot, waterfall, radar, and sunburst. Work with Power Query to gather your data and bring it into Excel for further analysis.  [Course Outline]
Fee: $199

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E3400 Tues., Nov. 29Virtual/WCMark Ratliff
E3575 Tues., Feb. 28Virtual/WCMark Ratliff

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

For more information, please email