Microsoft Excel: Unleash the Power of PivotTables and Reporting Tips - (In Person Session)

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 [email protected] or 210-431-5009.

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