Analyzing Data using Excel Tables
Learn how to analyze data found in rows and columns. Sort, filter, and format your data using a variety of techniques including number, text and conditional formats. Learn how to use icon sets. Discover how to make charts called Sparklines right in your data rows. Use Excel's new artificial intelligence influenced features to build pivottables and charts. Learn how Excel Dashboards work.
Proper data tables
Downloading data sets
Importing CSV and other text formats
Simple tools such as freeze panes and hiding columns
Setting data types
Total Row feature
Introduction to PivotTables
Introduction to Charts and PivotCharts
This workshop brings beginner users to intermediate level on the topics discussed.
Related LibGuide: Health Statistics by Nell Aronoff
- Monday, October 2, 2017
- 9:00am - 12:00pm
- B2C Abbott
- South Campus