An interview with Robert Raymond

It was such a pleasure to interview Robert Raymond, the presenter of “Using Excel to Create Time Lines” at the 2012 National Genealogical Society Conference. Mr. Raymond is a member of the NGS Board of Directors and is Deputy for FamilySearch Chief Genealogical Officer, David Rencher. Mr. Raymond also writes an award-winning blog and the author of a family history website.

“Using Excel to Create Timelines” is an interesting topic to help genealogists place their families in historical context and to organize data in a visual format. Mr. Raymond demonstrated how to use Excel to create time lines. One of the tough situations at a conference of this type is to reach the audience about the possibilities of the software without getting bogged down in the keystrokes and menus. Mr. Raymond explained the technical aspects and also was able to convey the usefulness of this method to provide context for family history.

There are some tricks to working with Excel. Dates after 1900 are already formatted with the default settings, but Excel does not support pre-1900 dates. Mr. Raymond suggested placing dates in Excel in the typical genealogical format: 24 Oct 1881 and also making a separate column for the sortable format: 1881-10-24. There were some tricks to using years with no month or date: 1719-00-00. This sortable format will allow the time line to fill in the proper sequence.

Mr. Raymond generated many types of charts using data. He made a time line with a table where the text was oriented at a 45-degree angle.

 He also showed participants how to create an XY Scatter Graph.

 In addition, Mr. Raymond demonstrated making a bar graph from a table of data.

Mr. Raymond was so gracious to spend a few minutes from his busy time at NGS 2012 to talk about genealogical organization. If you have a chance at future conferences, look for a Robert Raymond presentation. You will certainly enjoy it and learn something new and useful!

Graphs used with permission of the author and creator, Robert Raymond.

 

 

 

If you are not at NGS, you are missing out!

This year’s National Genealogical Society Conference 2012 is fantastic! Thousands of professional and amateur genealogists meet up with dozens of experts, lecturers, and vendors to make one great gathering this year in Cincinnati, Ohio.

No matter where I sit or where I go to eat, I can spot “new friends” with a common interest and passion. I hear stories of how they started the search for their ancestors. We chat about tips and tricks and the last workshop we attended. There is much common ground here. Genealogists are a unique breed of historians, archivists, and hoarders.  We love libraries and collections. We are fascinated by dating photos and the newest genealogical software. It’s a wonderful place to come to improve your skills and learn new things.

With registration and payment, you receive electronic (pdf) syllabi of all of the presentations. There is a wealth of knowledge there to keep you busy until the next conference. This year there were a few workshops on subtopics related to genealogical organization. I interviewed Robert Raymond on the topic of “Using Excel to Create Timelines”. And I interviewed Alvy Ray Smith on his presentation, “Advanced Word: Automatic Numbering for Genealogies”. Those interviews and tips from the presenters will appear as future blog postings. Sign up for the RSS feed so that you don’t miss it!

The 2013 conference is from May 8-11 in Las Vegas, Nevada. I hope to see you there!