Explain how you would use Excel functions like VLOOKUP, INDEX/MATCH, and pivot tables to clean and summarize a messy dataset.
