There are those people who have an extensive family history that they’ll want to share it with the future generation of family members. If they want to do that, then they’ll need something that contains information on all of the previous generations and how they were all connected to one another.
That’s why they create family trees in the event one wishes to learn all about his/her lineage. This article will teach you all that you need to know in regards to how you can create your own family tree in Excel.
Remember that the point of a family tree is for it to provide extensive knowledge on a person’s family history. So should you make one, you must learn about the basic elements to ensure that the family tree contains all the information it needs. The elements of a family tree would be the following:
1. Title: You’ll most likely create more than one family tree as you’ll most likely want to have separate ones that focus on different generations. So what you’ll need to do is to come up with an appropriate title for each of them. It’s important that the title has something to do with the contents of the family tree. For example, if you’re going to make a family tree that covers five generations, then you’ll want the title to consist of your last name and the number of generations whose information is being shared.
2. Names: The names that you will place into the document will depend on the generations that your family tree document will be covering. Make sure that you write down the first, last, and middle name of each person you will be including. Also, be sure to check that they are all spelled correctly as you don’t want to be presenting readers with the wrong information.
3. Date of birth/death: For every name that you put into the family tree, you’ll also have to include their date of birth and the date in which they have passed away. Make sure that you put in the exact month, day, and year for either so that there won’t be any questions regarding “when”.
4. Relationship ties: Those who go through your family tree chart will want to know the relations of each and every single person in the document. That’s why you’ll have to make it clear as to who is tied in with who. Point out things like who your mother and father are if you have any siblings, uncles, and aunts that made their way into the family, etc.
1. Make use of Microsoft Excel: Take note that it’s highly recommended that you use Microsoft Excel as it has generally been accepted as the standard program for making just about any documents in the Excel format. Once you have access to the program, then here’s what you’ll need to do:
You may use other alternative Excel programs should you not have access to Microsoft Excel. Just know that the process for creating the document will most likely differ.
2. Create your family tree: Now that you know how to use Microsoft Excel to create one, you still have to put in the information it needs. So here are the things that you’ll need to do:
We have more information on family trees and how to make them. All you have to do is to visit our site and search for those articles with the information you need.
Although there is no limit to how many you can place, you want to make sure that you can fit them all into the document. You may just have to make separate sheets or you can just focus on a particular generation to guarantee that everything fits into one sheet.
If the internet cannot help you, then you’ll have to directly ask your other family members for help. They will most likely have all of the information you’ll need. Just make sure to compare the information you’ve gathered from different sources to see if there are any inconsistencies.
Use the information this article has presented you to guarantee that you create a family tree that properly covers the history you want it to present.