Use super cancel to move a player when you otherwise cannot, eg when a striker is receiving a cross they are normally locked into position until you touch the ball - use super cancel to move the player forward to beat the defender.
It basically allows you to take control of a player during otherwise 'scripted' moves.