Event box
Excel: Data Table Analysis and Reports In-Person
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
- Time Zone:
- Eastern Time - US & Canada (change)
- Campus:
- North Campus
- Categories:
- All Workshops
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.