{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Formula","Table+Named Range","Table+Formula","VBA","Edit","Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":1,"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":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"List of Payment Types"]
[]
[null,"Payment Types"]
[null,"Cash"]
[null,"Checks"]
[null,"Debit cards"]
[null,"Credit cards"]
[null,"Mobile payments"]
[null,"Electronic bank transfers"]

{"sheet":"Formula","index":1,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,14]]}
[]
[null,"Combination of OFFSET and COUNTA Functions",null,null,null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Payment Types",null,"Dropdown List",null,null,null,null,null,null,null,null,"Payment Types",null,"Dropdown List"]
[null,"Cash",null,null,null,null,null,null,null,null,null,null,"Cash"]
[null,"Checks",null,null,null,null,null,null,null,null,null,null,"Checks"]
[null,"Debit cards",null,null,null,null,null,null,null,null,null,null,"Debit cards"]
[null,"Credit cards",null,null,null,null,null,null,null,null,null,null,"Credit cards"]
[null,"Mobile payments",null,null,null,null,null,null,null,null,null,null,"Mobile payments"]
[null,"Electronic bank transfers",null,null,null,null,null,null,null,null,null,null,"Electronic bank transfers"]

{"sheet":"Table+Named Range","index":2,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,14]]}
[]
[null,"Creating Table with a Named Range",null,null,null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Payment Types",null,"Dropdown List",null,null,null,null,null,null,null,null,"Payment Types",null,"Dropdown List"]
[null,"Cash",null,null,null,null,null,null,null,null,null,null,"Cash"]
[null,"Checks",null,null,null,null,null,null,null,null,null,null,"Checks"]
[null,"Debit cards",null,null,null,null,null,null,null,null,null,null,"Debit cards"]
[null,"Credit cards",null,null,null,null,null,null,null,null,null,null,"Credit cards"]
[null,"Mobile payments",null,null,null,null,null,null,null,null,null,null,"Mobile payments"]
[null,"Electronic bank transfers",null,null,null,null,null,null,null,null,null,null,"Electronic bank transfers"]
[null,"Bitcoin"]

{"sheet":"Table+Formula","index":3,"n_rows":11,"n_cols":16,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,13,1,15]]}
[]
[null,"Applying Formula with a Table",null,null,null,null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Payment Types",null,"Dropdown List",null,null,null,null,null,null,null,null,null,"Payment Types",null,"Dropdown List"]
[null,"Cash",null,null,null,null,null,null,null,null,null,null,null,"Cash"]
[null,"Checks",null,null,null,null,null,null,null,null,null,null,null,"Checks"]
[null,"Debit cards",null,null,null,null,null,null,null,null,null,null,null,"Debit cards"]
[null,"Credit cards",null,null,null,null,null,null,null,null,null,null,null,"Credit cards"]
[null,"Mobile payments",null,null,null,null,null,null,null,null,null,null,null,"Mobile payments"]
[null,"Electronic bank transfers",null,null,null,null,null,null,null,null,null,null,null,"Electronic bank transfers"]
[null,"Bitcoin"]

{"sheet":"VBA","index":4,"n_rows":11,"n_cols":16,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,13,1,15]]}
[]
[null,"Auto Populating Drop Down List Values",null,null,null,null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Payment Types",null,"Dropdown List",null,null,null,null,null,null,null,null,null,"Payment Types",null,"Dropdown List"]
[null,"Cash",null,"Cash",null,null,null,null,null,null,null,null,null,"Cash"]
[null,"Checks",null,null,null,null,null,null,null,null,null,null,null,"Checks"]
[null,"Debit cards",null,null,null,null,null,null,null,null,null,null,null,"Debit cards"]
[null,"Credit cards",null,null,null,null,null,null,null,null,null,null,null,"Credit cards"]
[null,"Mobile payments",null,null,null,null,null,null,null,null,null,null,null,"Mobile payments"]
[null,"Electronic bank transfers",null,null,null,null,null,null,null,null,null,null,null,"Electronic bank transfers"]
[null,"Bitcoin"]

{"sheet":"Edit","index":5,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,14]]}
[]
[null,"Editing Dropdown List",null,null,null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Payment Types",null,"Dropdown List",null,null,null,null,null,null,null,null,"Payment Types",null,"Dropdown List"]
[null,"Cash",null,null,null,null,null,null,null,null,null,null,"Cash"]
[null,"Checks",null,null,null,null,null,null,null,null,null,null,"Checks"]
[null,"Debit cards",null,null,null,null,null,null,null,null,null,null,"Debit cards"]
[null,"Credit cards",null,null,null,null,null,null,null,null,null,null,"Credit cards"]
[null,"Mobile payments",null,null,null,null,null,null,null,null,null,null,"Mobile payments"]
[null,"Electronic bank transfers",null,null,null,null,null,null,null,null,null,null,"Electronic bank transfers"]

{"sheet":"Sheet1","index":6,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["   Auto Update Drop Down List in Excel Using OFFSET and COUNTA Functions"]
[]
[null,"List ",null,null,"Drop Down List"]
[null,"Payment Types"]
[null,"Cash"]
[null,"Checks"]
[null,"Debit cards"]
[null,"Credit cards"]
[null,"Mobile payments"]
[null,"Electronic bank transfers"]
[null,"Bitcoin"]

{"sheet":"Sheet2","index":7,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Auto Update Drop Down List in Excel By Defining Name and Use Table"]
[]
[null,"List "]
[null,"Bitcoin"]
[null,"Cash"]
[null,"Checks"]
[null,"Debit cards"]
[null,"Credit cards"]
[null,"Mobile payments"]
[null,"Bitcoin"]

{"sheet":"Sheet3","index":8,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Auto Update Drop Down List in Excel Using INDIRECT Function"]
[]
[null,"List"]
[null,"Payment Types"]
[null,"Credit cards"]
[null,"Checks"]
[null,"Debit cards"]
[null,"Credit cards"]
[null,"Mobile payments"]
[null,"Electronic bank transfers"]