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

=UNIQUE(array,[by_col],[exactly_once])

=FILTER(array,include,[if_empty])

=SORT(ARRAY,[sort_index],[sort_order],[by_col])

Create a macro for conditional formatting & freezing panes
developer>record micro>view>freeze panes>freeze Top row>(some formating like conditional formatting,color formatting.....ect)

Create VBA Code to convert selected data into pdf from applicant data

sub pdf()
chdir "file path"
Sheeti.Export As fixedFormate xltypePDF.fileName
"filepath\REciept.Pdf"openafterpublish=true
End Sub

Check Spelling mistakes in the workbook using VBA Code

Public Sub Spelling_error()
Dim i As Range
For Each i In ActiveSheet.UsedRange
If Not Application.CheckSpelling(i.Text) Then
i.Interior.Color = RGB(225, 0, 0)
End If
Next i
End Sub0