{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Go_To_Special1","Go_To_Special2","PowerQuery","QueryTable","VBA","Find&Replace"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Dataset Overview"]
[]
[null,"Employee","Department","Age","Working Hour"]
[null,"John","Finance",25,8]
[null,"Peter",null,27]
[null,"Emily",null,24]
[null,"Tom","Marketing",28]
[null,"Erica",null,28,7]
[null,"Smith",null,25]
[null,"Thomas","IT",24]
[null,"Lily",null,23]

{"sheet":"Go_To_Special1","index":1,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"With 'Go To Special'",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Employee","Department","Age","Working Hour",null,null,null,null,"Employee","Department","Age","Working Hour"]
[null,"John","Finance",25,8,null,null,null,null,"John","Finance",25,8]
[null,"Peter",{"$f":"C5","v":"Finance"},27,{"$f":"E5","v":8},null,null,null,null,"Peter",null,27]
[null,"Emily","Finance",24,8,null,null,null,null,"Emily",null,24]
[null,"Tom","Marketing",28,8,null,null,null,null,"Tom","Marketing",28]
[null,"Erica",{"$f":"C8","v":"Marketing"},28,7,null,null,null,null,"Erica",null,28,7]
[null,"Smith","Marketing",25,{"$f":"E9","v":7},null,null,null,null,"Smith",null,25]
[null,"Thomas","IT",24,7,null,null,null,null,"Thomas","IT",24]
[null,"Lily",{"$f":"C11","v":"IT"},23,7,null,null,null,null,"Lily",null,23]

{"sheet":"Go_To_Special2","index":2,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"With 'Go To Special'",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Employee","Department","Age","Working Hour",null,null,null,null,"Employee","Department","Age","Working Hour"]
[null,"John","Finance",25,8,null,null,null,null,"John","Finance",25,8]
[null,"Peter","Finance",27,8,null,null,null,null,"Peter",null,27,8]
[null,"Emily","Finance",24,8,null,null,null,null,"Emily",null,24,8]
[null,"Tom","Marketing",28,8,null,null,null,null,"Tom","Marketing",28,8]
[null,"Erica","Marketing",28,7,null,null,null,null,"Erica",null,28,7]
[null,"Smith","Marketing",25,7,null,null,null,null,"Smith",null,25,7]
[null,"Thomas","IT",24,7,null,null,null,null,"Thomas","IT",24,7]
[null,"Lily","IT",23,7,null,null,null,null,"Lily",null,23,7]

{"sheet":"PowerQuery","index":3,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"With Power Query",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Employee","Department","Age","Working Hour",null,null,null,null,"Employee","Department","Age","Working Hour"]
[null,"John","Finance",25,8,null,null,null,null,"John","Finance",25,8]
[null,"Peter",null,27,null,null,null,null,null,"Peter",null,27]
[null,"Emily",null,24,null,null,null,null,null,"Emily",null,24]
[null,"Tom","Marketing",28,null,null,null,null,null,"Tom","Marketing",28]
[null,"Erica",null,28,7,null,null,null,null,"Erica",null,28,7]
[null,"Smith",null,25,null,null,null,null,null,"Smith",null,25]
[null,"Thomas","IT",24,null,null,null,null,null,"Thomas","IT",24]
[null,"Lily",null,23,null,null,null,null,null,"Lily",null,23]

{"sheet":"QueryTable","index":4,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Employee","Department","Age","Working Hour"]
["John","Finance",25,8]
["Peter","Finance",27,8]
["Emily","Finance",24,8]
["Tom","Marketing",28,8]
["Erica","Marketing",28,7]
["Smith","Marketing",25,7]
["Thomas","IT",24,7]
["Lily","IT",23,7]

{"sheet":"VBA","index":5,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"With VBA",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Employee","Department","Age","Working Hour",null,null,null,null,null,"Employee","Department","Age","Working Hour"]
[null,"John","Finance",25,8,null,null,null,null,null,"John","Finance",25,8]
[null,"Peter","Finance",27,8,null,null,null,null,null,"Peter",null,27]
[null,"Emily","Finance",24,8,null,null,null,null,null,"Emily",null,24]
[null,"Tom","Marketing",28,8,null,null,null,null,null,"Tom","Marketing",28]
[null,"Erica","Marketing",28,7,null,null,null,null,null,"Erica",null,28,7]
[null,"Smith","Marketing",25,7,null,null,null,null,null,"Smith",null,25]
[null,"Thomas","IT",24,7,null,null,null,null,null,"Thomas","IT",24]
[null,"Lily","IT",23,7,null,null,null,null,null,"Lily",null,23]

{"sheet":"Find&Replace","index":6,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Use of Find & Replace",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Employee","Department","Age","Working Hour",null,null,null,null,null,"Employee","Department","Age","Working Hour"]
[null,"John","Finance",25,8,null,null,null,null,null,"John","Finance",25,8]
[null,"Peter","Finance",27,8,null,null,null,null,null,"Peter",null,27]
[null,"Emily","Finance",24,8,null,null,null,null,null,"Emily",null,24]
[null,"Tom","Marketing",28,8,null,null,null,null,null,"Tom","Marketing",28]
[null,"Erica","Marketing",28,7,null,null,null,null,null,"Erica",null,28,7]
[null,"Smith","Marketing",25,7,null,null,null,null,null,"Smith",null,25]
[null,"Thomas","IT",24,7,null,null,null,null,null,"Thomas","IT",24]
[null,"Lily","IT",23,7,null,null,null,null,null,"Lily",null,23]