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

Dashboard link:-https://docs.google.com/spreadsheets/d/1i2nJL-X9YhwaRcxpHocjDm8MlUpF-PQv/edit?usp=share_link&ouid=108945806021981727278&rtpof=true&sd=true

Demonstrated using Dashboard into MS Excel:-

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:-

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:-