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:
Tuesday, June 25, 2019
Time:
9:00am - 3: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 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...