Excel: PivotTables, Slicers, PivotCharts and Dashboards
Simplifying advanced data analysis and display techniques.
Related LibGuide: Data Visualization by Carolyn Klotzbach-Russell
- Thursday, January 16, 2020
- 9:00am - 3:00pm
- 310 Silverman Library
- North Campus
PivotTables (aka crosstab tables) look like regular data tables, but the data within them is generated by calculations. Learn how to analyze your data with PivotTables. You are invited to bring your own data to work on in this workshop.
This workshop is designed to bring novice users to intermediate users. Becoming an expert with these tools takes practice.
Topics included in this workshop:
- Structured data tables
- Set Data types
- How to make a PivotTable
- Recommended PivotTables and PivotCharts
- Formatting data
- PivotTable Style and Style customization
- Sorting and filtering
- Connect multiple PivotTables with slicers
- Automatic Calculations
- Make a PivotChart from a PivotTable
Workshops are offered at no charge to UB faculty, staff, students and alumni.
Please remember to bring your own device to the workshop. The classroom does not have workstations.
Attendees are encouraged to update Microsoft Office prior to attending.
To get a free Microsoft Office 365 subscription for current faculty, staff or student privately owned devices click here.
Co-sponsored by The Graduate School.