Some functions in Excel are totally superior to other functions such as XNPV > NPV. Do you know of others?

XIRR Function is superior to the IRR Function.
other professional one is SUMPRODUCT which is superior to the SUMIF with only one condition

Please explain using the INDEX/MATCH for performing lookup's

if you want to get an exact result from VLOOKUP (so in our case exact means FALSE and TRUE,s o we will not have any #N/A) it's better to combine vlookup with IF

in general array formulas are better than their volatile counterparts (index/match vs.
vlookup).
with regards to andy osaretin's question, =index(array,row_num,column_num) and match is =match(lookup_value,lookup_array,[match_type]).
Simplified version: =index(reference,in which row?,in which column?) and =match(what will i find?,reference,0=exact;1=greater than;-1=less than) In using index function, you need to know what is the row number and column number, this is where match function comes in especially if you are dealing with dynamic values.
hope it helps!

GETPIVOTDATA

to retrieve summary data from a PivotTable report, provided the summary data is visible in the report.

excel NPV function calculates the net present value of an investment, based on upplied discount rate, and a series of future payment and income.

to use subtraction, addition ,multiplication when we work easily to statically data

XIRR>IRR

 

XIRR Function is superior to the IRR Function. other professional one is SUMPRODUCT which is superior to the SUMIF with only one condition

The XIRR is better than the IRR

Function is superior to the NPV function.