{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Dataset","Named Range","MsgBox","User Input","All Columns","Multiple Columns","Excel Formula","User Defined Function","Another Workbook","Table Array","Practice Section"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":24,"n_cols":18,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Employee Details of X Company"]
[]
[null,"Employee ID","Date of Joining","Employee Name","Salary"]
[null,1100801,"2022-01-01","Sam Curran",1350]
[null,1100802,"2022-02-01","Peter Pategrew",1400]
[null,1100803,"2022-03-01","Sarah Grace",1300]
[null,1100804,"2022-04-01","Tom Howard",1100]
[null,1100805,"2022-05-01","Gina Lanetti",1250]
[null,1100806,"2022-06-01","Mike Maignan",1500]
[null,1100807,"2022-07-01","Emma Thompson",1300]
[null,1100808,"2022-08-01","Daniel Hernandez",1100]
[null,1100809,"2022-09-01","Olivia Kim",1350]
[null,1100810,"2022-10-01","Jason Lee",1400]
[null,1100811,"2022-11-01","Samantha Patel",1500]
[null,1100812,"2022-12-01","Benjamin Chen",1550]
[null,1100813,"2023-01-01","Isabella Singh",1200]
[null,1100814,"2023-02-01","Ethan Davis",1100]
[null,1100815,"2023-03-01","Lucas Rodriguez",1450]
[null,1100816,"2023-04-01","Mia Brown",1600]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]

{"sheet":"Named Range","index":1,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Creating a Named Range in Excel"]
[]
[null,"Employee ID","Date of Joining","Employee Name","Salary"]
[null,1100801,"2022-01-01","Sam Curran",1350]
[null,1100802,"2022-02-01","Peter Pategrew",1400]
[null,1100803,"2022-03-01","Sarah Grace",1300]
[null,1100804,"2022-04-01","Tom Howard",1100]
[null,1100805,"2022-05-01","Gina Lanetti",1250]
[null,1100806,"2022-06-01","Mike Maignan",1500]
[null,1100807,"2022-07-01","Emma Thompson",1300]
[null,1100808,"2022-08-01","Daniel Hernandez",1100]
[null,1100809,"2022-09-01","Olivia Kim",1350]
[null,1100810,"2022-10-01","Jason Lee",1400]
[null,1100811,"2022-11-01","Samantha Patel",1500]
[null,1100812,"2022-12-01","Benjamin Chen",1550]
[null,1100813,"2023-01-01","Isabella Singh",1200]
[null,1100814,"2023-02-01","Ethan Davis",1100]
[null,1100815,"2023-03-01","Lucas Rodriguez",1450]
[null,1100816,"2023-04-01","Mia Brown",1600]

{"sheet":"MsgBox","index":2,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Showing Single Output for Definite Entry"]
[]
[null,"Employee ID","Date of Joining","Employee Name","Salary"]
[null,1100801,"2022-01-01","Sam Curran",1350]
[null,1100802,"2022-02-01","Peter Pategrew",1400]
[null,1100803,"2022-03-01","Sarah Grace",1300]
[null,1100804,"2022-04-01","Tom Howard",1100]
[null,1100805,"2022-05-01","Gina Lanetti",1250]
[null,1100806,"2022-06-01","Mike Maignan",1500]
[null,1100807,"2022-07-01","Emma Thompson",1300]
[null,1100808,"2022-08-01","Daniel Hernandez",1100]
[null,1100809,"2022-09-01","Olivia Kim",1350]
[null,1100810,"2022-10-01","Jason Lee",1400]
[null,1100811,"2022-11-01","Samantha Patel",1500]
[null,1100812,"2022-12-01","Benjamin Chen",1550]
[null,1100813,"2023-01-01","Isabella Singh",1200]
[null,1100814,"2023-02-01","Ethan Davis",1100]
[null,1100815,"2023-03-01","Lucas Rodriguez",1450]
[null,1100816,"2023-04-01","Mia Brown",1600]
[]
[null,"Employee ID"]
[null,1100814]

{"sheet":"User Input","index":3,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Extracting Values from a Named Range with User Input"]
[]
[null,"Employee ID","Date of Joining","Employee Name","Salary"]
[null,1100801,"2022-01-01","Sam Curran",1350]
[null,1100802,"2022-02-01","Peter Pategrew",1400]
[null,1100803,"2022-03-01","Sarah Grace",1300]
[null,1100804,"2022-04-01","Tom Howard",1100]
[null,1100805,"2022-05-01","Gina Lanetti",1250]
[null,1100806,"2022-06-01","Mike Maignan",1500]
[null,1100807,"2022-07-01","Emma Thompson",1300]
[null,1100808,"2022-08-01","Daniel Hernandez",1100]
[null,1100809,"2022-09-01","Olivia Kim",1350]
[null,1100810,"2022-10-01","Jason Lee",1400]
[null,1100811,"2022-11-01","Samantha Patel",1500]
[null,1100812,"2022-12-01","Benjamin Chen",1550]
[null,1100813,"2023-01-01","Isabella Singh",1200]
[null,1100814,"2023-02-01","Ethan Davis",1100]
[null,1100815,"2023-03-01","Lucas Rodriguez",1450]
[null,1100816,"2023-04-01","Mia Brown",1600]

{"sheet":"All Columns","index":4,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Showing All Columns Data for Definite Entry"]
[]
[null,"Employee ID","Date of Joining","Employee Name","Salary"]
[null,1100801,"2022-01-01","Sam Curran",1350]
[null,1100802,"2022-02-01","Peter Pategrew",1400]
[null,1100803,"2022-03-01","Sarah Grace",1300]
[null,1100804,"2022-04-01","Tom Howard",1100]
[null,1100805,"2022-05-01","Gina Lanetti",1250]
[null,1100806,"2022-06-01","Mike Maignan",1500]
[null,1100807,"2022-07-01","Emma Thompson",1300]
[null,1100808,"2022-08-01","Daniel Hernandez",1100]
[null,1100809,"2022-09-01","Olivia Kim",1350]
[null,1100810,"2022-10-01","Jason Lee",1400]
[null,1100811,"2022-11-01","Samantha Patel",1500]
[null,1100812,"2022-12-01","Benjamin Chen",1550]
[null,1100813,"2023-01-01","Isabella Singh",1200]
[null,1100814,"2023-02-01","Ethan Davis",1100]
[null,1100815,"2023-03-01","Lucas Rodriguez",1450]
[null,1100816,"2023-04-01","Mia Brown",1600]

{"sheet":"Multiple Columns","index":5,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Extracting Multiple Columns from Different Named Ranges"]
[]
[null,"Employee ID","Date of Joining","Employee Name","Salary","Region","Department"]
[null,1100801,"2022-01-01","Sam Curran",1350,"Central","Marketing"]
[null,1100802,"2022-02-01","Peter Pategrew",1400,"West","Marketing"]
[null,1100803,"2022-03-01","Sarah Grace",1300,"West","Sales"]
[null,1100804,"2022-04-01","Tom Howard",1100,"West","Sales"]
[null,1100805,"2022-05-01","Gina Lanetti",1250,"Central","Marketing"]
[null,1100806,"2022-06-01","Mike Maignan",1500,"East","Sales"]
[]
[null,"Employee ID","Region","Department"]
[null,1100804,"West","Sales"]
[null,1100806,"East","Sales"]
[null,1100805,"Central","Marketing"]
[null,1100802,"West","Marketing"]
[null,1100801,"Central","Marketing"]
[null,1100803,"West","Sales"]

{"sheet":"Excel Formula","index":6,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Adding Multiple Columns with Excel VLookup Formula in VBA"]
[]
[null,"Employee ID","Date of Joining","Employee Name","Salary",{"$f":"VLOOKUP($B4,New_Data,COLUMN(B$12),FALSE)","v":"Region"},"Department"]
[null,1100801,"2022-01-01","Sam Curran",1350,"Central","Marketing"]
[null,1100802,"2022-02-01","Peter Pategrew",1400,"West","Marketing"]
[null,1100803,"2022-03-01","Sarah Grace",1300,"West","Sales"]
[null,1100804,"2022-04-01","Tom Howard",1100,"West","Sales"]
[null,1100805,"2022-05-01","Gina Lanetti",1250,"Central","Marketing"]
[null,1100806,"2022-06-01","Mike Maignan",1500,"East","Sales"]
[]
[null,"Employee ID","Region","Department"]
[null,1100804,"West","Sales"]
[null,1100806,"East","Sales"]
[null,1100805,"Central","Marketing"]
[null,1100802,"West","Marketing"]
[null,1100801,"Central","Marketing"]
[null,1100803,"West","Sales"]

{"sheet":"User Defined Function","index":7,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,4],[21,3,21,4],[22,3,22,4]]}
[]
[null,"Creating a User Defined VLookup Function with Named Range"]
[]
[null,"Employee ID","Date of Joining","Employee Name","Salary"]
[null,1100801,"2022-01-01","Sam Curran",1350]
[null,1100802,"2022-02-01","Peter Pategrew",1400]
[null,1100803,"2022-03-01","Sarah Grace",1300]
[null,1100804,"2022-04-01","Tom Howard",1100]
[null,1100805,"2022-05-01","Gina Lanetti",1250]
[null,1100806,"2022-06-01","Mike Maignan",1500]
[null,1100807,"2022-07-01","Emma Thompson",1300]
[null,1100808,"2022-08-01","Daniel Hernandez",1100]
[null,1100809,"2022-09-01","Olivia Kim",1350]
[null,1100810,"2022-10-01","Jason Lee",1400]
[null,1100811,"2022-11-01","Samantha Patel",1500]
[null,1100812,"2022-12-01","Benjamin Chen",1550]
[null,1100813,"2023-01-01","Isabella Singh",1200]
[null,1100814,"2023-02-01","Ethan Davis",1100]
[null,1100815,"2023-03-01","Lucas Rodriguez",1450]
[null,1100816,"2023-04-01","Mia Brown",1600]
[]
[null,"Employee ID","Employee Name","Formula"]
[null,1100813,{"$f":"VBA_Vlookup(B23,Employee_Data,3,FALSE)","v":"Isabella Singh"},{"$f":"_xlfn.FORMULATEXT(C23)","v":"=VBA_Vlookup(B23,Employee_Data,3,FALSE)"}]

{"sheet":"Another Workbook","index":8,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Incorporating VBA VLookup Function in Another Workbook"]
[]
[null,"Employee ID","Date of Joining","Employee Name","Salary"]
[null,1100801,"2022-01-01","Sam Curran",1350]
[null,1100802,"2022-02-01","Peter Pategrew",1400]
[null,1100803,"2022-03-01","Sarah Grace",1300]
[null,1100804,"2022-04-01","Tom Howard",1100]
[null,1100805,"2022-05-01","Gina Lanetti",1250]
[null,1100806,"2022-06-01","Mike Maignan",1500]
[null,1100807,"2022-07-01","Emma Thompson",1300]
[null,1100808,"2022-08-01","Daniel Hernandez",1100]
[null,1100809,"2022-09-01","Olivia Kim",1350]
[null,1100810,"2022-10-01","Jason Lee",1400]
[null,1100811,"2022-11-01","Samantha Patel",1500]
[null,1100812,"2022-12-01","Benjamin Chen",1550]
[null,1100813,"2023-01-01","Isabella Singh",1200]
[null,1100814,"2023-02-01","Ethan Davis",1100]
[null,1100815,"2023-03-01","Lucas Rodriguez",1450]
[null,1100816,"2023-04-01","Mia Brown",1600]
[]
[null,"Employee ID","Employee Name"]
[null,1100811,"Dylan Patel"]

{"sheet":"Table Array","index":9,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using VBA VLookup Function with Table Array"]
[]
[null,"Employee ID","Date of Joining","Employee Name","Salary"]
[null,1100801,"2022-01-01","Sam Curran",1350]
[null,1100802,"2022-02-01","Peter Pategrew",1400]
[null,1100803,"2022-03-01","Sarah Grace",1300]
[null,1100804,"2022-04-01","Tom Howard",1100]
[null,1100805,"2022-05-01","Gina Lanetti",1250]
[null,1100806,"2022-06-01","Mike Maignan",1500]
[null,1100807,"2022-07-01","Emma Thompson",1300]
[null,1100808,"2022-08-01","Daniel Hernandez",1100]
[null,1100809,"2022-09-01","Olivia Kim",1350]
[null,1100810,"2022-10-01","Jason Lee",1400]
[null,1100811,"2022-11-01","Samantha Patel",1500]
[null,1100812,"2022-12-01","Benjamin Chen",1550]
[null,1100813,"2023-01-01","Isabella Singh",1200]
[null,1100814,"2023-02-01","Ethan Davis",1100]
[null,1100815,"2023-03-01","Lucas Rodriguez",1450]
[null,1100816,"2023-04-01","Mia Brown",1600]
[]
[null,"Employee ID","Employee Name"]
[null,1100809,"Olivia Kim"]

{"sheet":"Practice Section","index":10,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Practice Section"]
[]
[null,"Employee ID","Date of Joining","Employee Name","Salary"]
[null,1100801,"2022-01-01","Sam Curran",1350]
[null,1100802,"2022-02-01","Peter Pategrew",1400]
[null,1100803,"2022-03-01","Sarah Grace",1300]
[null,1100804,"2022-04-01","Tom Howard",1100]
[null,1100805,"2022-05-01","Gina Lanetti",1250]
[null,1100806,"2022-06-01","Mike Maignan",1500]
[null,1100807,"2022-07-01","Emma Thompson",1300]
[null,1100808,"2022-08-01","Daniel Hernandez",1100]
[null,1100809,"2022-09-01","Olivia Kim",1350]
[null,1100810,"2022-10-01","Jason Lee",1400]
[null,1100811,"2022-11-01","Samantha Patel",1500]
[null,1100812,"2022-12-01","Benjamin Chen",1550]
[null,1100813,"2023-01-01","Isabella Singh",1200]
[null,1100814,"2023-02-01","Ethan Davis",1100]
[null,1100815,"2023-03-01","Lucas Rodriguez",1450]
[null,1100816,"2023-04-01","Mia Brown",1600]
[]
[null,"Employee ID","Employee Name"]