{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Deleting Mutilple Columns","Deleting Mutilple Columns (2)","Deleting Mutilple Columns (3)","Deleting Mutilple Columns (4)","Deleting Mutilple Columns (5)","Deleting Mutilple Columns (6)","info"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Deleting Mutilple Columns","index":0,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Sample Dataset"]
[]
[null,"Id Number","Name","Joining Month ","Station","Salary","Allowances"]
[null,44198,"James","January","Emergency",2000,250]
[null,44199,"Robert","February","In Ward",1500,200]
[null,44200,"John","March","Pharmacy",2500,300]
[null,44199,"Michael","April","Pharmacy",3000,300]
[null,44200,"William","April","Emergency",2000,250]
[null,44201,"David","June","Emergency",2000,250]
[null,44202,"Richard","July","Emergency",2000,250]
[null,44203,"Joseph","April","In Ward",1500,200]
[null,44204,"Thomas","September","In Ward",1500,200]

{"sheet":"Deleting Mutilple Columns (2)","index":1,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Use of Context Menu"]
[]
[null,"Id Number","Name","Joining Month ","Station","Salary","Allowances"]
[null,44198,"James","January","Emergency",2000,250]
[null,44199,"Robert","February","In Ward",1500,200]
[null,44200,"John","March","Pharmacy",2500,300]
[null,44199,"Michael","April","Pharmacy",3000,300]
[null,44200,"William","April","Emergency",2000,250]
[null,44201,"David","June","Emergency",2000,250]
[null,44202,"Richard","July","Emergency",2000,250]
[null,44203,"Joseph","April","In Ward",1500,200]
[null,44204,"Thomas","September","In Ward",1500,200]

{"sheet":"Deleting Mutilple Columns (3)","index":2,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Use of Delete Sheet Columns Option in Home Tab"]
[]
[null,"Id Number","Name","Joining Month ","Station","Salary","Allowances"]
[null,44198,"James","January","Emergency",2000,250]
[null,44199,"Robert","February","In Ward",1500,200]
[null,44200,"John","March","Pharmacy",2500,300]
[null,44199,"Michael","April","Pharmacy",3000,300]
[null,44200,"William","April","Emergency",2000,250]
[null,44201,"David","June","Emergency",2000,250]
[null,44202,"Richard","July","Emergency",2000,250]
[null,44203,"Joseph","April","In Ward",1500,200]
[null,44204,"Thomas","September","In Ward",1500,200]

{"sheet":"Deleting Mutilple Columns (4)","index":3,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Use of Find & Select Feature"]
[]
[null,"Id Number","Name","Joining Month ","Station","Salary","Allowances"]
[null,44198,"James","January","Emergency",2000,250]
[null,44199,"Robert","February","In Ward",1500,200]
[null,44200,"John","March","Pharmacy",2500,300]
[null,44199,"Michael","April","Pharmacy",3000,300]
[null,44200,"William","April","Emergency",2000,250]
[null,44201,"David","June","Emergency",2000,250]
[null,44202,"Richard","July","Emergency",2000,250]
[null,44203,"Joseph","April","In Ward",1500,200]
[null,44204,"Thomas","September","In Ward",1500,200]

{"sheet":"Deleting Mutilple Columns (5)","index":4,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Use of COUNTA Function"]
[]
[null,"Id Number","Name","Joining Month ","Station","Salary","Allowances"]
[null,44198,"James","January","Emergency",2000,250]
[null,44199,"Robert","February","In Ward",1500,200]
[null,44200,"John","March","Pharmacy",2500,300]
[null,44199,"Michael","April","Pharmacy",3000,300]
[null,44200,"William","April","Emergency",2000,250]
[null,44201,"David","June","Emergency",2000,250]
[null,44202,"Richard","July","Emergency",2000,250]
[null,44203,"Joseph","April","In Ward",1500,200]
[null,44204,"Thomas","September","In Ward",1500,200]

{"sheet":"Deleting Mutilple Columns (6)","index":5,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[]
[null,"Use of VBA"]
[]
[null,"Id Number","Name","Origin","Joining Month ","Station","Salary","Tax","Allowances"]
[null,44198,"James",null,"January","Emergency",2000,null,250]
[null,44199,"Robert",null,"February","In Ward",1500,null,200]
[null,44200,"John",null,"March","Pharmacy",2500,null,300]
[null,44199,"Michael",null,"April","Pharmacy",3000,null,300]
[null,44200,"William",null,"April","Emergency",2000,null,250]
[null,44201,"David",null,"June","Emergency",2000,null,250]
[null,44202,"Richard",null,"July","Emergency",2000,null,250]
[null,44203,"Joseph",null,"April","In Ward",1500,null,200]
[null,44204,"Thomas",null,"September","In Ward",1500,null,200]

{"sheet":"info","index":6,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":true,"merged":[[0,0,0,2]]}
["Basic Info & Salary data"]
["Id Number","Name","Joining Month "]
[44198,"James","January"]
[44199,"Robert","February"]
[44200,"John","March"]
[44199,"Michael","April"]
[44200,"William","April"]
[44201,"David","June"]
[44202,"Richard","July"]
[44203,"Joseph","April"]
[44204,"Thomas","September"]