OBJECTIVETo provide an easy computational tool for evaluating the health condition of local residents.

METHODSAn abridged life table was programmed by applying mathematical functions and formula in Excel program and tested with the real study data to evaluate the results computed.

RESULTSThe Excel was capable of computing group death probability of age in the life table ((n)q(x)), number of survivors (l(x)), number of death ((n)d(x)), survival per person-year ((n)L(x)), survival total per person-year (T(x)) and life expectancy (e(x)). The calculated results were consistent with those by SAS.

CONCLUSIONThe abridged life table constructed using Microsoft Excel can conveniently and accurately calculate the relevant indices for evaluating the health condition of the residents.