University of Southern Indiana

USI @ WestGate: MS Excel Pivot Table Workshop

PivotTables are one of the most powerful features of Excel and are something that every serious user should know how to use. PivotTables are also one of the most difficult features to figure out unless you have training. Our goal is to make PivotTables less intimidating and more useful by turning data into meaningful information.
This course is six hours in length with a one-hour break for lunch and is hands-on so participants must bring a laptop to the training. Also, it is designed for advanced Excel users who want to focus more on PivotTables. Some of the topics that will be covered are:
• How to get multiple reports from the same worksheet without sorting, filtering, converting into a table or performing other manipulations
• How to perform many different types of financial, count and statistical summaries on the same worksheet
• Start with recommended PivotTables, modify them, and then build your own for even more control over the information you need
• How to use the interactive features to get different views of your data with drag and drop data fields
• Create graphs more easily because the data is already summarized for you
• Discover how timelines and slicers make it even easier to find the information needed

Contact Paula Nurrenbern, manager, customized solutions at 812-461-5425 or, for a needs assessment to see how our programs can meet the training needs of your company or organization.  

Contact Bill Groves


Send Email to