by Oluwaseun | Dec 19, 2022 | Project Management Tutorials and Articles
You can perform financial analysis with Excel in an easy way. Excel provides you several financial functions such as PMT, PV, NPV, XNPV, IRR, MIRR, XIRR, and so on that enable you to quickly arrive at the financial analysis results. In this chapter, you will learn...
by Oluwaseun | Dec 12, 2022 | Project Management Tutorials and Articles
A pie chart is a circular statistical graphic often used in business showing percentages of types of customers, percentages of revenue from different products, and profit from a different department in an organization. First step; get data into power bi click on the...
by Oluwaseun | 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 Oluwaseun | 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 Oluwaseun | 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 Oluwaseun | 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....