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.
 

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

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