How to Link Two Excel Files | External Reference Tutorial for LSD and ANOVA Data
In this video, you’ll learn how to create and link two Excel files — one for LSD (Least Significant Difference) and another for ANOVA data.
I will use external references (linking) in Excel so that whenever you add a new trait or update any data in the ANOVA file, the linked LSD file updates automatically and recalculates the results.
In this video, you’ll learn:
• What is an external reference in Excel
• How to create a separate LSD file for multiple traits
• How to link cells between LSD and ANOVA files
• How to make Excel automatically update linked data
This video is for all, especially useful for students and researchers in agriculture, plant breeding, and data analysis who work with LSD and ANOVA results in Excel.