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

Genealogy TV October 16, 2020
Video Thumbnail
Genealogy TV Logo

Genealogy TV

@genealogytv

About

Genealogy TV is here to help you "Go Further, Faster... and Factually... with your Family History Research." This channel is all about genealogy and free family history education. Beginners to advanced genealogist can find the latest tips, techniques and smart research strategies for finding your ancestors accurately. Learn DNA research, where the records are located, and how to focus your research so you can expand your family tree with these free genealogy videos. I am a fanatic for genealogy, family history, and DNA to research my American ancestors. My mission is to make Genealogy TV the best free genealogy videos and webinars. Top videos on “Genealogy TV” are about research strategies, staying organized, DNA & genetic genealogy, finding missing ancestors, and where to find records. Learn genealogy gems, tips & tricks, how to research on Ancestry.com, FamilySearch.org, MyHeritage.com, FindMyPast.com, FamilyTreeDNA, AncestryDNA, 23andMe, Wikitree, and genealogy websites.

Latest Posts

No results found. Try different keywords.

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/

You May Also Like

Upgrade Your Everyday

AI-recommended products based on this video

Loading...
Kasa Smart Outdoor Smart Plug by TP-Link (KP400) - Smart WiFi Outlet with 2 Sockets, IP64 Waterproof, Works with Alexa and Google Home, 2.4GHz WiFi Required, No Hub Required, Sunset & Sunrise Offset

Kasa Smart Outdoor Smart Plug by TP-Link (KP400) - Smart WiFi Outlet with 2 Sockets, IP64 Waterproof, Works with Alexa and Google Home, 2.4GHz WiFi Required, No Hub Required, Sunset & Sunrise Offset

(28,846)
$21.99$17.99
FREE delivery Wed, Aug 20 on your first order
1K+ bought in past month
Loading...
Wireless Earbuds Bluetooth 5.4 Headphones, 50H Playtime Stereo Earphones with ENC Noise Cancelling, IPX7 Waterproof Open Ear Buds with Ergonomic Earhook for Fitness/Sports/Workouts Black

Wireless Earbuds Bluetooth 5.4 Headphones, 50H Playtime Stereo Earphones with ENC Noise Cancelling, IPX7 Waterproof Open Ear Buds with Ergonomic Earhook for Fitness/Sports/Workouts Black

(182)
$39.99
Prime
Loading...
Wireless Earbuds, Bluetooth 5.4 Headphones HiFi Stereo with 6 HD Mics, 2025 Active Noise Cancelling Earbuds, 36H Playtime and LED Display in Ear Earphones, IP7 Waterproof Wireless Headphones, Black

Wireless Earbuds, Bluetooth 5.4 Headphones HiFi Stereo with 6 HD Mics, 2025 Active Noise Cancelling Earbuds, 36H Playtime and LED Display in Ear Earphones, IP7 Waterproof Wireless Headphones, Black

(159)
$29.99$26.99
FREE delivery Fri, Jan 2 on your first order
Loading...
Wireless Earbuds, Sports Bluetooth Headphones, 80Hrs Playtime Ear Buds with LED Power Display, Noise Canceling Headset, IPX7 Waterproof Earphones for Workout/Running(Black)

Wireless Earbuds, Sports Bluetooth Headphones, 80Hrs Playtime Ear Buds with LED Power Display, Noise Canceling Headset, IPX7 Waterproof Earphones for Workout/Running(Black)

(421)
$39.99
Prime
1K+ bought in past month
Loading...
Monster Open Ear Headphones AC330, Wireless Earbuds Bluetooth 5.4 with Clear Talk, Stylish Rotating Case with Lanyard, Type-C Charging, Comfort Fit, 24H Playback, IPX5 Water Resistant, Black

Monster Open Ear Headphones AC330, Wireless Earbuds Bluetooth 5.4 with Clear Talk, Stylish Rotating Case with Lanyard, Type-C Charging, Comfort Fit, 24H Playback, IPX5 Water Resistant, Black

(262)
$29.99
FREE delivery Tue, Dec 30 on your first order
500+ bought in past month
Loading...
Brita Stainless Steel Premium Filtering Water Bottle, BPA-Free, Reusable, Insulated, Replaces 300 Plastic Water Bottles, Filter Lasts 2 Months or 40 Gallons, Includes 1 Filter, Carbon - 20 oz.

Brita Stainless Steel Premium Filtering Water Bottle, BPA-Free, Reusable, Insulated, Replaces 300 Plastic Water Bottles, Filter Lasts 2 Months or 40 Gallons, Includes 1 Filter, Carbon - 20 oz.

(2,652)
$81.37$76.36
FREE delivery Sep 29 - Oct 2
Loading...
Simple Modern Filtered Water Bottle | Insulated Stainless-Steel Carbon Filter Travel Water Bottles | Reusable for Clean Drinking Water On The Go | 24oz, Sea Glass Sage

Simple Modern Filtered Water Bottle | Insulated Stainless-Steel Carbon Filter Travel Water Bottles | Reusable for Clean Drinking Water On The Go | 24oz, Sea Glass Sage

(26)
$30.13
FREE delivery Tue, Sep 23 on your first order
Loading...
FITVII Health & Fitness Tracker (Answer/Make Calls), Smart Watch with 24/7 Heart Rate and Blood Pressure, Sleep Tracking Monitor, 120+ Sport Mode Activity Tracker

FITVII Health & Fitness Tracker (Answer/Make Calls), Smart Watch with 24/7 Heart Rate and Blood Pressure, Sleep Tracking Monitor, 120+ Sport Mode Activity Tracker

(198)
$59.99
FREE delivery Sun, Aug 10
100+ bought in past month
Loading...
AYATAHA AYATAHA Smart Watch for Kids, Smartwatch Fitness Tracker for Boys Girls, Children's Activity Watch 37 Sports Modes SMS Notification, HD Full Touchscreen IP67 Waterproof, Blue

AYATAHA AYATAHA Smart Watch for Kids, Smartwatch Fitness Tracker for Boys Girls, Children's Activity Watch 37 Sports Modes SMS Notification, HD Full Touchscreen IP67 Waterproof, Blue

(55)
$41.99
PrimeFREE delivery Sat, Jun 14
Loading...
Iaret Iaret Smart Watch for Women, 1.83" HD Fitness Tracker with 4 Bands, Answer/Make Calls, Heart Rate/Sleep/SpO2/Step Tracking, 100+ Sport Modes, Android/iPhone Compatible Gift (Rose Gold)

Iaret Iaret Smart Watch for Women, 1.83" HD Fitness Tracker with 4 Bands, Answer/Make Calls, Heart Rate/Sleep/SpO2/Step Tracking, 100+ Sport Modes, Android/iPhone Compatible Gift (Rose Gold)

(42)
$59.99
FREE delivery Thu, Jun 19
100+ bought in past month
Loading...
Smart Watch for Men Women 1.8" Fitness Tracker, Bluetooth Call, DIY Dial, Heart Rate Sleep Blood Oxygen Monitor, 100+ Sports Modes, IP68 Waterproof Smartwatch for Android iPhone, Alexa Built-in

Smart Watch for Men Women 1.8" Fitness Tracker, Bluetooth Call, DIY Dial, Heart Rate Sleep Blood Oxygen Monitor, 100+ Sports Modes, IP68 Waterproof Smartwatch for Android iPhone, Alexa Built-in

(980)
$39.99
FREE delivery Sun, Sep 21
300+ bought in past month
Loading...
Hand Warmers 2 Pack, 14000mAh Rechargeable Hand Warmers, Electric Hand Warmer Reusable, Portable Power Bank USB Hand Warmers 4 Levels 8 Heating, Gifts for Raynauds Ski Golf Camping

Hand Warmers 2 Pack, 14000mAh Rechargeable Hand Warmers, Electric Hand Warmer Reusable, Portable Power Bank USB Hand Warmers 4 Levels 8 Heating, Gifts for Raynauds Ski Golf Camping

(683)
$74.08$59.47
FREE delivery Jun 13 - 18
Loading...
Hand Warmers Rechargeable, 10000mAh Electric Heated Gloves Power Bank Portable Graphene Handwarmers Pouch with 3 Levels & Double-Sided Heating for Hunting Camping Golf Xmas Gifts for Women Men Kids

Hand Warmers Rechargeable, 10000mAh Electric Heated Gloves Power Bank Portable Graphene Handwarmers Pouch with 3 Levels & Double-Sided Heating for Hunting Camping Golf Xmas Gifts for Women Men Kids

(651)
$44.99
PrimeFREE delivery Sun, Jun 15
Loading...
2Pack Rechargeable Hand Warmer, 8000mAh Electric Hand Warmer Power Bank, Portable USB-C Hand Warmer for Pocket, Reusable Hand Warmer Up to 8 hrs Each, Warm Gift for Men Women, for Hunting, Camping
Amazon's Choice

2Pack Rechargeable Hand Warmer, 8000mAh Electric Hand Warmer Power Bank, Portable USB-C Hand Warmer for Pocket, Reusable Hand Warmer Up to 8 hrs Each, Warm Gift for Men Women, for Hunting, Camping

(1,128)
$15.99
FREE delivery Sat, Jun 14 on your first order
Loading...
GTOCE Portable Charger,40000mAh Power Bank with 22.5W Fast Charging LED Digital Display Battery Pack with 6 Outputs 2 Inputs, Type C Powerbank Portable Charger for iPhone 16 pro Samsung AirPods,Black

GTOCE Portable Charger,40000mAh Power Bank with 22.5W Fast Charging LED Digital Display Battery Pack with 6 Outputs 2 Inputs, Type C Powerbank Portable Charger for iPhone 16 pro Samsung AirPods,Black

(334)
$42.99
FREE delivery Thu, Oct 16
1K+ bought in past month
Loading...
Monster Sleep Ear100 Ear Buds, Sleep Earbuds with Stereo Sound, Design for Side Sleeper, 32H Playtime, Bluetooth 6.0, ENC Noise Cancelling, IPX6 Waterproof Mini Headphones, Black

Monster Sleep Ear100 Ear Buds, Sleep Earbuds with Stereo Sound, Design for Side Sleeper, 32H Playtime, Bluetooth 6.0, ENC Noise Cancelling, IPX6 Waterproof Mini Headphones, Black

(6)
$39.99
FREE delivery Sat, Dec 27
Loading...
Hydroponics Growing System Indoor Garden - Herb Garden with Grow Light, 15 Pods Stainless Steel Indoor Garden Kit, Auto Timer, Gardening Gift for All Ages

Hydroponics Growing System Indoor Garden - Herb Garden with Grow Light, 15 Pods Stainless Steel Indoor Garden Kit, Auto Timer, Gardening Gift for All Ages

(24)
$206.57$200.61
FREE delivery Jun 13 - 17
Loading...
Umbra Triflora Hanging Planter for Window, Indoor Herb Garden, Set of 5, White/Black

Umbra Triflora Hanging Planter for Window, Indoor Herb Garden, Set of 5, White/Black

(7,808)
$71.52
PrimeFREE delivery Sat, Jun 14
Loading...
Large Hydroponics Growing System 14 Pods, Indoor Herb Garden with LED Grow Light, 5L Water Tank, Hydroponic Grow Kit with 3 Auto-Timers, Rotatable Light Panel and Child Lock for Home School Gardening

Large Hydroponics Growing System 14 Pods, Indoor Herb Garden with LED Grow Light, 5L Water Tank, Hydroponic Grow Kit with 3 Auto-Timers, Rotatable Light Panel and Child Lock for Home School Gardening

(119)
$167.81
FREE delivery Jun 16 - 20
Loading...
Hanging Planter Hanging Plant Holder, 6 Inch 4 Indoor Plant Pots, Wall/Window Plant Hanger Indoor Herb Garden

Hanging Planter Hanging Plant Holder, 6 Inch 4 Indoor Plant Pots, Wall/Window Plant Hanger Indoor Herb Garden

(269)
$35.99$28.90
PrimeFREE delivery Sat, Jun 14
Loading...
slopehill Multi Hair Stylers & Hair Straightener - 2 in 1 Wet to Dry Air Straightener and Hair Dryer Combo with High Speed Air + Rapid Heat-Up + Customizable Temperature(Pink)

slopehill Multi Hair Stylers & Hair Straightener - 2 in 1 Wet to Dry Air Straightener and Hair Dryer Combo with High Speed Air + Rapid Heat-Up + Customizable Temperature(Pink)

(177)
$139.99
Prime
Loading...
Hi.FANCY Portable Laptop Stand with Dual Cooling Fans for 14-17inch Laptops, Grey, 23.5 x 25.9 x 0.95cm

Hi.FANCY Portable Laptop Stand with Dual Cooling Fans for 14-17inch Laptops, Grey, 23.5 x 25.9 x 0.95cm

(0)
$36.99
FREE delivery Aug 18 - 28
Loading...
Laptop Stand for Desk, Adjustable Laptop Riser ABS+Silicone Foldable Portable Laptop Holder, Ventilated Cooling Notebook Stand for 10-15.6” Laptops,Tablet-Black

Laptop Stand for Desk, Adjustable Laptop Riser ABS+Silicone Foldable Portable Laptop Holder, Ventilated Cooling Notebook Stand for 10-15.6” Laptops,Tablet-Black

(11,679)
$14.99
FREE delivery Sat, Jun 14 on your first order
500+ bought in past month
Loading...
JETech 5 in 1 Case for Samsung Galaxy S25 Ultra 5G with 2-Pack Each Tempered Glass Screen Protector and Camera Lens Protector, Non-Yellowing Shockproof Bumper Phone Cover (Clear)

JETech 5 in 1 Case for Samsung Galaxy S25 Ultra 5G with 2-Pack Each Tempered Glass Screen Protector and Camera Lens Protector, Non-Yellowing Shockproof Bumper Phone Cover (Clear)

(197)
$15.99
FREE delivery Sat, Jun 14 on your first order
100+ bought in past month
Loading...
TAURI for iPhone 17 Pro Max Case 6.9" with 1-Pack Screen Protector, Camera Lens Full Protection, Military-Grade Protection, Shockproof Transparent Back Bumper Phone Cover - Clear Global Recycled Standard

TAURI for iPhone 17 Pro Max Case 6.9" with 1-Pack Screen Protector, Camera Lens Full Protection, Military-Grade Protection, Shockproof Transparent Back Bumper Phone Cover - Clear Global Recycled Standard

(0)
$10.76
FREE delivery Thu, Oct 16 on your first order
2K+ bought in past month
Loading...
TAURI for iPhone 17 Pro Case 6.3" with 1-Pack Screen Protector, Camera Lens Full Protection, Military-Grade Protection, Shockproof Transparent Back Bumper Phone Cover - Clear Global Recycled Standard
Best Seller

TAURI for iPhone 17 Pro Case 6.3" with 1-Pack Screen Protector, Camera Lens Full Protection, Military-Grade Protection, Shockproof Transparent Back Bumper Phone Cover - Clear Global Recycled Standard

(61,696)
$10.76
Prime
2K+ bought in past month
Loading...
JOINPAYA 1Set Rechargeable Hand Warmer Hand Heater for Winter Heating Levels Compact

JOINPAYA 1Set Rechargeable Hand Warmer Hand Heater for Winter Heating Levels Compact

(0)
$9.29
FREE delivery Jun 20 - Jul 4
Loading...
Shakven Rechargeable Hand Warmer | Cute Comfortable Portable Hand Warmers,Ergonomic Adjustable Energy-Efficient Small Heater for Travel, Outdoor, Winter

Shakven Rechargeable Hand Warmer | Cute Comfortable Portable Hand Warmers,Ergonomic Adjustable Energy-Efficient Small Heater for Travel, Outdoor, Winter

(0)
$26.93
FREE delivery Jun 19 - Jul 2
Loading...
OCOOPA IP45 Waterproof Hand Warmer Rechargeable, Up to 15hrs Heat,10000mAh Durable Quick Charge Electric Hand Heater, PD Compatible, 3 Levels for Outdoors, Heavy Duty, H01-PD PRO

OCOOPA IP45 Waterproof Hand Warmer Rechargeable, Up to 15hrs Heat,10000mAh Durable Quick Charge Electric Hand Heater, PD Compatible, 3 Levels for Outdoors, Heavy Duty, H01-PD PRO

(50)
$39.99
PrimeFREE delivery Sat, Jun 14
Loading...
OCOOPA IP45 Waterproof Hand Warmer Rechargeable, Up to 15hrs Heat,10000mAh Durable Quick Charge Electric Hand Heater, PD Compatible, 3 Levels for Outdoors, Heavy Duty, H01-PD PRO

OCOOPA IP45 Waterproof Hand Warmer Rechargeable, Up to 15hrs Heat,10000mAh Durable Quick Charge Electric Hand Heater, PD Compatible, 3 Levels for Outdoors, Heavy Duty, H01-PD PRO

(649)
$39.99
PrimeFREE delivery Sat, Jun 14