Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies
Dear Sir,
Please find the attachements and Google Drive Links are given below for your refernace
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
