{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Dataset","Using Fill Handle ","Using Fill Series ","Adding 1 to the Previous Row","Name Manager","IF and MAX Function","Using the OFFSET Function","Using The Row Function","Using the COUNTA Function","Using the SEQUENCE Function","By Creating a Table ","SUBTOTAL for Filtered Data","VBA Macros","COLUMN Function"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Sample Dataset"]
[]
[null,"Serial No.","Name ","Country ","Product","Sale 1","Sale 2"]
[null,1,"Chris ","UK ","Laptop ",25000,56000]
[null,2,"Lucy ","USA ","Notebook ",34000,45000]
[null,3,"David ","Italy ","Computer ",23000,75000]
[null,4,"Alan ","Germany ","Laptop ",12300,54300]
[null,5,"John ","France ","Computer ",45600,64800]
[null,6,"Jenny ","UK ","Smartphone ",4300,56700]
[null,7,"Mike ","UK ","Notebook ",78900,43200]
[null,8,"Robbin ","USA ","Motherboard ",12300,65400]
[null,9,"Donald ","USA ","Processor ",45600,5432]
[null,10,"Bob ","Russia ","Transistor ",54455,76540]
[null,11,"Alex ","Malta ","Microchip ",78900,87600]
[null,12,"Don ","Mexico ","Laptop ",25000,86500]
[null,13,"Leo ","Spain ","Computer ",37000,87600]
[null,14,"Smith ","Ghana ","Notebook ",65000,76500]

{"sheet":"Using Fill Handle ","index":1,"n_rows":21,"n_cols":22,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,11,1,16]]}
[]
[null,"Using Fill Handle ",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Serial No.","Name ","Country ","Product","Sale 1","Sale 2",null,null,null,null,"Serial No.","Name ","Country ","Product","Sale 1","Sale 2"]
[null,1,"Chris ","UK ","Laptop ",25000,56000,null,null,null,null,null,"Chris ","UK ","Laptop ",25000,56000]
[null,2,"Lucy ","USA ","Notebook ",34000,45000,null,null,null,null,null,"Lucy ","USA ","Notebook ",34000,45000]
[null,3,"David ","Italy ","Computer ",23000,75000,null,null,null,null,null,"David ","Italy ","Computer ",23000,75000]
[null,4,"Alan ","Germany ","Laptop ",12300,54300,null,null,null,null,null,"Alan ","Germany ","Laptop ",12300,54300]
[null,5,"John ","France ","Computer ",45600,64800,null,null,null,null,null,"John ","France ","Computer ",45600,64800]
[null,6,"Jenny ","UK ","Smartphone ",4300,56700,null,null,null,null,null,"Jenny ","UK ","Smartphone ",4300,56700]
[null,7,"Mike ","UK ","Notebook ",78900,43200,null,null,null,null,null,"Mike ","UK ","Notebook ",78900,43200]
[null,8,"Robbin ","USA ","Motherboard ",12300,65400,null,null,null,null,null,"Robbin ","USA ","Motherboard ",12300,65400]
[null,9,"Donald ","USA ","Processor ",45600,5432,null,null,null,null,null,"Donald ","USA ","Processor ",45600,5432]
[null,10,"Bob ","Russia ","Transistor ",54455,76540,null,null,null,null,null,"Bob ","Russia ","Transistor ",54455,76540]
[null,11,"Alex ","Malta ","Microchip ",78900,87600,null,null,null,null,null,"Alex ","Malta ","Microchip ",78900,87600]
[null,12,"Don ","Mexico ","Laptop ",25000,86500,null,null,null,null,null,"Don ","Mexico ","Laptop ",25000,86500]
[null,13,"Leo ","Spain ","Computer ",37000,87600,null,null,null,null,null,"Leo ","Spain ","Computer ",37000,87600]
[null,14,"Smith ","Ghana ","Notebook ",65000,76500,null,null,null,null,null,"Smith ","Ghana ","Notebook ",65000,76500]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Using Fill Series ","index":2,"n_rows":18,"n_cols":17,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,11,1,16]]}
[]
[null,"Using Fill series ",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Serial No.","Name ","Country ","Product","Sale 1","Sale 2",null,null,null,null,"Serial No.","Name ","Country ","Product","Sale 1","Sale 2"]
[null,1,"Chris ","UK ","Laptop ",25000,56000,null,null,null,null,null,"Chris ","UK ","Laptop ",25000,56000]
[null,2,"Lucy ","USA ","Notebook ",34000,45000,null,null,null,null,null,"Lucy ","USA ","Notebook ",34000,45000]
[null,3,"David ","Italy ","Computer ",23000,75000,null,null,null,null,null,"David ","Italy ","Computer ",23000,75000]
[null,4,"Alan ","Germany ","Laptop ",12300,54300,null,null,null,null,null,"Alan ","Germany ","Laptop ",12300,54300]
[null,5,"John ","France ","Computer ",45600,64800,null,null,null,null,null,"John ","France ","Computer ",45600,64800]
[null,6,"Jenny ","UK ","Smartphone ",4300,56700,null,null,null,null,null,"Jenny ","UK ","Smartphone ",4300,56700]
[null,7,"Mike ","UK ","Notebook ",78900,43200,null,null,null,null,null,"Mike ","UK ","Notebook ",78900,43200]
[null,8,"Robbin ","USA ","Motherboard ",12300,65400,null,null,null,null,null,"Robbin ","USA ","Motherboard ",12300,65400]
[null,9,"Donald ","USA ","Processor ",45600,5432,null,null,null,null,null,"Donald ","USA ","Processor ",45600,5432]
[null,10,"Bob ","Russia ","Transistor ",54455,76540,null,null,null,null,null,"Bob ","Russia ","Transistor ",54455,76540]
[null,11,"Alex ","Malta ","Microchip ",78900,87600,null,null,null,null,null,"Alex ","Malta ","Microchip ",78900,87600]
[null,12,"Don ","Mexico ","Laptop ",25000,86500,null,null,null,null,null,"Don ","Mexico ","Laptop ",25000,86500]
[null,13,"Leo ","Spain ","Computer ",37000,87600,null,null,null,null,null,"Leo ","Spain ","Computer ",37000,87600]
[null,14,"Smith ","Ghana ","Notebook ",65000,76500,null,null,null,null,null,"Smith ","Ghana ","Notebook ",65000,76500]

{"sheet":"Adding 1 to the Previous Row","index":3,"n_rows":21,"n_cols":22,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,11,1,16]]}
[]
[null,"Adding One to the Previous Row Number",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Serial No.","Name ","Country ","Product","Sale 1","Sale 2",null,null,null,null,"Serial No.","Name ","Country ","Product","Sale 1","Sale 2"]
[null,1,"Chris ","UK ","Laptop ",25000,56000,null,null,null,null,null,"Chris ","UK ","Laptop ",25000,56000]
[null,{"$f":"B5+1","v":2},"Lucy ","USA ","Notebook ",34000,45000,null,null,null,null,null,"Lucy ","USA ","Notebook ",34000,45000]
[null,{"$f":"B6+1","v":3},"David ","Italy ","Computer ",23000,75000,null,null,null,null,null,"David ","Italy ","Computer ",23000,75000]
[null,4,"Alan ","Germany ","Laptop ",12300,54300,null,null,null,null,null,"Alan ","Germany ","Laptop ",12300,54300]
[null,5,"John ","France ","Computer ",45600,64800,null,null,null,null,null,"John ","France ","Computer ",45600,64800]
[null,6,"Jenny ","UK ","Smartphone ",4300,56700,null,null,null,null,null,"Jenny ","UK ","Smartphone ",4300,56700]
[null,7,"Mike ","UK ","Notebook ",78900,43200,null,null,null,null,null,"Mike ","UK ","Notebook ",78900,43200]
[null,8,"Robbin ","USA ","Motherboard ",12300,65400,null,null,null,null,null,"Robbin ","USA ","Motherboard ",12300,65400]
[null,9,"Donald ","USA ","Processor ",45600,5432,null,null,null,null,null,"Donald ","USA ","Processor ",45600,5432]
[null,10,"Bob ","Russia ","Transistor ",54455,76540,null,null,null,null,null,"Bob ","Russia ","Transistor ",54455,76540]
[null,11,"Alex ","Malta ","Microchip ",78900,87600,null,null,null,null,null,"Alex ","Malta ","Microchip ",78900,87600]
[null,12,"Don ","Mexico ","Laptop ",25000,86500,null,null,null,null,null,"Don ","Mexico ","Laptop ",25000,86500]
[null,13,"Leo ","Spain ","Computer ",37000,87600,null,null,null,null,null,"Leo ","Spain ","Computer ",37000,87600]
[null,14,"Smith ","Ghana ","Notebook ",65000,76500,null,null,null,null,null,"Smith ","Ghana ","Notebook ",65000,76500]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Name Manager","index":4,"n_rows":21,"n_cols":22,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,11,1,16]]}
[]
[null,"Using Name Manager",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Serial No.","Name ","Country ","Product","Sale 1","Sale 2",null,null,null,null,"Serial No.","Name ","Country ","Product","Sale 1","Sale 2"]
[null,{"$f":"SUM(AutoNumber,1)","v":1},"Mike ","UK ","Notebook ",78900,43200,null,null,null,null,null,"Chris ","UK ","Laptop ",25000,56000]
[null,{"$f":"SUM(AutoNumber,1)","v":2},"Alex ","Malta ","Microchip ",78900,87600,null,null,null,null,null,"Lucy ","USA ","Notebook ",34000,45000]
[null,3,"Bob ","Russia ","Transistor ",54455,76540,null,null,null,null,null,"David ","Italy ","Computer ",23000,75000]
[null,4,"John ","France ","Computer ",45600,64800,null,null,null,null,null,"Alan ","Germany ","Laptop ",12300,54300]
[null,5,"Donald ","USA ","Processor ",45600,5432,null,null,null,null,null,"John ","France ","Computer ",45600,64800]
[null,6,"Leo ","Spain ","Computer ",37000,87600,null,null,null,null,null,"Jenny ","UK ","Smartphone ",4300,56700]
[null,7,"Lucy ","USA ","Notebook ",34000,45000,null,null,null,null,null,"Mike ","UK ","Notebook ",78900,43200]
[null,8,"Chris ","UK ","Laptop ",25000,56000,null,null,null,null,null,"Robbin ","USA ","Motherboard ",12300,65400]
[null,9,"Don ","Mexico ","Laptop ",25000,86500,null,null,null,null,null,"Donald ","USA ","Processor ",45600,5432]
[null,10,"David ","Italy ","Computer ",23000,75000,null,null,null,null,null,"Bob ","Russia ","Transistor ",54455,76540]
[null,11,"Alan ","Germany ","Laptop ",12300,54300,null,null,null,null,null,"Alex ","Malta ","Microchip ",78900,87600]
[null,12,"Robbin ","USA ","Motherboard ",12300,65400,null,null,null,null,null,"Don ","Mexico ","Laptop ",25000,86500]
[null,13,"Jenny ","UK ","Smartphone ",4300,56700,null,null,null,null,null,"Leo ","Spain ","Computer ",37000,87600]
[null,14,"Smith ","Ghana ","Notebook ",65000,76500,null,null,null,null,null,"Smith ","Ghana ","Notebook ",65000,76500]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"IF and MAX Function","index":5,"n_rows":20,"n_cols":23,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,11,1,16]]}
[]
[null,"Using Name Manager",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Serial No.","Name ","Country ","Product","Sale 1","Sale 2",null,null,null,null,"Serial No.","Name ","Country ","Product","Sale 1","Sale 2"]
[null,{"$f":"IF(C5=\"\",\"\",MAX($B$4:B4)+1)","v":1},"Mike ","UK ","Notebook ",78900,43200,null,null,null,null,null,"Chris ","UK ","Laptop ",25000,56000]
[null,{"$f":"IF(C6=\"\",\"\",MAX($B$4:B5)+1)","v":2},"Alex ","Malta ","Microchip ",78900,87600,null,null,null,null,null,"Lucy ","USA ","Notebook ",34000,45000]
[null,{"$f":"IF(C7=\"\",\"\",MAX($B$4:B6)+1)","v":3},"Bob ","Russia ","Transistor ",54455,76540,null,null,null,null,null,"David ","Italy ","Computer ",23000,75000]
[null,{"$f":"IF(C8=\"\",\"\",MAX($B$4:B7)+1)","v":""},null,null,null,null,null,null,null,null,null,null,"Alan ","Germany ","Laptop ",12300,54300]
[null,{"$f":"IF(C9=\"\",\"\",MAX($B$4:B8)+1)","v":4},"Donald ","USA ","Processor ",45600,5432,null,null,null,null,null,"John ","France ","Computer ",45600,64800]
[null,{"$f":"IF(C10=\"\",\"\",MAX($B$4:B9)+1)","v":""},null,null,null,null,null,null,null,null,null,null,"Jenny ","UK ","Smartphone ",4300,56700]
[null,{"$f":"IF(C11=\"\",\"\",MAX($B$4:B10)+1)","v":5},"Lucy ","USA ","Notebook ",34000,45000,null,null,null,null,null,"Mike ","UK ","Notebook ",78900,43200]
[null,{"$f":"IF(C12=\"\",\"\",MAX($B$4:B11)+1)","v":6},"Chris ","UK ","Laptop ",25000,56000,null,null,null,null,null,"Robbin ","USA ","Motherboard ",12300,65400]
[null,{"$f":"IF(C13=\"\",\"\",MAX($B$4:B12)+1)","v":7},"Don ","Mexico ","Laptop ",25000,86500,null,null,null,null,null,"Donald ","USA ","Processor ",45600,5432]
[null,{"$f":"IF(C14=\"\",\"\",MAX($B$4:B13)+1)","v":""},null,null,null,null,null,null,null,null,null,null,"Bob ","Russia ","Transistor ",54455,76540]
[null,{"$f":"IF(C15=\"\",\"\",MAX($B$4:B14)+1)","v":8},"Alan ","Germany ","Laptop ",12300,54300,null,null,null,null,null,"Alex ","Malta ","Microchip ",78900,87600]
[null,{"$f":"IF(C16=\"\",\"\",MAX($B$4:B15)+1)","v":9},"Robbin ","USA ","Motherboard ",12300,65400,null,null,null,null,null,"Don ","Mexico ","Laptop ",25000,86500]
[null,{"$f":"IF(C17=\"\",\"\",MAX($B$4:B16)+1)","v":""},null,null,null,null,null,null,null,null,null,null,"Leo ","Spain ","Computer ",37000,87600]
[null,{"$f":"IF(C18=\"\",\"\",MAX($B$4:B17)+1)","v":10},"Smith ","Ghana ","Notebook ",65000,76500,null,null,null,null,null,"Smith ","Ghana ","Notebook ",65000,76500]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Using the OFFSET Function","index":6,"n_rows":19,"n_cols":17,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,11,1,16]]}
[]
[null,"Using the OFFSET Function ",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Serial No.","Name ","Country ","Product","Sale 1","Sale 2",null,null,null,null,"Serial No.","Name ","Country ","Product","Sale 1","Sale 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Chris ","UK ","Laptop ",25000,56000]
[null,{"$f":"OFFSET(B6,-1,0)+1","v":1},"Chris ","UK ","Laptop ",25000,56000,null,null,null,null,null,"Lucy ","USA ","Notebook ",34000,45000]
[null,{"$f":"OFFSET(B7,-1,0)+1","v":2},"Lucy ","USA ","Notebook ",34000,45000,null,null,null,null,null,"David ","Italy ","Computer ",23000,75000]
[null,3,"David ","Italy ","Computer ",23000,75000,null,null,null,null,null,"Alan ","Germany ","Laptop ",12300,54300]
[null,4,"Alan ","Germany ","Laptop ",12300,54300,null,null,null,null,null,"John ","France ","Computer ",45600,64800]
[null,5,"John ","France ","Computer ",45600,64800,null,null,null,null,null,"Jenny ","UK ","Smartphone ",4300,56700]
[null,6,"Jenny ","UK ","Smartphone ",4300,56700,null,null,null,null,null,"Mike ","UK ","Notebook ",78900,43200]
[null,7,"Mike ","UK ","Notebook ",78900,43200,null,null,null,null,null,"Robbin ","USA ","Motherboard ",12300,65400]
[null,8,"Robbin ","USA ","Motherboard ",12300,65400,null,null,null,null,null,"Donald ","USA ","Processor ",45600,5432]
[null,9,"Donald ","USA ","Processor ",45600,5432,null,null,null,null,null,"Bob ","Russia ","Transistor ",54455,76540]
[null,10,"Bob ","Russia ","Transistor ",54455,76540,null,null,null,null,null,"Alex ","Malta ","Microchip ",78900,87600]
[null,11,"Alex ","Malta ","Microchip ",78900,87600,null,null,null,null,null,"Don ","Mexico ","Laptop ",25000,86500]
[null,12,"Don ","Mexico ","Laptop ",25000,86500,null,null,null,null,null,"Leo ","Spain ","Computer ",37000,87600]
[null,13,"Leo ","Spain ","Computer ",37000,87600,null,null,null,null,null,"Smith ","Ghana ","Notebook ",65000,76500]
[null,14,"Smith ","Ghana ","Notebook ",65000,76500]

{"sheet":"Using The Row Function","index":7,"n_rows":22,"n_cols":22,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,11,1,16]]}
[]
[null,"Using the ROW Function ",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Serial No.","Name ","Country ","Product","Sale 1","Sale 2",null,null,null,null,"Serial No.","Name ","Country ","Product","Sale 1","Sale 2"]
[null,{"$f":"ROW()-4","v":1},"Chris ","UK ","Laptop ",25000,56000,null,null,null,null,null,"Chris ","UK ","Laptop ",25000,56000]
[null,{"$f":"ROW()-4","v":2},"Lucy ","USA ","Notebook ",34000,45000,null,null,null,null,null,"Lucy ","USA ","Notebook ",34000,45000]
[null,3,"David ","Italy ","Computer ",23000,75000,null,null,null,null,null,"David ","Italy ","Computer ",23000,75000]
[null,4,"Alan ","Germany ","Laptop ",12300,54300,null,null,null,null,null,"Alan ","Germany ","Laptop ",12300,54300]
[null,5,"John ","France ","Computer ",45600,64800,null,null,null,null,null,"John ","France ","Computer ",45600,64800]
[null,6,"Jenny ","UK ","Smartphone ",4300,56700,null,null,null,null,null,"Jenny ","UK ","Smartphone ",4300,56700]
[null,7,"Mike ","UK ","Notebook ",78900,43200,null,null,null,null,null,"Mike ","UK ","Notebook ",78900,43200]
[null,8,"Robbin ","USA ","Motherboard ",12300,65400,null,null,null,null,null,"Robbin ","USA ","Motherboard ",12300,65400]
[null,9,"Donald ","USA ","Processor ",45600,5432,null,null,null,null,null,"Donald ","USA ","Processor ",45600,5432]
[null,10,"Bob ","Russia ","Transistor ",54455,76540,null,null,null,null,null,"Bob ","Russia ","Transistor ",54455,76540]
[null,11,"Alex ","Malta ","Microchip ",78900,87600,null,null,null,null,null,"Alex ","Malta ","Microchip ",78900,87600]
[null,12,"Don ","Mexico ","Laptop ",25000,86500,null,null,null,null,null,"Don ","Mexico ","Laptop ",25000,86500]
[null,13,"Leo ","Spain ","Computer ",37000,87600,null,null,null,null,null,"Leo ","Spain ","Computer ",37000,87600]
[null,14,"Smith ","Ghana ","Notebook ",65000,76500,null,null,null,null,null,"Smith ","Ghana ","Notebook ",65000,76500]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Using the COUNTA Function","index":8,"n_rows":25,"n_cols":21,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,11,1,16]]}
[]
[null,"Using the COUNTA Function ",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Serial No.","Name ","Country ","Product","Sale 1","Sale 2",null,null,null,null,"Serial No.","Name ","Country ","Product","Sale 1","Sale 2"]
[null,{"$f":"IF(ISBLANK(C5),\"\",COUNTA($C$5:C5))","v":1},"Chris ","UK ","Laptop ",25000,56000,null,null,null,null,null,"Chris ","UK ","Laptop ",25000,56000]
[null,{"$f":"IF(ISBLANK(C6),\"\",COUNTA($C$5:C6))","v":2},"David ","Italy ","Computer ",23000,75000,null,null,null,null,null,"Lucy ","USA ","Notebook ",34000,45000]
[null,{"$f":"IF(ISBLANK(C7),\"\",COUNTA($C$5:C7))","v":3},"John ","France ","Computer ",45600,64800,null,null,null,null,null,"David ","Italy ","Computer ",23000,75000]
[null,{"$f":"IF(ISBLANK(C8),\"\",COUNTA($C$5:C8))","v":""},null,null,null,null,null,null,null,null,null,null,"Alan ","Germany ","Laptop ",12300,54300]
[null,{"$f":"IF(ISBLANK(C9),\"\",COUNTA($C$5:C9))","v":4},"Jenny ","UK ","Smartphone ",4300,56700,null,null,null,null,null,"John ","France ","Computer ",45600,64800]
[null,{"$f":"IF(ISBLANK(C10),\"\",COUNTA($C$5:C10))","v":""},null,null,null,null,null,null,null,null,null,null,"Jenny ","UK ","Smartphone ",4300,56700]
[null,{"$f":"IF(ISBLANK(C11),\"\",COUNTA($C$5:C11))","v":5},"Mike ","UK ","Notebook ",78900,43200,null,null,null,null,null,"Mike ","UK ","Notebook ",78900,43200]
[null,{"$f":"IF(ISBLANK(C12),\"\",COUNTA($C$5:C12))","v":6},"Robbin ","USA ","Motherboard ",12300,65400,null,null,null,null,null,"Robbin ","USA ","Motherboard ",12300,65400]
[null,{"$f":"IF(ISBLANK(C13),\"\",COUNTA($C$5:C13))","v":""},null,null,null,null,null,null,null,null,null,null,"Donald ","USA ","Processor ",45600,5432]
[null,{"$f":"IF(ISBLANK(C14),\"\",COUNTA($C$5:C14))","v":7},"Donald ","USA ","Processor ",45600,5432,null,null,null,null,null,"Bob ","Russia ","Transistor ",54455,76540]
[null,{"$f":"IF(ISBLANK(C15),\"\",COUNTA($C$5:C15))","v":""},null,null,null,null,null,null,null,null,null,null,"Alex ","Malta ","Microchip ",78900,87600]
[null,{"$f":"IF(ISBLANK(C16),\"\",COUNTA($C$5:C16))","v":8},"Bob ","Russia ","Transistor ",54455,76540,null,null,null,null,null,"Don ","Mexico ","Laptop ",25000,86500]
[null,{"$f":"IF(ISBLANK(C17),\"\",COUNTA($C$5:C17))","v":9},"Alex ","Malta ","Microchip ",78900,87600,null,null,null,null,null,"Leo ","Spain ","Computer ",37000,87600]
[null,{"$f":"IF(ISBLANK(C18),\"\",COUNTA($C$5:C18))","v":""},null,null,null,null,null,null,null,null,null,null,"Smith ","Ghana ","Notebook ",65000,76500]
[null,{"$f":"IF(ISBLANK(C19),\"\",COUNTA($C$5:C19))","v":10},"Don ","Mexico ","Laptop ",25000,86500]
[null,{"$f":"IF(ISBLANK(C20),\"\",COUNTA($C$5:C20))","v":11},"Leo ","Spain ","Computer ",37000,87600]
[null,{"$f":"IF(ISBLANK(C21),\"\",COUNTA($C$5:C21))","v":12},"Smith ","Ghana ","Notebook ",65000,76500]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Using the SEQUENCE Function","index":9,"n_rows":18,"n_cols":17,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,11,1,16]]}
[]
[null," Using the SEQUENCE Function",null,null,null,null,null,null,null,null,null,"Practice Section"]
[null,{"$f":"_xlfn.SEQUENCE(1,6)","v":1},2,3,4,5,6]
[null,"Serial No.","Name ","Country ","Product","Sale 1","Sale 2",null,null,null,null,"Serial No.","Name ","Country ","Product","Sale 1","Sale 2"]
[null,{"$f":"_xlfn.SEQUENCE(14)","v":1},"Chris ","UK ","Laptop ",25000,56000,null,null,null,null,null,"Chris ","UK ","Laptop ",25000,56000]
[null,2,"Lucy ","USA ","Notebook ",34000,45000,null,null,null,null,null,"Lucy ","USA ","Notebook ",34000,45000]
[null,3,"David ","Italy ","Computer ",23000,75000,null,null,null,null,null,"David ","Italy ","Computer ",23000,75000]
[null,4,"Alan ","Germany ","Laptop ",12300,54300,null,null,null,null,null,"Alan ","Germany ","Laptop ",12300,54300]
[null,5,"John ","France ","Computer ",45600,64800,null,null,null,null,null,"John ","France ","Computer ",45600,64800]
[null,6,"Jenny ","UK ","Smartphone ",4300,56700,null,null,null,null,null,"Jenny ","UK ","Smartphone ",4300,56700]
[null,7,"Mike ","UK ","Notebook ",78900,43200,null,null,null,null,null,"Mike ","UK ","Notebook ",78900,43200]
[null,8,"Robbin ","USA ","Motherboard ",12300,65400,null,null,null,null,null,"Robbin ","USA ","Motherboard ",12300,65400]
[null,9,"Donald ","USA ","Processor ",45600,5432,null,null,null,null,null,"Donald ","USA ","Processor ",45600,5432]
[null,10,"Bob ","Russia ","Transistor ",54455,76540,null,null,null,null,null,"Bob ","Russia ","Transistor ",54455,76540]
[null,11,"Alex ","Malta ","Microchip ",78900,87600,null,null,null,null,null,"Alex ","Malta ","Microchip ",78900,87600]
[null,12,"Don ","Mexico ","Laptop ",25000,86500,null,null,null,null,null,"Don ","Mexico ","Laptop ",25000,86500]
[null,13,"Leo ","Spain ","Computer ",37000,87600,null,null,null,null,null,"Leo ","Spain ","Computer ",37000,87600]
[null,14,"Smith ","Ghana ","Notebook ",65000,76500,null,null,null,null,null,"Smith ","Ghana ","Notebook ",65000,76500]

{"sheet":"By Creating a Table ","index":10,"n_rows":24,"n_cols":22,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,11,1,16]]}
[]
[null,"Creating a Table in Excel ",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Serial No.","Name ","Country ","Product","Sale 1","Sale 2",null,null,null,null,"Serial No.","Name ","Country ","Product","Sale 1","Sale 2"]
[null,{"$f":"ROW()-ROW(Table3[#Headers])","v":1},"Chris ","UK ","Laptop ",25000,56000,null,null,null,null,null,"Chris ","UK ","Laptop ",25000,56000]
[null,{"$f":"ROW()-ROW(Table3[#Headers])","v":2},"Lucy ","USA ","Notebook ",34000,45000,null,null,null,null,null,"Lucy ","USA ","Notebook ",34000,45000]
[null,{"$f":"ROW()-ROW(Table3[#Headers])","v":3},"David ","Italy ","Computer ",23000,75000,null,null,null,null,null,"David ","Italy ","Computer ",23000,75000]
[null,{"$f":"ROW()-ROW(Table3[#Headers])","v":4},"Alan ","Germany ","Laptop ",12300,54300,null,null,null,null,null,"Alan ","Germany ","Laptop ",12300,54300]
[null,{"$f":"ROW()-ROW(Table3[#Headers])","v":5},"John ","France ","Computer ",45600,64800,null,null,null,null,null,"John ","France ","Computer ",45600,64800]
[null,{"$f":"ROW()-ROW(Table3[#Headers])","v":6},"Jenny ","UK ","Smartphone ",4300,56700,null,null,null,null,null,"Jenny ","UK ","Smartphone ",4300,56700]
[null,{"$f":"ROW()-ROW(Table3[#Headers])","v":7},"Mike ","UK ","Notebook ",78900,43200,null,null,null,null,null,"Mike ","UK ","Notebook ",78900,43200]
[null,{"$f":"ROW()-ROW(Table3[#Headers])","v":8},"Robbin ","USA ","Motherboard ",12300,65400,null,null,null,null,null,"Robbin ","USA ","Motherboard ",12300,65400]
[null,{"$f":"ROW()-ROW(Table3[#Headers])","v":9},"Donald ","USA ","Processor ",45600,5432,null,null,null,null,null,"Donald ","USA ","Processor ",45600,5432]
[null,{"$f":"ROW()-ROW(Table3[#Headers])","v":10},"Bob ","Russia ","Transistor ",54455,76540,null,null,null,null,null,"Bob ","Russia ","Transistor ",54455,76540]
[null,{"$f":"ROW()-ROW(Table3[#Headers])","v":11},"Alex ","Malta ","Microchip ",78900,87600,null,null,null,null,null,"Alex ","Malta ","Microchip ",78900,87600]
[null,{"$f":"ROW()-ROW(Table3[#Headers])","v":12},"Don ","Mexico ","Laptop ",25000,86500,null,null,null,null,null,"Don ","Mexico ","Laptop ",25000,86500]
[null,{"$f":"ROW()-ROW(Table3[#Headers])","v":13},"Leo ","Spain ","Computer ",37000,87600,null,null,null,null,null,"Leo ","Spain ","Computer ",37000,87600]
[null,{"$f":"ROW()-ROW(Table3[#Headers])","v":14},"Smith ","Ghana ","Notebook ",65000,76500,null,null,null,null,null,"Smith ","Ghana ","Notebook ",65000,76500]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"SUBTOTAL for Filtered Data","index":11,"n_rows":21,"n_cols":21,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,11,1,16]]}
[]
[null,"Using SUBTOTAL Function",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Serial No.","Name ","Country ","Product","Sale 1","Sale 2",null,null,null,null,"Serial No.","Name ","Country ","Product","Sale 1","Sale 2"]
[null,{"$f":"SUBTOTAL(3,$C$5:C5)","v":1},"Mike ","UK ","Notebook ",78900,43200,null,null,null,null,null,"Chris ","UK ","Laptop ",25000,56000]
[null,{"$f":"SUBTOTAL(3,$C$5:C6)","v":2},"Alex ","Malta ","Microchip ",78900,87600,null,null,null,null,null,"Lucy ","USA ","Notebook ",34000,45000]
[null,{"$f":"SUBTOTAL(3,$C$5:C7)","v":3},"Bob ","Russia ","Transistor ",54455,76540,null,null,null,null,null,"David ","Italy ","Computer ",23000,75000]
[null,{"$f":"SUBTOTAL(3,$C$5:C8)","v":4},"John ","France ","Computer ",45600,64800,null,null,null,null,null,"Alan ","Germany ","Laptop ",12300,54300]
[null,{"$f":"SUBTOTAL(3,$C$5:C9)","v":5},"Donald ","USA ","Processor ",45600,5432,null,null,null,null,null,"John ","France ","Computer ",45600,64800]
[null,{"$f":"SUBTOTAL(3,$C$5:C10)","v":6},"Leo ","Spain ","Computer ",37000,87600,null,null,null,null,null,"Jenny ","UK ","Smartphone ",4300,56700]
[null,{"$f":"SUBTOTAL(3,$C$5:C11)","v":7},"Lucy ","USA ","Notebook ",34000,45000,null,null,null,null,null,"Mike ","UK ","Notebook ",78900,43200]
[null,{"$f":"SUBTOTAL(3,$C$5:C12)","v":8},"Chris ","UK ","Laptop ",25000,56000,null,null,null,null,null,"Robbin ","USA ","Motherboard ",12300,65400]
[null,{"$f":"SUBTOTAL(3,$C$5:C13)","v":9},"Don ","Mexico ","Laptop ",25000,86500,null,null,null,null,null,"Donald ","USA ","Processor ",45600,5432]
[null,{"$f":"SUBTOTAL(3,$C$5:C14)","v":10},"David ","Italy ","Computer ",23000,75000,null,null,null,null,null,"Bob ","Russia ","Transistor ",54455,76540]
[null,{"$f":"SUBTOTAL(3,$C$5:C15)","v":11},"Alan ","Germany ","Laptop ",12300,54300,null,null,null,null,null,"Alex ","Malta ","Microchip ",78900,87600]
[null,{"$f":"SUBTOTAL(3,$C$5:C16)","v":12},"Robbin ","USA ","Motherboard ",12300,65400,null,null,null,null,null,"Don ","Mexico ","Laptop ",25000,86500]
[null,{"$f":"SUBTOTAL(3,$C$5:C17)","v":13},"Jenny ","UK ","Smartphone ",4300,56700,null,null,null,null,null,"Leo ","Spain ","Computer ",37000,87600]
[null,{"$f":"SUBTOTAL(3,$C$5:C18)","v":14},"Smith ","Ghana ","Notebook ",65000,76500,null,null,null,null,null,"Smith ","Ghana ","Notebook ",65000,76500]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"VBA Macros","index":12,"n_rows":18,"n_cols":17,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,11,1,16]]}
[]
[null,"Using VBA Macros for Automatic Serial Numbers ",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Serial No.","Name ","Country ","Product","Sale 1","Sale 2",null,null,null,null,"Serial No.","Name ","Country ","Product","Sale 1","Sale 2"]
[null,1,"Mike ","UK ","Notebook ",78900,43200,null,null,null,null,null,"Chris ","UK ","Laptop ",25000,56000]
[null,2,"Alex ","Malta ","Microchip ",78900,87600,null,null,null,null,null,"Lucy ","USA ","Notebook ",34000,45000]
[null,3,"Bob ","Russia ","Transistor ",54455,76540,null,null,null,null,null,"David ","Italy ","Computer ",23000,75000]
[null,4,"John ","France ","Computer ",45600,64800,null,null,null,null,null,"Alan ","Germany ","Laptop ",12300,54300]
[null,5,"Donald ","USA ","Processor ",45600,5432,null,null,null,null,null,"John ","France ","Computer ",45600,64800]
[null,6,"Leo ","Spain ","Computer ",37000,87600,null,null,null,null,null,"Jenny ","UK ","Smartphone ",4300,56700]
[null,7,"Lucy ","USA ","Notebook ",34000,45000,null,null,null,null,null,"Mike ","UK ","Notebook ",78900,43200]
[null,8,"Chris ","UK ","Laptop ",25000,56000,null,null,null,null,null,"Robbin ","USA ","Motherboard ",12300,65400]
[null,9,"Don ","Mexico ","Laptop ",25000,86500,null,null,null,null,null,"Donald ","USA ","Processor ",45600,5432]
[null,10,"David ","Italy ","Computer ",23000,75000,null,null,null,null,null,"Bob ","Russia ","Transistor ",54455,76540]
[null,11,"Alan ","Germany ","Laptop ",12300,54300,null,null,null,null,null,"Alex ","Malta ","Microchip ",78900,87600]
[null,12,"Robbin ","USA ","Motherboard ",12300,65400,null,null,null,null,null,"Don ","Mexico ","Laptop ",25000,86500]
[null,13,"Jenny ","UK ","Smartphone ",4300,56700,null,null,null,null,null,"Leo ","Spain ","Computer ",37000,87600]
[null,14,"Smith ","Ghana ","Notebook ",65000,76500,null,null,null,null,null,"Smith ","Ghana ","Notebook ",65000,76500]

{"sheet":"COLUMN Function","index":13,"n_rows":19,"n_cols":17,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,11,1,16]]}
[]
[null,"Automatic Numbering of the Column",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Column Serial",{"$f":"COLUMN(B4)-COLUMN($A$3)","v":1},{"$f":"COLUMN(C4)-COLUMN($A$3)","v":2},3,4,5,null,null,null,null,"Serial No.","Name ","Country ","Product","Sale 1","Sale 2"]
[null,"Row Serial","Name ","Country ","Product","Sale 1","Sale 2",null,null,null,null,null,"Chris ","UK ","Laptop ",25000,56000]
[null,1,"Mike ","UK ","Notebook ",78900,43200,null,null,null,null,null,"Lucy ","USA ","Notebook ",34000,45000]
[null,2,"Alex ","Malta ","Microchip ",78900,87600,null,null,null,null,null,"David ","Italy ","Computer ",23000,75000]
[null,3,"Bob ","Russia ","Transistor ",54455,76540,null,null,null,null,null,"Alan ","Germany ","Laptop ",12300,54300]
[null,4,"John ","France ","Computer ",45600,64800,null,null,null,null,null,"John ","France ","Computer ",45600,64800]
[null,5,"Donald ","USA ","Processor ",45600,5432,null,null,null,null,null,"Jenny ","UK ","Smartphone ",4300,56700]
[null,6,"Leo ","Spain ","Computer ",37000,87600,null,null,null,null,null,"Mike ","UK ","Notebook ",78900,43200]
[null,7,"Lucy ","USA ","Notebook ",34000,45000,null,null,null,null,null,"Robbin ","USA ","Motherboard ",12300,65400]
[null,8,"Chris ","UK ","Laptop ",25000,56000,null,null,null,null,null,"Donald ","USA ","Processor ",45600,5432]
[null,9,"Don ","Mexico ","Laptop ",25000,86500,null,null,null,null,null,"Bob ","Russia ","Transistor ",54455,76540]
[null,10,"David ","Italy ","Computer ",23000,75000,null,null,null,null,null,"Alex ","Malta ","Microchip ",78900,87600]
[null,11,"Alan ","Germany ","Laptop ",12300,54300,null,null,null,null,null,"Don ","Mexico ","Laptop ",25000,86500]
[null,12,"Robbin ","USA ","Motherboard ",12300,65400,null,null,null,null,null,"Leo ","Spain ","Computer ",37000,87600]
[null,13,"Jenny ","UK ","Smartphone ",4300,56700,null,null,null,null,null,"Smith ","Ghana ","Notebook ",65000,76500]
[null,14,"Smith ","Ghana ","Notebook ",65000,76500]