Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies

I am working as Business Analyst in IJS Bank Limited. Currently my organization is working on Loan Applicant Clients for the current quarter. My Manager asked me to analyse Loan Applicant’s data and to present appropriate report on the data. I created Excel Dashboard on the client data of education, occupation, income, and family status, Data Summary of female and male clients and other deliverables like VBA macro on Conditional Formatting, Freezing Panes, and Spell Check etc.

Google Drive Link:

https://drive.google.com/drive/folders/1NaawgY-gWWTYSouyAOY3bQlAwcKWu-1I?usp=sharing