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