Event box

Excel: Data Table Analysis and Reports

Excel: Data Table Analysis and Reports

Learn how to analyze data found in data tables.

Related LibGuide: Properties Data for Chemicals & Materials by Erin Rowley

Monday, June 17, 2019
9:00am - 3:00pm
Time Zone:
Eastern Time - US & Canada (change)
310 Silverman Library
North Campus
  All Workshops  
Registration has closed.

Analyze your data using a variety of techniques including sort, filter, number, text and conditional formats. Learn how to use icon sets. Discover how to make charts called Sparklines right within your data rows.


Learn how to build pivottables and charts. Learn how to make a Dashboard. Discover the new Ideas feature.


This workshop is designed to bring novice users to proficient or expert on covered topics


Topics included in this workshop:

  • Even more ways to clean data
  • Data copyright exclusions
  • Data sources
  • Structured tables and Excel tables
  • Resize columns
  • Set column data type
  • Freeze panes
  • Filter and sort
  • Conditional formatting
  • Sparklines
  • Pivottables
  • Slicers
  • Dashboards
  • Connect multiple pivottables with slicers
  • Recommended PivotCharts
  • New feature: Ideas

There will be a 30 minute lunch break at 11:30am

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.

Co-sponsored by The Graduate School.

Event Organizer

Profile photo of James Gordon
James Gordon

More events like this...