Multiconfiguration self‐consistent field (MCSCF) theory for excited states