Skip to main content

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 01WorksheetVideo Link
1. Setup worksheet Screenshots
Getting Started: Download the setup worksheet file00Video: 00a-Download Working File
Save File and CREATE 05 Summary Sheet00Video:00b-Save File & Setup 05 Summary
Tips on Selecting a Large Data Set01aVideo: 01a-Tips on Selecting a Large Data Set
Format 01 as a Table and Highlight a Cell01bVideo: 01b-Format as Table and Apply Cell Color
Freeze Panes and Validate Data01cVideo: 01c-Freeze panes and validate Data
2. Conditional Formatting Screenshots02Video: 02-Conditional Formatting
Hiding Columns C and H03Video: 04-Hiding Columns C & H
Hiding Row 3004Technique 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 Data05aVideo: 05a-Summary Vector Demo
4. Functions Screenshots
Earliest Foundation Date05bVideo: 05b-Earliest Foundation Date
Total Numbers of Counties in the US05cVideo: 05c-Total Number of Counties in the US
Number of Navy Programs in North Carolina05dVideo: 05d-Number of Navy Programs
VLOOKUP06 & 07Video: 05e-VLOOKUP