by Folorunsho Ajala | Dec 9, 2022 | Project Management Tutorials and Articles
When you import data from relational databases like Microsoft Access database that contain multiple related tables, Data Model is automatically created if you import more than one table at once. You can optionally add tables to the Data Model, when you import data...
by Folorunsho Ajala | Nov 29, 2022 | Project Management Tutorials and Articles
The Excel SUMPRODUCT function multiplies ranges or arrays together and returns the sum of products. This sounds boring, but SUMPRODUCT is an incredibly versatile function that can be used to count and sum like COUNTIFS or SUMIFS, but with more flexibility....
by Folorunsho Ajala | 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 Folorunsho Ajala | 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 Folorunsho Ajala | 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 Folorunsho Ajala | 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...
