by Oluwaseun | Nov 28, 2022 | Project Management Tutorials and Articles
The Excel XLOOKUP function is a modern and flexible replacement for older functions like VLOOKUP, HLOOKUP, and LOOKUP. XLOOKUP supports approximate and exact matching, wildcards (* ?) for partial matches, and lookups in vertical or horizontal ranges....
by Oluwaseun | Nov 26, 2022 | Project Management Tutorials and Articles
In certain cases, you may not have IRR. Consider the following cash flows. Calculate IRR with different guess values. You will get the result as #NUM for all the guess values. The result #NUM means that there is no IRR for the cash flows considered. Cash Flows...
by Oluwaseun | Nov 25, 2022 | Project Management Tutorials and Articles
Internal Rate of Return (IRR) of an investment is the rate of interest at which NPV is 0. It is the rate value for which the present values of the positive cash flows exactly compensate the negative ones. When the discount rate is the IRR, the investment is perfectly...
by Oluwaseun | Nov 24, 2022 | Project Management Tutorials and Articles
What Is a Dashboard? Dashboards track KPIs, metrics, and other data points in one visual, central place. They give you a high-level view of work, helping you make quick decisions and keeping everyone up to date. A dashboard’s visual nature simplifies complex data and...
by Oluwaseun | Nov 23, 2022 | Project Management Tutorials and Articles
You can use the Workbook Analysis command to create an interactive report that can show detailed information about the workbook and its Structure, Formulas, Cells, Ranges and Warnings. Click the Inquire tab on the Ribbon. Click Workbook Analysis in the...
by Oluwaseun | Nov 23, 2022 | Project Management Tutorials and Articles
You can use Inquire to − Compare two workbooks. Analyze a workbook for problems or inconsistencies. View the links between workbooks. View the links between worksheets. View the relationships between cells. Clean excess cell formatting. Manage passwords. The INQUIRE...