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/10eBiiqEHwDr_53LYPhWpDmgC-amNBl5a/edit?usp=share_link&ouid=116331684304513993252&rtpof=true&sd=true

Other Deliverables

  • Create a Macro for Data Formatting (Conditional Formatting, Freezing Panes) of workbook as same will be applied to the data of next quarter
  • Create VBA Code to convert selected data into pdf from applicant data
  • Check Spelling mistakes in the workbook using VBA Code

Note above answers are shared in screen shots

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.