iFamily History: Instructions in Excel for a Surname Table

Family History Fanatics have a YouTube channel with training videos. Devon has a video training on a Surname Table, shown below.

The video explains how to use it and why but she does not explain how to make it in Excel.

With Devon's permission, I created a four (4) page pdf document explaining how to create her document in Excel.

Watch the video [link below] to hear Devon explain what this is and why it will help you in your family history research.
https://www.youtube.com/watch?v=oOshdUcsoK4

Click below to download the pdf document with the instruction on how to recreate your own Surname Table.

Excel Instructions for Surname Table

These instructions may also help you create other genealogical tables you would like to use.

About Lianne Kruger

Genealogy

I researched my paternal grandmother's line to the first three white landowners of Canada in the 80's. I began genealogy going on genealogy trips in Ontario, England, and Scotland at graveyards with my mother starting at age 7 on. As a teenager, I sat in front of a microfilm reader with a list of names every Saturday at an FHL while my mother volunteered helping others.

I have spoken at Genealogical conferences and sessions at RootsTech (UT), FamilyRoots (UT), The Genealogy Show (in Birmingham, UK) as well as in Alberta, Saskatchewan, Ogden, and Ontario.

Click on My Speaking Experience for session titles.

I have articles published on BYU Studies Quarterly magazine website and FamilySearch as well as AGS Relatively Speaking and Tree Climber.

Click on My Publications for complete list.