|
Spreadsheet Tricks for Genealogists
Pamela K. Boyer, CG, CGL
Most genealogists use only the minimum of features in their spreadsheet program. This lecture focuses on
learning to use a spreadsheet to record genealogical facts and sort them in new and revealing ways. It shows
the ease with which "advanced" features most users never discover can be used, from inserting a chart, to creating
custom maps of family migration with Excel's mapping tool. We also reveal the "secrets" of creating headers and
footers for your spreadsheet, and easily merging selected information from your spreadsheet into a word processing document.
Many practical uses of a spreadsheet for genealogical research and analysis are demonstrated in this lecture, with
easy-to-follow steps. While the lecturer uses Microsoft Excel, most of the "tricks" can be performed in any
Windows-based or Macintosh spreadsheet.
|