Abstract: The paper introduces a kind of complex number calculations tool，Excel .Compared with other tools, such as Matlab and Labview, Excel is expediently to operate, easy to provide control interfaces, abundant functions, and suitable for non-programmer to calculate complex number. In order to solve the problems presented in the open/short compensation during impedance measurement, a method for the open and short compensation of using Microsoft Excel 2007 is provided. This method is easy to learn, which is without fussy program. It is possible to spread the method in the following years.

Key words: Impedance Measurement, Complex number calculations, Open/short compensation, Excel