{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","Table and Pivot Table","Pivot Table","OFFSET and COUNTA","Filter Feature","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Creating Table Based on Cell Value"]
[]
[null,"Product","Quantity","Profit"]
[null,"Laptop",6,10000]
[null,"Mobile",4,12000]
[null,"Mouse",7,8000]
[null,"Printer",10,14000]
[null,"Monitor",9,20000]

{"sheet":"Table and Pivot Table","index":1,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Using Table and Pivot Table",null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Product","Quantity","Profit",null,null,null,"Product","Quantity","Profit"]
[null,"Laptop",6,10000,null,null,null,"Laptop",6,10000]
[null,"Mobile",4,12000,null,null,null,"Mobile",4,12000]
[null,"Mouse",7,8000,null,null,null,"Mouse",7,8000]
[null,"Printer",10,14000,null,null,null,"Printer",10,14000]
[null,"Monitor",9,20000,null,null,null,"Monitor",9,20000]
[null,"Battery",4,7000]

{"sheet":"Pivot Table","index":2,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Row Labels","Sum of Profit"]
["Laptop",10000]
["Mobile",12000]
["Monitor",20000]
["Mouse",8000]
["Printer",14000]
["Battery",7000]
["Grand Total",71000]

{"sheet":"OFFSET and COUNTA","index":3,"n_rows":21,"n_cols":15,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,14]]}
[]
[null,"Use of OFFSET and COUNTA Functions",null,null,null,null,null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Product","Quantity","Profit",null,null,null,null,null,null,null,null,"Product","Quantity","Profit"]
[null,"Laptop",6,10000,null,null,null,null,null,null,null,null,"Laptop",6,10000]
[null,"Mobile",4,12000,null,null,null,null,null,null,null,null,"Mobile",4,12000]
[null,"Mouse",7,8000,null,null,null,null,null,null,null,null,"Mouse",7,8000]
[null,"Printer",10,14000,null,null,null,null,null,null,null,null,"Printer",10,14000]
[null,"Monitor",9,20000,null,null,null,null,null,null,null,null,"Monitor",9,20000]
[null,"Batterty",7,9000]
[]
[]
[]
[]
[null,null,{"$f":"Profit_list","v":"Product"},"Quantity","Profit"]
[null,null,"Laptop",6,10000]
[null,null,"Mobile",4,12000]
[null,null,"Mouse",7,8000]
[null,null,"Printer",10,14000]
[null,null,"Monitor",9,20000]
[null,null,"Batterty",7,9000]

{"sheet":"Filter Feature","index":4,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Filter Feature"]
[]
[null,"Date","Product","Profit"]
[null,"2022-01-03","Laptop",10000]
[null,"2022-02-01","Monitor",12000]
[null,"2022-04-09","Laptop",8000]
[null,"2022-05-01","Laptop",14000]
[null,"2022-06-14","Monitor",20000,null,null,null,null,null,null,"2022-06-14","Monitor",20000]
[null,"2022-07-10","Monitor",25000]
[null,"2022-07-19","Laptop",22000]
[null,"2022-08-01","Laptop",27000]

{"sheet":"VBA","index":5,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Applying VBA"]
[]
[null,"Rows",5]
[]
[null,"Fixed Headings","Product","Quantity","Profit"]
[]
[null,"Product","Quantity","Profit"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]