INLS161-002 | Spring 2017

Session Date: Monday Mar 20, 2017

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]

In this class session we will cover

  • Sorting
  • Filtering
  • Subtotals
  • Linking worksheets within workbooks
  • We will download and demo two or three practice files

In our last class, before Spring Break, we covered basic charting and the rest of the class was an open lab. In this class, I will present the last remaining concepts that you will need to finish the project.

Practice Files

Quick Links

Instructor

Lawrence Jones

Office hours by appointment.