{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset ","Clicking on The Filter Option","Using Advanced Filtering","Using VBA to Hide Filter Button","Hiding Filter Button Pivot Tabl","Hiding Filter Button from Pivot","Hiding Filter Button from Table","Unhide Pivot Table Filters","Removing from Some Columns "],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":3},"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,"Hiding Filter Buttons in Excel"]
[]
[null,"Employee","Age","Hours of Work ","Salary"]
[null,"Andrew",24,144,1400]
[null,"Mira",25,147,1450]
[null,"Sara",27,155,1560]
[null,"Ross",23,138,1390]
[null,"Hena",26,164,1660]
[null,"Mike",31,173,1720]
[null,"Jane",29,184,1860]
[null,"Tom",28,176,1790]
[null,"Bob",33,130,1320]
[null,"Lily",30,190,1950]

{"sheet":"Clicking on The Filter Option","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Clicking on The Filter Option"]
[]
[null,"Employee","Age","Hours of Work ","Salary"]
[null,"Andrew",24,144,1400]
[null,"Mira",25,147,1450]
[null,"Sara",27,155,1560]
[null,"Ross",23,138,1390]
[null,"Hena",26,164,1660]
[null,"Mike",31,173,1720]
[null,"Jane",29,184,1860]
[null,"Tom",28,176,1790]
[null,"Bob",33,130,1320]
[null,"Lily",30,190,1950]

{"sheet":"Using Advanced Filtering","index":2,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Advanced Filtering"]
[]
[null,"Employee","Age","Hours of Work ","Salary"]
[null,"Andrew",24,144,1400]
[null,"Mira",25,147,1450]
[null,"Sara",27,155,1560]
[null,"Ross",23,138,1390]
[null,"Hena",26,164,1660]
[null,"Mike",31,173,1720]
[null,"Jane",29,184,1860]
[null,"Tom",28,176,1790]
[null,"Bob",33,130,1320]
[null,"Lily",30,190,1950]
[]
[null,"Filering Field","Salary"]
[null,"Condition",">1400"]

{"sheet":"Using VBA to Hide Filter Button","index":3,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using VBA to Hide Filter Buttons"]
[]
[null,"Employee","Age","Hours of Work ","Salary"]
[null,"Andrew",24,144,1400]
[null,"Mira",25,147,1450]
[null,"Sara",27,155,1560]
[null,"Ross",23,138,1390]
[null,"Hena",26,164,1660]
[null,"Mike",31,173,1720]
[null,"Jane",29,184,1860]
[null,"Tom",28,176,1790]
[null,"Bob",33,130,1320]
[null,"Lily",30,190,1950]

{"sheet":"Hiding Filter Button Pivot Tabl","index":4,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Hiding Filter Buttons from Pivot Table"]
[]
[null,"Employee","Age","Hours of Work ","Salary"]
[null,"Andrew",24,144,1400]
[null,"Mira",25,147,1450]
[null,"Sara",27,155,1560]
[null,"Ross",23,138,1390]
[null,"Hena",26,164,1660]
[null,"Mike",31,173,1720]
[null,"Jane",29,184,1860]
[null,"Tom",28,176,1790]
[null,"Bob",33,130,1320]
[null,"Lily",30,190,1950]
[]
[null,null,"Sum of Hours of Work ","Sum of Salary"]
[null,130,130,1320]
[null,138,138,1390]
[null,144,144,1400]
[null,147,147,1450]
[null,155,155,1560]
[null,164,164,1660]
[null,173,173,1720]
[null,176,176,1790]
[null,184,184,1860]
[null,190,190,1950]
[null,"Grand Total",1601,16100]

{"sheet":"Hiding Filter Button from Pivot","index":5,"n_rows":30,"n_cols":14,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Hiding Filter Buttons from Pivot Chart"]
[]
[null,"Employee","Age","Hours of Work ","Salary"]
[null,"Andrew",24,144,1400]
[null,"Mira",25,147,1450]
[null,"Sara",27,155,1560]
[null,"Ross",23,138,1390]
[null,"Hena",26,164,1660]
[null,"Mike",31,173,1720]
[null,"Jane",29,184,1860]
[null,"Tom",28,176,1790]
[null,"Bob",33,130,1320]
[null,"Lily",30,190,1950]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Sum of Hours of Work ","Sum of Salary"]
[null,null,null,null,null,null,null,null,null,null,null,130,130,1320]
[null,null,null,null,null,null,null,null,null,null,null,138,138,1390]
[null,null,null,null,null,null,null,null,null,null,null,144,144,1400]
[null,null,null,null,null,null,null,null,null,null,null,147,147,1450]
[null,null,null,null,null,null,null,null,null,null,null,155,155,1560]
[null,null,null,null,null,null,null,null,null,null,null,164,164,1660]
[null,null,null,null,null,null,null,null,null,null,null,173,173,1720]
[null,null,null,null,null,null,null,null,null,null,null,176,176,1790]
[null,null,null,null,null,null,null,null,null,null,null,184,184,1860]
[null,null,null,null,null,null,null,null,null,null,null,190,190,1950]
[null,null,null,null,null,null,null,null,null,null,null,"Grand Total",1601,16100]

{"sheet":"Hiding Filter Button from Table","index":6,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Hiding Filter Button from Table"]
[]
[null,"Employee","Age","Hours of Work ","Salary"]
[null,"Andrew",24,144,1400]
[null,"Mira",25,147,1450]
[null,"Sara",27,155,1560]
[null,"Ross",23,138,1390]
[null,"Hena",26,164,1660]
[null,"Mike",31,173,1720]
[null,"Jane",29,184,1860]
[null,"Tom",28,176,1790]
[null,"Bob",33,130,1320]
[null,"Lily",30,190,1950]

{"sheet":"Unhide Pivot Table Filters","index":7,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Unhide Pivot Table Filters"]
[]
[null,"Employee","Age","Hours of Work ","Salary"]
[null,"Andrew",24,144,1400]
[null,"Mira",25,147,1450]
[null,"Sara",27,155,1560]
[null,"Ross",23,138,1390]
[null,"Hena",26,164,1660]
[null,"Mike",31,173,1720]
[null,"Jane",29,184,1860]
[null,"Tom",28,176,1790]
[null,"Bob",33,130,1320]
[null,"Lily",30,190,1950]
[]
[null,"Row Labels","Sum of Hours of Work ","Sum of Salary"]
[null,130,130,1320]
[null,138,138,1390]
[null,144,144,1400]
[null,147,147,1450]
[null,155,155,1560]
[null,164,164,1660]
[null,173,173,1720]
[null,176,176,1790]
[null,184,184,1860]
[null,190,190,1950]
[null,"Grand Total",1601,16100]

{"sheet":"Removing from Some Columns ","index":8,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Removing Filter Buttons from Some Columns"]
[]
[null,"Employee","Age","Hours of Work ","Salary"]
[null,"Andrew",24,144,1400]
[null,"Mira",25,147,1450]
[null,"Sara",27,155,1560]
[null,"Ross",23,138,1390]
[null,"Hena",26,164,1660]
[null,"Mike",31,173,1720]
[null,"Jane",29,184,1860]
[null,"Tom",28,176,1790]
[null,"Bob",33,130,1320]
[null,"Lily",30,190,1950]