The Genealogy & Family History Social Network

Excel Family History Program

Information

How to get the most out of the program Microsoft Excel in a family history project

Members: 57
Latest Activity: Feb 20, 2014

Name change

Was called Database. I have changed to Program to cover wider aspects of use of Excel for genealogical work. Also this avoids clash with Database group set up by Keith Bage.

Discussion Forum

Converting gedcom to excel? 3 Replies

Started by Alaine Keisling. Last reply by Sue Mastel Oct 9, 2009.

Recent article in the Journal of the Genealogical One-Name Society about spreadsheets 4 Replies

Started by WibblingJo. Last reply by WibblingJo Jul 19, 2009.

Creating drop charts in Excel 3 Replies

Started by Brian Woolvett. Last reply by WibblingJo Jul 18, 2009.

View All

Comment Wall

Comment

You need to be a member of Excel Family History Program to add comments!

Comment by William Douglas on August 24, 2009 at 10:11am: Microsoft has a section for genealogy templates. Not much for Excel, but...

http://office.microsoft.com/en-us/templates/results.aspx?qu=genealogy&sc=4&av=TPL

...might be worth looking at.

William
www.douglashistory.co.uk

Comment by Sue Gover on July 13, 2009 at 10:09am: Thanks Wendy, I'm only about 5 miles from Woolmer Green where Herts FHS meet, but as I have no known Herts ancestors I'm not a member & don't go to meetings. I could go because our local (Stevenage) FHS is afilliated, but meetings are always on Saturdays when I am expected to ditch Family History & spend quality time with my husband. He's not a fan unfortunately.
Sue

Comment by Wendy Archer on July 13, 2009 at 8:15am: Sue -

Herts FHS has a computer group which meets monthly - I haven't looked up how far away you are from their meeting venue, but their meetings might be helpful. http://www.hertsfhs.org.uk/hfphs43.html Certainly at Oxfordshire FHS we have computer help and chat at our meetings. Firefox is a browser instead of IE - http://www.mozilla-europe.org/en/firefox/

Wendy

Comment by Sue Gover on July 13, 2009 at 7:06am: I use Excel a lot for my family history, and have several large databases with multiple sheets. But I'm sure I do a lot of things the long way round, and would love some tips to get more out of the programme.
I did read the document in the GOONS journal & have used it to make a Free BMD spreadsheet, but like a lot of GOONS articles I found some of it hard to follow, & it mentioned a lot of things like Firefox which I had never heard of, never used before & didn't know what they were for. Perhaps someone could explain.
Sue

Comment by John Keith Coldwell on July 12, 2009 at 10:34am: Derek
As it happens there is an article in the Journal of One-Name Studies Vol 10 issue 3 July-Sept 2009 entitled Computing for beginers - spreadsheets which covers Excel. See www.one-name.org. The Journal is available in some libraries.

Comment by Derek Ive on July 12, 2009 at 7:09am: I have never used Excel for any genealogical work, but would love to know what you use it for? Might help me reduce my huge files of paper!!