摘要
总结了利用Excel进行配合力分析的实用技巧，强调利用Excel进行配合力分析要注意保持计算过程的前后关联性。提出利用“条件格式”使分析结果一目了然，利用“保护”工作表的方法防止因误操作而产生的计算错误。
The article summarized the practical skills of combining ability with Excel and emphasized the importance of keeping the relevance of computation process,It also proposed that the Analysis is clear with Conditional formatting, and prevented the miscount for operation with the method of protecting worksheet.
