The next Best of Elizabeth Shown Mills, CG, CGL series webinar is on Friday (a members-only event). Learn more here. 

The next Best of Elizabeth Shown Mills, CG, CGL series webinar is on Friday (a members-only event). Learn more here. 

By
By
Webinar Library
Bonus webinars Software Excel Technology Spreadsheets

Spreadsheets 301 – un-Excel-ed Tips and Tricks (BONUS webinar for subscribers)

Mary Kircher Roddy, CG
Aug 27, 2015
7.7K views
Advanced
Want to watch the full webinar?
Join now to access all 2,309 webinars and unlock all features.
Join now
Syllabus
Join now

Content

Play. Playing.
Introduction
53s
Play. Playing.
Magic Corner
2m 29s
Play. Playing.
Magic Fill for Common Patterns
1m 23s
Play. Playing.
Copy Versus Move
1m 31s
Play. Playing.
Heading Over Multiple Columns
5m 04s
Play. Playing.
Filtering
4m 19s
Play. Playing.
Importing Data
11m 49s
Play. Playing.
Smart Sorting
4m 40s
Play. Playing.
Formulas
11m 13s
Play. Playing.
Math With Words
1m 20s
Play. Playing.
Format Painter
2m 23s
Play. Playing.
Transpose
2m 50s
Play. Playing.
Google Drive
4m 17s
Play. Playing.
Pulling It All Together
7m 26s

About this webinar

Learn new ways to make data entry faster and easier and a few things that will make your spreadsheets more attractive. See how quickly Magic Fill will help you complete a list and watch Mary turn a spreadsheet "on it's ear" to filp rows and columns. Learn how to "add" words (and a few numbers, too) and more.

About the speaker

About the speaker

Mary Kircher Roddy, CG
Mary Kircher Roddy, CG became interested in family history in 2000 in anticipation of her husband’s sabbatical at the University of Limerick in Ireland. While she didn’t learn everything about her ancestors while they lived there, she was hooked!
Learn more...

Comments

Your email address will not be published. Required fields are marked *

1000 characters remaining
Cancel Submit

Sort by Newest
Sort by Close.
  • Newest
  • Oldest
  • Likes

Related Webinars

1:33:42
SoftwareTechnology
Spreadsheets 401 : Excel-lent Inspiration
Mary Kircher Roddy, CG
7.1K views
CC
Spreadsheets 401 : Excel-lent Inspiration
Take a trip with spreadsheets to the lands of your ancestors. Learn how spreadsheets can help as you learn to read foreign language newspapers. Use spreadsheets as a translation tool for your ancestors' vital and religious records. Create a spreadsheet to track your ancestors and those great ethnic or locality…
SoftwareTechnology
Spreadsheets 401 : Excel-lent Inspiration
CC
Mary Kircher Roddy, CG
7.1K views
Take a trip with spreadsheets to the lands of your ancestors. Learn how spreadsheets can help as you learn to read foreign language newspapers. Use spreadsheets as a translation tool for your ancestors' vital and religious records. Create a spreadsheet to track your ancestors and those great ethnic or locality…
Wed, February 27 2019: 0:00 UTC
Register for free
1:07:59
Bonus webinarsSoftwareTechnology
Spreadsheets 201 – Excel-lent Examples (BONUS webinar for subscribers)
Mary Kircher Roddy, CG
12.5K views
Spreadsheets 201 – Excel-lent Examples (BONUS webinar for subscribers)
Spreadsheets can help you analyze your genealogy data and keep track of your research. In this webinar, Mary Roddy teaches how to use this powerful tool to gain perspective and further your genealogy research. You'll also learn how to quickly take search results from Familysearch and…
Bonus webinarsSoftwareTechnology
Spreadsheets 201 – Excel-lent Examples (BONUS webinar for subscribers)
Mary Kircher Roddy, CG
12.5K views
Spreadsheets can help you analyze your genealogy data and keep track of your research. In this webinar, Mary Roddy teaches how to use this powerful tool to gain perspective and further your genealogy research. You'll also learn how to quickly take search results from Familysearch and…
Thu, April 16 2015: 0:00 UTC
Login to register (for webinar members)
Login to register (for webinar members)
1:13:25
Bonus webinarsSoftwareTechnology
Spreadsheets 101 – Excel-lence in Genealogy (BONUS webinar for subscribers)
Mary Kircher Roddy, CG
16.6K views
CC
Spreadsheets 101 – Excel-lence in Genealogy (BONUS webinar for subscribers)
Are you afraid of spreadsheets because you don't know how or where to start? Or are you comfortable with spreadsheets but know there's a trick or two still to learn? In this webinar, Mary Kircher Roddy will get beginners up to speed, and share with experienced users tricks she's learned…
Bonus webinarsSoftwareTechnology
Spreadsheets 101 – Excel-lence in Genealogy (BONUS webinar for subscribers)
CC
Mary Kircher Roddy, CG
16.6K views
Are you afraid of spreadsheets because you don't know how or where to start? Or are you comfortable with spreadsheets but know there's a trick or two still to learn? In this webinar, Mary Kircher Roddy will get beginners up to speed, and share with experienced users tricks she's learned…
Tue, February 24 2015: 0:00 UTC
Login to register (for webinar members)
Login to register (for webinar members)
1:27:13
Places and EthnicitiesAfrican DiasporaSoftware
Documenting, Organizing, and Analyzing Plantation Enslaved Persons
Ari Wilkins
706 views
CC
Documenting, Organizing, and Analyzing Plantation Enslaved Persons
Keeping track of hundreds of enslaved persons can be an overwhelming task. This lecture will offer suggestions for organizing and analyzing enslaved persons' information using spreadsheets.
Places and EthnicitiesAfrican DiasporaSoftware
Documenting, Organizing, and Analyzing Plantation Enslaved Persons
CC
Ari Wilkins
706 views
Keeping track of hundreds of enslaved persons can be an overwhelming task. This lecture will offer suggestions for organizing and analyzing enslaved persons' information using spreadsheets.
Fri, March 4 2022: 19:00 UTC
Register for free
2:34
Bonus webinarsSoftwareTechZone
Microsoft Excel tip: Paste Special
Thomas MacEntee
932 views
Microsoft Excel tip: Paste Special
Copying a table of numbers or text into a Microsoft Excel Spreadsheet often has messy results. Understand how the Paste Special function can strip out unnecessary formatting saving you time and frustration!
Bonus webinarsSoftwareTechZone
Microsoft Excel tip: Paste Special
Thomas MacEntee
932 views
Copying a table of numbers or text into a Microsoft Excel Spreadsheet often has messy results. Understand how the Paste Special function can strip out unnecessary formatting saving you time and frustration!
Sun, December 29 2019: 0:00 UTC
Login to register (for webinar members)
Login to register (for webinar members)
2:06
Bonus webinarsSoftwareTechZone
Microsoft Excel tip: Adding a Line Within a Cell
Thomas MacEntee
972 views
Microsoft Excel tip: Adding a Line Within a Cell
What happens when you hit “Enter” when typing within a cell in a spreadsheet? You end up in a new cell. So how do you create a new line within a cell? Learn the secret shortcut for a Line Break in Microsoft Excel!
Bonus webinarsSoftwareTechZone
Microsoft Excel tip: Adding a Line Within a Cell
Thomas MacEntee
972 views
What happens when you hit “Enter” when typing within a cell in a spreadsheet? You end up in a new cell. So how do you create a new line within a cell? Learn the secret shortcut for a Line Break in Microsoft Excel!
Sun, December 29 2019: 0:00 UTC
Login to register (for webinar members)
Login to register (for webinar members)
2:25
Bonus webinarsSoftwareTechZone
Microsoft Excel tip: Linking Without Making a Mess
Thomas MacEntee
1.2K views
Microsoft Excel tip: Linking Without Making a Mess
Sometimes you want to link to an Ancestry record or FamilySearch image within a Microsoft Excel spreadsheet. Often you end up with a long URL in a weird font. Learn how to create a link to an external file or website without creating a mess.
Bonus webinarsSoftwareTechZone
Microsoft Excel tip: Linking Without Making a Mess
Thomas MacEntee
1.2K views
Sometimes you want to link to an Ancestry record or FamilySearch image within a Microsoft Excel spreadsheet. Often you end up with a long URL in a weird font. Learn how to create a link to an external file or website without creating a mess.
Sun, December 29 2019: 0:00 UTC
Login to register (for webinar members)
Login to register (for webinar members)
1:08:18
Writing and PublishingTechnology
Meaningful Tables and Graphs for Correlation in Family History
Ruth Wilson Craig, CG
5.8K views
CC
Meaningful Tables and Graphs for Correlation in Family History
The objective of this webinar is to give viewers concrete examples of how tables and graphs can be used in family history reports and presentations.
Writing and PublishingTechnology
Meaningful Tables and Graphs for Correlation in Family History
CC
Ruth Wilson Craig, CG
5.8K views
The objective of this webinar is to give viewers concrete examples of how tables and graphs can be used in family history reports and presentations.
Wed, September 25 2019: 0:00 UTC
Register for free
1:37:51
DNA TestingSoftware
Organizing Your Genetic Genealogy
Diahan Southard
15.4K views
CC
Organizing Your Genetic Genealogy
In this one-of-a-kind lecture we will discuss various methods for keeping track of your DNA matches- especially your autosomal DNA matches. We will first discuss what kind of information you need to keep track of, and why. We will cover the basics of Excel, Word, email folders and correspondence. We…
DNA TestingSoftware
Organizing Your Genetic Genealogy
CC
Diahan Southard
15.4K views
In this one-of-a-kind lecture we will discuss various methods for keeping track of your DNA matches- especially your autosomal DNA matches. We will first discuss what kind of information you need to keep track of, and why. We will cover the basics of Excel, Word, email folders and correspondence. We…
Wed, November 11 2015: 0:00 UTC
Register for free