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

PROJECT2-1

Since I do not have 2019 or above version, I do not have access to create Dashboard in MS Excel

However, we can create dashboard using Pivot Table Analyzer after creating pivot table

https://docs.google.com/spreadsheets/d/1-29zdku6qo4e6u2Ps0S32dpYGPa5_hWj/edit?usp=sharing&ouid=118427022142005171788&rtpof=true&sd=true

PROJECT2-2

Since I do not have 2019 or above version, I do not have access to perform new functions in the data sheet

New Functions are:

UNIQUE()

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

FILTER()

=FILTER(array,Include,[If_empty])

SORT()

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

SORTBY()

=SORTBY(array,by_array1,[sort_order1])

SWITCH()

=SWITCH(expression,value1,result1,[default_or_value2,result2])

https://docs.google.com/spreadsheets/d/16u-TCLKeVdM9dWB5K5CZsAYP5kPejEG5/edit?usp=sharing&ouid=118427022142005171788&rtpof=true&sd=true

PROJECT2-3

Check Spelling Mistakes:

Public Sub InputsortBy()
Dim userinput As String
Dim prompt As String
prompt = "Check spelling mistakes" & vbCrLf

userinput = InputBox(prompt)

End Sub

https://docs.google.com/spreadsheets/d/1-NE3nFHjYrWXWBYwH7zIga0uLY3S_F4j/edit?usp=sharing&ouid=118427022142005171788&rtpof=true&sd=true