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:
Monday, November 5, 2018
Time:
9:00am - 12:00pm
Location:
310 Silverman
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 icon sets. Discover how to make charts called Sparklines right within your data rows. 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 45 minute lunch break at 11:30am

 

This is the fourth session in a full week of data workshops given by internationally recognized experts 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...