UMSL logo

Computer Education & Training Center


Excel PivotTables and PowerPivot Classes

The PivotTable feature in Excel is a great time-saving tool to quickly extract and summarize large quantities of data. With just a few keystrokes, you can create a new data table with your results. [More on PivotTables]

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

  • 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 PivotTables

(Prerequisite: Intermediate Applications of Excel or equivalent experience.) Learn how to save time extracting, organizing, and summarizing meaningful data from Excel spreadsheets or other sources by creating interactive PivotTables and PivotCharts. Explore how to create and customize a PivotTable, view subsets of data, and show or hide details. Discover how to create and design a PivotChart to view the summarized data in graphical format. Set up a PivotTable from a large database to view specific data and work with calculation/date fields. Discover the tips and shortcuts that will make you more efficient and your PivotTables more effective in summarizing your data. [Course Outline]
Fee: $199

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E3355 Fri., Nov. 11Virtual/WCDawn Robinson
E3545 Tues., Jan. 31Virtual/WCDawn Robinson

Intermediate Excel PivotTables

(Prerequisites: Introduction to PivotTables or equivalent experience) Build on your knowledge of PivotTable capabilities to understand and visualize your data more effectively. Organize your data through customized grouping, and quickly view date ranges using Timeline slicers. Include calculated fields to give you new insights about your data. Understand how conditional formatting interacts with PivotTables, giving you more options on how to present your data. Additional topics include creating more useful PivotTables by adding KPI indicators, working with standard deviation, and using IF statements. [Course Outline]
Fee: $199

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E3097 Thurs., Sept. 1Virtual/WCDawn Robinson
E3356 Fri., Nov. 18Virtual/WCDawn Robinson
E3546 Tues., Feb. 7Virtual/WCDawn Robinson

Introduction to PowerPivot

(Prerequisite: Introduction to PivotTables or equivalent experience.) Create PivotTables and PivotCharts from large, multi-source data sets. Import data directly from the source, or build queries to extract specific parts of data from very large sources. Learn how to relate multiple data tables through key fields, allowing fact tables to lookup information from other parts of the data model. Add calculated columns and measures directly in the data model within DAX (data analysis expressions). Break the data down with user-defined hierarchies. Generate dynamic key performance indicators (KPI) for display. Utilize date intelligence functions to pinpoint trends within the data, allowing end users to make informed data-driven decisions.  [Course Outline]
Fee: $199

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E3457 Tues., Nov. 22Virtual/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 VBA (Visual Basic for Applications), Formulas and Functions, and Excel Data Manipulation.

For more information, please email