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

Video Description

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! https://www.patreon.com/GenealogyTV ▶️ SUBSCRIBE To Genealogy TV on YouTube at https://www.youtube.com/genealogytv/?sub_confirmation=1 ▶️ SUBSCRIBE to NC Ancestry on YouTube at https://www.youtube.com/channel/UCwOIg2lTv7ifY_AEitw7L-g ✅ Genealogy TV WEBSITE https://genealogytv.org/ ✅ Genealogy TV on FACEBOOK https://www.facebook.com/Genealogytv/ ✅ SIGN UP For GENEALOGY TV NEWSLETTER https://mailchi.mp/a0862c6473aa/genealogytvnewsletter ✅ NC ANCESTRY Website https://ncancestry.com/ 🍃BEGINNERS go to LEARN GENEALOGY Playlist at https://www.youtube.com/playlist?list=PLiMXWjHlj5RR12Cc859K76dLKP14t8sAo 🍃 BEGINNERS must see the US Census series!!! https://www.youtube.com/playlist?list=PLiMXWjHlj5RQn9sWPHtwMdaQQ84RRykAw 🌳 FOR ALL PLAYLISTS on Genealogy TV https://www.youtube.com/channel/UCcvpi8XvOScBogIxmarmADw/playlists 🎥 *** 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/by/3.0/