{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Dataset","A to Z","Z to A","Filter","Custom Sort","Multi-level Sorting","SORT Function","SORTBY Function","VBA","Problems You Might Face"],"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","index":0,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"List of Employee"]
[]
[null,"ID","Name","Income"]
[null,1212010,"Rodney",25600]
[null,1212011,"Phillips",23000]
[null,1212012,"Smith",15000]
[null,1212013,"Adam",80000]
[null,1212014,"Heyden",50000]
[null,1212015,"William",45000]
[null,1212016,"Symonds",34500]
[null,1212017,"Andrew",44000]
[null,1212018,"Mike",70000]
[null,1212019,"Steve",95000]

{"sheet":"A to Z","index":1,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Applying Sort A to Z Button",null,null,null,null,null,"Do It Yourself"]
[]
[null,"ID","Name","Income",null,null,null,"ID","Name","Income"]
[null,1212012,"Smith",15000,null,null,null,1212010,"Rodney",25600]
[null,1212011,"Phillips",23000,null,null,null,1212011,"Phillips",23000]
[null,1212010,"Rodney",25600,null,null,null,1212012,"Smith",15000]
[null,1212016,"Symonds",34500,null,null,null,1212013,"Adam",80000]
[null,1212017,"Andrew",44000,null,null,null,1212014,"Heyden",50000]
[null,1212015,"William",45000,null,null,null,1212015,"William",45000]
[null,1212014,"Heyden",50000,null,null,null,1212016,"Symonds",34500]
[null,1212018,"Mike",70000,null,null,null,1212017,"Andrew",44000]
[null,1212013,"Adam",80000,null,null,null,1212018,"Mike",70000]
[null,1212019,"Steve",95000,null,null,null,1212019,"Steve",95000]

{"sheet":"Z to A","index":2,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Applying Sort Z to A Button",null,null,null,null,null,"Do It Yourself"]
[]
[null,"ID","Name","Income",null,null,null,"ID","Name","Income"]
[null,1212019,"Steve",95000,null,null,null,1212010,"Rodney",25600]
[null,1212013,"Adam",80000,null,null,null,1212011,"Phillips",23000]
[null,1212018,"Mike",70000,null,null,null,1212012,"Smith",15000]
[null,1212014,"Heyden",50000,null,null,null,1212013,"Adam",80000]
[null,1212015,"William",45000,null,null,null,1212014,"Heyden",50000]
[null,1212017,"Andrew",44000,null,null,null,1212015,"William",45000]
[null,1212016,"Symonds",34500,null,null,null,1212016,"Symonds",34500]
[null,1212010,"Rodney",25600,null,null,null,1212017,"Andrew",44000]
[null,1212011,"Phillips",23000,null,null,null,1212018,"Mike",70000]
[null,1212012,"Smith",15000,null,null,null,1212019,"Steve",95000]

{"sheet":"Filter","index":3,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Utilizing Filter Option",null,null,null,null,null,"Do It Yourself"]
[]
[null,"ID","Name","Income",null,null,null,"ID","Name","Income"]
[null,1212012,"Smith",15000,null,null,null,1212010,"Rodney",25600]
[null,1212011,"Phillips",23000,null,null,null,1212011,"Phillips",23000]
[null,1212010,"Rodney",25600,null,null,null,1212012,"Smith",15000]
[null,1212016,"Symonds",34500,null,null,null,1212013,"Adam",80000]
[null,1212017,"Andrew",44000,null,null,null,1212014,"Heyden",50000]
[null,1212015,"William",45000,null,null,null,1212015,"William",45000]
[null,1212014,"Heyden",50000,null,null,null,1212016,"Symonds",34500]
[null,1212018,"Mike",70000,null,null,null,1212017,"Andrew",44000]
[null,1212013,"Adam",80000,null,null,null,1212018,"Mike",70000]
[null,1212019,"Steve",95000,null,null,null,1212019,"Steve",95000]

{"sheet":"Custom Sort","index":4,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Employing Custom Sort Tool",null,null,null,null,null,"Do It Yourself"]
[]
[null,"ID","Name","Income",null,null,null,"ID","Name","Income"]
[null,1212019,"Steve",95000,null,null,null,1212010,"Rodney",25600]
[null,1212013,"Adam",80000,null,null,null,1212011,"Phillips",23000]
[null,1212018,"Mike",70000,null,null,null,1212012,"Smith",15000]
[null,1212014,"Heyden",50000,null,null,null,1212013,"Adam",80000]
[null,1212015,"William",45000,null,null,null,1212014,"Heyden",50000]
[null,1212017,"Andrew",44000,null,null,null,1212015,"William",45000]
[null,1212016,"Symonds",34500,null,null,null,1212016,"Symonds",34500]
[null,1212010,"Rodney",25600,null,null,null,1212017,"Andrew",44000]
[null,1212011,"Phillips",23000,null,null,null,1212018,"Mike",70000]
[null,1212012,"Smith",15000,null,null,null,1212019,"Steve",95000]

{"sheet":"Multi-level Sorting","index":5,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Engaging Multi-level Sorting",null,null,null,null,null,null,"Do It yourself"]
[]
[null,"ID","Name","Income","Expenditure",null,null,null,"ID","Name","Income","Expenditure"]
[null,1212019,"Steve",95000,65000,null,null,null,1212010,"Rodney",25600,10000]
[null,1212018,"Mike",95000,55000,null,null,null,1212011,"Phillips",23000,12000]
[null,1212013,"Adam",95000,30000,null,null,null,1212012,"Smith",15000,5000]
[null,1212014,"Heyden",95000,25000,null,null,null,1212013,"Adam",95000,30000]
[null,1212015,"William",45000,12500,null,null,null,1212014,"Heyden",95000,25000]
[null,1212017,"Andrew",44000,40000,null,null,null,1212015,"William",45000,12500]
[null,1212016,"Symonds",34500,30000,null,null,null,1212016,"Symonds",34500,30000]
[null,1212010,"Rodney",25600,10000,null,null,null,1212017,"Andrew",44000,40000]
[null,1212011,"Phillips",23000,12000,null,null,null,1212018,"Mike",95000,55000]
[null,1212012,"Smith",15000,5000,null,null,null,1212019,"Steve",95000,65000]

{"sheet":"SORT Function","index":6,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,1,3,3],[3,5,3,7],[3,11,3,13],[1,11,1,13]]}
[]
[null,"Inserting SORT Function",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Raw Data",null,null,null,"Sorted Data",null,null,null,null,null,"Raw Data"]
[null,"ID","Name"," Income ",null,"ID","Name"," Income ",null,null,null,"ID","Name"," Income "]
[null,1212010,"Rodney",25600,null,{"$f":"_xlfn._xlws.SORT(B6:D15,3,-1)","v":1212019},"Steve",95000,null,null,null,1212010,"Rodney",25600]
[null,1212011,"Phillips",23000,null,1212013,"Adam",80000,null,null,null,1212011,"Phillips",23000]
[null,1212012,"Smith",15000,null,1212018,"Mike",70000,null,null,null,1212012,"Smith",15000]
[null,1212013,"Adam",80000,null,1212014,"Heyden",50000,null,null,null,1212013,"Adam",80000]
[null,1212014,"Heyden",50000,null,1212015,"William",45000,null,null,null,1212014,"Heyden",50000]
[null,1212015,"William",45000,null,1212017,"Andrew",44000,null,null,null,1212015,"William",45000]
[null,1212016,"Symonds",34500,null,1212016,"Symonds",34500,null,null,null,1212016,"Symonds",34500]
[null,1212017,"Andrew",44000,null,1212010,"Rodney",25600,null,null,null,1212017,"Andrew",44000]
[null,1212018,"Mike",70000,null,1212011,"Phillips",23000,null,null,null,1212018,"Mike",70000]
[null,1212019,"Steve",95000,null,1212012,"Smith",15000,null,null,null,1212019,"Steve",95000]

{"sheet":"SORTBY Function","index":7,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,1,3,3],[3,5,3,7],[3,11,3,13],[1,11,1,13]]}
[]
[null,"Implementing SORTBY Function",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Raw Data",null,null,null,"Sorted Data",null,null,null,null,null,"Raw Data"]
[null,"ID","Name"," Income ",null,"ID","Name"," Income ",null,null,null,"ID","Name"," Income "]
[null,1212010,"Rodney",25600,null,{"$f":"_xlfn.SORTBY(B6:D15,D6:D15,-1)","v":1212019},"Steve",95000,null,null,null,1212010,"Rodney",25600]
[null,1212011,"Phillips",23000,null,1212013,"Adam",80000,null,null,null,1212011,"Phillips",23000]
[null,1212012,"Smith",15000,null,1212018,"Mike",70000,null,null,null,1212012,"Smith",15000]
[null,1212013,"Adam",80000,null,1212014,"Heyden",50000,null,null,null,1212013,"Adam",80000]
[null,1212014,"Heyden",50000,null,1212015,"William",45000,null,null,null,1212014,"Heyden",50000]
[null,1212015,"William",45000,null,1212017,"Andrew",44000,null,null,null,1212015,"William",45000]
[null,1212016,"Symonds",34500,null,1212016,"Symonds",34500,null,null,null,1212016,"Symonds",34500]
[null,1212017,"Andrew",44000,null,1212010,"Rodney",25600,null,null,null,1212017,"Andrew",44000]
[null,1212018,"Mike",70000,null,1212011,"Phillips",23000,null,null,null,1212018,"Mike",70000]
[null,1212019,"Steve",95000,null,1212012,"Smith",15000,null,null,null,1212019,"Steve",95000]

{"sheet":"VBA","index":8,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,"Do It Yourself"]
[]
[null,"ID","Name","Income",null,null,null,"ID","Name","Income"]
[null,1212019,"Steve",95000,null,null,null,1212010,"Rodney",25600]
[null,1212013,"Adam",80000,null,null,null,1212011,"Phillips",23000]
[null,1212018,"Mike",70000,null,null,null,1212012,"Smith",15000]
[null,1212014,"Heyden",50000,null,null,null,1212013,"Adam",80000]
[null,1212015,"William",45000,null,null,null,1212014,"Heyden",50000]
[null,1212017,"Andrew",44000,null,null,null,1212015,"William",45000]
[null,1212016,"Symonds",34500,null,null,null,1212016,"Symonds",34500]
[null,1212010,"Rodney",25600,null,null,null,1212017,"Andrew",44000]
[null,1212011,"Phillips",23000,null,null,null,1212018,"Mike",70000]
[null,1212012,"Smith",15000,null,null,null,1212019,"Steve",95000]

{"sheet":"Problems You Might Face","index":9,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Problems You Might Face",null,null,null,null,null,"Do It Yourself"]
[]
[null,"ID","Name","Income",null,null,null,"ID","Name","Income"]
[null,1212012,"Smith",15000,null,null,null,1212010,"Rodney",25600]
[null,1212011,"Phillips",23000,null,null,null,1212011,"Phillips",23000]
[null,1212010,"Rodney",25600,null,null,null,1212012,"Smith",15000]
[null,1212016,"Symonds",34500,null,null,null,1212013,"Adam",80000]
[null,1212017,"Andrew",44000,null,null,null,1212014,"Heyden",50000]
[null,1212014,"Heyden",50000]
[null,1212018,"Mike",70000,null,null,null,1212016,"Symonds",34500]
[null,1212013,"Adam",80000,null,null,null,1212017,"Andrew",44000]
[null,1212019,"Steve",95000,null,null,null,1212018,"Mike",70000]
[null,null,null,null,null,null,null,1212019,"Steve",95000]