Challenge

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

New Functions like unique, sort, filter functions are not supporting in my current excel version

=Unique(Selected range)

=Sort(Range)

=Filter(Range)

vba code for pdf conversation

Public Sub Convert_PDF()

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _

"Fownload\.About Applicant Data.pdf", Quality:=xlQualityStandard, _

IncludeDocProperties:=True, IgnorepetntAreas:=Flase, OpenAfterpublish:= _

True

End Sub

vba code for spelling checking

Public Sub spelling_Checking()

Dim rng As Range

For Each rng In ActiveSheet.UsedRange

If Not Application.CheckSpelling(word:=rng.Text) Then

rng.Style = "Bad"

End If

Next rng

End Sub

Please find the above link for the Excel spreadsheet.

Ship work like this
in your own course.