Class Session: Wednesday Oct 24, 2018

Spreadsheets: Database Tools


Preparations for this Session

How to create a Database in Excel

glance over Excel 2007+ Step by Step Database Tutorial

top/reload prep panel

Sorting

Filtering

We will download the titanic-passenger-list.xlsx and follow the instructions in the file to learn how to filter.

Subtotals

Linking within Worksheets and Workbooks

Quick links

opal login: ssh ONYEN@opal.ils.unc.edu
opal password: ONYEN password

Instructor

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.

Office hours by appointment.