A Demo of our Excel Workbook for the Leeds Method with Ancestry Matches

[@tracyskegg1918]

Thanks I find your information very helpful. I now have some relatives without family history software. So I am revisiting your videos using Excel as a tool, to assist in data sharing.

[@kjw79]

Wow what a great explanation and video. Thank you very much!

[@DataMiningDNA]

Glad you enjoyed it!

[@7tracey7]

This is brilliant! Thank you. Not sure I can use it as don't have full version of Excel but still great to see

[@DataMiningDNA]

You're welcome!

[@ChristolJ]

There are a number of references to the "description below" the video for links but I don't see anything. Could these be added? I am interested in the article for your blog and workbook download.

[@DataMiningDNA]

I've added the links to the the description

[@LAYERSOFLIFE24]

I don't have Excel. I've tried opening your .xlsb file in Google Sheets but it doesn't work. Do you have a link for the DataMiningDNA in Google Sheets format?

[@DataMiningDNA]

I'm not a sheets user so unfortunately not.

[@darlenesye1609]

Does this workbook work in Open Office as is or should it be modified?

[@Disblair]

Can you please explain the advantage of going to the bother of using spreadsheets (not easy for everyone) when you can easily colour code your groups directly in Ancestry thereby achieving the same result?

[@DataMiningDNA]

Some people prefer spreadsheets. It's that simple.

[@morgansweeley6630]

Will this work for myheritage matches?

[@vancraven7688]

Excellent job

[@jaymm165]

I would be interested in using the workbook but not link here and nothing on your website. Any ideas please?

[@vonjon43]

see my comment above

[@DataMiningDNA]

I've added the links to the the description

[@audreyhughes1159]

CTL-A on my Mac is not grabbing the cm information on Ancestry?

[@DataMiningDNA]

I think the problem may be the Firefox browser? People have this problem with Firefox but it works with Chrome.

[@mattpotter8725]

You've probably worked this out by now but in case you haven't I think on a Mac it's Cmd+A whereas on Windows it's CTL+A

[@cindycuellar5645]

This is an awesome instructional demo on how to set up a Leeds chart. How do I access your workbook?

[@kimberlyfields8497]

I am trying to figure this out also

[@vonjon43]

see my comment above

[@DataMiningDNA]

I've added the links to the the description

[@jacquelinearcher1158]

Seems to be no links in the description box below as you say in the video ?

[@vonjon43]

see my comment above

[@DataMiningDNA]

I've added the links to the the description

[@victoriabrown7304]

A link for this resource would be really nice. I couldn't find anything on your website either?

[@vonjon43]

see my comment above

[@Pixiegirl1280]

@@vonjon43 which comment above?

[@DataMiningDNA]

I've added the links to the the description

[@doylemcguire1588]

? p̴r̴o̴m̴o̴s̴m̴