Extracting Census Data into Excel to Find More Ancestors: Tiny Tip Clip

Learn how to break down genealogical brick walls by extracting data from census records to find additional families in the community where your ancestors lived. This is demonstrated on Ancestry but can be used on FamilySearch and MyHeritage. This is a clip from the original episode was #1 Way to Break Down Brick Walls: Updated 2020.

OTHER VIDEOS
🔴 #1 Way to Break Down Brick Walls: Updated 2020
https://youtu.be/wnI8Np_J4WE

🔴 Find More Ancestors by Extracting Census Data into Google Sheets
https://youtu.be/qgSSYl5oJdU

🔴 Obituaries: Finding Facts, Clues, Leads, Sources, and Research Questions in an Obituary
https://youtu.be/orXNn_YiQuE

🔴 Searching Private Trees on Ancestry: Tiny Tip Clip
https://youtu.be/QmDytH6HChY

TIMING
0:00 Intro
0:15 How much to extract?
1:36 Highlighting & Copying the Data
1:57 Using Paste Special in Excel
2:23 How to insert a column in Excel
2:52 How to delete multiple rows in excel
3:30 How to copy data from one cell to another in excel automatically
4:00 Adding the second page
5:51 Midroll
6:02 How to filter rows in Excel
6:51 Using your filter for surnames
8:16 Filtering by gender
8:37 How Excel handles fractions
9:13 Digging deeper
10:05 Handout Info
10:54 Outro

❤️BECOME A GENEALOGY TV CHANNEL MEMBER and help support Genealogy TV - see perks!
https://www.youtube.com/genealogytv/join

👉 Subscribe to Genealogy TV
https://www.youtube.com/channel/UCcvpi8XvOScBogIxmarmADw/Subscribe

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

✅ GTV on FACEBOOK
https://www.facebook.com/Genealogytv/

✅ SIGN UP For GTV’s NEWSLETTER
https://mailchi.mp/a0862c6473aa/genealogytvnewsletter

❤️ NEED HELP? Get coaching.
https://genealogytv.org/virtual-private-coaching/

🌳 Subscription to Ancestry.com (affiliate) https://prf.hn/click/camref:1101l4aFW/creativeref:1011l28781

📰 Subscription to Newspapers.com (affiliate)
https://www.anrdoezrs.net/click-9110145-11504323

Genealogy TV’s Amazon Store full of Connie’s favorites. https://www.amazon.com/shop/genealogytv (Amazon Affiliate)

📝📝📝THREE DIFFERENT WAYS to find the HANDOUTS!

📝 1) Become a CHANNEL MEMBER at the INFO ACCESS level $9.99 per month. This gets you all the handouts. https://www.youtube.com/genealogytv/join.
As a Channel Member, find the handouts by scrolling through the blog posts on the Community tab at https://www.youtube.com/GenealogyTV/Community.

📝 2) All handouts can be PURCHASED INDIVIDUALLY ($5 and up) at https://genealogytv.org/handouts/. Here you will get a redirect and an email to download the handouts.

📝 3) Become a monthly PATRON at the HAPPY DANCE level ($15/Month) or more. You will get early release of the videos and the handouts are emailed to you, when they become available. https://www.patreon.com/GenealogyTV

❤️ TIP JAR - If you like what you see and wish to help support Genealogy TV or NC Ancestry, please consider becoming a Patreon member. Thank you!
https://www.patreon.com/GenealogyTV

🌳 Subscription to ANCESTRY.com (affiliate) https://prf.hn/click/camref:1101l4aFW/creativeref:1011l28781

📰 Subscription to NEWSPAPERS.com (affiliate)
https://www.anrdoezrs.net/click-9110145-11504323

🛍️ Genealogy TV’s AMAZON STORE full of Connie’s favorites. https://www.amazon.com/shop/genealogytv (Amazon Affiliate)

▶️ SUBSCRIBE to NC ANCESTRY (North Carolina Ancestry) at
https://www.youtube.com/ncancestry

I am a fanatic for genealogy, family history and DNA to research my American ancestors. I create the best free genealogy videos and webinars on YouTube. I teach the genealogy research skills to help you with your family tree and family origins. I am a professional genealogist; I teach research skills and records research. The best videos on “Genealogy TV” (YouTube) are about learning research notes, logs, staying organized, genetic genealogy, finding missing ancestors, and where to find family history records. Learn genealogy for free and how to research on Ancestry.com, FamilySearch.org, MyHeritage.com, FindMyPast.com, FamilyTreeDNA, AncestryDNA, 23andMe, Wiki Tree, Geni, National Genealogical Society, National Archives, National and State Archives, genealogical and historical societies genealogybank.com, Chronicling America, Newspapers.com, Newspaper Archives.com, Fold3, Archive.org, Internet Archive, Wayback Machine, Digital Public Libraries, Google, Google Books, Google News, Facebook genealogy groups, and the very best genealogy websites and resources.
Best YouTubers for genealogy are Genealogy TV (of course), The History Guy, Ancestral Findings, Family History Fanatics, Geneavlogger, Legacy Tree Genealogy, Genealogy TV (of course), Ancestry, FamilySearch, Useful Charts, Dear Myrtle, and 23andMe.
#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/

Видео Extracting Census Data into Excel to Find More Ancestors: Tiny Tip Clip канала Genealogy TV