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

1.Dashboard is done in Sheet1 also attached the screenshot of dashboard.

1.Sheet2 Data summary of all female clients =FILTER(FILTER('Applicant Data'!D2:I307512,'Applicant Data'!D2:D307512="F"),{1,0,0,0,1,1})

2.Sheet3 Data summary of all mails =DSUM('Applicant Data'!D1:H307512,5,Sheet3!C2:C3)

3.Sheet4 count of (Flag mob, Flag emp....)

Other Deliverables:

• Macro is recorded - Conditional formatting and freeze panes.

VBA Code to convert selected data into pdf from applicant data

Sub Save_As_PDF()
Dim saveLocation As String
saveLocation = "C:\Users\myPDFFile.pdf"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=saveLocation

End Sub

Spelling mistakes in the workbook using VBA Code

Sub Check_Spelling(Cancel As Boolean)
Sheet1.Cells.CheckSpelling

End Sub

https://drive.google.com/file/d/1pNycNmkShjXZXHBF7domTMa4iN9u9MO0/view?usp=drive_link