Event box

Excel: PivotTables, Slicers, PivotCharts and Dashboards

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
  All Workshops  
Registration has closed.

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
  • Slicers
  • 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.

Event Organizer

Profile photo of James Gordon
James Gordon

More events like this...