From what I understand, when there is a drop in the voltage the current is drawn out of the capacitor and so the balance is maintained. But when there is an over voltage from the power supply or when the load draws more current how does the decoupling capacitor balance it. The capacitor is already fully charged. So when the load draws more current, doesn't that current get drawn from the capacitor/power supply?
You can think of a decoupling capacitor as a toilet tank. If you just had the water pipe feeding the toilet you would never have enough volume of water to flush the toilet. The is a local storage area for extra water. When you flush it, it gives a large supply of water at once and allows a flush to happen. Then when the toilet is done flushing, the tank gets filled back up.
It's not quite the same with a capacitor, but similar. When your load needs more current, the capacitor will source some extra current. This causes a slight dip in voltage but not a huge one. If there wasn't a capacitor there, if the load needs a lot of current for a moment, the voltage will droop a lot because the load resistance would have dropped and power supply resistance would consume too much of the voltage.
Now for the other case for voltage spikes. A capacitor is never really "full". There's a maximum voltage it can handle, but usually that should be at least 25% higher than the normal operating voltage. Let's say the supply voltage is 5V, the capacitor should be able to handle at least 6.25 volts. That means that when there's a voltage spike coming down the line, the capacitor will absorb some of the extra current caused by the voltage and quench the incoming voltage spike to be much less than it would be otherwise. In this case, you should think of a capacitor like a flexible membrane attached to the side of a water hose. If there's ever a higher pressure transiently in the water hose, the flexible membrane (kind of like a shock absorber) would absorb the excess pressure and allow anything further down the line to not see the excess pressure (voltage) spike because it would have been absorbed by the membrane. Bypass capacitors work in a similar way.
Also note that when the load needs more current transiently, it will absorb current from both the capacitor and the power supply. It's just that the transient seen from the power supply will be distributed over time more.