{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","FILTER","INDEX, MATCH, SMALL, IF, & ROW","Date Filter","Excel Table","PivotTable","PowerQuery","VBA Code"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Dataset","index":0,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sales Data"]
[]
[null,"Item","Date","Sales"]
[null,"Playstation","2022-03-09",1450]
[null,"TV","2022-03-10",1300]
[null,"Blender","2022-04-06",900]
[null,"Dishwasher","2022-04-12",1150]
[null,"AC","2022-01-09",1050]
[null,"Laptop","2022-01-29",1950]
[null,"Laser Printer","2022-02-15",750]
[null,"Computer","2022-04-08",1350]
[null,"Oven","2022-02-22",1045]

{"sheet":"FILTER","index":1,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3],[14,1,14,3],[1,11,1,13],[14,11,14,13]]}
[]
[null,"Using FILTER Function",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Item","Date","Sales",null,null,null,null,null,null,null,"Item","Date","Sales"]
[null,"Playstation","2022-03-09",1450,null,null,null,null,null,null,null,"Playstation","2022-03-09",1450]
[null,"TV","2022-03-10",1300,null,null,null,null,null,null,null,"TV","2022-03-10",1300]
[null,"Blender","2022-04-06",900,null,null,null,null,null,null,null,"Blender","2022-04-06",900]
[null,"Dishwasher","2022-04-12",1150,null,null,null,null,null,null,null,"Dishwasher","2022-04-12",1150]
[null,"AC","2022-01-09",1050,null,null,null,null,null,null,null,"AC","2022-01-09",1050]
[null,"Laptop","2022-01-29",1950,null,null,null,null,null,null,null,"Laptop","2022-01-29",1950]
[null,"Laser Printer","2022-02-15",750,null,null,null,null,null,null,null,"Laser Printer","2022-02-15",750]
[null,"Computer","2022-04-08",1350,null,null,null,null,null,null,null,"Computer","2022-04-08",1350]
[null,"Oven","2022-02-22",1045,null,null,null,null,null,null,null,"Oven","2022-02-22",1045]
[]
[null,"Extracted Data",null,null,null,null,null,null,null,null,null,"Extracted Data"]
[null,"Item","Date","Sales",null,null,null,null,null,null,null,"Item","Date","Sales"]
[null,{"$f":"_xlfn._xlws.FILTER(B5:D13,MONTH(C5:C13)=4,\"No Info.\")","v":"Blender"},"2022-04-06",900]
[null,"Dishwasher","2022-04-12",1150]
[null,"Computer","2022-04-08",1350]

{"sheet":"INDEX, MATCH, SMALL, IF, & ROW","index":2,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,6],[14,1,14,3],[14,11,14,13],[1,11,1,16]]}
[]
[null,"Combining INDEX, MATCH, SMALL, IF, ROW, and COLUMN Functions",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Item","Date","Sales",null,"Start Date","2022-01-01",null,null,null,null,"Item","Date","Sales",null,"Start Date"]
[null,"Playstation","2022-03-09",1450,null,"End Date","2022-03-31",null,null,null,null,"Playstation","2022-03-09",1450,null,"End Date"]
[null,"TV","2022-03-10",1300,null,null,null,null,null,null,null,"TV","2022-03-10",1300]
[null,"Blender","2022-04-06",900,null,null,null,null,null,null,null,"Blender","2022-04-06",900]
[null,"Dishwasher","2022-04-12",1150,null,null,null,null,null,null,null,"Dishwasher","2022-04-12",1150]
[null,"AC","2022-01-09",1050,null,null,null,null,null,null,null,"AC","2022-01-09",1050]
[null,"Laptop","2022-01-29",1950,null,null,null,null,null,null,null,"Laptop","2022-01-29",1950]
[null,"Laser Printer","2022-02-15",750,null,null,null,null,null,null,null,"Laser Printer","2022-02-15",750]
[null,"Computer","2022-04-08",1350,null,null,null,null,null,null,null,"Computer","2022-04-08",1350]
[null,"Oven","2022-02-22",1045,null,null,null,null,null,null,null,"Oven","2022-02-22",1045]
[]
[null,"Extracted Data",null,null,null,null,null,null,null,null,null,"Extracted Data"]
[null,"Item","Date","Sales",null,null,null,null,null,null,null,"Item","Date","Sales"]
[null,{"$f":"IFERROR(INDEX($B$5:$D$13, SMALL(IF(($C$5:$C$13<=$G$5)*($C$5:$C$13>=$G$4), MATCH(ROW($B$5:$B$13), ROW($B$5:$B$13)), \"\"), ROW(A1)), COLUMN(A1)), \"No Info.\")","v":"Playstation"},{"$f":"IFERROR(INDEX($B$5:$D$13, SMALL(IF(($C$5:$C$13<=$G$5)*($C$5:$C$13>=$G$4), MATCH(ROW($B$5:$B$13), ROW($B$5:$B$13)), \"\"), ROW(B1)), COLUMN(B1)), \"No Info.\")","v":"2022-03-09"},{"$f":"IFERROR(INDEX($B$5:$D$13, SMALL(IF(($C$5:$C$13<=$G$5)*($C$5:$C$13>=$G$4), MATCH(ROW($B$5:$B$13), ROW($B$5:$B$13)), \"\"), ROW(C1)), COLUMN(C1)), \"No Info.\")","v":1450}]
[null,{"$f":"IFERROR(INDEX($B$5:$D$13, SMALL(IF(($C$5:$C$13<=$G$5)*($C$5:$C$13>=$G$4), MATCH(ROW($B$5:$B$13), ROW($B$5:$B$13)), \"\"), ROW(A2)), COLUMN(A2)), \"No Info.\")","v":"TV"},{"$f":"IFERROR(INDEX($B$5:$D$13, SMALL(IF(($C$5:$C$13<=$G$5)*($C$5:$C$13>=$G$4), MATCH(ROW($B$5:$B$13), ROW($B$5:$B$13)), \"\"), ROW(B2)), COLUMN(B2)), \"No Info.\")","v":"2022-03-10"},{"$f":"IFERROR(INDEX($B$5:$D$13, SMALL(IF(($C$5:$C$13<=$G$5)*($C$5:$C$13>=$G$4), MATCH(ROW($B$5:$B$13), ROW($B$5:$B$13)), \"\"), ROW(C2)), COLUMN(C2)), \"No Info.\")","v":1300}]
[null,{"$f":"IFERROR(INDEX($B$5:$D$13, SMALL(IF(($C$5:$C$13<=$G$5)*($C$5:$C$13>=$G$4), MATCH(ROW($B$5:$B$13), ROW($B$5:$B$13)), \"\"), ROW(A3)), COLUMN(A3)), \"No Info.\")","v":"AC"},{"$f":"IFERROR(INDEX($B$5:$D$13, SMALL(IF(($C$5:$C$13<=$G$5)*($C$5:$C$13>=$G$4), MATCH(ROW($B$5:$B$13), ROW($B$5:$B$13)), \"\"), ROW(B3)), COLUMN(B3)), \"No Info.\")","v":"2022-01-09"},{"$f":"IFERROR(INDEX($B$5:$D$13, SMALL(IF(($C$5:$C$13<=$G$5)*($C$5:$C$13>=$G$4), MATCH(ROW($B$5:$B$13), ROW($B$5:$B$13)), \"\"), ROW(C3)), COLUMN(C3)), \"No Info.\")","v":1050}]
[null,{"$f":"IFERROR(INDEX($B$5:$D$13, SMALL(IF(($C$5:$C$13<=$G$5)*($C$5:$C$13>=$G$4), MATCH(ROW($B$5:$B$13), ROW($B$5:$B$13)), \"\"), ROW(A4)), COLUMN(A4)), \"No Info.\")","v":"Laptop"},{"$f":"IFERROR(INDEX($B$5:$D$13, SMALL(IF(($C$5:$C$13<=$G$5)*($C$5:$C$13>=$G$4), MATCH(ROW($B$5:$B$13), ROW($B$5:$B$13)), \"\"), ROW(B4)), COLUMN(B4)), \"No Info.\")","v":"2022-01-29"},{"$f":"IFERROR(INDEX($B$5:$D$13, SMALL(IF(($C$5:$C$13<=$G$5)*($C$5:$C$13>=$G$4), MATCH(ROW($B$5:$B$13), ROW($B$5:$B$13)), \"\"), ROW(C4)), COLUMN(C4)), \"No Info.\")","v":1950}]
[null,{"$f":"IFERROR(INDEX($B$5:$D$13, SMALL(IF(($C$5:$C$13<=$G$5)*($C$5:$C$13>=$G$4), MATCH(ROW($B$5:$B$13), ROW($B$5:$B$13)), \"\"), ROW(A5)), COLUMN(A5)), \"No Info.\")","v":"Laser Printer"},{"$f":"IFERROR(INDEX($B$5:$D$13, SMALL(IF(($C$5:$C$13<=$G$5)*($C$5:$C$13>=$G$4), MATCH(ROW($B$5:$B$13), ROW($B$5:$B$13)), \"\"), ROW(B5)), COLUMN(B5)), \"No Info.\")","v":"2022-02-15"},{"$f":"IFERROR(INDEX($B$5:$D$13, SMALL(IF(($C$5:$C$13<=$G$5)*($C$5:$C$13>=$G$4), MATCH(ROW($B$5:$B$13), ROW($B$5:$B$13)), \"\"), ROW(C5)), COLUMN(C5)), \"No Info.\")","v":750}]
[null,{"$f":"IFERROR(INDEX($B$5:$D$13, SMALL(IF(($C$5:$C$13<=$G$5)*($C$5:$C$13>=$G$4), MATCH(ROW($B$5:$B$13), ROW($B$5:$B$13)), \"\"), ROW(A6)), COLUMN(A6)), \"No Info.\")","v":"Oven"},{"$f":"IFERROR(INDEX($B$5:$D$13, SMALL(IF(($C$5:$C$13<=$G$5)*($C$5:$C$13>=$G$4), MATCH(ROW($B$5:$B$13), ROW($B$5:$B$13)), \"\"), ROW(B6)), COLUMN(B6)), \"No Info.\")","v":"2022-02-22"},{"$f":"IFERROR(INDEX($B$5:$D$13, SMALL(IF(($C$5:$C$13<=$G$5)*($C$5:$C$13>=$G$4), MATCH(ROW($B$5:$B$13), ROW($B$5:$B$13)), \"\"), ROW(C6)), COLUMN(C6)), \"No Info.\")","v":1045}]

{"sheet":"Date Filter","index":3,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,3],[14,1,14,3],[1,11,1,13],[14,11,14,13]]}
[]
[null,"Employing Date Filter Feature",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Item","Date","Sales",null,null,null,null,null,null,null,"Item","Date","Sales"]
[null,"Playstation","2022-03-09",1450,null,null,null,null,null,null,null,"Playstation","2022-03-09",1450]
[null,"TV","2022-03-10",1300,null,null,null,null,null,null,null,"TV","2022-03-10",1300]
[null,"Blender","2022-04-06",900,null,null,null,null,null,null,null,"Blender","2022-04-06",900]
[null,"Dishwasher","2022-04-12",1150,null,null,null,null,null,null,null,"Dishwasher","2022-04-12",1150]
[null,"AC","2022-01-09",1050,null,null,null,null,null,null,null,"AC","2022-01-09",1050]
[null,"Laptop","2022-01-29",1950,null,null,null,null,null,null,null,"Laptop","2022-01-29",1950]
[null,"Laser Printer","2022-02-15",750,null,null,null,null,null,null,null,"Laser Printer","2022-02-15",750]
[null,"Computer","2022-04-08",1350,null,null,null,null,null,null,null,"Computer","2022-04-08",1350]
[null,"Oven","2022-02-22",1045,null,null,null,null,null,null,null,"Oven","2022-02-22",1045]
[]
[null,"Extracted Data",null,null,null,null,null,null,null,null,null,"Extracted Data"]
[null,"Item","Date","Sales",null,null,null,null,null,null,null,"Item","Date","Sales"]
[null,"Playstation","2022-03-09",1450]
[null,"TV","2022-03-10",1300]
[null,"Blender","2022-04-06",900,null,null,null,null,null,null,null,"Blender","2022-04-06",900]
[null,"Dishwasher","2022-04-12",1150]
[null,"AC","2022-01-09",1050]
[null,"Laptop","2022-01-29",1950]
[null,"Laser Printer","2022-02-15",750]
[null,"Computer","2022-04-08",1350]
[null,"Oven","2022-02-22",1045]

{"sheet":"Excel Table","index":4,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,3],[14,1,14,3],[1,11,1,13],[14,11,14,13]]}
[]
[null,"Utilizing Excel Table",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Item","Date","Sales",null,null,null,null,null,null,null,"Item","Date","Sales"]
[null,"Playstation","2022-03-09",1450,null,null,null,null,null,null,null,"Playstation","2022-03-09",1450]
[null,"TV","2022-03-10",1300,null,null,null,null,null,null,null,"TV","2022-03-10",1300]
[null,"Blender","2022-04-06",900,null,null,null,null,null,null,null,"Blender","2022-04-06",900]
[null,"Dishwasher","2022-04-12",1150,null,null,null,null,null,null,null,"Dishwasher","2022-04-12",1150]
[null,"AC","2022-01-09",1050,null,null,null,null,null,null,null,"AC","2022-01-09",1050]
[null,"Laptop","2022-01-29",1950,null,null,null,null,null,null,null,"Laptop","2022-01-29",1950]
[null,"Laser Printer","2022-02-15",750,null,null,null,null,null,null,null,"Laser Printer","2022-02-15",750]
[null,"Computer","2022-04-08",1350,null,null,null,null,null,null,null,"Computer","2022-04-08",1350]
[null,"Oven","2022-02-22",1045,null,null,null,null,null,null,null,"Oven","2022-02-22",1045]
[]
[null,"Extracted Data",null,null,null,null,null,null,null,null,null,"Extracted Data"]
[null,"Item","Date","Sales",null,null,null,null,null,null,null,"Item","Date","Sales"]
[null,"Playstation","2022-03-09",1450]
[null,"TV","2022-03-10",1300]
[null,"Blender","2022-04-06",900]
[null,"Dishwasher","2022-04-12",1150]
[null,"AC","2022-01-09",1050]
[null,"Laptop","2022-01-29",1950]
[null,"Laser Printer","2022-02-15",750]
[null,"Computer","2022-04-08",1350]
[null,"Oven","2022-02-22",1045]

{"sheet":"PivotTable","index":5,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Implementing PivotTable"]
[]
[null,"Date","(Multiple Items)"]
[]
[null,"Item","Sales in USD"]
[null,"AC",1050]
[null,"Laptop",1950]
[null,"Laser Printer",750]
[null,"Oven",1045]
[null,"Playstation",1450]
[null,"TV",1300]
[null,"Grand Total",7545]

{"sheet":"PowerQuery","index":6,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,3],[14,1,14,3],[1,11,1,13]]}
[]
[null,"Using PowerQuery",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Item","Date","Sales",null,null,null,null,null,null,null,"Item","Date","Sales"]
[null,"Playstation","2022-03-09",1450,null,null,null,null,null,null,null,"Playstation","2022-03-09",1450]
[null,"TV","2022-03-10",1300,null,null,null,null,null,null,null,"TV","2022-03-10",1300]
[null,"Blender","2022-04-06",900,null,null,null,null,null,null,null,"Blender","2022-04-06",900]
[null,"Dishwasher","2022-04-12",1150,null,null,null,null,null,null,null,"Dishwasher","2022-04-12",1150]
[null,"AC","2022-01-09",1050,null,null,null,null,null,null,null,"AC","2022-01-09",1050]
[null,"Laptop","2022-01-29",1950,null,null,null,null,null,null,null,"Laptop","2022-01-29",1950]
[null,"Laser Printer","2022-02-15",750,null,null,null,null,null,null,null,"Laser Printer","2022-02-15",750]
[null,"Computer","2022-04-08",1350,null,null,null,null,null,null,null,"Computer","2022-04-08",1350]
[null,"Oven","2022-02-22",1045,null,null,null,null,null,null,null,"Oven","2022-02-22",1045]
[]
[null,"Extracted Data"]
[null,"Item","Date","Sales"]
[null,"Playstation","2022-03-09",1450]
[null,"TV","2022-03-10",1300]
[null,"AC","2022-01-09",1050]
[null,"Laptop","2022-01-29",1950]
[null,"Laser Printer","2022-02-15",750]
[null,"Oven","2022-02-22",1045]

{"sheet":"VBA Code","index":7,"n_rows":25,"n_cols":16,"rows_kept":25,"cut":false,"hidden":false,"merged":[[14,1,14,3],[1,1,1,6],[14,11,14,13],[1,11,1,16]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Item","Date","Sales",null,"Start Date","2022-01-01",null,null,null,null,"Item","Date","Sales",null,"Start Date"]
[null,"Playstation","2022-03-09",1450,null,"End Date","2022-03-31",null,null,null,null,"Playstation","2022-03-09",1450,null,"End Date"]
[null,"TV","2022-03-10",1300,null,null,null,null,null,null,null,"TV","2022-03-10",1300]
[null,"Blender","2022-04-06",900,null,null,null,null,null,null,null,"Blender","2022-04-06",900]
[null,"Dishwasher","2022-04-12",1150,null,null,null,null,null,null,null,"Dishwasher","2022-04-12",1150]
[null,"AC","2022-01-09",1050,null,null,null,null,null,null,null,"AC","2022-01-09",1050]
[null,"Laptop","2022-01-29",1950,null,null,null,null,null,null,null,"Laptop","2022-01-29",1950]
[null,"Laser Printer","2022-02-15",750,null,null,null,null,null,null,null,"Laser Printer","2022-02-15",750]
[null,"Computer","2022-04-08",1350,null,null,null,null,null,null,null,"Computer","2022-04-08",1350]
[null,"Oven","2022-02-22",1045,null,null,null,null,null,null,null,"Oven","2022-02-22",1045]
[]
[null,"Extracted Data",null,null,null,null,null,null,null,null,null,"Extracted Data"]
[null,"Item","Date","Sales",null,null,null,null,null,null,null,"Item","Date","Sales"]
[null,"Playstation","2022-03-09",1450]
[null,"TV","2022-03-10",1300]
[null,"Blender","2022-04-06",900,null,null,null,null,null,null,null,"Blender","2022-04-06",900]
[null,"Dishwasher","2022-04-12",1150]
[null,"AC","2022-01-09",1050]
[null,"Laptop","2022-01-29",1950]
[null,"Laser Printer","2022-02-15",750]
[null,"Computer","2022-04-08",1350]
[null,"Oven","2022-02-22",1045]