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
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
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.