This workshop is designed for all who want to use the Excel Pivot Table to quickly summarize large amounts of data. Think of it like this: you have a giant pile of information, but you want to find patterns, totals, and trends without getting lost in the weeds. A Pivot Table helps you do that by allowing you to drag and drop your data into different configurations so you can analyze it in a way that makes sense. It’s like a magic lens for your data. 

Course outline:
•    An overview of the use of Pivot Tables to summarize and obtain insights from Excel worksheets
•    The use of the slicer and Timeline functionality to create dashboards
•    The creation of Pivot Charts
•    An explanation of the most common formulas to summarize information and manage dates and times.

Session Information:
In Person:  Blume Library Commons Room 124 (CIT Lab)

If you have any questions, please get in touch with Angel Tazzer, Ph.D. Director of Instructional Technology and Training, at atazzer@stmarytx.edu or 210-431-5009. 

Academic Technology Services (ATS) offers weekly workshops for faculty, staff, and students.