Linear‐Scaling Quantum Mechanical Methods for Excited States