Advanced MS Excel 3: Data Analysis

Class ID: 

Advanced Microsoft Excel III: Import and export data, remove duplicates and use data validation, and analyze data using filters and pivot tables. 

Students should have taken all previous Excel classes or be familiar with the skills covered.

Download handouts and practice problem files below. If files fail to download properly, try a different browser (Internet Explorer, Firefox).

Advanced Excel 2010 3 - Data.pdf871.59 KB
Yarn Shops.txt11.2 KB
Advanced Excel Practice - Data.xlsx123.9 KB
Advanced Excel Practice - Data 97-2003.xls252 KB
Advanced Excel Data Homework Answers.xlsx333.25 KB