View More
View Less
System Message
My Schedule
An unknown error has occurred and your request could not be completed. Please contact support.
Wait Listed
Personal Calendar
Conference Event
There aren't any available sessions at this time.
Conflict Found
This session is already scheduled at another time. Would you like to...
Please enter a maximum of {0} characters.
{0} remaining of {1} character maximum.
Please enter a maximum of {0} words.
{0} remaining of {1} word maximum.
must be 50 characters or less.
must be 40 characters or less.
Session Summary
We were unable to load the map image.
This has not yet been assigned to a map.
Search Catalog
Replies ()
New Post
Microblog Thread
Post Reply
Your session timed out.
This web page is not optimized for viewing on a mobile device. Visit this site in a desktop browser to access the full set of features.
RootsTech 2016

LAB2636-S - Fun with Excel - Manipulate Your Genealogy Data (S)

Session Description

A comma separated value (csv) file simply stores data and exchanges that data between programs. You can save much of your data from genealogy database programs into a csv file (who knew?) or download data from various websites to use with your genealogy. Let’s explore how to use the most popular spreadsheet program, Microsoft Excel, with your genealogy. Whether for your personal family history or a special genealogy project, genealogy and spreadsheets are a great combination. How Excel Workbooks compare to Google Spreadsheets 15 Tips for Your Excel Workbooks Using Properties Preparing Instructions Working with columns and rows Understanding the "date issue" Setting up your worksheets to mirror documents Making it clear and colorful with Labels & Colors Entering data in Excel cells Checking your work (quality control) Learning to use some basic formulas and macros Transposing to save yourself time and effort Downloading data from websites Filtering and Sorting Saving your workbook Publishing and Sharing Using a workbook with a specialized genealogy project.

This computer lab is also taught on Thursday at 4:30 p.m.

Session Speakers
Additional Information
Computer Lab
1 hour
Similar Sessions