{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Helper Column VLOOKUP","Copy Paste","Fill","AutoFill","VBA","Product","Power Query Editor","CHOOSE"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Helper Column VLOOKUP","index":0,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,12,1,13]]}
[]
[null,"Use of Helper Column & VLOOKUP Function",null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Helper Column","Product","Repeat Time","Helper Column","Product",null,null,null,null,null,null,"Product","Repeat Time"]
[null,1,"Cable",2,1,{"$f":"VLOOKUP(E5,$B$5:$C$8,2)","v":"Cable"},null,null,null,null,null,null,"Cable",2]
[null,{"$f":"B5+D5","v":3},"AC",1,2,{"$f":"VLOOKUP(E6,$B$5:$C$8,2)","v":"Cable"},null,null,null,null,null,null,"AC",1]
[null,{"$f":"B6+D6","v":4},"TV",2,3,{"$f":"VLOOKUP(E7,$B$5:$C$8,2)","v":"AC"},null,null,null,null,null,null,"TV",2]
[null,6,null,null,4,"TV"]
[null,null,null,null,5,"TV"]

{"sheet":"Copy Paste","index":1,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Use of Copy and Paste Features",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Product","Repeat Time",null,null,null,null,null,null,null,"Product","Repeat Time"]
[null,"Cable",2,null,null,null,null,null,null,null,"Cable",2]
[null,"Cable",null,null,null,null,null,null,null,null,"AC",1]
[null,"Cable",null,null,null,null,null,null,null,null,"TV",2]
[null,"AC",1]
[null,"AC"]
[null,"TV",2]
[null,"TV"]
[null,"TV"]

{"sheet":"Fill","index":2,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Use of Fill Feature",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Product","Repeat Time",null,null,null,null,"Product","Repeat Time"]
[null,"Cable",2,null,null,null,null,"Cable",2]
[null,"AC",1,null,null,null,null,"AC",1]
[null,"TV",2,null,null,null,null,"TV",2]
[null,"TV"]
[null,"TV"]

{"sheet":"AutoFill","index":3,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Use of AutoFill Tool",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Product","Repeat Time",null,null,null,null,null,"Product","Repeat Time"]
[null,"Cable",2,null,null,null,null,null,"Cable",2]
[null,"AC",1,null,null,null,null,null,"AC",1]
[null,"TV",2,null,null,null,null,null,"TV",2]
[null,"TV"]
[null,"TV"]

{"sheet":"VBA","index":4,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Use of Excel VBA",null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Product","Repeat Time",null,null,null,null,null,null,null,null,"Product","Repeat Time"]
[null,"Cable",2,null,null,null,null,null,null,null,null,"Cable",2]
[null,"AC",1,null,null,null,null,null,null,null,null,"AC",1]
[null,"TV",2,null,null,null,null,null,null,null,null,"TV",2]
[]
[null,"Cable"]
[null,"Cable"]
[null,"AC"]
[null,"TV"]
[null,"TV"]

{"sheet":"Product","index":5,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Product","Months"]
["Cable","Jan"]
["Cable","Feb"]
["Cable","Mar"]
["AC","Jan"]
["AC","Feb"]
["AC","Mar"]
["TV","Jan"]
["TV","Feb"]
["TV","Mar"]

{"sheet":"Power Query Editor","index":6,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Use of Power Query Editor",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Product","Months",null,null,null,null,null,"Product","Repeat Time"]
[null,"Cable","Jan",null,null,null,null,null,"Cable",2]
[null,"AC","Feb",null,null,null,null,null,"AC",1]
[null,"TV","Mar",null,null,null,null,null,"TV",2]

{"sheet":"CHOOSE","index":7,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Combining CHOOSE and SEQUENCE Functions",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Product","Repeat Time",null,"Repeated Products",null,null,"Product","Repeat Time"]
[null,"Cable",2,null,{"$f":"CHOOSE(_xlfn.SEQUENCE(C5,1,1,0),B5)","v":"Cable"},null,null,"Cable",2]
[null,"AC",1,null,"Cable",null,null,"AC",1]
[null,"TV",2,null,null,null,null,"TV",2]