{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Excel Options","Automatic","Calculate Now","Keyboard Shortcut","Table","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sales of Products"]
[]
[null,"Product Name","Unit Price","Quantity","Total Price"]
[null,"Mobile",400,10,{"$f":"C5*D5","v":4000}]
[null,"Keyboard",120,12]
[null,"Television",1400,5]
[null,"Speaker",100,3]
[null,"Headphone",75,7]
[null,"LED Light",10,18]
[null,"Router",125,6]
[null,"Trimmer",80,9]
[null,"Mouse",50,14]
[null,"Laptop",1000,8]

{"sheet":"Excel Options","index":1,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Using Excel Options",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product Name","Unit Price","Quantity","Total Price",null,null,null,"Product Name","Unit Price","Quantity","Total Price"]
[null,"Mobile",400,10,{"$f":"C5*D5","v":4000},null,null,null,"Mobile",400,10]
[null,"Keyboard",120,12,{"$f":"C6*D6","v":1440},null,null,null,"Keyboard",120,12]
[null,"Television",1400,5,7000,null,null,null,"Television",1400,5]
[null,"Speaker",100,3,300,null,null,null,"Speaker",100,3]
[null,"Headphone",75,7,525,null,null,null,"Headphone",75,7]
[null,"LED Light",10,18,180,null,null,null,"LED Light",10,18]
[null,"Router",125,6,750,null,null,null,"Router",125,6]
[null,"Trimmer",80,9,720,null,null,null,"Trimmer",80,9]
[null,"Mouse",50,14,700,null,null,null,"Mouse",50,14]
[null,"Laptop",1000,8,8000,null,null,null,"Laptop",1000,8]

{"sheet":"Automatic","index":2,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Enabling Calculations Options to Automatic",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product Name","Unit Price","Quantity","Total Price",null,null,null,"Product Name","Unit Price","Quantity","Total Price"]
[null,"Mobile",400,10,{"$f":"C5*D5","v":4000},null,null,null,"Mobile",400,10]
[null,"Keyboard",120,12,{"$f":"C6*D6","v":1440},null,null,null,"Keyboard",120,12]
[null,"Television",1400,5,7000,null,null,null,"Television",1400,5]
[null,"Speaker",100,3,300,null,null,null,"Speaker",100,3]
[null,"Headphone",75,7,525,null,null,null,"Headphone",75,7]
[null,"LED Light",10,18,180,null,null,null,"LED Light",10,18]
[null,"Router",125,6,750,null,null,null,"Router",125,6]
[null,"Trimmer",80,9,720,null,null,null,"Trimmer",80,9]
[null,"Mouse",50,14,700,null,null,null,"Mouse",50,14]
[null,"Laptop",1000,8,8000,null,null,null,"Laptop",1000,8]

{"sheet":"Calculate Now","index":3,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Using Calculate Now Option",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product Name","Unit Price","Quantity","Total Price",null,null,null,"Product Name","Unit Price","Quantity","Total Price"]
[null,"Mobile",400,10,{"$f":"C5*D5","v":4000},null,null,null,"Mobile",400,10]
[null,"Keyboard",120,12,{"$f":"C6*D6","v":1440},null,null,null,"Keyboard",120,12]
[null,"Television",1400,5,7000,null,null,null,"Television",1400,5]
[null,"Speaker",100,3,300,null,null,null,"Speaker",100,3]
[null,"Headphone",75,7,525,null,null,null,"Headphone",75,7]
[null,"LED Light",10,18,180,null,null,null,"LED Light",10,18]
[null,"Router",125,6,750,null,null,null,"Router",125,6]
[null,"Trimmer",80,9,720,null,null,null,"Trimmer",80,9]
[null,"Mouse",50,14,700,null,null,null,"Mouse",50,14]
[null,"Laptop",1000,8,8000,null,null,null,"Laptop",1000,8]

{"sheet":"Keyboard Shortcut","index":4,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Applying Keyboard Shortcut",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product Name","Unit Price","Quantity","Total Price",null,null,null,"Product Name","Unit Price","Quantity","Total Price"]
[null,"Mobile",400,10,{"$f":"C5*D5","v":4000},null,null,null,"Mobile",400,10]
[null,"Keyboard",120,12,{"$f":"C6*D6","v":1440},null,null,null,"Keyboard",120,12]
[null,"Television",1400,5,7000,null,null,null,"Television",1400,5]
[null,"Speaker",100,3,300,null,null,null,"Speaker",100,3]
[null,"Headphone",75,7,525,null,null,null,"Headphone",75,7]
[null,"LED Light",10,18,180,null,null,null,"LED Light",10,18]
[null,"Router",125,6,750,null,null,null,"Router",125,6]
[null,"Trimmer",80,9,720,null,null,null,"Trimmer",80,9]
[null,"Mouse",50,14,700,null,null,null,"Mouse",50,14]
[null,"Laptop",1000,8,8000,null,null,null,"Laptop",1000,8]

{"sheet":"Table","index":5,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Auto Calculate for a Table",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product Name","Unit Price","Quantity","Total Price",null,null,null,"Product Name","Unit Price","Quantity","Total Price"]
[null,"Mobile",400,10,{"$f":"Table2[[#This Row],[Unit Price]]*Table2[[#This Row],[Quantity]]","v":4000},null,null,null,"Mobile",400,10]
[null,"Keyboard",120,12,{"$f":"Table2[[#This Row],[Unit Price]]*Table2[[#This Row],[Quantity]]","v":1440},null,null,null,"Keyboard",120,12]
[null,"Television",1400,5,{"$f":"Table2[[#This Row],[Unit Price]]*Table2[[#This Row],[Quantity]]","v":7000},null,null,null,"Television",1400,5]
[null,"Speaker",100,3,{"$f":"Table2[[#This Row],[Unit Price]]*Table2[[#This Row],[Quantity]]","v":300},null,null,null,"Speaker",100,3]
[null,"Headphone",75,7,{"$f":"Table2[[#This Row],[Unit Price]]*Table2[[#This Row],[Quantity]]","v":525},null,null,null,"Headphone",75,7]
[null,"LED Light",10,18,{"$f":"Table2[[#This Row],[Unit Price]]*Table2[[#This Row],[Quantity]]","v":180},null,null,null,"LED Light",10,18]
[null,"Router",125,6,{"$f":"Table2[[#This Row],[Unit Price]]*Table2[[#This Row],[Quantity]]","v":750},null,null,null,"Router",125,6]
[null,"Trimmer",80,9,{"$f":"Table2[[#This Row],[Unit Price]]*Table2[[#This Row],[Quantity]]","v":720},null,null,null,"Trimmer",80,9]
[null,"Mouse",50,14,{"$f":"Table2[[#This Row],[Unit Price]]*Table2[[#This Row],[Quantity]]","v":700},null,null,null,"Mouse",50,14]
[null,"Laptop",1000,8,{"$f":"Table2[[#This Row],[Unit Price]]*Table2[[#This Row],[Quantity]]","v":8000},null,null,null,"Laptop",1000,8]

{"sheet":"VBA","index":6,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Applying VBA Code to Auto Calculate",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product Name","Unit Price","Quantity","Total Price",null,null,null,"Product Name","Unit Price","Quantity","Total Price"]
[null,"Mobile",400,10,4000,null,null,null,"Mobile",400,10]
[null,"Keyboard",120,12,1440,null,null,null,"Keyboard",120,12]
[null,"Television",1400,5,7000,null,null,null,"Television",1400,5]
[null,"Speaker",100,3,300,null,null,null,"Speaker",100,3]
[null,"Headphone",75,7,525,null,null,null,"Headphone",75,7]
[null,"LED Light",10,18,180,null,null,null,"LED Light",10,18]
[null,"Router",125,6,750,null,null,null,"Router",125,6]
[null,"Trimmer",80,9,720,null,null,null,"Trimmer",80,9]
[null,"Mouse",50,14,700,null,null,null,"Mouse",50,14]
[null,"Laptop",1000,8,8000,null,null,null,"Laptop",1000,8]