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

Separate 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 function.

Other Deliverables

• Create a Macro for Data Formatting (Conditional Formatting, Freezing Panes) of workbook as same will be applied to the data of next quarter
• Create VBA Code to convert selected data into pdf from applicant data
• Check Spelling mistakes in the workbook using VBA Code