{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["dataset","Keyboard Shortcut","Button","Dynamic Filter"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":12,"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":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,9]]}
[]
[null,"Using Dynamic Advanced Filter in Excel"]
[]
[null,"Sales Person","Region","Product Name","Brand",null,"Sales Person","Region","Product Name","Brand"]
[null,"John","US","Mobile","Apple",null,null,"US","Mobile"]
[null,"August","Australia","Mobile","Samsung"]
[null,"Nick","US","Laptop","Asus"]
[null,"Jordi","Canada","Hard Disk ","Toshiba"]
[null,"Ismail","Asia","Keyboard","A4",null,"Sales Person","Region","Product Name","Brand"]
[null,"Moses","Canada","Laptop","HP"]
[null,"Ajantha","Asia","Mobile","Samsung"]
[null,"Jamil","US","Mobile","Apple"]
[null,"David","Australia","Laptop","Apple"]
[null,"John","Asia","Hard Disk ","Western digital"]
[null,"Abraham","Asia","Hard Disk ","Seagate"]
[null,"Noah","US","Keyboard","Logitech"]
[null,"Xaka","Australia","Laptop","Dell"]
[null,"Jaun","Asia","Laptop","Dell"]
[null,"Isshak","Canada","Mobile","Apple"]

{"sheet":"Keyboard Shortcut","index":1,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,9]]}
[]
[null,"Creating Dynamic Advanced Filter Using Macros with a Keyboard Shortcut"]
[]
[null,"Sales Person","Region","Product Name","Brand",null,"Sales Person","Region","Product Name","Brand"]
[null,"John","US","Mobile","Apple",null,null,"US","Mobile"]
[null,"August","Australia","Mobile","Samsung"]
[null,"Nick","US","Laptop","Asus"]
[null,"Jordi","Canada","Hard Disk ","Toshiba"]
[null,"Ismail","Asia","Keyboard","A4",null,"Sales Person","Region","Product Name","Brand"]
[null,"Moses","Canada","Laptop","HP",null,"John","US","Mobile","Apple"]
[null,"Ajantha","Asia","Mobile","Samsung",null,"Jamil","US","Mobile","Apple"]
[null,"Jamil","US","Mobile","Apple"]
[null,"David","Australia","Laptop","Apple"]
[null,"John","Asia","Hard Disk ","Western digital"]
[null,"Abraham","Asia","Hard Disk ","Seagate"]
[null,"Noah","US","Keyboard","Logitech"]
[null,"Xaka","Australia","Laptop","Dell"]
[null,"Jaun","Asia","Laptop","Dell"]
[null,"Isshak","Canada","Mobile","Apple"]

{"sheet":"Button","index":2,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,9]]}
[]
[null,"Creating Dynamic Advanced Filter Using Macros with a Button"]
[]
[null,"Sales Person","Region","Product Name","Brand",null,"Sales Person","Region","Product Name","Brand"]
[null,"John","US","Mobile","Apple",null,null,null,"Mobile"]
[null,"August","Australia","Mobile","Samsung"]
[null,"Nick","US","Laptop","Asus"]
[null,"Jordi","Canada","Hard Disk ","Toshiba"]
[null,"Ismail","Asia","Keyboard","A4",null,"Sales Person","Region","Product Name","Brand"]
[null,"Moses","Canada","Laptop","HP",null,"John","US","Mobile","Apple"]
[null,"Ajantha","Asia","Mobile","Samsung",null,"August","Australia","Mobile","Samsung"]
[null,"Jamil","US","Mobile","Apple",null,"Ajantha","Asia","Mobile","Samsung"]
[null,"David","Australia","Laptop","Apple",null,"Jamil","US","Mobile","Apple"]
[null,"John","Asia","Hard Disk ","Western digital",null,"Isshak","Canada","Mobile","Apple"]
[null,"Abraham","Asia","Hard Disk ","Seagate"]
[null,"Noah","US","Keyboard","Logitech"]
[null,"Xaka","Australia","Laptop","Dell"]
[null,"Jaun","Asia","Laptop","Dell"]
[null,"Isshak","Canada","Mobile","Apple"]

{"sheet":"Dynamic Filter","index":3,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Applying a Dynamic Filter in Excel",null,null,null,null,"Filter"]
[null,null,null,null,null,null,"US"]
[null,"Sales Person","Region","Product Name","Brand"]
[null,"John","US","Mobile","Apple"]
[null,"August","Australia","Mobile","Samsung"]
[null,"Nick","US","Laptop","Asus"]
[null,"Jordi","Canada","Hard Disk ","Toshiba"]
[null,"Ismail","Asia","Keyboard","A4"]
[null,"Moses","Canada","Laptop","HP"]
[null,"Ajantha","Asia","Mobile","Samsung"]
[null,"Jamil","US","Mobile","Apple"]
[null,"David","Australia","Laptop","Apple"]
[null,"John","Asia","Hard Disk ","Western digital"]
[null,"Abraham","Asia","Hard Disk ","Seagate"]
[null,"Noah","US","Keyboard","Logitech"]
[null,"Xaka","Australia","Laptop","Dell"]
[null,"Jaun","Asia","Laptop","Dell"]
[null,"Isshak","Canada","Mobile","Apple"]