Explain a situation where you had to use advanced Excel functions to automate a repetitive reporting task.
