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

1. Features of Dashboard

Please see the attached file '1. Application data.xlsx'

Also Full data with the file link here

https://docs.google.com/spreadsheets/d/1ZMZ2HmZdIlhHDuFg7ebyj0KpayRXqlN9/edit?usp=sharing&ouid=107416689042952726621&rtpof=true&sd=true


2.Data Summary

Please see the attached file 'Q2.xlsx'
I have deleted more rows and coloumns to reduce size of file.
Each question done in three worksheets 2.1,2.2,2.3


3. Other Deliverables

Please see the attachment '3 Application data.xlsx'

Macros saved (marcro2) for conditional formatting and freeze panes

Module- q1 : convert selected data into pdf from applicant data

Module- q2 : Check Spelling mistakes