There are a lot of softwares available for directional drilling trajectory design and control. Based on the Excel calculation formula and graphical functions, Excel program of directional intersected well was compiled for convenient application, which was proved by field applications that it could satisfy the calculation accuracy for directional intersected well. This simple and easy program provides realtime decision of drilling trajectory through formation by the relation of formation information with the error greatly reduced at the end of the buildup portion. Application of Excel in directional intersected well is instructive to the accurate design and construction of longreach horizontal directional well, directional well and trenchless engineering.