Advanced Excel #4

Lesson #4

Introduce Database

Create Table

Convert Existing Spreadsheet to Database

Create Database from scratch

Sort Data in a table

Filter Data in a Table

Introduce Data Entry form

Create New Tab for Data Entry

Use Data Entry Form

Introduce VLOOKUP

Use VLOOKUP to Query Database