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

Friday, June 21, 2019
9:00am - 3:00pm
2101 SMBS
Downtown Campus
  All Workshops  

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 (2101 Jacobs Downtown Medical Center) does not have workstations. You must have chip key card access to the building in order to attend this workshop.

Co-sponsored by The Graduate School.

Event Organizer

Profile photo of James Gordon
James Gordon

More events like this...