Learning
155 Points
Joined March 2016
Use of Pivot Tables in Bank Audits
With the help of Pivot Tables we can quickly get an overview of the Loans Portfolio. Import the text files obtained from the CBS system into excel and Insert a pivot table.Drag and drop the required fields in the pivot table to get the desired output for further analysis of the data.
Sample Analysis.
Imported Raw Data had a Total Loan Balance of Rs.67,87,60,387 having 1,568 Accounts in Various products.
After Inserting a pivot table we can see that New Construction Housing Loans account for 21.72% of the portfolio Consisting of only 56 Accounts out of Total 1,568 accounts.