Challenge

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

https://docs.google.com/spreadsheets/d/1fHTPlVJYl2Qht69SPgfrj8CUneKFhLEW/edit?usp=drive_link&ouid=108321187990630390366&rtpof=true&sd=true

Public Sub convert_to_pdf()

Range("A1:D7").ExportAsFixedFormat xlTypePDF

End Sub

Public Sub Check_spelling_mistake()

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

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.