Abstract: The collective excited states are macroscopically described as the nuclear resonances in coordinate, spin, and isospin spaces. Researching these excited states may acquire the properties of nuclear structure and the information of nucleon-nucleon interaction inside nucleus. In addition, it may also provide important input for nuclear astrophysics. The self-consistent Second Random Approximation (SRPA) theory based on Skyrme density functional was applied to research these collective excited states, including normal parity 0⁺, 2⁺, 3⁻ sates, and charge-exchange Gamow-Teller (GT) transition. In addition, the effects of tensor force under the two particle-two hole configurations are discussed primarily. And the research points out that it may produce low-energy normal transition states or enhance their transition strengths. Moreover, the including of tensor force is helpful for the systematical describing of the strength and excitation energy of GT giant resonances of a series of closed-shell nuclei, and the β decay half-lives of closed-shell or quasi closed-shell nuclei.