{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Ampersand Operator","CONCATENATE Function","CONCAT Function","TEXTJOIN Function","VBA","Merge & Center"],"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":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[4,1,6,1],[7,1,8,1],[9,1,12,1],[13,1,15,1],[1,1,1,2]]}
[]
[null,"Book Record of Martin Bookstore"]
[]
[null,"Author","Book Name"]
[null,"Charles Dickens","Great Expectations"]
[null,null,"Oliver Twist"]
[null,null,"David Copperfield"]
[null,"Elif Shafak","The Forty Rules of Love"]
[null,null,"The Bastard Of Istanbul"]
[null,"H. Rider Haggard","She"]
[null,null,"Return of She"]
[null,null,"Montejuma's Daughter"]
[null,null,"The Brethren"]
[null,"Charlotte Bronte","Jane Eyre"]
[null,null,"Villette"]
[null,null,"Glass Town"]

{"sheet":"Ampersand Operator","index":1,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,3,6,3],[7,3,8,3],[9,3,12,3],[13,3,15,3],[13,1,15,1],[9,1,12,1],[7,1,8,1],[4,1,6,1],[4,13,6,13],[7,13,8,13],[9,13,12,13],[13,13,15,13],[1,11,1,13]]}
[]
[null,"Using Ampersand Operator",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Author","Book Name","Merged Books",null,null,null,null,null,null,null,"Author","Book Name","Merged Books"]
[null,"Charles Dickens","Great Expectations",{"$f":"C5&\", \"&C6&\", \"&C7","v":"Great Expectations, Oliver Twist, David Copperfield"},null,null,null,null,null,null,null,"Charles Dickens","Great Expectations"]
[null,null,"Oliver Twist",null,null,null,null,null,null,null,null,null,"Oliver Twist"]
[null,null,"David Copperfield",null,null,null,null,null,null,null,null,null,"David Copperfield"]
[null,"Elif Shafak","The Forty Rules of Love",{"$f":"C8&\", \"&C9","v":"The Forty Rules of Love, The Bastard Of Istanbul"},null,null,null,null,null,null,null,"Elif Shafak","The Forty Rules of Love"]
[null,null,"The Bastard Of Istanbul",null,null,null,null,null,null,null,null,null,"The Bastard Of Istanbul"]
[null,"H. Rider Haggard","She",{"$f":"C10&\", \"&C11&\", \"&C12&\", \"&C13","v":"She, Return of She, Montejuma's Daughter, The Brethren"},null,null,null,null,null,null,null,"H. Rider Haggard","She"]
[null,null,"Return of She",null,null,null,null,null,null,null,null,null,"Return of She"]
[null,null,"Montejuma's Daughter",null,null,null,null,null,null,null,null,null,"Montejuma's Daughter"]
[null,null,"The Brethren",null,null,null,null,null,null,null,null,null,"The Brethren"]
[null,"Charlotte Bronte","Jane Eyre",{"$f":"C14&\", \"&C15&\", \"&C16","v":"Jane Eyre, Villette, Glass Town"},null,null,null,null,null,null,null,"Charlotte Bronte","Jane Eyre"]
[null,null,"Villette",null,null,null,null,null,null,null,null,null,"Villette"]
[null,null,"Glass Town",null,null,null,null,null,null,null,null,null,"Glass Town"]

{"sheet":"CONCATENATE Function","index":2,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[4,1,6,1],[7,1,8,1],[9,1,12,1],[13,1,15,1],[1,1,1,3],[4,3,6,3],[7,3,8,3],[9,3,12,3],[13,3,15,3],[4,13,6,13],[7,13,8,13],[9,13,12,13],[13,13,15,13],[1,11,1,13]]}
[]
[null,"Applying CONCATENATE Function",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Author","Book Name","Merged Books",null,null,null,null,null,null,null,"Author","Book Name","Merged Books"]
[null,"Charles Dickens","Great Expectations",{"$f":"CONCATENATE(C5,\", \",C6,\", \",C7)","v":"Great Expectations, Oliver Twist, David Copperfield"},null,null,null,null,null,null,null,"Charles Dickens","Great Expectations"]
[null,null,"Oliver Twist",null,null,null,null,null,null,null,null,null,"Oliver Twist"]
[null,null,"David Copperfield",null,null,null,null,null,null,null,null,null,"David Copperfield"]
[null,"Elif Shafak","The Forty Rules of Love",{"$f":"CONCATENATE(C8,\",\",C9)","v":"The Forty Rules of Love,The Bastard Of Istanbul"},null,null,null,null,null,null,null,"Elif Shafak","The Forty Rules of Love"]
[null,null,"The Bastard Of Istanbul",null,null,null,null,null,null,null,null,null,"The Bastard Of Istanbul"]
[null,"H. Rider Haggard","She",{"$f":"CONCATENATE(C10,\",\",C11,\",\",C12,\",\",C13)","v":"She,Return of She,Montejuma's Daughter,The Brethren"},null,null,null,null,null,null,null,"H. Rider Haggard","She"]
[null,null,"Return of She",null,null,null,null,null,null,null,null,null,"Return of She"]
[null,null,"Montejuma's Daughter",null,null,null,null,null,null,null,null,null,"Montejuma's Daughter"]
[null,null,"The Brethren",null,null,null,null,null,null,null,null,null,"The Brethren"]
[null,"Charlotte Bronte","Jane Eyre",{"$f":"CONCATENATE(C14,\",\",C15,\",\",C16)","v":"Jane Eyre,Villette,Glass Town"},null,null,null,null,null,null,null,"Charlotte Bronte","Jane Eyre"]
[null,null,"Villette",null,null,null,null,null,null,null,null,null,"Villette"]
[null,null,"Glass Town",null,null,null,null,null,null,null,null,null,"Glass Town"]

{"sheet":"CONCAT Function","index":3,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[13,1,15,1],[13,3,15,3],[1,1,1,3],[4,1,6,1],[4,3,6,3],[7,1,8,1],[7,3,8,3],[9,1,12,1],[9,3,12,3],[4,13,6,13],[7,13,8,13],[9,13,12,13],[13,13,15,13],[1,11,1,13]]}
[]
[null,"Employing CONCAT Function",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Author","Book Name","Merged Books",null,null,null,null,null,null,null,"Author","Book Name","Merged Books"]
[null,"Charles Dickens","Great Expectations",{"$f":"_xlfn.CONCAT(C5,\", \",C6,\", \",C7)","v":"Great Expectations, Oliver Twist, David Copperfield"},null,null,null,null,null,null,null,"Charles Dickens","Great Expectations"]
[null,null,"Oliver Twist",null,null,null,null,null,null,null,null,null,"Oliver Twist"]
[null,null,"David Copperfield",null,null,null,null,null,null,null,null,null,"David Copperfield"]
[null,"Elif Shafak","The Forty Rules of Love",{"$f":"_xlfn.CONCAT(C8,\", \",C9)","v":"The Forty Rules of Love, The Bastard Of Istanbul"},null,null,null,null,null,null,null,"Elif Shafak","The Forty Rules of Love"]
[null,null,"The Bastard Of Istanbul",null,null,null,null,null,null,null,null,null,"The Bastard Of Istanbul"]
[null,"H. Rider Haggard","She",{"$f":"_xlfn.CONCAT(C10,\", \",C11,\",\",C12,\",\",C13)","v":"She, Return of She,Montejuma's Daughter,The Brethren"},null,null,null,null,null,null,null,"H. Rider Haggard","She"]
[null,null,"Return of She",null,null,null,null,null,null,null,null,null,"Return of She"]
[null,null,"Montejuma's Daughter",null,null,null,null,null,null,null,null,null,"Montejuma's Daughter"]
[null,null,"The Brethren",null,null,null,null,null,null,null,null,null,"The Brethren"]
[null,"Charlotte Bronte","Jane Eyre",{"$f":"_xlfn.CONCAT(C14,\",\",C15,\",\",C16)","v":"Jane Eyre,Villette,Glass Town"},null,null,null,null,null,null,null,"Charlotte Bronte","Jane Eyre"]
[null,null,"Villette",null,null,null,null,null,null,null,null,null,"Villette"]
[null,null,"Glass Town",null,null,null,null,null,null,null,null,null,"Glass Town"]

{"sheet":"TEXTJOIN Function","index":4,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[13,1,15,1],[13,3,15,3],[1,1,1,3],[4,1,6,1],[4,3,6,3],[7,1,8,1],[7,3,8,3],[9,1,12,1],[9,3,12,3],[4,13,6,13],[7,13,8,13],[9,13,12,13],[13,13,15,13],[1,11,1,13]]}
[]
[null,"Utilizing TEXTJOIN Function",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Author","Book Name","Merged Books",null,null,null,null,null,null,null,"Author","Book Name","Merged Books"]
[null,"Charles Dickens","Great Expectations",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,C5,C6,C7)","v":"Great Expectations,Oliver Twist,David Copperfield"},null,null,null,null,null,null,null,"Charles Dickens","Great Expectations"]
[null,null,"Oliver Twist",null,null,null,null,null,null,null,null,null,"Oliver Twist"]
[null,null,"David Copperfield",null,null,null,null,null,null,null,null,null,"David Copperfield"]
[null,"Elif Shafak","The Forty Rules of Love",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,C8,C9)","v":"The Forty Rules of Love,The Bastard Of Istanbul"},null,null,null,null,null,null,null,"Elif Shafak","The Forty Rules of Love"]
[null,null,"The Bastard Of Istanbul",null,null,null,null,null,null,null,null,null,"The Bastard Of Istanbul"]
[null,"H. Rider Haggard","She",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,C10,C11,C12,C13)","v":"She,Return of She,Montejuma's Daughter,The Brethren"},null,null,null,null,null,null,null,"H. Rider Haggard","She"]
[null,null,"Return of She",null,null,null,null,null,null,null,null,null,"Return of She"]
[null,null,"Montejuma's Daughter",null,null,null,null,null,null,null,null,null,"Montejuma's Daughter"]
[null,null,"The Brethren",null,null,null,null,null,null,null,null,null,"The Brethren"]
[null,"Charlotte Bronte","Jane Eyre",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,C14,C15,C16)","v":"Jane Eyre,Villette,Glass Town"},null,null,null,null,null,null,null,"Charlotte Bronte","Jane Eyre"]
[null,null,"Villette",null,null,null,null,null,null,null,null,null,"Villette"]
[null,null,"Glass Town",null,null,null,null,null,null,null,null,null,"Glass Town"]

{"sheet":"VBA","index":5,"n_rows":30,"n_cols":20,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,11,1,12],[4,1,6,1],[1,1,1,2],[13,1,15,1],[9,1,12,1],[7,1,8,1],[4,2,6,2],[7,2,8,2],[9,2,12,2],[13,2,15,2]]}
[]
[null,"Incorporating VBA Macros",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Author","Book Name",null,null,null,null,null,null,null,null,"Author","Book Name"]
[null,"Charles Dickens","Great Expectations\r\nOliver Twist\r\nDavid Copperfield",null,null,null,null,null,null,null,null,"Charles Dickens","Great Expectations"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Oliver Twist"]
[null,null,null,null,null,null,null,null,null,null,null,null,"David Copperfield"]
[null,"Elif Shafak","The Forty Rules of Love\r\nThe Bastard Of Istanbul",null,null,null,null,null,null,null,null,"Elif Shafak","The Forty Rules of Love"]
[null,null,null,null,null,null,null,null,null,null,null,null,"The Bastard Of Istanbul"]
[null,"H. Rider Haggard","She\r\nReturn of She\r\nMontejuma's Daughter\r\nThe Brethren",null,null,null,null,null,null,null,null,"H. Rider Haggard","She"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Return of She"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Montejuma's Daughter"]
[null,null,null,null,null,null,null,null,null,null,null,null,"The Brethren"]
[null,"Charlotte Bronte","Jane Eyre\r\nVillette\r\nGlass Town",null,null,null,null,null,null,null,null,"Charlotte Bronte","Jane Eyre"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Villette"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Glass Town"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":"Merge & Center","index":6,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,11,1,12],[4,2,6,2],[7,2,8,2],[9,2,12,2],[13,2,15,2],[1,1,1,2]]}
[]
[null,"Using Merge & Center Feature",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Author","Book Name",null,null,null,null,null,null,null,null,"Author","Book Name"]
[null,"Charles Dickens","Great Expectations",null,null,null,null,null,null,null,null,"Charles Dickens","Great Expectations"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Oliver Twist"]
[null,null,null,null,null,null,null,null,null,null,null,null,"David Copperfield"]
[null,"Elif Shafak","The Forty Rules of Love",null,null,null,null,null,null,null,null,"Elif Shafak","The Forty Rules of Love"]
[null,null,null,null,null,null,null,null,null,null,null,null,"The Bastard Of Istanbul"]
[null,"H. Rider Haggard","She",null,null,null,null,null,null,null,null,"H. Rider Haggard","She"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Return of She"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Montejuma's Daughter"]
[null,null,null,null,null,null,null,null,null,null,null,null,"The Brethren"]
[null,"Charlotte Bronte","Jane Eyre",null,null,null,null,null,null,null,null,"Charlotte Bronte","Jane Eyre"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Villette"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Glass Town"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]