{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Dataset","Go_To","AutoFilter","Advanced","Vertical","Horizontal","FILTER","Find","Sort","Power","Table2 (3)","VBA "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"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":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Dataset"]
[]
[null,"Items","State","Date","Sales"]
[null,"iPhone 13","CA","2022-03-01",10000]
[null,"iPhone 13","NY","2022-03-02",12000]
[null,"Apple Watch","TX",null,5000]
[null,"Apple Watch","CA","2022-03-02",6000]
[null,"Apple Watch","NY","2022-03-06",8000]
[null,"iPad","CA"]
[null,"iPad","WA","2022-03-01",6000]
[null,"iPad","TX",null,8000]

{"sheet":"Go_To","index":1,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Use of Go To Special Command",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Items","State","Date","Sales",null,null,null,null,null,null,"Items","State","Date","Sales"]
[null,"iPhone 13","CA","2022-03-01",10000,null,null,null,null,null,null,"iPhone 13","CA","2022-03-01",10000]
[null,"iPhone 13","NY","2022-03-02",12000,null,null,null,null,null,null,"iPhone 13","NY","2022-03-02",12000]
[null,"Apple Watch","TX","2022-03-02",5000,null,null,null,null,null,null,"Apple Watch","TX",null,5000]
[null,"Apple Watch","CA","2022-03-06",6000,null,null,null,null,null,null,"Apple Watch","CA","2022-03-02",6000]
[null,"Apple Watch","NY","2022-03-01",8000,null,null,null,null,null,null,"Apple Watch","NY","2022-03-06",8000]
[null,"iPad","CA",null,6000,null,null,null,null,null,null,"iPad","CA"]
[null,"iPad","WA",null,8000,null,null,null,null,null,null,"iPad","WA","2022-03-01",6000]
[null,"iPad","TX",null,null,null,null,null,null,null,null,"iPad","TX",null,8000]

{"sheet":"AutoFilter","index":2,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Use of Filter Option",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Items","State","Date","Sales",null,null,null,null,null,null,"Items","State","Date","Sales"]
[null,"iPhone 13","CA","2022-03-01",10000,null,null,null,null,null,null,"iPhone 13","CA","2022-03-01",10000]
[null,"iPhone 13","NY","2022-03-02",12000,null,null,null,null,null,null,"iPhone 13","NY","2022-03-02",12000]
[null,"Apple Watch","CA","2022-03-02",6000,null,null,null,null,null,null,"Apple Watch","TX",null,5000]
[null,"Apple Watch","NY","2022-03-06",8000,null,null,null,null,null,null,"Apple Watch","CA","2022-03-02",6000]
[null,"iPad","WA","2022-03-01",6000,null,null,null,null,null,null,"Apple Watch","NY","2022-03-06",8000]
[null,null,null,null,null,null,null,null,null,null,null,"iPad","CA"]
[null,null,null,null,null,null,null,null,null,null,null,"iPad","WA","2022-03-01",6000]
[null,null,null,null,null,null,null,null,null,null,null,"iPad","TX",null,8000]

{"sheet":"Advanced","index":3,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Use of Advanced Filter Option",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Items","State","Date","Sales",null,"Date","Sales",null,null,null,"Items","State","Date","Sales"]
[null,"iPhone 13","CA","2022-03-01",10000,null,"<>","<>",null,null,null,"iPhone 13","CA","2022-03-01",10000]
[null,"iPhone 13","NY","2022-03-02",12000,null,null,null,null,null,null,"iPhone 13","NY","2022-03-02",12000]
[null,"Apple Watch","TX",null,5000,null,null,null,null,null,null,"Apple Watch","TX",null,5000]
[null,"Apple Watch","CA","2022-03-02",6000,null,null,null,null,null,null,"Apple Watch","CA","2022-03-02",6000]
[null,"Apple Watch","NY","2022-03-06",8000,null,null,null,null,null,null,"Apple Watch","NY","2022-03-06",8000]
[null,"iPad","CA",null,null,null,null,null,null,null,null,"iPad","CA"]
[null,"iPad","WA","2022-03-01",6000,null,null,null,null,null,null,"iPad","WA","2022-03-01",6000]
[null,"iPad","TX",null,8000,null,null,null,null,null,null,"iPad","TX",null,8000]
[]
[null,"Items","State","Date","Sales"]
[null,"iPhone 13","CA","2022-03-01",10000]
[null,"iPhone 13","NY","2022-03-02",12000]
[null,"Apple Watch","CA","2022-03-02",6000]
[null,"Apple Watch","NY","2022-03-06",8000]
[null,"iPad","WA","2022-03-01",6000]

{"sheet":"Vertical","index":4,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Remove Unused Cells from a Vertical Range",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Range with Blank Cells",null,"Range without Blank Cells",null,null,null,null,null,null,null,"Range with Blank Cells"]
[null,"Apple",null,{"$f":"IFERROR(INDEX($B$5:$B$12, SMALL(IF(ISBLANK($B$5:$B$12),\"\",ROW($B$5:$B$12)-MIN(ROW($B$5:$B$12))+1), ROW(A1))),\"\")","v":"Apple"},null,null,null,null,null,null,null,"Apple"]
[null,"Orange",null,{"$f":"IFERROR(INDEX($B$5:$B$12, SMALL(IF(ISBLANK($B$5:$B$12),\"\",ROW($B$5:$B$12)-MIN(ROW($B$5:$B$12))+1), ROW(A2))),\"\")","v":"Orange"},null,null,null,null,null,null,null,"Orange"]
[null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$12, SMALL(IF(ISBLANK($B$5:$B$12),\"\",ROW($B$5:$B$12)-MIN(ROW($B$5:$B$12))+1), ROW(A3))),\"\")","v":"Dates"}]
[null,"Dates",null,{"$f":"IFERROR(INDEX($B$5:$B$12, SMALL(IF(ISBLANK($B$5:$B$12),\"\",ROW($B$5:$B$12)-MIN(ROW($B$5:$B$12))+1), ROW(A4))),\"\")","v":"Plum"},null,null,null,null,null,null,null,"Dates"]
[null,"Plum",null,{"$f":"IFERROR(INDEX($B$5:$B$12, SMALL(IF(ISBLANK($B$5:$B$12),\"\",ROW($B$5:$B$12)-MIN(ROW($B$5:$B$12))+1), ROW(A5))),\"\")","v":"Banana"},null,null,null,null,null,null,null,"Plum"]
[null,"Banana",null,{"$f":"IFERROR(INDEX($B$5:$B$12, SMALL(IF(ISBLANK($B$5:$B$12),\"\",ROW($B$5:$B$12)-MIN(ROW($B$5:$B$12))+1), ROW(A6))),\"\")","v":"Cherries"},null,null,null,null,null,null,null,"Banana"]
[null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$12, SMALL(IF(ISBLANK($B$5:$B$12),\"\",ROW($B$5:$B$12)-MIN(ROW($B$5:$B$12))+1), ROW(A7))),\"\")","v":""}]
[null,"Cherries",null,{"$f":"IFERROR(INDEX($B$5:$B$12, SMALL(IF(ISBLANK($B$5:$B$12),\"\",ROW($B$5:$B$12)-MIN(ROW($B$5:$B$12))+1), ROW(A8))),\"\")","v":""},null,null,null,null,null,null,null,"Cherries"]

{"sheet":"Horizontal","index":5,"n_rows":8,"n_cols":24,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,8],[3,1,3,8],[6,1,6,8],[1,16,1,23],[3,16,3,23]]}
[]
[null,"Remove Unused Cells from a Horizontal Range",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Range with Blank Cells",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Range with Blank Cells"]
[null,"Apple","Orange",null,"Dates","Plum","Banana",null,"Cherries",null,null,null,null,null,null,null,"Apple","Orange",null,"Dates","Plum","Banana",null,"Cherries"]
[]
[null,"Range without Blank Cells"]
[null,{"$f":"IF(COLUMN(B:B)<=SUM(--($B$5:$I$5<>\"\"))+1,INDEX($B$5:$I$5,0,SMALL(IF($B$5:$I$5<>\"\",COLUMN($B$5:$I$5)-1,\"\"),COLUMN(B:B)-1)),\"\")","v":"Apple"},{"$f":"IF(COLUMN(C:C)<=SUM(--($B$5:$I$5<>\"\"))+1,INDEX($B$5:$I$5,0,SMALL(IF($B$5:$I$5<>\"\",COLUMN($B$5:$I$5)-1,\"\"),COLUMN(C:C)-1)),\"\")","v":"Orange"},{"$f":"IF(COLUMN(D:D)<=SUM(--($B$5:$I$5<>\"\"))+1,INDEX($B$5:$I$5,0,SMALL(IF($B$5:$I$5<>\"\",COLUMN($B$5:$I$5)-1,\"\"),COLUMN(D:D)-1)),\"\")","v":"Dates"},{"$f":"IF(COLUMN(E:E)<=SUM(--($B$5:$I$5<>\"\"))+1,INDEX($B$5:$I$5,0,SMALL(IF($B$5:$I$5<>\"\",COLUMN($B$5:$I$5)-1,\"\"),COLUMN(E:E)-1)),\"\")","v":"Plum"},{"$f":"IF(COLUMN(F:F)<=SUM(--($B$5:$I$5<>\"\"))+1,INDEX($B$5:$I$5,0,SMALL(IF($B$5:$I$5<>\"\",COLUMN($B$5:$I$5)-1,\"\"),COLUMN(F:F)-1)),\"\")","v":"Banana"},{"$f":"IF(COLUMN(G:G)<=SUM(--($B$5:$I$5<>\"\"))+1,INDEX($B$5:$I$5,0,SMALL(IF($B$5:$I$5<>\"\",COLUMN($B$5:$I$5)-1,\"\"),COLUMN(G:G)-1)),\"\")","v":"Cherries"},{"$f":"IF(COLUMN(H:H)<=SUM(--($B$5:$I$5<>\"\"))+1,INDEX($B$5:$I$5,0,SMALL(IF($B$5:$I$5<>\"\",COLUMN($B$5:$I$5)-1,\"\"),COLUMN(H:H)-1)),\"\")","v":""},{"$f":"IF(COLUMN(I:I)<=SUM(--($B$5:$I$5<>\"\"))+1,INDEX($B$5:$I$5,0,SMALL(IF($B$5:$I$5<>\"\",COLUMN($B$5:$I$5)-1,\"\"),COLUMN(I:I)-1)),\"\")","v":""}]

{"sheet":"FILTER","index":6,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Use of FILTER Function",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Items","State","Date","Sales",null,null,null,null,null,null,"Items","State","Date","Sales"]
[null,"iPhone 13","CA","2022-03-01",10000,null,null,null,null,null,null,"iPhone 13","CA","2022-03-01",10000]
[null,"iPhone 13","NY","2022-03-02",12000,null,null,null,null,null,null,"iPhone 13","NY","2022-03-02",12000]
[null,null,"TX",null,5000,null,null,null,null,null,null,null,"TX",null,5000]
[null,"Apple Watch","CA","2022-03-02",6000,null,null,null,null,null,null,"Apple Watch","CA","2022-03-02",6000]
[null,"Apple Watch","NY","2022-03-06",8000,null,null,null,null,null,null,"Apple Watch","NY","2022-03-06",8000]
[null,"iPad","CA",null,null,null,null,null,null,null,null,"iPad","CA"]
[null,null,"WA","2022-03-01",6000,null,null,null,null,null,null,null,"WA","2022-03-01",6000]
[null,"iPad","TX",null,8000,null,null,null,null,null,null,"iPad","TX",null,8000]
[]
[null,"Items","State","Date","Sales"]
[null,{"$f":"_xlfn._xlws.FILTER(Table1[],Table1[Items]<>\"\",\"\")","v":"iPhone 13"},"CA",44621,10000]
[null,"iPhone 13","NY",44622,12000]
[null,"Apple Watch","CA",44622,6000]
[null,"Apple Watch","NY",44626,8000]
[null,"iPad","CA",0,0]
[null,"iPad","TX",0,8000]

{"sheet":"Find","index":7,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Use of Find Option",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Items","State","Date","Sales",null,null,null,null,null,null,"Items","State","Date","Sales"]
[null,"iPhone 13","CA","2022-03-01",10000,null,null,null,null,null,null,"iPhone 13","CA","2022-03-01",10000]
[null,"iPhone 13","NY","2022-03-02",12000,null,null,null,null,null,null,"iPhone 13","NY","2022-03-02",12000]
[null,"Apple Watch","TX","2022-03-02",5000,null,null,null,null,null,null,"Apple Watch","TX",null,5000]
[null,"Apple Watch","CA","2022-03-06",6000,null,null,null,null,null,null,"Apple Watch","CA","2022-03-02",6000]
[null,"Apple Watch","NY","2022-03-01",8000,null,null,null,null,null,null,"Apple Watch","NY","2022-03-06",8000]
[null,"iPad","CA",null,6000,null,null,null,null,null,null,"iPad","CA"]
[null,"iPad","WA",null,8000,null,null,null,null,null,null,"iPad","WA","2022-03-01",6000]
[null,"iPad","TX",null,null,null,null,null,null,null,null,"iPad","TX",null,8000]

{"sheet":"Sort","index":8,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Use of Sort Option",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Items","State","Date","Sales",null,null,null,null,null,null,"Items","State","Date","Sales"]
[null,"Apple Watch","CA","2022-03-02",6000,null,null,null,null,null,null,"iPhone 13","CA","2022-03-01",10000]
[null,"Apple Watch","NY","2022-03-06",8000,null,null,null,null,null,null,"iPhone 13","NY","2022-03-02",12000]
[null,"iPad","CA","2022-03-01",8000]
[null,"iPad","TX","2022-03-02",8000,null,null,null,null,null,null,"Apple Watch","CA","2022-03-02",6000]
[null,"iPhone 13","CA","2022-03-01",10000,null,null,null,null,null,null,"Apple Watch","NY","2022-03-06",8000]
[null,"iPhone 13","NY","2022-03-02",12000,null,null,null,null,null,null,"iPad","CA","2022-03-01",8000]
[]
[null,null,null,null,null,null,null,null,null,null,null,"iPad","TX","2022-03-02",8000]

{"sheet":"Power","index":9,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Use of Power Query",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Items","State","Date","Sales",null,null,null,null,null,null,"Items","State","Date","Sales"]
[null,"iPhone 13","CA","2022-03-01",10000,null,null,null,null,null,null,"iPhone 13","CA","2022-03-01",10000]
[null,"iPhone 13","NY","2022-03-02",12000,null,null,null,null,null,null,"iPhone 13","NY","2022-03-02",12000]
[]
[null,"Apple Watch","CA","2022-03-02",6000,null,null,null,null,null,null,"Apple Watch","CA","2022-03-02",6000]
[null,"Apple Watch","NY","2022-03-06",8000,null,null,null,null,null,null,"Apple Watch","NY","2022-03-06",8000]
[null,"iPad","CA","2022-03-01",6000,null,null,null,null,null,null,"iPad","CA","2022-03-01",6000]
[]
[null,"iPad","TX","2022-03-02",8000,null,null,null,null,null,null,"iPad","TX","2022-03-02",8000]

{"sheet":"Table2 (3)","index":10,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Items","State","Date","Sales"]
["iPhone 13","CA","2022-03-01",10000]
["iPhone 13","NY","2022-03-02",12000]
["Apple Watch","CA","2022-03-02",6000]
["Apple Watch","NY","2022-03-06",8000]
["iPad","CA","2022-03-01",6000]
["iPad","TX","2022-03-02",8000]

{"sheet":"VBA ","index":11,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of VBA Code"]
[]
[null,"Items","State","Date","Sales"]
[null,"iPhone 13","CA","2022-03-01",10000]
[null,"iPhone 13","NY","2022-03-02",12000]
[null,"Apple Watch","TX","2022-03-02",5000]
[null,"Apple Watch","CA","2022-03-06",6000]
[null,"Apple Watch","NY","2022-03-01",8000]
[null,"iPad","CA",null,6000]
[null,"iPad","WA",null,8000]
[null,"iPad","TX"]