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 Updated 2020
[ Ссылка ]
🔴 Extract and Filter City Directories Using Excel
[ Ссылка ]
🔴 Extracting Census Data into Excel to Find More Ancestors: Tiny Tip Clip
[ Ссылка ]
🔴 Organizing DNA Cousin Matches Using Excel Spreadsheets
[ Ссылка ]
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
[ Ссылка ]
📝📝📝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. [ Ссылка ].
As a Channel Member, find the handouts by scrolling through the blog posts on the Community tab at [ Ссылка ].
📝 2) All handouts can be PURCHASED INDIVIDUALLY ($5 and up) at [ Ссылка ]. 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. [ Ссылка ]
❤️BECOME A GENEALOGY TV CHANNEL MEMBER and help support Genealogy TV - see perks!
[ Ссылка ]
👉 Subscribe to Genealogy TV
[ Ссылка ]
🛍️ Genealogy TV’s AMAZON STORE full of Connie’s favorites. [ Ссылка ] (Amazon Affiliate)
✅ Genealogy TV WEBSITE
[ Ссылка ]
✅ GTV on FACEBOOK
[ Ссылка ]
✅ SIGN UP For GTV’s NEWSLETTER
[ Ссылка ]
🌳 Subscribe to Ancestry.com (affiliate) [ Ссылка ]
📰 Subscribe to Newspapers.com (affiliate)
[ Ссылка ]
❤️ TIP JAR - If you like the videos, please consider becoming a Patreon member.
[ Ссылка ]
📰 Subscription to NEWSPAPERS.com (affiliate)
[ Ссылка ]
▶️ SUBSCRIBE to NC ANCESTRY (North Carolina Ancestry) at
[ Ссылка ]
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
[ Ссылка ]
