Excess pore pressure is pore water pressure generated by loading the soil. Imagine a sponge soaked with water. If you load it (push down on it) water comes out, exactly the same sort of thing happens when you load soil, you try and squeeze the water out of it. However, clay soil is not very permeable, so the water can't get out quickly, so the water pressures increase, and gradually decrease as the excess pressure is dissipated by seepage through the soil. Sands and gravels are more permeable so rarely generate significant excess pore pressures, the excess pressure gererated by the load dissipates almost immediately.
Pile driving imparts force onto soil, this also generates excess pore pressures.