Organize DNA Cousin Matches with Excel 📊

Learn how to map out your DNA cousins matches using an Excel spreadsheet and how to use Conditional Formatting to find the hot zones. I’ve had a lot of comments from viewers who wanted to learn how I did this, so I’m showing you step by step how to build this spreadsheet.

🧬 Grouping DNA Cousin Matches on Ancestry: https://www.youtube.com/watch?v=ErWHYCLjjxM

📃 There is a HANDOUT for INFO ACCESS level Channel Members. Channel Members can find the handouts in the Community Tab on the YouTube channel. Look for the words HANDOUT in the blog posts.
📃 This HANDOUT can also be found here https://genealogytv.org/product/handout-organizing-dna-cousins-using-excel-spreadsheets/

JOIN the CHANNEL MEMBERSHIP at the Information Access level to get the handout. https://www.youtube.com/GenealogyTV/join

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

TIMING
0:00 Intro
1:18 My DNA Cousins Spreadsheet
1:46 Using DNA spreadsheets to break down brick walls
4:05 Intro to making your spreadsheet
5:38 Example
6:15 Labeling and entering your most recent common ancestor(s)
7:18 Sorting descendants
8:25 Reminder - not all descendants have DNA tests!
8:45 Comparing centimorgan counts
9:00 Pedigree collapse - when cousins marry cousins
9:35 Example overview
10:39 Building your own - ancestral couple
10:57 Adding the children
11:14 Moving cells
11:26 Merge & Center your cells
11:48 Coloring Your Cells for organization
12:12 Adding the next generation
12:55 What if I have extra columns?
13:10 Copying & Pasting your cells
13:35 What if I need more columns?
14:30 Copying your spreadsheet
15:25 Removing conditional formatting
15:48 Using scales to organize
16:13 Custom scale formatting
18:15 Handout worksheet overview
18:32 Reminders for your documents
18:46 What is this best for? What is your research question?
19:05 Save Early! Save Often!
19:25 Channel member info & Outtro


* * *
❤️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

❤️ NEED HELP? Join the "Genealogy TV Insiders" coaching group or sign up for private coaching. For more info...

https://genealogytv.org/coaching-options/

❤️ 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

🆓 FREE eBOOK - How to Trace Your Family History for Free.
https://mailchi.mp/c5db92ec5df1/genealogytvfreeebook

▶️ 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

I am a fanatic for genealogy, family history and DNA to research my American ancestors . My mission is to create the best free genealogy videos and webinars on YouTube. 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, State Archives, local family history rooms, genealogical and historical societies genealogybank.com, Chronicling America, Newspapers.com, Newspaper Archives.com, Fold3, Archive.org, Internet Archive, Wayback Machine, Digital Public Libraries, National Archives, Google, Google Books, Google News, Facebook for genealogy groups, and the very best genealogy websites and resources.

Other YouTubers are 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/