How would you use Excel functions such as VLOOKUP, INDEX/MATCH, Pivot Tables, and nested IF statements in financial analysis?