Challenge

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

VBA code for Spell check

Sub SpellCheckIn_ActiveSheet()
ActiveSheet.CheckSpelling
End Sub

VBA COde for converting into PDF.

Sub Save_pre_Selection()
Dim LocationSave As String
LocationSave = "C:\Users\DELL\OneDrive\Desktop\Deliverables"
Selection.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=LocationSave, OpenAfterPublish:=True
End Sub

https://drive.google.com/drive/folders/1-fHxpdpH6y2prAzlcW35n_9BXgU5XCMy?usp=sharing

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.