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
- Monday, November 5, 2018
- 9:00am - 12:00pm
- 310 Silverman
- North Campus
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
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.