Challenge

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

In this Project, I am done this based on this condition working as Business Analyst in IJS Bank Limited. Currently your organization is working on Loan Applicant Clients for the current quarter. The Manager of the Branch asked you to analyze Loan Applicant’s data and to Present appropriate report on the shared data. The report should be demonstrated using Dashboard into MS Excel.

For other Deliverable; i am done with Macro For conditonal Formatting and Freeze Panes you can see that in Visually
and for the VBA part i attached the Screenshot of this

i attached the google Drive link here;https://docs.google.com/spreadsheets/d/1-ftoEOAj3ExRR7iiGofgl5-7jo3VChX_/edit?usp=share_link&ouid=114743177576530232760&rtpof=true&sd=true

spelling mistake VBA

conditional FOrmatting & Freeze panes macro' VBA

Your portfolio, next

Ship work like this
in your own course.

Talk to a career counsellor

Free 20-minute call. We'll map the right course to where you want to work.

By submitting you agree to our Terms and Privacy Policy.