Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies
Project 2
- In this excel project we worked on given data of Loan Applicant Clients for the current quarter.
- Created dashboard for respective fileds using pivot table and charts.
- Also performed data summary using new functions and list functions of excel like dsum , sumif etc.
- Did data formatting on given data as needed
- Created macros and vba code for spelling check and covert the sheet/data to pdf.
- VBA code is also attached in below ss.
- Google drive Link has been attached containg project details.
Thank you
