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

Thursday, February 14, 2019
9:00am - 4:00pm
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 slicers and icon sets. Discover how to make charts called Sparklines right within your data rows. Learn how to solve the Fiscal Year problem using calculated Fields. Learn how to make a Dashboard.


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

There will be a lunch break


This workshops is given by internationally recognized experts. It is presented by the University Libraries.


Workshops are offered at no charge to UB faculty, staff and students. All workshops in this series will be presented in room 310 of Capen Hall inside Silverman Library. Bring your laptop, as this room is not equipped with workstations.


Co-sponsored by The Graduate School.

Event Organizer

Profile photo of James Gordon
James Gordon

More events like this...