Session Date: Wednesday Oct 25, 2017
Spreadsheets: Database Tools
Preparations for this Session
How to create a Database in Excel
glance over Excel 2007+ Step by Step Database Tutorial
In this class session we will cover
- Sorting
- Filtering
- Subtotals
- Linking worksheets within workbooks
- We will download and demo two or three practice files
Practice Files
- File: General Social Survey data, 1996 | Example Website using this data
- Skyscraper example | Example Website using this data (skyscraper data is only for demo purposes: do not trust data)
last page update: Friday Aug 11, 2017