#1 Way to Break Down Brick Walls: Updated (2020)

What is the number one way to break down those brick walls and get unstuck in your family history research? I’ve got a trick to help you with that and make the job faster in the long run. In this episode I’ll show you how to extract census information, so you can filter it to your ancestors fast.

📄 There is a handout for this episode for Information Access Channel Members.

❤️BECOME A GENEALOGY TV CHANNEL MEMBER and help support Genealogy TV. Click the link to learn about the Perks of Membership.
https://www.youtube.com/genealogytv/join

0:00 Intro
5:37 Research Question
6:45 Researching the 1860 Census
7:05 Extracting data from 1860 Census
7:20 Open Census Transcriptions
8:03 Highlight All on Census
8:27 Copy Command
8:39 Paste Special as Text
9:13 How to insert a column in Excel
9:41 How to Delete Rows in Excel
10:25 How to copy one cell to many
11:33 How to move a cell
12:20 How to resize columns in Excel
12:57 Resize multiple columns
13:23 Bold an entire row
13:35 Freeze Panes - Top Row
15:45 Full Example
16:06 Inserting Rows
16:22 Add Source Citation Info
17:45 Freeze Many Rows with Split
18:58 Creating Filters
19:47 Filter by Surname
21:10 Filter by Gender
21:32 Date Error in Extraction
22:15 Highlight cell with color
23:20 Process of Elimination
24:17 Why Image Numbers
25:14 Davis Men in Bastardy Bonds
26:40 Un-filter columns
27:40 Recap
28:38 Closing information

Episode 173
* *

❤️ TIP JAR - If you like what you see and wish to help support Genealogy TV or NC Ancestry, please consider becoming a Patreon member. Click link below to donate to help keep more videos coming. Thank you!
  / genealogytv  

▶️ SUBSCRIBE To Genealogy TV on YouTube at
https://www.youtube.com/genealogytv/?...

▶️ SUBSCRIBE to NC Ancestry on YouTube at
   / @ncancestry  

✅ Genealogy TV WEBSITE
https://genealogytv.org/

✅ Genealogy TV on FACEBOOK
  / genealogytv  

✅ SIGN UP For GENEALOGY TV NEWSLETTER
https://mailchi.mp/a0862c6473aa/genea...

✅ NC ANCESTRY Website
https://ncancestry.com/

🍃BEGINNERS go to LEARN GENEALOGY Playlist at
   • Learn Genealogy From the Beginning  

🍃 BEGINNERS must see the US Census series!!!
   • US Census Records  

🌳 FOR ALL PLAYLISTS on Genealogy TV
   / @genealogytv  

🎥 ** GEAR I USE TO CREATE THESE VIDEOS ** 📸

Canon EOS M50 Mirrorless Camera Kit w/ EF-M15-45mm Lens and 4K Video (I love this camera, it's really easy or as advanced as you want) Two thumbs up!
https://amzn.to/39x8mHF

Rhode Wireless Go Microphones (Awesome and Affordable)
https://amzn.to/2Hrd8dA

Webcam Logitec C920 1080p
https://amzn.to/2GmPgIM

Canon 7D Camera Body (without lens)
https://amzn.to/2MPHMiL

Canon 24-105mm Lens
https://amzn.to/2BllDEv

Caddie Buddy Teleprompter
https://amzn.to/2BiLjBz

Popup Green Screen
https://amzn.to/2TtSNsE

Softbox Lights by Fovitec
https://amzn.to/2TtI6WR

Lavalier MICROPHONE is by Boya
https://amzn.to/2WFGbAM

Disclosure: Please know I will never-ever recommend a product that I don't believe in. Having said that, some of the links in the show notes (not all, but a few) are affiliate marketing links. Using those links gives me a commission, but costs you nothing more, I promise, but helps me out a bunch. Thanks for using affiliate marketing links whenever possible.

#Genealogy #GenealogyTV #FamilyHistory

Music Credits for Song on Word Tree Open
Circus Waltz Kevin MacLeod (incompetech.com)
Licensed under Creative Commons: By Attribution 3.0 License
http://creativecommons.org/licenses/b...