{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Dataset","Fill Handle Tool","Fill Command","CustomList1","CustomList2","Flash Fill","CONCATENATE","Sequence","VBA1","VBA2"],"not_rendered":{"charts":0,"images":1,"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":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Dataset"]
[]
[null,"Employee ID No","Employee Name","Joining Month","Joining Date","Salary"]
[null,1001,"James Smith","Jan","2022-02-01",40000]
[null,1002,"Jim Brown"]
[null,1003,"Robert Smith"]
[null,1004,"Maria Garcia"]
[null,1005,"David Smith"]
[null,1006,"Liz Smith"]
[null,1007,"Mary Smith"]
[null,1008,"Maria Hernandez"]

{"sheet":"Fill Handle Tool","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using the Fill Handle Tool"]
[]
[null,"Employee ID No","Employee Name","Joining Month"]
[null,1001,"James Smith","Jan"]
[null,1002,"Jim Brown","Feb"]
[null,1003,"Robert Smith","Mar"]
[null,1004,"Maria Garcia","Apr"]
[null,1005,"David Smith","May"]
[null,1006,"Liz Smith","Jun"]
[null,1007,"Mary Smith","Jul"]
[null,1008,"Maria Hernandez","Aug"]

{"sheet":"Fill Command","index":2,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using the Fill Command "]
[]
[null,"Employee ID No","Employee Name","Joining Date"]
[null,1001,"James Smith","2022-02-01"]
[null,1002,"Jim Brown","2022-02-02"]
[null,1003,"Robert Smith","2022-02-03"]
[null,1004,"Maria Garcia","2022-02-04"]
[null,1005,"David Smith","2022-02-07"]
[null,1006,"Liz Smith","2022-02-08"]
[null,1007,"Mary Smith","2022-02-09"]
[null,1008,"Maria Hernandez","2022-02-10"]

{"sheet":"CustomList1","index":3,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Generating Custom List"]
[]
[null,"Employee ID No","Employee Name","Joining Month","Joining Date"]
[null,1001,"James Smith","Jan","2022-02-01"]
[null,1002,"Jim Brown","Feb","2022-02-02"]
[null,1003,"Robert Smith","Mar","2022-02-03"]
[null,1004,"Maria Garcia","Apr","2022-02-04"]
[null,1005,"David Smith","May","2022-02-05"]
[null,1006,"Liz Smith","Jun","2022-02-06"]
[null,1007,"Mary Smith","Jul","2022-02-07"]
[null,1008,"Maria Hernandez","Aug","2022-02-08"]

{"sheet":"CustomList2","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Generating Custom List"]
[]
[null,"ID ","Employee Name","AutoFill Using Custom List"]
[null,1001,"James Smith","James Smith"]
[null,1002,"Jim Brown","Jim Brown"]
[null,1003,"Robert Smith","Robert Smith"]
[null,1004,"Maria Garcia","Maria Garcia"]
[null,1005,"David Smith","David Smith"]
[null,1006,"Liz Smith","Liz Smith"]
[null,1007,"Mary Smith","Mary Smith"]
[null,1008,"Maria Hernandez","Maria Hernandez"]

{"sheet":"Flash Fill","index":5,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using the Flash Fill Tool"]
[]
[null,"Employee ID No","First Name","Last Name","Full Name"]
[null,1001,"James ","Smith","James Smith"]
[null,1002,"Jim ","Brown","Jim Brown"]
[null,1003,"Robert ","Smith","Robert Smith"]
[null,1004,"Maria ","Garcia","Maria Garcia"]
[null,1005,"David ","Smith","David Smith"]
[null,1006,"Liz ","Smith","Liz Smith"]
[null,1007,"Mary ","Smith","Mary Smith"]
[null,1008,"Maria ","Hernandez","Maria Hernandez"]

{"sheet":"CONCATENATE","index":6,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using the Fill Handle Tool"]
[]
[null,"Employee ID No","First Name","Last Name","Full Name"]
[null,1001,"James ","Smith",{"$f":"CONCATENATE(C5,D5)","v":"James Smith"}]
[null,1002,"Jim ","Brown",{"$f":"CONCATENATE(C6,D6)","v":"Jim Brown"}]
[null,1003,"Robert ","Smith","Robert Smith"]
[null,1004,"Maria ","Garcia","Maria Garcia"]
[null,1005,"David ","Smith","David Smith"]
[null,1006,"Liz ","Smith","Liz Smith"]
[null,1007,"Mary ","Smith","Mary Smith"]
[null,1008,"Maria ","Hernandez","Maria Hernandez"]

{"sheet":"Sequence","index":7,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using the SEQUENCE Function"]
[]
[null,"Employee ID No","Employee Name","Salary"]
[null,1001,"James Smith",{"$f":"_xlfn.SEQUENCE(8,1,40000,500)","v":40000}]
[null,1002,"Jim Brown",40500]
[null,1003,"Robert Smith",41000]
[null,1004,"Maria Garcia",41500]
[null,1005,"David Smith",42000]
[null,1006,"Liz Smith",42500]
[null,1007,"Mary Smith",43000]
[null,1008,"Maria Hernandez",43500]

{"sheet":"VBA1","index":8,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using VBA to AutoFill from List"]
[]
[null,"Employee ID No","Employee Name","Last Name"]
[null,1001,"James Smith","Smith"]
[null,1002,"Jim Brown","Brown"]
[null,1003,"Robert Smith","Smith"]
[null,1004,"Maria Garcia","Garcia"]
[null,1005,"David Smith","Smith"]
[null,1006,"Liz Smith","Smith"]
[null,1007,"Mary Smith","Smith"]
[null,1008,"Maria Hernandez","Hernandez"]

{"sheet":"VBA2","index":9,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using VBA to AutoFill from List"]
[]
[null,"Employee ID ","Employee Name","AutoFill"]
[null,1001,"James Smith"]
[null,1002,"Jim Brown"]
[null,1003,"Robert Smith"]
[null,1004,"Maria Garcia"]
[null,1005,"David Smith"]
[null,1006,"Liz Smith"]
[null,1007,"Mary Smith"]
[null,1008,"Maria Hernandez"]