Here comes your first assignment for this course

Subject:UnrecognizedPrice:80 Bought3

Share With

Here comes your first assignment for this course. Please ensure that you have watched all the videos listed under Week 1 module before starting this assignment. Using the dataset -Pivot Table Dashboard.xlsx , Download Pivot Table Dashboard.xlsx , create a dashboard, that looks exactly as shown in the picture below. You will need understanding of pivot table, slicers and filters, among other concepts, to build this dashboard. Hint: Create three different slicers for Year, Month and Country. To create Slicer, go to Insert and click Slicer, select one option at a time. You can also format the charts to achieve the exact same dashboard. For any changes in look and feel of Slicers, click on any slicer box (say Year), go to Slicer on top bar and it will show different options for formatting. Excel Basics - https://www.youtube.com/watch?v=0tdlR1rBwkM&list=PLmHVyfmcRKyx1KSoobwukzf1Nf-Y97Rw0 Shortcuts - SC Video 1 https://youtube.com/shorts/WY_y0apzeGs?si=2FkJWKE1496hZGv_SC Video 2 https://www.youtube.com/watch?v=Xe4U_-o_EWw Aggregate Functions - AG Video 1 https://www.youtube.com/watch?v=_EWcAR_Hkvg AG Video 2 https://www.youtube.com/watch?v=y1126PQ5zRU Logical statements - https://www.youtube.com/watch?v=3MdPSHkyfdI Lookups - https://www.youtube.com/watch?v=3MdPSHkyfdI