利用Excel编制育种数据清单

编制育种数据清单是育种的前提准备工作。文中分享了使用电子表格Microsoft Excel编制育种数据清单的几个小技巧。Excel中“if”、“ vlookup”、“rand”、“=”、“ &”、“$”等函数及符号,以及一些菜单命令的巧用,可以快速、准确地得到育种数据清单。

Processing Breeding Data Listings in Excel

Processing breeding data listings was the precondition of breeding. Currently, Microsoft Excel was mainly and widely used to process breeding data listings. In this article, a few tips were shared by using Microsoft Excel to process breeding data listings. In excel, opportunely using some of the menu commands, functions and symbols, such as "if", "vlookup", "rand", "=", "&", "$" and so on, the breeding data listing with detailed information could be quickly and accurately obtained. As processing breeding data listings in excel, the use of some functions and commands that could help to solve the continuity and correlation of breeding data listings should be especially noticed, in order to solve the problems of processing breeding data listings.