DEV Community

lora-1
lora-1

Posted on

Advanced Excel Formulas

Excel is a tool that every financial analyst uses more frequently than they might like to acknowledge. We have selected the most significant and complex Excel formulas that any top-tier financial analyst needs to be familiar with based on our extensive experience.

  1. INDEX MATCH
  2. IF combined with AND / OR
  3. OFFSET combined with SUM or AVERAGE
  4. CHOOSE
  5. XNPV and XIRR

Top comments (0)