Excel: Data table visualization
Learn how to visualize your data within tables. We'll cover topics from simple data presentation to conditional formatting and spark lines. Our goal is to help you go from novice to proficient on the topics covered.
Related LibGuide: Data Visualization by Carolyn Klotzbach-Russell
- Thursday, January 9, 2020
- 9:00am - 3:00pm
- 310 Silverman Library
- North Campus
Using Microsoft Excel, we will use data tables as data visualizations. You are invited to bring your own data sets to work on. After this workshop you will be familiar with:
- STRUCTURED, normalized data tables
- AVERAGE worksheet function
- TEXT TO COLUMNS using File > Open's Text Import Wizard
- FREEZE PANES for scrolling data
- DATA TYPES why and how to specify
- TEXT AND NUMBER FORMATS
- CUSTOM NUMBER FORMATS
- HIDE and UNHIDE rows and columns
- SPECIAL EXCEL TABLE features
- CALCULATED FIELDS and columns
- TOTAL ROW worksheet functions
- SORT and FILTER data
- CUSTOM AUTOFILTER and ADVANCED FILTER
- SLICERS for tables
- DASHBOARDS and how to make them
- FISCAL YEAR how to solve this reporting problem
- CONDITIONAL FORMAT to draw attention to specific data
- SPARKLINES add charts within your data table rows
- GROUP EXERCISE the database kind, not the athletic kind
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.
Attendees are encouraged to update Microsoft Office prior to attending.
To get a free Microsoft Office 365 subscription for current faculty, staff or student privately owned devices click here.
Co-sponsored by The Graduate School.
Dental Medicine staff comment on most valuable aspect of this workshop:
"The slicers on the pivot tables, the spark lines, and all the different conditional formatting that I didn't know about."