by Folorunsho Ajala | Dec 11, 2022 | Project Management Tutorials and Articles
The Excel FILTER function filters a range of data based on supplied criteria and extracts matching records. Purpose Filters range with given criteria Return value Array of filtered values Syntax =FILTER (array, include, [if_empty]) Arguments ...
by Folorunsho Ajala | Dec 11, 2022 | Project Management Tutorials and Articles
If you want to make calculations across the tables, you have to first define relationships among them. Click the Home tab on the Ribbon in the PowerPivot window. As you can observe, the tables are displayed in the Data View. Click Diagram View. The tables appear in...
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...