Setup Workbook

Video Demonstrations

In this session there are no slides. I will follow Dr. Berqquist's site and do video demonstrations.

To get started download the gradesheet and the setup workbook

"Nice-to-know" things...

There is no 05 worksheet in the Workbook. You will need to follow instructions below to CREATE the 05-Summary Worksheet.

Seeing hash tags in your data?

|###|###|###|     Q: Why? 
|6097|5496|1429   A: Because the sheet creator made the columns to narrow too fit the data.  

Watch this before starting "Pull Vector Data:" VIDEO: Widen columns to get rid of hashtags.

Wednesday Task 01	Worksheet	Video Link
1. Setup worksheet Screenshots	—	—
Getting Started: Download the setup worksheet file	00	Video: 00a-Download Working File
Save File and CREATE 05 Summary Sheet	00	Video:00b-Save File & Setup 05 Summary
Tips on Selecting a Large Data Set	01a	Video: 01a-Tips on Selecting a Large Data Set
Format 01 as a Table and Highlight a Cell	01b	Video: 01b-Format as Table and Apply Cell Color
Freeze Panes and Validate Data	01c	Video: 01c-Freeze panes and validate Data
2. Conditional Formatting Screenshots	02	Video: 02-Conditional Formatting
Hiding Columns C and H	03	Video: 04-Hiding Columns C & H
Hiding Row 30	04	Technique is the same as the above video for columns; just click the row number as you did the column number.
3. Formulas Screenshots	—	—
Summary: Pull Vectored Data	05a	Video: 05a-Summary Vector Demo
4. Functions Screenshots	—	—
Earliest Foundation Date	05b	Video: 05b-Earliest Foundation Date
Total Numbers of Counties in the US	05c	Video: 05c-Total Number of Counties in the US
Number of Navy Programs in North Carolina	05d	Video: 05d-Number of Navy Programs
VLOOKUP	06 & 07	Video: 05e-VLOOKUP