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

https://docs.google.com/spreadsheets/d/17yPzv75nlcj0UAsN6CzDrIBYXIWsh-nn/edit?usp=sharing&ouid=115399761592207093649&rtpof=true&sd=true

I Done Here a Features of Dashboard - created a pivot charts for all below mentioned Options And I make an attractive dashboard here !

• Gender Ratio of Applicants
• Car Owner/ Non-Owner Ratio
• House Owner/ Non-Owner Ratio
• Client Income Type
• Client’s Level of Education
• Client’s Housing Type
• Client’s Family Status
• Client’s Occupation Type

I Separate A Worksheet Required for

• Data Summary of All Female Client’s for Income and Loan Amount using New Functions
• Data Summary of All male Client’s for Income and Loan Amount using list Functions
• Data Summary for all Flag Columns like (FLAG_DOCUMENT_2, FLAG_DOCUMENT_3 etc.) using all variants of DCOUNT functions

And i created

• A macro for conditional formatting & freezing panes
• i Write the VBA Code to convert selected data into pdf from applicant data
• I Write to Check Spelling mistakes in the workbook using VBA Code

https://docs.google.com/spreadsheets/d/17yPzv75nlcj0UAsN6CzDrIBYXIWsh-nn/edit?usp=sharing&ouid=115399761592207093649&rtpof=true&sd=true

Please Fetch The Attachment For My Excel Project 2 in Above Link !

And i Attached & Uploaded The NOTE TEXT FILE