UMSL logo

Computer Education & Training Center

PivotTables and PowerPivot

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]

Excel PivotTables

(Prerequisite: Intermediate Applications of Excel or equivalent experience.) In this course, you will 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. Understand how to create PivotTables from multiple consolidation ranges, use macros to refresh your data, and synchronize multiple tables. Set up a PivotTable from a large database to view specific data and work with calculation and 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 2013  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E9515 Fri., Jan. 18West CountyMark Ratliff
E9575 Mon., Mar. 25West CountyMark Ratliff

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 2013  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E9516 Fri., Jan. 25West CountyMark Ratliff
E9576 Tues., Mar. 26West CountyMark Ratliff

Introduction to PowerPivot

(Prerequisite: Excel PivotTables or equivalent experience. Learn more advanced techniques to analyze your data including advanced PivotTable formatting and creating PivotTables from imported and related tables. Discover how the PowerPivot add-on allows you to import large quantities of data, create relationship between tables, and build calculated columns. Topics include importing, using queries, linking tables, filtering data, creating data models, establishing table relationships, creating hierarchies, using the PowerPivot ribbon, and using DAX (data analysis expressions).
Fee: $199

Excel 2013  [Course Outline]
One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E9517 Fri., Feb. 1West CountyMark Ratliff

Intermediate PowerPivot

(Prerequisite: Introduction to PowerPivot or equivalent experience.) Empower your companys data analysis techniques with more advanced techniques in PowerPivot. Build upon previous Excel knowledge calculating columns and fields by using Count, Text, Date and Format DAX expressions. Take these expressions further by extracting, comparing, and making sense of critical business data. Discover new, efficient ways to pinpoint trends and goals with Key Performance Indicators. Streamline business processes and workflows using the Related expression. PowerPivot energizes data giving you the tools needed to make informed decisions that will impact business in powerful ways.
Fee: $199

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