{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Dataset","Custom_Sort","Custom_Sort_Multi Columns","Custom_Sort Using For Loop","Sorting in Table","Multiple Columns Sorting","Ascending-Alphabetically","Ascending-Numeric","Ascending-Date","Descending","Mouse Click","Practice Section"],"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":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sample Dataset"]
[]
[null,"Date","Product","Salesperson","Total Sales"]
[null,"2023-01-10","Desktop PC","John",10000]
[null,"2023-01-08","Laptop","Mary",12000]
[null,"2023-01-02","Printer","John",5000]
[null,"2022-01-06","Monitor","Jack",25000]
[null,"2023-01-03","Keyboard","Mary",1000]
[null,"2023-01-07","Mouse","Jack",900]
[null,"2023-01-04","Router","John",1500]
[null,"2023-01-01","External Drive","Jack",1500]
[null,"2023-01-05","Desktop PC","Mary",8000]
[null,"2023-01-05","Laptop","John",9600]

{"sheet":"Custom_Sort","index":1,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Custom Sorting Based on Single Column"]
[]
[null,"Date","Product","Salesperson","Total Sales",null,"List"]
[null,"2023-01-08","Laptop","Mary",12000,null,"Mary"]
[null,"2023-01-03","Keyboard","Mary",1000,null,"Jack"]
[null,"2023-01-05","Desktop PC","Mary",8000,null,"John"]
[null,"2022-01-06","Monitor","Jack",25000]
[null,"2023-01-07","Mouse","Jack",900]
[null,"2023-01-01","External Drive","Jack",1500]
[null,"2023-01-10","Desktop PC","John",10000]
[null,"2023-01-02","Printer","John",5000]
[null,"2023-01-04","Router","John",1500]
[null,"2023-01-05","Laptop","John",9600]

{"sheet":"Custom_Sort_Multi Columns","index":2,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Custom Sorting Based on Multiple Columns"]
[]
[null,null,null,1]
[null,null,null,2]
[]
[null,"Date","Product","Salesperson","Total Sales",null,"List"]
[null,"2023-01-08","Laptop","Mary",12000,null,"Mary"]
[null,"2023-01-05","Desktop PC","Mary",8000,null,"Jack"]
[null,"2023-01-03","Keyboard","Mary",1000,null,"John"]
[null,"2022-01-06","Monitor","Jack",25000]
[null,"2023-01-01","External Drive","Jack",1500]
[null,"2023-01-07","Mouse","Jack",900]
[null,"2023-01-10","Desktop PC","John",10000]
[null,"2023-01-05","Laptop","John",9600]
[null,"2023-01-02","Printer","John",5000]
[null,"2023-01-04","Router","John",1500]

{"sheet":"Custom_Sort Using For Loop","index":3,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Custom Sorting Based on Conditions"]
[]
[null,"Date","Product","Salesperson","Total Sales"]
[null,"2023-01-04","Router","John",1500]
[null,"2023-01-05","Laptop","John",9600]
[null,"2023-01-02","Printer","Jack",5000]
[null,"2022-01-06","Monitor","Jack",0]
[null,"2023-01-10","Desktop PC","John",20000]
[null,"2023-01-07","Mouse","Jack",900]
[null,"2023-01-10","Desktop PC","John",13000]
[null,"2023-01-01","External Drive","Jack",1500]
[null,"2023-01-05","Desktop PC","Jack",8000]
[null,"2023-01-10","Laptop","John",10000]
[null,"2023-01-03","Keyboard","Mary",1000]
[null,"2023-01-08","Printer","Mary",0]
[null,"2023-01-02","Desktop PC","Jack",50000]
[null,"2022-01-06","Keyboard","Jack",0]
[null,"2023-01-03","Mouse","Mary",1000]
[null,"2023-01-07","Desktop PC","Jack",9000]
[null,"2023-01-08","Laptop","Mary",12000]

{"sheet":"Sorting in Table","index":4,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sorting Data in Excel Table"]
[]
[null,"Date","Product","Salesperson","Total Sales"]
[null,"2023-01-04","Router","John",1500]
[null,"2023-01-02","Printer","John",5000]
[null,"2023-01-07","Mouse","Jack",900]
[null,"2022-01-06","Monitor","Jack",25000]
[null,"2023-01-05","Laptop","John",9600]
[null,"2023-01-08","Laptop","Mary",12000]
[null,"2023-01-03","Keyboard","Mary",1000]
[null,"2023-01-01","External Drive","Jack",1500]
[null,"2023-01-05","Desktop PC","Mary",8000]
[null,"2023-01-10","Desktop PC","John",10000]

{"sheet":"Multiple Columns Sorting","index":5,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sorting Data Within Multiple Columns"]
[]
[null,"Date","Product","Salesperson","Total Sales"]
[null,"2023-01-05","Desktop PC","Mary",8000]
[null,"2023-01-10","Desktop PC","John",10000]
[null,"2023-01-01","External Drive","Jack",1500]
[null,"2023-01-03","Keyboard","Mary",1000]
[null,"2023-01-05","Laptop","John",9600]
[null,"2023-01-08","Laptop","Mary",12000]
[null,"2022-01-06","Monitor","Jack",25000]
[null,"2023-01-07","Mouse","Jack",900]
[null,"2023-01-02","Printer","John",5000]
[null,"2023-01-04","Router","John",1500]

{"sheet":"Ascending-Alphabetically","index":6,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sorting Text Data in Ascending Order"]
[]
[null,"Date","Product","Salesperson","Total Sales"]
[null,"2023-01-10","Desktop PC","Jack",10000]
[null,"2023-01-08","Laptop","Jack",12000]
[null,"2023-01-02","Printer","Jack",5000]
[null,"2022-01-06","Monitor","John",25000]
[null,"2023-01-03","Keyboard","John",1000]
[null,"2023-01-07","Mouse","John",900]
[null,"2023-01-04","Router","John",1500]
[null,"2023-01-01","External Drive","Mary",1500]
[null,"2023-01-05","Desktop PC","Mary",8000]
[null,"2023-01-05","Laptop","Mary",9600]

{"sheet":"Ascending-Numeric","index":7,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sorting Numeric Data in Ascending Order"]
[]
[null,"Date","Product","Salesperson","Total Sales"]
[null,"2023-01-10","Desktop PC","John",900]
[null,"2023-01-08","Laptop","Mary",1000]
[null,"2023-01-02","Printer","John",1500]
[null,"2022-01-06","Monitor","Jack",1500]
[null,"2023-01-03","Keyboard","Mary",5000]
[null,"2023-01-07","Mouse","Jack",8000]
[null,"2023-01-04","Router","John",9600]
[null,"2023-01-01","External Drive","Jack",10000]
[null,"2023-01-05","Desktop PC","Mary",12000]
[null,"2023-01-05","Laptop","John",25000]

{"sheet":"Ascending-Date","index":8,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sorting Date in Ascending Order"]
[]
[null,"Date","Product","Salesperson","Total Sales"]
[null,"2022-01-06","Desktop PC","John",10000]
[null,"2023-01-01","Laptop","Mary",12000]
[null,"2023-01-02","Printer","John",5000]
[null,"2023-01-03","Monitor","Jack",25000]
[null,"2023-01-04","Keyboard","Mary",1000]
[null,"2023-01-05","Mouse","Jack",900]
[null,"2023-01-05","Router","John",1500]
[null,"2023-01-07","External Drive","Jack",1500]
[null,"2023-01-08","Desktop PC","Mary",8000]
[null,"2023-01-10","Laptop","John",9600]

{"sheet":"Descending","index":9,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sorting Data in Descending Order"]
[]
[null,"Date","Product","Salesperson","Total Sales"]
[null,"2023-01-10","Router","John",10000]
[null,"2023-01-08","Printer","Mary",12000]
[null,"2023-01-02","Mouse","John",5000]
[null,"2022-01-06","Monitor","Jack",25000]
[null,"2023-01-03","Laptop","Mary",1000]
[null,"2023-01-07","Laptop","Jack",900]
[null,"2023-01-04","Keyboard","John",1500]
[null,"2023-01-01","External Drive","Jack",1500]
[null,"2023-01-05","Desktop PC","Mary",8000]
[null,"2023-01-05","Desktop PC","John",9600]

{"sheet":"Mouse Click","index":10,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sorting by Double Click"]
[]
[null,"Date","Product","Salesperson","Total Sales"]
[null,"2022-01-06","Desktop PC","John",10000]
[null,"2023-01-01","Laptop","Mary",12000]
[null,"2023-01-02","Printer","John",5000]
[null,"2023-01-03","Monitor","Jack",25000]
[null,"2023-01-04","Keyboard","Mary",1000]
[null,"2023-01-05","Mouse","Jack",900]
[null,"2023-01-05","Router","John",1500]
[null,"2023-01-07","External Drive","Jack",1500]
[null,"2023-01-08","Desktop PC","Mary",8000]
[null,"2023-01-10","Laptop","John",9600]

{"sheet":"Practice Section","index":11,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Do It Yourself"]
[]
[null,"Date","Product","Salesperson","Total Sales"]
[null,"2023-01-10","Laptop","John",10000]
[null,"2023-01-08","Laptop","Mary",12000]
[null,"2023-01-02","Printer","Jack",5000]
[null,"2022-01-06","Monitor","Jack",0]
[null,"2023-01-03","Keyboard","Mary",1000]
[null,"2023-01-07","Mouse","Jack",900]
[null,"2023-01-04","Router","John",1500]
[null,"2023-01-01","External Drive","Jack",1500]
[null,"2023-01-05","Desktop PC","Jack",8000]
[null,"2023-01-05","Laptop","John",9600]
[null,"2023-01-10","Desktop PC","John",13000]
[null,"2023-01-08","Printer","Mary",0]
[null,"2023-01-02","Desktop PC","Jack",50000]
[null,"2022-01-06","Keyboard","Jack",0]
[null,"2023-01-03","Mouse","Mary",1000]
[null,"2023-01-07","Desktop PC","Jack",9000]
[null,"2023-01-10","Desktop PC","John",20000]