Class Session: Thursday Jan 01, 1970
Spreadsheets: Database Tools
Preparations for this Session
How to create a Database in Excel
glance over Excel 2007+ Step by Step Database Tutorial
I taught some of this material a bit out of order, so we will make up for it today
Before diving in to the Database tools demo, we will cover the remaining items that I have not yet demonstrated in class:
- adjusting row height
- adjusting column width
- Multilevel sort (as opposed to a multi-level filter, which I have covered)
- Comments
- Charts and adding graphics to charts
- Page Setup: header rows, footers, layout for printing
If you have been to each class, you will have seen everything you need to complete the 04-spreadsheets project.
Practice Files
If we have time, we will download and demo two or three practice files to introduce the concept of Excel as a database. If not, we will look at this in our introductory database session.
- 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)