gasratm.blogg.se

Using excel for timelines in genealogy
Using excel for timelines in genealogy












using excel for timelines in genealogy
  1. Using excel for timelines in genealogy how to#
  2. Using excel for timelines in genealogy series#

If this looks too complicated, don’t panic, I’m going to break it down for you and show you several different options so you can choose the best fit for you. I’ll give you some tips about each option. Now we have multiple options, everything from a simple research notebook to complex computer programs.īelow is what a basic research log looks like, courtesy of. If you’re new to the world of family history research, a research log is where you simply record what you’re looking for, where you looked, and what you found.īefore the computer age, genealogists kept these logs by hand. For more about the process of researching difficult problems in your family tree, check out my book, Research Like a Pro: A Genealogist’s Guide. If I’m searching land records on microfilm or browsing an entire county in a census, I don’t want to repeat that search and I want to record it somewhere safe. Instead I like to use a simple research notebook to keep track of the family I’m working on and what I need to search.īut what about those more difficult research projects where I’m trying to break through some brick walls in my family history? That is where a research log comes in handy. When I work on the collaborative Family Tree attaching record hints and doing easy searches for sources, I don’t fill out a formal research log. I don’t want to spin my wheels looking for the same information over and over because I neglected to record searches. Efficiency is key with a limited amount of hours in the day. I’m continually looking for ways to make better use of my research time. Now we have the collaborative Family Tree on FamilySearch, record hinting, the ability to attach sources with a few clicks of our mouse, need I go on? Searching for our ancestors has never been easier, and organizing our research should be getting easier, right? Or do the many options available just paralyze us and we do nothing? When I first started research in 2003, I kept all of my documents in paper file folders, my family tree on PAF (Personal Ancestral File) and was new. This course is unique in that the weekly assignments are completed in-application (i.e., on your own computer in Excel), providing you with valuable hands-on training.Family History work has come a long way in the last twelve years. To pass each module, you'll need to pass a mastery quiz and complete a problem solving assignment. The course is organized into 5 Weeks (modules).

using excel for timelines in genealogy

I hope for you to at least several times in the course say to yourself, "Wow, I hadn't thought of that before!" Given the wide range in experience and abilities of learners, the goal of the course is to appeal to a wide audience. This course is meant to be fun and thought-provoking.

Using excel for timelines in genealogy how to#

In this course (Part 2), you will: 1) learn advanced data management techniques 2) learn how to implement financial calculations in Excel 3) use advanced tools in Excel (Data Tables, Goal Seek, and Solver) to perform and solve "what-if" analyses 4) learn how to create mathematical predictive regression models using the Regression tool in Excel.

Using excel for timelines in genealogy series#

This course is the second part of a three-part series and Specialization that focuses on teaching introductory through very advanced techniques and tools in Excel.

using excel for timelines in genealogy

By the end of this course, you will have the skills and tools to take on the project-based "Everyday Excel, Part 3 (Projects)". This course is aimed at intermediate users, but even advanced users will pick up new skills and tools in Excel. Building on concepts learned in the first course, you will continue to expand your knowledge of applications in Excel. "Everyday Excel, Part 2" is a continuation of the popular "Everyday Excel, Part 1".














Using excel for timelines in genealogy