EXCEL Project 2-Report using Power Query, Macro VBA, List Functions and Data Validation functions.

The task assigned to the Business Analyst in IJS Bank Limited is to analyze loan applicant data and create a dashboard in MS Excel. The dashboard will provide an overview of various features, such as gender ratio, car/house owner ratios, client income/education/housing type, family status, and occupation type. Separate worksheets are required for data summaries of female and male clients and flag columns, and VBA codes will be created to automate data formatting, PDF conversion, and spell-checking. The dashboard will provide valuable insights into the financial status of the applicants and aid in informed decision-making.

https://drive.google.com/drive/folders/1eCEVbOFPxdZHXc1HzAnK1o3MlAactp1_?usp=share_link