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

Date:
Thursday, February 14, 2019
Time:
9:00am - 4:00pm
Location:
310 Silverman Library
Campus:
North Campus
Categories:
  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...