{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Flash Fill ","Ampersand Operator"," Custom Formatting","CONCATENATE Function","TEXTJOIN Function","VBA Code"],"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":"Flash Fill ","index":0,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Utilizing Flash Fill Feature",null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"ID","Employee Name","Age","Add Text",null,null,null,null,null,null,"ID","Employee Name","Age","Add Text"]
[null,1,"Adam",34,"34 Years",null,null,null,null,null,null,1,"Adam",34]
[null,2,"Chris",52,"52 Years",null,null,null,null,null,null,2,"Chris",52]
[null,3,"Joana",46,"46 Years",null,null,null,null,null,null,3,"Joana",46]
[null,4,"Wanda",28,"28 Years",null,null,null,null,null,null,4,"Wanda",28]
[null,5,"Scarlet",53,"53 Years",null,null,null,null,null,null,5,"Scarlet",53]
[null,6,"Will",35,"35 Years",null,null,null,null,null,null,6,"Will",35]
[null,7,"Tom",42,"42 Years",null,null,null,null,null,null,7,"Tom",42]

{"sheet":"Ampersand Operator","index":1,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Using Ampersand Operator",null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"ID","Employee Name","Age","Add Text",null,null,null,null,null,null,"ID","Employee Name","Age","Add Text"]
[null,1,"Adam",34,{"$f":"D5&\" Years\"","v":"34 Years"},null,null,null,null,null,null,1,"Adam",34]
[null,2,"Chris",52,{"$f":"D6&\" Years\"","v":"52 Years"},null,null,null,null,null,null,2,"Chris",52]
[null,3,"Joana",46,"46 Years",null,null,null,null,null,null,3,"Joana",46]
[null,4,"Wanda",28,"28 Years",null,null,null,null,null,null,4,"Wanda",28]
[null,5,"Scarlet",53,"53 Years",null,null,null,null,null,null,5,"Scarlet",53]
[null,6,"Will",35,"35 Years",null,null,null,null,null,null,6,"Will",35]
[null,7,"Tom",42,"42 Years",null,null,null,null,null,null,7,"Tom",42]

{"sheet":" Custom Formatting","index":2,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Using Custom Formatting",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Professor Name","Add Text",null,null,null,null,null,null,"Professor Name","Add Text"]
[null,"Dr. Adam","Dr. Adam",null,null,null,null,null,null,"Dr. Adam"]
[null,"Dr. Chris","Dr. Chris",null,null,null,null,null,null,"Dr. Chris"]
[null,"Dr. Joana","Dr. Joana",null,null,null,null,null,null,"Dr. Joana"]
[null,"Dr. Wanda","Dr. Wanda",null,null,null,null,null,null,"Dr. Wanda"]
[null,"Dr. Scarlet","Dr. Scarlet",null,null,null,null,null,null,"Dr. Scarlet"]
[null,"Dr. Will","Dr. Will",null,null,null,null,null,null,"Dr. Will"]
[null,"Dr. Tom","Dr. Tom",null,null,null,null,null,null,"Dr. Tom"]

{"sheet":"CONCATENATE Function","index":3,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Utilizing CONCATENATE Function",null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"ID","Employee Name","Age","Add Text",null,null,null,null,null,null,"ID","Employee Name","Age","Add Text"]
[null,1,"Adam",34,{"$f":"CONCATENATE(D5,\" Years\")","v":"34 Years"},null,null,null,null,null,null,1,"Adam",34]
[null,2,"Chris",52,{"$f":"CONCATENATE(D6,\" Years\")","v":"52 Years"},null,null,null,null,null,null,2,"Chris",52]
[null,3,"Joana",46,"46 Years",null,null,null,null,null,null,3,"Joana",46]
[null,4,"Wanda",28,"28 Years",null,null,null,null,null,null,4,"Wanda",28]
[null,5,"Scarlet",53,"53 Years",null,null,null,null,null,null,5,"Scarlet",53]
[null,6,"Will",35,"35 Years",null,null,null,null,null,null,6,"Will",35]
[null,7,"Tom",42,"42 Years",null,null,null,null,null,null,7,"Tom",42]

{"sheet":"TEXTJOIN Function","index":4,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,11,2,14]]}
[]
[null,"Using TEXTJOIN Function"]
[null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[null,"ID","Employee Name","Age","Add Text"]
[null,1,"Adam",34,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,D5,\" Years\")","v":"34 Years"},null,null,null,null,null,null,"ID","Employee Name","Age","Add Text"]
[null,2,"Chris",52,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,D6,\" Years\")","v":"52 Years"},null,null,null,null,null,null,1,"Adam",34]
[null,3,"Joana",46,"46 Years",null,null,null,null,null,null,2,"Chris",52]
[null,4,"Wanda",28,"28 Years",null,null,null,null,null,null,3,"Joana",46]
[null,5,"Scarlet",53,"53 Years",null,null,null,null,null,null,4,"Wanda",28]
[null,6,"Will",35,"35 Years",null,null,null,null,null,null,5,"Scarlet",53]
[null,7,"Tom",42,"42 Years",null,null,null,null,null,null,6,"Will",35]
[null,null,null,null,null,null,null,null,null,null,null,7,"Tom",42]

{"sheet":"VBA Code","index":5,"n_rows":11,"n_cols":15,"rows_kept":11,"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,"Practice Yourself"]
[]
[null,"ID","Employee Name","Age","Add Text",null,null,null,null,null,null,"ID","Employee Name","Age","Add Text"]
[null,1,"Adam",34,"34 Years",null,null,null,null,null,null,1,"Adam",34]
[null,2,"Chris",52,"52 Years",null,null,null,null,null,null,2,"Chris",52]
[null,3,"Joana",46,"46 Years",null,null,null,null,null,null,3,"Joana",46]
[null,4,"Wanda",28,"28 Years",null,null,null,null,null,null,4,"Wanda",28]
[null,5,"Scarlet",53,"53 Years",null,null,null,null,null,null,5,"Scarlet",53]
[null,6,"Will",35,"35 Years",null,null,null,null,null,null,6,"Will",35]
[null,7,"Tom",42,"42 Years",null,null,null,null,null,null,7,"Tom",42]