{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Dataset","Home","Custom Tab","QAT","Format Painter","Paste Special","Keyboard Shortcut","Table Formatting","Pivot Table","VBA","Remove Format of Specific Cell","Remove Format, Keep Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":2},"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":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Sales Report"]
[]
[null,"Sales Rep","Order Date","Product Name","Unit Price","Unit","Sales"]
[null,"Jonas","2022-01-05","Apple",4,1550,{"$f":"E5*F5","v":6200}]
[null,"Harry","2022-01-25","Orange",8,1468,{"$f":"E6*F6","v":11744}]
[null,"Nick","2022-02-08","Guava",4,1265,5060]
[null,"Sara","2022-02-22","Coconut",5,4500,22500]
[null,"John","2022-03-16","Apricot",3,3025,9075]
[null,"Leon","2022-03-25","Watermelon",7,2550,17850]
[null,"Tom","2022-04-21","Jackfruit",9,1560,14040]
[null,"Hardy","2022-04-17","Kiwi",3,4050,12150]
[null,"Mark","2022-05-09","Lemon",6,1900,11400]
[null,"Chris","2022-05-19","Avocado",5,2050,10250]

{"sheet":"Home","index":1,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,9,1,14]]}
[]
[null,"Using Home Tab",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Rep","Order Date","Product Name","Unit Price","Unit","Sales",null,null,"Sales Rep","Order Date","Product Name","Unit Price","Unit","Sales"]
[null,"Jonas",44566,"Apple",4,1550,{"$f":"E5*F5","v":6200},null,null,"Jonas","2022-01-05","Apple",4,1550,{"$f":"M5*N5","v":6200}]
[null,"Harry",44586,"Orange",8,1468,{"$f":"E6*F6","v":11744},null,null,"Harry","2022-01-25","Orange",8,1468,{"$f":"M6*N6","v":11744}]
[null,"Nick",44600,"Guava",4,1265,5060,null,null,"Nick","2022-02-08","Guava",4,1265,5060]
[null,"Sara",44614,"Coconut",5,4500,22500,null,null,"Sara","2022-02-22","Coconut",5,4500,22500]
[null,"John",44636,"Apricot",3,3025,9075,null,null,"John","2022-03-16","Apricot",3,3025,9075]
[null,"Leon",44645,"Watermelon",7,2550,17850,null,null,"Leon","2022-03-25","Watermelon",7,2550,17850]
[null,"Tom",44672,"Jackfruit",9,1560,14040,null,null,"Tom","2022-04-21","Jackfruit",9,1560,14040]
[null,"Hardy",44668,"Kiwi",3,4050,12150,null,null,"Hardy","2022-04-17","Kiwi",3,4050,12150]
[null,"Mark",44690,"Lemon",6,1900,11400,null,null,"Mark","2022-05-09","Lemon",6,1900,11400]
[null,"Chris",44700,"Avocado",5,2050,10250,null,null,"Chris","2022-05-19","Avocado",5,2050,10250]

{"sheet":"Custom Tab","index":2,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,9,1,14]]}
[]
[null,"Utilizing New Customized Tab",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Rep","Order Date","Product Name","Unit Price","Unit","Sales",null,null,"Sales Rep","Order Date","Product Name","Unit Price","Unit","Sales"]
[null,"Jonas",44566,"Apple",4,1550,{"$f":"E5*F5","v":6200},null,null,"Jonas","2022-01-05","Apple",4,1550,{"$f":"M5*N5","v":6200}]
[null,"Harry",44586,"Orange",8,1468,{"$f":"E6*F6","v":11744},null,null,"Harry","2022-01-25","Orange",8,1468,{"$f":"M6*N6","v":11744}]
[null,"Nick",44600,"Guava",4,1265,5060,null,null,"Nick","2022-02-08","Guava",4,1265,5060]
[null,"Sara",44614,"Coconut",5,4500,22500,null,null,"Sara","2022-02-22","Coconut",5,4500,22500]
[null,"John",44636,"Apricot",3,3025,9075,null,null,"John","2022-03-16","Apricot",3,3025,9075]
[null,"Leon",44645,"Watermelon",7,2550,17850,null,null,"Leon","2022-03-25","Watermelon",7,2550,17850]
[null,"Tom",44672,"Jackfruit",9,1560,14040,null,null,"Tom","2022-04-21","Jackfruit",9,1560,14040]
[null,"Hardy",44668,"Kiwi",3,4050,12150,null,null,"Hardy","2022-04-17","Kiwi",3,4050,12150]
[null,"Mark",44690,"Lemon",6,1900,11400,null,null,"Mark","2022-05-09","Lemon",6,1900,11400]
[null,"Chris",44700,"Avocado",5,2050,10250,null,null,"Chris","2022-05-19","Avocado",5,2050,10250]

{"sheet":"QAT","index":3,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,9,1,14]]}
[]
[null,"Handling Quick Access Toolbar",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Rep","Order Date","Product Name","Unit Price","Unit","Sales",null,null,"Sales Rep","Order Date","Product Name","Unit Price","Unit","Sales"]
[null,"Jonas",44566,"Apple",4,1550,{"$f":"E5*F5","v":6200},null,null,"Jonas","2022-01-05","Apple",4,1550,{"$f":"M5*N5","v":6200}]
[null,"Harry",44586,"Orange",8,1468,{"$f":"E6*F6","v":11744},null,null,"Harry","2022-01-25","Orange",8,1468,{"$f":"M6*N6","v":11744}]
[null,"Nick",44600,"Guava",4,1265,5060,null,null,"Nick","2022-02-08","Guava",4,1265,5060]
[null,"Sara",44614,"Coconut",5,4500,22500,null,null,"Sara","2022-02-22","Coconut",5,4500,22500]
[null,"John",44636,"Apricot",3,3025,9075,null,null,"John","2022-03-16","Apricot",3,3025,9075]
[null,"Leon",44645,"Watermelon",7,2550,17850,null,null,"Leon","2022-03-25","Watermelon",7,2550,17850]
[null,"Tom",44672,"Jackfruit",9,1560,14040,null,null,"Tom","2022-04-21","Jackfruit",9,1560,14040]
[null,"Hardy",44668,"Kiwi",3,4050,12150,null,null,"Hardy","2022-04-17","Kiwi",3,4050,12150]
[null,"Mark",44690,"Lemon",6,1900,11400,null,null,"Mark","2022-05-09","Lemon",6,1900,11400]
[null,"Chris",44700,"Avocado",5,2050,10250,null,null,"Chris","2022-05-19","Avocado",5,2050,10250]

{"sheet":"Format Painter","index":4,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,9,1,14]]}
[]
[null,"Employing Format Painter Option",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Rep","Order Date","Product Name","Unit Price","Unit","Sales",null,null,"Sales Rep","Order Date","Product Name","Unit Price","Unit","Sales"]
[null,"Jonas",44566,"Apple",4,1550,{"$f":"E5*F5","v":6200},null,null,"Jonas","2022-01-05","Apple",4,1550,{"$f":"M5*N5","v":6200}]
[null,"Harry",44586,"Orange",8,1468,{"$f":"E6*F6","v":11744},null,null,"Harry","2022-01-25","Orange",8,1468,{"$f":"M6*N6","v":11744}]
[null,"Nick",44600,"Guava",4,1265,5060,null,null,"Nick","2022-02-08","Guava",4,1265,5060]
[null,"Sara",44614,"Coconut",5,4500,22500,null,null,"Sara","2022-02-22","Coconut",5,4500,22500]
[null,"John",44636,"Apricot",3,3025,9075,null,null,"John","2022-03-16","Apricot",3,3025,9075]
[null,"Leon",44645,"Watermelon",7,2550,17850,null,null,"Leon","2022-03-25","Watermelon",7,2550,17850]
[null,"Tom",44672,"Jackfruit",9,1560,14040,null,null,"Tom","2022-04-21","Jackfruit",9,1560,14040]
[null,"Hardy",44668,"Kiwi",3,4050,12150,null,null,"Hardy","2022-04-17","Kiwi",3,4050,12150]
[null,"Mark",44690,"Lemon",6,1900,11400,null,null,"Mark","2022-05-09","Lemon",6,1900,11400]
[null,"Chris",44700,"Avocado",5,2050,10250,null,null,"Chris","2022-05-19","Avocado",5,2050,10250]

{"sheet":"Paste Special","index":5,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,9,1,14]]}
[]
[null,"Using Paste Special Tool",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Rep","Order Date","Product Name","Unit Price","Unit","Sales",null,null,"Sales Rep","Order Date","Product Name","Unit Price","Unit","Sales"]
[null,"Jonas",44566,"Apple",4,1550,{"$f":"E5*F5","v":6200},null,null,"Jonas","2022-01-05","Apple",4,1550,{"$f":"M5*N5","v":6200}]
[null,"Harry",44586,"Orange",8,1468,{"$f":"E6*F6","v":11744},null,null,"Harry","2022-01-25","Orange",8,1468,{"$f":"M6*N6","v":11744}]
[null,"Nick",44600,"Guava",4,1265,5060,null,null,"Nick","2022-02-08","Guava",4,1265,5060]
[null,"Sara",44614,"Coconut",5,4500,22500,null,null,"Sara","2022-02-22","Coconut",5,4500,22500]
[null,"John",44636,"Apricot",3,3025,9075,null,null,"John","2022-03-16","Apricot",3,3025,9075]
[null,"Leon",44645,"Watermelon",7,2550,17850,null,null,"Leon","2022-03-25","Watermelon",7,2550,17850]
[null,"Tom",44672,"Jackfruit",9,1560,14040,null,null,"Tom","2022-04-21","Jackfruit",9,1560,14040]
[null,"Hardy",44668,"Kiwi",3,4050,12150,null,null,"Hardy","2022-04-17","Kiwi",3,4050,12150]
[null,"Mark",44690,"Lemon",6,1900,11400,null,null,"Mark","2022-05-09","Lemon",6,1900,11400]
[null,"Chris",44700,"Avocado",5,2050,10250,null,null,"Chris","2022-05-19","Avocado",5,2050,10250]

{"sheet":"Keyboard Shortcut","index":6,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,9,1,14]]}
[]
[null,"Implementing Keyboard Shortcut",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Rep","Order Date","Product Name","Unit Price","Unit","Sales",null,null,"Sales Rep","Order Date","Product Name","Unit Price","Unit","Sales"]
[null,"Jonas",44566,"Apple",4,1550,{"$f":"E5*F5","v":6200},null,null,"Jonas","2022-01-05","Apple",4,1550,{"$f":"M5*N5","v":6200}]
[null,"Harry",44586,"Orange",8,1468,{"$f":"E6*F6","v":11744},null,null,"Harry","2022-01-25","Orange",8,1468,{"$f":"M6*N6","v":11744}]
[null,"Nick",44600,"Guava",4,1265,5060,null,null,"Nick","2022-02-08","Guava",4,1265,5060]
[null,"Sara",44614,"Coconut",5,4500,22500,null,null,"Sara","2022-02-22","Coconut",5,4500,22500]
[null,"John",44636,"Apricot",3,3025,9075,null,null,"John","2022-03-16","Apricot",3,3025,9075]
[null,"Leon",44645,"Watermelon",7,2550,17850,null,null,"Leon","2022-03-25","Watermelon",7,2550,17850]
[null,"Tom",44672,"Jackfruit",9,1560,14040,null,null,"Tom","2022-04-21","Jackfruit",9,1560,14040]
[null,"Hardy",44668,"Kiwi",3,4050,12150,null,null,"Hardy","2022-04-17","Kiwi",3,4050,12150]
[null,"Mark",44690,"Lemon",6,1900,11400,null,null,"Mark","2022-05-09","Lemon",6,1900,11400]
[null,"Chris",44700,"Avocado",5,2050,10250,null,null,"Chris","2022-05-19","Avocado",5,2050,10250]

{"sheet":"Table Formatting","index":7,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Clearing Table Formatting"]
[]
[null,"Sales Rep","Order Date","Product Name","Unit Price","Unit","Sales"]
[null,"Jonas","2022-01-05","Apple",4,1550,{"$f":"E5*F5","v":6200}]
[null,"Harry","2022-01-25","Orange",8,1468,{"$f":"E6*F6","v":11744}]
[null,"Nick","2022-02-08","Guava",4,1265,5060]
[null,"Sara","2022-02-22","Coconut",5,4500,22500]
[null,"John","2022-03-16","Apricot",3,3025,9075]
[null,"Leon",44645,"Watermelon",7,2550,17850]
[null,"Tom","2022-04-21","Jackfruit",9,1560,14040]
[null,"Hardy","2022-04-17","Kiwi",3,4050,12150]
[null,"Mark","2022-05-09","Lemon",6,1900,11400]
[null,"Chris","2022-05-19","Avocado",5,2050,10250]

{"sheet":"Pivot Table","index":8,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Clearing Pivot Table Formatting",null,null,null,null,"Do It Yourself"]
[]
[null,"Row Labels","Sum of Unit","Sum of Sales",null,null,"Row Labels","Sum of Unit","Sum of Sales"]
[null,"Chris",2050,10250,null,null,"Chris",2050,10250]
[null,"Hardy",4050,12150,null,null,"Hardy",4050,12150]
[null,"Harry",1468,11744,null,null,"Harry",1468,11744]
[null,"John",3025,9075,null,null,"John",3025,9075]
[null,"Jonas",1550,6200,null,null,"Jonas",1550,6200]
[null,"Leon",2550,17850,null,null,"Leon",2550,17850]
[null,"Mark",1900,11400,null,null,"Mark",1900,11400]
[null,"Nick",1265,5060,null,null,"Nick",1265,5060]
[null,"Sara",4500,22500,null,null,"Sara",4500,22500]
[null,"Tom",1560,14040,null,null,"Tom",1560,14040]
[null,"Grand Total",23918,120269,null,null,"Grand Total",23918,120269]

{"sheet":"VBA","index":9,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,9,1,14]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Rep","Order Date","Product Name","Unit Price","Unit","Sales",null,null,"Sales Rep","Order Date","Product Name","Unit Price","Unit","Sales"]
[null,"Jonas",44566,"Apple",4,1550,{"$f":"E5*F5","v":6200},null,null,"Jonas","2022-01-05","Apple",4,1550,{"$f":"M5*N5","v":6200}]
[null,"Harry",44586,"Orange",8,1468,{"$f":"E6*F6","v":11744},null,null,"Harry","2022-01-25","Orange",8,1468,{"$f":"M6*N6","v":11744}]
[null,"Nick",44600,"Guava",4,1265,5060,null,null,"Nick","2022-02-08","Guava",4,1265,5060]
[null,"Sara",44614,"Coconut",5,4500,22500,null,null,"Sara","2022-02-22","Coconut",5,4500,22500]
[null,"John",44636,"Apricot",3,3025,9075,null,null,"John","2022-03-16","Apricot",3,3025,9075]
[null,"Leon",44645,"Watermelon",7,2550,17850,null,null,"Leon","2022-03-25","Watermelon",7,2550,17850]
[null,"Tom",44672,"Jackfruit",9,1560,14040,null,null,"Tom","2022-04-21","Jackfruit",9,1560,14040]
[null,"Hardy",44668,"Kiwi",3,4050,12150,null,null,"Hardy","2022-04-17","Kiwi",3,4050,12150]
[null,"Mark",44690,"Lemon",6,1900,11400,null,null,"Mark","2022-05-09","Lemon",6,1900,11400]
[null,"Chris",44700,"Avocado",5,2050,10250,null,null,"Chris","2022-05-19","Avocado",5,2050,10250]

{"sheet":"Remove Format of Specific Cell","index":10,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,9,1,14]]}
[]
[null,"Removing Formatting without Removing Contents",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Rep","Order Date","Product Name","Unit Price","Unit","Sales",null,null,"Sales Rep","Order Date","Product Name","Unit Price","Unit","Sales"]
[null,"Jonas","2022-01-05","Apple",4,1550,{"$f":"E5*F5","v":6200},null,null,"Jonas","2022-01-05","Apple",4,1550,{"$f":"M5*N5","v":6200}]
[null,"Harry","2022-01-25","Orange",8,1468,{"$f":"E6*F6","v":11744},null,null,"Harry","2022-01-25","Orange",8,1468,{"$f":"M6*N6","v":11744}]
[null,"Nick","2022-02-08","Guava",4,1265,5060,null,null,"Nick","2022-02-08","Guava",4,1265,5060]
[null,"Sara",44614,"Coconut",5,4500,22500,null,null,"Sara","2022-02-22","Coconut",5,4500,22500]
[null,"John","2022-03-16","Apricot",3,3025,9075,null,null,"John","2022-03-16","Apricot",3,3025,9075]
[null,"Leon",44645,"Watermelon",7,2550,17850,null,null,"Leon","2022-03-25","Watermelon",7,2550,17850]
[null,"Tom","2022-04-21","Jackfruit",9,1560,14040,null,null,"Tom","2022-04-21","Jackfruit",9,1560,14040]
[null,"Hardy","2022-04-17","Kiwi",3,4050,12150,null,null,"Hardy","2022-04-17","Kiwi",3,4050,12150]
[null,"Mark","2022-05-09","Lemon",6,1900,11400,null,null,"Mark","2022-05-09","Lemon",6,1900,11400]
[null,"Chris","2022-05-19","Avocado",5,2050,10250,null,null,"Chris","2022-05-19","Avocado",5,2050,10250]

{"sheet":"Remove Format, Keep Data","index":11,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Removing Table Formatting but Keeping Data"]
[]
[null,"Sales Rep","Order Date","Product Name","Unit Price","Unit","Sales"]
[null,"Jonas",44566,"Apple",4,1550,{"$f":"E5*F5","v":6200}]
[null,"Harry",44586,"Orange",8,1468,{"$f":"E6*F6","v":11744}]
[null,"Nick",44600,"Guava",4,1265,5060]
[null,"Sara",44614,"Coconut",5,4500,22500]
[null,"John",44636,"Apricot",3,3025,9075]
[null,"Leon",44645,"Watermelon",7,2550,17850]
[null,"Tom",44672,"Jackfruit",9,1560,14040]
[null,"Hardy",44668,"Kiwi",3,4050,12150]
[null,"Mark",44690,"Lemon",6,1900,11400]
[null,"Chris",44700,"Avocado",5,2050,10250]