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

Dashboard of pivot charts

Data summary for all female clients for income and loan amount

using filter function for income

=FILTER(AMT_INCOME_TOTAL,CODE_GENDER = F)

ADD the given amounts

filter function for loan

=FILTER(AMT_CREDIT,CODE_GENDER = F)

ad the given amounts

Data summary for all male clients for income and loan amount

Data summary for all Flag column

other deliverables

Macro for conditional formatting and freezing panes

 VBA Code to convert selected data into pdf from applicant data

VBA Code to Check Spelling mistakes in the workbook