Learn how to use Excel for Genealogy. This episode shows how to use Excel and some tricks to using it for genealogy. Here I show how to edit, color, move, delete, insert cells, rows, columns and more. Learn different reasons to use Excel for family history, like outlining DNA matches, extracting data from indexes so it can be filtered to your answers or research questions, and correlating evidence. This is a great video for beginners and intermediate Excel users alike. It is a step by step process of how to use Excel. If I can do it, you can too!

OTHER VIDEOS
#1 Way to Break Down Brick Walls (uses Excel to extract census).
   • #1 Way to Break Down Brick Walls  Tr...  

#1 Way to Break Down Brick Walls Updated 2020
   • #1 Way to Break Down Brick Walls: Upd...  

Extract and Filter City Directories Using Excel
   • Extract Ancestors from City Directori...  

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

Organizing DNA Cousin Matches Using Excel Spreadsheets
   • Organizing DNA Cousin Matches using E...  

TIMING
0:00 Intro
0:18 Why use Excel?
2:33 How you can use Excel
3:33 Using Excel for DNA Matches
5:58 FAN Club worksheet and filtering
8:28 Handouts and how to get them
9:52 How to use Excel for Genealogy
10:20 Basic template for correlating evidence
10:51 Cell width formatting
11:50 Expanding cells for notes
13:30 Creating a source hyperlink
15:24 Save early save often
16:34 Undo and redo button options
17:30 Moving cells
17:52 Cell handle to copy/drag/delete
18:12 Insert a column
20:44 Create a filter
22:21 Extracting census record data
25:09 Highlighting/coloring cells
30:00 Conditional formatting for DNA matches
33:39 Birth year calculation formula
34:29 Correcting infant birth year
38:20 This equals that formula

❤ JOIN the GENEALOGY TV ACADEMY
https://genealogytv.org/aboutgenealo...

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.'>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/C....

2) All handouts can be PURCHASED INDIVIDUALLY ($5 and up) at https://genealogytv.org/handouts/.'>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.   / genealogytv  

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

Subscribe to Genealogy TV
   / @genealogytv  

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

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

✅ GTV on FACEBOOK
  / genealogytv  

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

Subscribe to Ancestry.com (affiliate) https://prf.hn/click/camref:1101l4aFW...

Subscribe to Newspapers.com (affiliate)
https://www.anrdoezrs.net/click91101...

❤ TIP JAR If you like the videos, please consider becoming a Patreon member.
  / genealogytv  

Subscription to NEWSPAPERS.com (affiliate)
https://www.anrdoezrs.net/click91101...

▶ SUBSCRIBE to NC ANCESTRY (North Carolina Ancestry) at
   / 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. Learn 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.

Best YouTubers for genealogy are Genealogy TV, The History Guy, Aimee Cross Genealogy Hints, Family History Fanatics, Geneavlogger, Legacy Tree Genealogy, , Ancestry, FamilySearch, Useful Charts, Dear Myrtle, Genealogy with Amy Johnson Crow, 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/b...