UMSL logo

Computer Education & Training Center

PivotTables

Excel PivotTables 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]

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. For more information, email info@cetc.umsl.edu.

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.
Fee: $199

Excel 2016  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E0785 Tues., June 16West CountyDawn Robinson
E1185 Mon., Aug. 17West CountyDawn 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.
Fee: $199

Excel 2016  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E0786 Wed., June 24West CountyDawn Robinson
E1186 Tues., Aug. 25West CountyDawn Robinson

Advanced Excel PivotTables

(Prerequisites: Intermediate PivotTables or equivalent experience) Learn some of the advanced settings that will allow you to set up subtotals and change your layout. Understand how to create PivotTables from multiple consolidation ranges, use macros to refresh your data, and synchronize multiple tables. Discover how to set up fiscal quarters, and perform calculations and filtering as well as work with atypical fiscal years. Understand how to create calculated items, and change the solve order for calculated fields and calculated items. Learn techniques to improve the appearance of your spreadsheets including advanced conditional formatting. Add data sets to create a data model, and then generate a PivotTable from the model. Learn to show values as an index and how this impacts your PivotTable. Additional topics include how to use ISNULL and advanced calculations such as nested IFs and logical AND/OR.
Fee: $199

Excel 2016  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E0787 Tues., June 30West CountyDawn Robinson
E1187 Mon., Aug. 31West CountyDawn 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 VBA (Visual Basic for Applications), Formulas and Functions, and Excel Data Manipulation.