Published On Oct 16, 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
* * *
❤️ NEED HELP? Join the "Genealogy TV Insiders" coaching group or sign up for private coaching. For more info...
https://genealogytv.org/coaching-opti...
❤️ 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...