{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Dataset-1","CHAR Function","TEXTJOIN Function","CONCATENATE and CHAR Functions","Keyboard Shortcut","Wrap Text Toggle","Named Range","Find and Replace","VBA Code","Dataset-2","New Line in Cell Formula"],"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-1","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"List of Best Selling Books"]
[]
[null,"Book Name","Author","Genre"]
[null,"Poor Economics"," Abhijit Banarjee"," Economics"]
[null,"House of Wisdom"," Jim Khalili"," History"]
[null,"Purple Cow"," Seth Godin"," Marketing"]
[null,"Made to Stick"," Chip Heath"," Self Help"]
[null,"The Black Swan"," Nassim Taleb"," Philosophy"]
[null,"Thinking Fast and Slow"," Daniel Kahneman"," Psychology"]

{"sheet":"CHAR Function","index":1,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Using CHAR Function",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Book Name","Author","Genre","Output",null,null,null,null,null,null,"Book Name","Author","Genre","Output"]
[null,"Poor Economics"," Abhijit Banarjee"," Economics",{"$f":"B5 & CHAR(10) & C5 & CHAR(10) & D5","v":"Poor Economics\n Abhijit Banarjee\n Economics"},null,null,null,null,null,null,"Poor Economics"," Abhijit Banarjee"," Economics"]
[null,"House of Wisdom"," Jim Khalili"," History",{"$f":"B6 & CHAR(10) & C6 & CHAR(10) & D6","v":"House of Wisdom\n Jim Khalili\n History"},null,null,null,null,null,null,"House of Wisdom"," Jim Khalili"," History"]
[null,"Purple Cow"," Seth Godin"," Marketing","Purple Cow\n Seth Godin\n Marketing",null,null,null,null,null,null,"Purple Cow"," Seth Godin"," Marketing"]
[null,"Made to Stick"," Chip Heath"," Self Help","Made to Stick\n Chip Heath\n Self Help",null,null,null,null,null,null,"Made to Stick"," Chip Heath"," Self Help"]
[null,"The Black Swan"," Nassim Taleb"," Philosophy","The Black Swan\n Nassim Taleb\n Philosophy",null,null,null,null,null,null,"The Black Swan"," Nassim Taleb"," Philosophy"]
[null,"Thinking Fast and Slow"," Daniel Kahneman"," Psychology","Thinking Fast and Slow\n Daniel Kahneman\n Psychology",null,null,null,null,null,null,"Thinking Fast and Slow"," Daniel Kahneman"," Psychology"]

{"sheet":"TEXTJOIN Function","index":2,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Using TEXTJOIN Function",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Book Name","Author","Genre","Output",null,null,null,null,null,null,"Book Name","Author","Genre","Output"]
[null,"Poor Economics"," Abhijit Banarjee"," Economics",{"$f":"_xlfn.TEXTJOIN(CHAR(10),TRUE,B5:D5)","v":"Poor Economics\n Abhijit Banarjee\n Economics"},null,null,null,null,null,null,"Poor Economics"," Abhijit Banarjee"," Economics"]
[null,"House of Wisdom"," Jim Khalili"," History",{"$f":"_xlfn.TEXTJOIN(CHAR(10),TRUE,B6:D6)","v":"House of Wisdom\n Jim Khalili\n History"},null,null,null,null,null,null,"House of Wisdom"," Jim Khalili"," History"]
[null,"Purple Cow"," Seth Godin"," Marketing","Purple Cow\n Seth Godin\n Marketing",null,null,null,null,null,null,"Purple Cow"," Seth Godin"," Marketing"]
[null,"Made to Stick"," Chip Heath"," Self Help","Made to Stick\n Chip Heath\n Self Help",null,null,null,null,null,null,"Made to Stick"," Chip Heath"," Self Help"]
[null,"The Black Swan"," Nassim Taleb"," Philosophy","The Black Swan\n Nassim Taleb\n Philosophy",null,null,null,null,null,null,"The Black Swan"," Nassim Taleb"," Philosophy"]
[null,"Thinking Fast and Slow"," Daniel Kahneman"," Psychology","Thinking Fast and Slow\n Daniel Kahneman\n Psychology",null,null,null,null,null,null,"Thinking Fast and Slow"," Daniel Kahneman"," Psychology"]

{"sheet":"CONCATENATE and CHAR Functions","index":3,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Using CONCATENATE and CHAR Functions",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Book Name","Author","Genre","Output",null,null,null,null,null,null,"Book Name","Author","Genre","Output"]
[null,"Poor Economics"," Abhijit Banarjee"," Economics",{"$f":"CONCATENATE(B5, CHAR(10), C5, CHAR(10), D5)","v":"Poor Economics\n Abhijit Banarjee\n Economics"},null,null,null,null,null,null,"Poor Economics"," Abhijit Banarjee"," Economics"]
[null,"House of Wisdom"," Jim Khalili"," History",{"$f":"CONCATENATE(B6, CHAR(10), C6, CHAR(10), D6)","v":"House of Wisdom\n Jim Khalili\n History"},null,null,null,null,null,null,"House of Wisdom"," Jim Khalili"," History"]
[null,"Purple Cow"," Seth Godin"," Marketing","Purple Cow\n Seth Godin\n Marketing",null,null,null,null,null,null,"Purple Cow"," Seth Godin"," Marketing"]
[null,"Made to Stick"," Chip Heath"," Self Help","Made to Stick\n Chip Heath\n Self Help",null,null,null,null,null,null,"Made to Stick"," Chip Heath"," Self Help"]
[null,"The Black Swan"," Nassim Taleb"," Philosophy","The Black Swan\n Nassim Taleb\n Philosophy",null,null,null,null,null,null,"The Black Swan"," Nassim Taleb"," Philosophy"]
[null,"Thinking Fast and Slow"," Daniel Kahneman"," Psychology","Thinking Fast and Slow\n Daniel Kahneman\n Psychology",null,null,null,null,null,null,"Thinking Fast and Slow"," Daniel Kahneman"," Psychology"]

{"sheet":"Keyboard Shortcut","index":4,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Using Keyboard Shortcut",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Book Name, Author, Genre","Output",null,null,null,null,null,null,null,null,"Book Name, Author, Genre","Output"]
[null,"Poor Economics, Abhijit Banarjee, Economics","Poor Economics, \nAbhijit Banarjee, \nEconomics",null,null,null,null,null,null,null,null,"Poor Economics, Abhijit Banarjee, Economics"]
[null,"House of Wisdom, Jim Khalili, History","House of Wisdom, \nJim Khalili, \nHistory",null,null,null,null,null,null,null,null,"House of Wisdom, Jim Khalili, History"]
[null,"Purple Cow, Seth Godin, Marketing","Purple Cow, \nSeth Godin, \nMarketing",null,null,null,null,null,null,null,null,"Purple Cow, Seth Godin, Marketing"]
[null,"Made to Stick, Chip Heath, Self Help","Made to Stick, \nChip Heath, \nSelf Help",null,null,null,null,null,null,null,null,"Made to Stick, Chip Heath, Self Help"]
[null,"The Black Swan, Nassim Taleb, Philosophy","The Black Swan, \nNassim Taleb, \nPhilosophy",null,null,null,null,null,null,null,null,"The Black Swan, Nassim Taleb, Philosophy"]
[null,"Thinking Fast and Slow, Daniel Kahneman, Psychology","Thinking Fast and Slow, \nDaniel Kahneman, \nPsychology",null,null,null,null,null,null,null,null,"Thinking Fast and Slow, Daniel Kahneman, Psychology"]

{"sheet":"Wrap Text Toggle","index":5,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Using Wrap Text Toggle",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Book Name, Author, Genre","Output",null,null,null,null,null,null,null,null,"Book Name, Author, Genre","Output"]
[null,"Poor Economics, Abhijit Banarjee, Economics","Poor Economics,\n Abhijit Banarjee, \nEconomics",null,null,null,null,null,null,null,null,"Poor Economics, Abhijit Banarjee, Economics"]
[null,"House of Wisdom, Jim Khalili, History","House of Wisdom, \nJim Khalili, \nHistory",null,null,null,null,null,null,null,null,"House of Wisdom, Jim Khalili, History"]
[null,"Purple Cow, Seth Godin, Marketing","Purple Cow, \nSeth Godin, \nMarketing",null,null,null,null,null,null,null,null,"Purple Cow, Seth Godin, Marketing"]
[null,"Made to Stick, Chip Heath, Self Help","Made to Stick, \nChip Heath, \nSelf Help",null,null,null,null,null,null,null,null,"Made to Stick, Chip Heath, Self Help"]
[null,"The Black Swan, Nassim Taleb, Philosophy","The Black Swan, \nNassim Taleb, \nPhilosophy",null,null,null,null,null,null,null,null,"The Black Swan, Nassim Taleb, Philosophy"]
[null,"Thinking Fast and Slow, Daniel Kahneman, Psychology","Thinking Fast and Slow, \nDaniel Kahneman, \nPsychology",null,null,null,null,null,null,null,null,"Thinking Fast and Slow, Daniel Kahneman, Psychology"]

{"sheet":"Named Range","index":6,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Using Named Range",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Book Name","Author","Genre","Output",null,null,null,null,null,null,"Book Name","Author","Genre","Output"]
[null,"Poor Economics"," Abhijit Banarjee"," Economics",{"$f":"B5&NewLine&C5&NewLine&D5","v":"Poor Economics\n Abhijit Banarjee\n Economics"},null,null,null,null,null,null,"Poor Economics"," Abhijit Banarjee"," Economics"]
[null,"House of Wisdom"," Jim Khalili"," History",{"$f":"B6&NewLine&C6&NewLine&D6","v":"House of Wisdom\n Jim Khalili\n History"},null,null,null,null,null,null,"House of Wisdom"," Jim Khalili"," History"]
[null,"Purple Cow"," Seth Godin"," Marketing",{"$f":"B7&NewLine&C7&NewLine&D7","v":"Purple Cow\n Seth Godin\n Marketing"},null,null,null,null,null,null,"Purple Cow"," Seth Godin"," Marketing"]
[null,"Made to Stick"," Chip Heath"," Self Help",{"$f":"B8&NewLine&C8&NewLine&D8","v":"Made to Stick\n Chip Heath\n Self Help"},null,null,null,null,null,null,"Made to Stick"," Chip Heath"," Self Help"]
[null,"The Black Swan"," Nassim Taleb"," Philosophy",{"$f":"B9&NewLine&C9&NewLine&D9","v":"The Black Swan\n Nassim Taleb\n Philosophy"},null,null,null,null,null,null,"The Black Swan"," Nassim Taleb"," Philosophy"]
[null,"Thinking Fast and Slow"," Daniel Kahneman"," Psychology",{"$f":"B10&NewLine&C10&NewLine&D10","v":"Thinking Fast and Slow\n Daniel Kahneman\n Psychology"},null,null,null,null,null,null,"Thinking Fast and Slow"," Daniel Kahneman"," Psychology"]

{"sheet":"Find and Replace","index":7,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Using Find and Select Option",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Book Name, Author, Genre","Output",null,null,null,null,null,null,null,null,"Book Name, Author, Genre","Output"]
[null,"Poor Economics, Abhijit Banarjee, Economics","Poor Economics\n Abhijit Banarjee\n Economics",null,null,null,null,null,null,null,null,"Poor Economics, Abhijit Banarjee, Economics"]
[null,"House of Wisdom, Jim Khalili, History","House of Wisdom\n Jim Khalili\n History",null,null,null,null,null,null,null,null,"House of Wisdom, Jim Khalili, History"]
[null,"Purple Cow, Seth Godin, Marketing","Purple Cow\n Seth Godin\n Marketing",null,null,null,null,null,null,null,null,"Purple Cow, Seth Godin, Marketing"]
[null,"Made to Stick, Chip Heath, Self Help","Made to Stick\n Chip Heath\n Self Help",null,null,null,null,null,null,null,null,"Made to Stick, Chip Heath, Self Help"]
[null,"The Black Swan, Nassim Taleb, Philosophy","The Black Swan\n Nassim Taleb\n Philosophy",null,null,null,null,null,null,null,null,"The Black Swan, Nassim Taleb, Philosophy"]
[null,"Thinking Fast and Slow, Daniel Kahneman, Psychology","Thinking Fast and Slow\n Daniel Kahneman\n Psychology",null,null,null,null,null,null,null,null,"Thinking Fast and Slow, Daniel Kahneman, Psychology"]

{"sheet":"VBA Code","index":8,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Book Name","Author","Genre","Output",null,null,null,null,null,null,"Book Name","Author","Genre","Output"]
[null,"Poor Economics"," Abhijit Banarjee"," Economics","Poor Economics\r\n Abhijit Banarjee\r\n Economics",null,null,null,null,null,null,"Poor Economics"," Abhijit Banarjee"," Economics"]
[null,"House of Wisdom"," Jim Khalili"," History","House of Wisdom\r\n Jim Khalili\r\n History",null,null,null,null,null,null,"House of Wisdom"," Jim Khalili"," History"]
[null,"Purple Cow"," Seth Godin"," Marketing","Purple Cow\r\n Seth Godin\r\n Marketing",null,null,null,null,null,null,"Purple Cow"," Seth Godin"," Marketing"]
[null,"Made to Stick"," Chip Heath"," Self Help","Made to Stick\r\n Chip Heath\r\n Self Help",null,null,null,null,null,null,"Made to Stick"," Chip Heath"," Self Help"]
[null,"The Black Swan"," Nassim Taleb"," Philosophy","The Black Swan\r\n Nassim Taleb\r\n Philosophy",null,null,null,null,null,null,"The Black Swan"," Nassim Taleb"," Philosophy"]
[null,"Thinking Fast and Slow"," Daniel Kahneman"," Psychology","Thinking Fast and Slow\r\n Daniel Kahneman\r\n Psychology",null,null,null,null,null,null,"Thinking Fast and Slow"," Daniel Kahneman"," Psychology"]

{"sheet":"Dataset-2","index":9,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Employee Sales Performance"]
[]
[null,"Name","Sales"]
[null,"Sam",2435]
[null,"Adam",4025]
[null,"Anna",4767]
[null,"Harry",4533]
[null,"Tyler",1591]
[null,"Will",3660]
[null,"Smith",2092]
[null,"Julie",2914]
[null,"Gloria",2652]
[null,"Mary",1096]

{"sheet":"New Line in Cell Formula","index":10,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"New Line in Cell Formula",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Sales","Performance",null,null,null,null,null,null,null,"Name","Sales","Performance"]
[null,"Sam",2435,{"$f":"IF(C5>2000,\"Satisfactory\",\nIF(C5=1000,\"OK\",\nIF(C5<2000,\"Bad\")))","v":"Satisfactory"},null,null,null,null,null,null,null,"Sam",2435]
[null,"Adam",4025,{"$f":"IF(C6>2000,\"Satisfactory\",\nIF(C6=1000,\"OK\",\nIF(C6<2000,\"Bad\")))","v":"Satisfactory"},null,null,null,null,null,null,null,"Adam",4025]
[null,"Anna",4767,"Satisfactory",null,null,null,null,null,null,null,"Anna",4767]
[null,"Harry",4533,"Satisfactory",null,null,null,null,null,null,null,"Harry",4533]
[null,"Tyler",1591,"Bad",null,null,null,null,null,null,null,"Tyler",1591]
[null,"Will",3660,"Satisfactory",null,null,null,null,null,null,null,"Will",3660]
[null,"Smith",2092,"Satisfactory",null,null,null,null,null,null,null,"Smith",2092]
[null,"Julie",2914,"Satisfactory",null,null,null,null,null,null,null,"Julie",2914]
[null,"Gloria",2652,"Satisfactory",null,null,null,null,null,null,null,"Gloria",2652]
[null,"Mary",1096,"Bad",null,null,null,null,null,null,null,"Mary",1096]