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.