Post by @your_finance_brother

Some of my most used Excel functions, as someone who has spent over 10,000 hours in Excel: * =XLOOKUP / =INDEX(MATCH()) - Used to look up a specific value and return the corresponding item * =SUMIFS(Sum Range, Criteria 1 Range, Criteria 1…) - Used to sum a range based on specific criteria * =COUNTIFS - Same concept as =SUMIFS, but used to count instead of sum * =XIRR(Values, Dates) - Takes a range of cash flows and corresponding dates to calculate internal rate of return * =RRI (Number of Periods, Present Value, Future Value) - Used to calculate compound annual growth rate or “CAGR” * =IF(Logic, True Value, False Value) - Checks for a certain logical condition then returns a value if true or false * =IFERROR(Value, Value If Error) - Used to make sure an error is not returned, returns a specific value instead of an error Follow if you found these helpful! Not advice, just educational.