Drop a strip of magnesium ribbon into a few millilitres of dilute hydrochloric acid. It fizzes, slows down and stops, and a piece of shiny ribbon is still sitting in the liquid. The acid was used up first, so it was the limiting reactant; the magnesium is the excess reactant, and here you can see what is left of it. Pour in more acid and the fizzing starts again.
On paper the same thing happens with moles. For 2H2+O2→2H2O, suppose you mix 3.0 mol of H2 with 2.0 mol of O2. Burning all 3.0 mol of H2 takes only 1.5 mol of O2, so hydrogen runs out first and 2.0−1.5=0.5 mol of O2 is left over. Oxygen is the excess reactant. The leftover always comes from a subtraction, start minus used, and the amount used is set by the limiting reactant.
Grams can mislead. Mix 10 g of hydrogen with 10 g of oxygen and it looks like an even match, but 10 g of H2 is 4.96 mol while 10 g of O2 is only 0.313 mol. That oxygen can burn only 0.625 mol of H2, so most of the hydrogen is left over. Always convert to moles before deciding which reactant is in excess.
Think of it like this. A bike shop with 30 frames and 50 wheels can build only 25 bikes, since each bike needs 2 wheels; the 5 spare frames are the excess, even though frames were the smaller pile. The coefficients in an equation play the role of "1 frame, 2 wheels".
Core idea. When the limiting reactant runs out, the reaction stops. The excess reactant's leftover is its starting amount minus the amount the limiting reactant could react with, worked out in moles through the balanced equation.