{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Dataset","Manually","Format Table","Table","Format Painter","IF,MOD","IF,MOD,ROW","AND,IF,LEN,MOD","ISODD","ISEVEN,FILTER","VBA","Practice Section"],"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":"Dataset","index":0,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Daily Sales- Fruits Section"]
[]
[null,"Product","Customer","Quantity"]
[null,"Apple","Jonas",25]
[null,"Apple","Harry",14]
[null,"Guava","Nick",15]
[null,"Coconut","Sara",5]
[null,"Apricot","John",20]
[null,"Watermelon","Leon",8]
[null,"Jackfruit","Tom",25]
[null,"Kiwi","Hardy",12]
[null,"Lemon","Mark",6]
[null,"Avocado","Chris",10]

{"sheet":"Manually","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Coloring Alternate Rows Manually"]
[]
[null,"Product","Customer","Quantity"]
[null,"Apple","Jonas",25]
[null,"Apple","Harry",14]
[null,"Guava","Nick",15]
[null,"Coconut","Sara",5]
[null,"Apricot","John",20]
[null,"Watermelon","Leon",8]
[null,"Jackfruit","Tom",25]
[null,"Kiwi","Hardy",12]
[null,"Lemon","Mark",6]
[null,"Avocado","Chris",10]

{"sheet":"Format Table","index":2,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Format as Table Option"]
[]
[null,"Product","Customer","Quantity"]
[null,"Apple","Jonas",25]
[null,"Orange","Harry",14]
[null,"Guava","Nick",15]
[null,"Coconut","Sara",5]
[null,"Apricot","John",20]
[null,"Watermelon","Leon",8]
[null,"Jackfruit","Tom",25]
[null,"Kiwi","Hardy",12]
[null,"Lemon","Mark",6]
[null,"Avocado","Chris",10]

{"sheet":"Table","index":3,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Creating Table"]
[]
[null,"Product","Customer","Quantity"]
[null,"Apple","Jonas",25]
[null,"Orange","Harry",14]
[null,"Guava","Nick",15]
[null,"Coconut","Sara",5]
[null,"Apricot","John",20]
[null,"Watermelon","Leon",8]
[null,"Jackfruit","Tom",25]
[null,"Kiwi","Hardy",12]
[null,"Lemon","Mark",6]
[null,"Avocado","Chris",10]

{"sheet":"Format Painter","index":4,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Format Painter Option"]
[]
[null,"Product","Customer","Quantity"]
[null,"Apple","Jonas",25]
[null,"Orange","Harry",14]
[null,"Guava","Nick",15]
[null,"Coconut","Sara",5]
[null,"Apricot","John",20]
[null,"Watermelon","Leon",8]
[null,"Jackfruit","Tom",25]
[null,"Kiwi","Hardy",12]
[null,"Lemon","Mark",6]
[null,"Avocado","Chris",10]

{"sheet":"IF,MOD","index":5,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Applying IF and MOD Functions"]
[]
[null,"Product","Customer","Quantity",0]
[null,"Apple","Jonas",25,{"$f":"MOD(IF(B5=B4,E4,E4+1),2)","v":1}]
[null,"Apple","Harry",14,{"$f":"MOD(IF(B6=B5,E5,E5+1),2)","v":1}]
[null,"Guava","Nick",15,0]
[null,"Coconut","Sara",5,1]
[null,"Apricot","John",20,0]
[null,"Watermelon","Leon",8,1]
[null,"Jackfruit","Tom",25,0]
[null,"Kiwi","Hardy",12,1]
[null,"Lemon","Mark",6,0]
[null,"Avocado","Chris",10,1]

{"sheet":"IF,MOD,ROW","index":6,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Combining IF, MOD and ROW Functions"]
[]
[null,"Product","Customer","Quantity",0]
[null,"Apple","Jonas",25,{"$f":"MOD(IF(ROW()=2,0,IF(B5=B4,E4,E4+1)),2)","v":1}]
[null,"Apple","Harry",14,{"$f":"MOD(IF(ROW()=2,0,IF(B6=B5,E5,E5+1)),2)","v":1}]
[null,"Guava","Nick",15,0]
[null,"Coconut","Sara",5,1]
[null,"Apricot","John",20,0]
[null,"Watermelon","Leon",8,1]
[null,"Jackfruit","Tom",25,0]
[null,"Kiwi","Hardy",12,1]
[null,"Lemon","Mark",6,0]
[null,"Avocado","Chris",10,1]

{"sheet":"AND,IF,LEN,MOD","index":7,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Utilizing AND, IF, LEN and MOD Functions"]
[]
[null,"Product","Customer","Quantity",0]
[null,"Apple","Jonas",25,{"$f":"IF(B5=B4,E4,E4+1)","v":1}]
[null,"Apple","Harry",14,{"$f":"IF(B6=B5,E5,E5+1)","v":1}]
[null,"Guava","Nick",15,2]
[null,"Coconut","Sara",5,3]
[null,"Apricot","John",20,4]
[null,"Watermelon","Leon",8,5]
[null,"Jackfruit","Tom",25,6]
[null,"Kiwi","Hardy",12,7]
[null,"Lemon","Mark",6,8]
[null,"Avocado","Chris",10,9]

{"sheet":"ISODD","index":8,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Applying ISODD Function"]
[]
[null,"Product","Customer","Quantity",0]
[null,"Apple","Jonas",25,{"$f":"IF(B5=B4,E4,E4+1)","v":1}]
[null,"Apple","Harry",14,{"$f":"IF(B6=B5,E5,E5+1)","v":1}]
[null,"Guava","Nick",15,2]
[null,"Coconut","Sara",5,3]
[null,"Apricot","John",20,4]
[null,"Watermelon","Leon",8,5]
[null,"Jackfruit","Tom",25,6]
[null,"Kiwi","Hardy",12,7]
[null,"Lemon","Mark",6,8]
[null,"Avocado","Chris",10,9]

{"sheet":"ISEVEN,FILTER","index":9,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Linking ISEVEN Function with Filter Option"]
[]
[null,"Product","Customer","Quantity","Helper"]
[null,"Apple","Jonas",25,{"$f":"ISEVEN(ROW())","v":false}]
[null,"Orange","Harry",14,{"$f":"ISEVEN(ROW())","v":true}]
[null,"Guava","Nick",15,false]
[null,"Coconut","Sara",5,true]
[null,"Apricot","John",20,false]
[null,"Watermelon","Leon",8,true]
[null,"Jackfruit","Tom",25,false]
[null,"Kiwi","Hardy",12,true]
[null,"Lemon","Mark",6,false]
[null,"Avocado","Chris",10,true]

{"sheet":"VBA","index":10,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Employing VBA Code"]
[]
[null,"Product","Customer","Quantity"]
[null,"Apple","Jonas",25]
[null,"Orange","Harry",14]
[null,"Guava","Nick",15]
[null,"Coconut","Sara",5]
[null,"Apricot","John",20]
[null,"Watermelon","Leon",8]
[null,"Jackfruit","Tom",25]
[null,"Kiwi","Hardy",12]
[null,"Lemon","Mark",6]
[null,"Avocado","Chris",10]

{"sheet":"Practice Section","index":11,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Do It Yourself"]
[]
[null,"Product","Customer","Quantity"]
[null,"Apple","Jonas",25]
[null,"Apple","Harry",14]
[null,"Guava","Nick",15]
[null,"Coconut","Sara",5]
[null,"Apricot","John",20]
[null,"Watermelon","Leon",8]
[null,"Jackfruit","Tom",25]
[null,"Kiwi","Hardy",12]
[null,"Lemon","Mark",6]
[null,"Avocado","Chris",10]