Challenge

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

Features of Dashboard

First creat pivot table and base on that create charts as per input.

Q2(Separate Worksheet Required for)

Create Google sheet and perform New Function as per input

List Function

In Yellow Cells user choice input base on list

& base on user input we got results

I used index,match,dsum,daverage,dcount function for apply automation in sheet

Q3 Macro

Make 3 different macros as per input

Ship work like this
in your own course.