Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
There are a lot of stereotype questions on here so let’s up the level a bit. From my regular use of Excel I have come across functions that are totally superior to another function. Some of which are; XNPV Function is superior to the NPV Function. INDEX Function is superior to the OFFSET Function. Using INDEX and MATCH together to perform a lookup task is superior to using VLOOKUP, HLOOKUP, or LOOKUP. Which other Function do you think is superior to another?
GETPIVOTDATA
to retrieve summary data from a PivotTable report, provided the summary data is visible in the report.
XIRR Function is superior to the IRR Function. other professional one is SUMPRODUCT which is superior to the SUMIF with only one condition