{"text_format":"1","workbook":"xlsx","n_sheets":27,"sheets":["dataset","selecting entire table","referencing column","get value","entering row","entering column","Sheet8","filtering","resize","without header","select header","select row","delete row and columns (2)","output","delete table","normal range (2)"," output 2","change table style (2)","Output 3","default style","loop","table header visible","count rows and colums","check","copying","Sheet8 (2)","Sheet8 (3)"],"not_rendered":{"charts":0,"images":0,"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":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Dataset Overview"]
[]
[null,"Seller","Region","Date","Sales Amount"]
[null,"Alex","East","2021-12-18",1500]
[null,"Paul","North","2021-08-14",2000]
[null,"John","North","2021-01-15",1800]
[null,"Lily","East","2021-04-12",2100]
[null,"Sam","West","2021-09-10",2600]
[null,"Tom","West","2021-04-21",2700]
[null,"Smith","North","2021-06-24",1700]
[null,"Peter","East","2021-09-25",2200]
[null,"Emily","West","2021-07-13",2300]

{"sheet":"selecting entire table","index":1,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Selecting an Entire Table"]
[]
[null,"Seller","Region","Date","Sales Amount"]
[null,"Alex","East","2021-12-18",1500]
[null,"Paul","North","2021-08-14",2000]
[null,"John","North","2021-01-15",1800]
[null,"Lily","East","2021-04-12",2100]
[null,"Sam","West","2021-09-10",2600]
[null,"Tom","West","2021-04-21",2700]
[null,"Smith","North","2021-06-24",1700]
[null,"Peter","East","2021-09-25",2200]
[null,"Emily","West","2021-07-13",2300]

{"sheet":"referencing column","index":2,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Referencing a Column of a Table"]
[]
[null,"Seller","Region","Date","Sales Amount"]
[null,"Alex","East","2021-12-18",1500]
[null,"Paul","North","2021-08-14",2000]
[null,"John","North","2021-01-15",1800]
[null,"Lily","East","2021-04-12",2100]
[null,"Sam","West","2021-09-10",2600]
[null,"Tom","West","2021-04-21",2700]
[null,"Smith","North","2021-06-24",1700]
[null,"Peter","East","2021-09-25",2200]
[null,"Emily","West","2021-07-13",2300]

{"sheet":"get value","index":3,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Getting a Value from a Cell from a Table"]
[]
[null,"Seller","Region","Date","Sales Amount"]
[null,"Alex","East","2021-12-18",1500]
[null,"Paul","North","2021-08-14",2000]
[null,"John","North","2021-01-15",1800]
[null,"Lily","East","2021-04-12",2100]
[null,"Sam","West","2021-09-10",2600]
[null,"Tom","West","2021-04-21",2700]
[null,"Smith","North","2021-06-24",1700]
[null,"Peter","East","2021-09-25",2200]
[null,"Emily","West","2021-07-13",2300]

{"sheet":"entering row","index":4,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null," Entering a Row "]
[]
[null,"Seller","Region","Date","Sales Amount"]
[null,"Alex","East","2021-12-18",1500]
[null,"Paul","North","2021-08-14",2000]
[null,"John","North","2021-01-15",1800]
[null,"Lily","East","2021-04-12",2100]
[null,"Sam","West","2021-09-10",2600]
[null,"Tom","West","2021-04-21",2700]
[null,"Smith","North","2021-06-24",1700]
[null,"Peter","East","2021-09-25",2200]
[null,"Emily","West","2021-07-13",2300]

{"sheet":"entering column","index":5,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null," Entering a Column"]
[]
[null,"Seller","Region","Date","Sales Amount","Column1"]
[null,"Alex","East","2021-12-18",1500]
[null,"Paul","North","2021-08-14",2000]
[null,"John","North","2021-01-15",1800]
[null,"Lily","East","2021-04-12",2100]
[null,"Sam","West","2021-09-10",2600]
[null,"Tom","West","2021-04-21",2700]
[null,"Smith","North","2021-06-24",1700]
[null,"Peter","East","2021-09-25",2200]
[null,"Emily","West","2021-07-13",2300]

{"sheet":"Sheet8","index":6,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Filtering a Table "]
[]
[null,"Name","From","Age","Income (Year)"]
[null,"Lisa Wilson","Alabama",28,35803]
[null,"Bobby Miller","California",35,79493]
[null,"Julia Davis","Texas",30,62256]
[null,"Harry Reed","Texas",32,53501]
[null,"Kelly Lewis","Nevada",25,40421]
[null,"Susan Sanders","Nevada",24,79089]
[null,"Brad Riley","Alabama",32,47159]
[null,"Julie Hughes","California",35,36250]
[null,"Shirley Ward","Texas",30,38980]
[null,"Ann Michell","California",26,60880]

{"sheet":"filtering","index":7,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Filtering a Table "]
[]
[null,"Name","From","Age","Income (Year)"]
[null,"Lisa Wilson","Alabama",28,35803]
[null,"Bobby Miller","California",35,79493]
[null,"Julia Davis","Texas",30,62256]
[null,"Harry Reed","Texas",32,53501]
[null,"Kelly Lewis","Nevada",25,40421]
[null,"Susan Sanders","Nevada",24,79089]
[null,"Brad Riley","Alabama",32,47159]
[null,"Julie Hughes","California",35,36250]
[null,"Shirley Ward","Texas",30,38980]
[null,"Ann Michell","California",26,60880]

{"sheet":"resize","index":8,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Resizing Range of a Table"]
[]
[null,"Seller","Region","Date","Sales Amount"]
[null,"Alex","East","2021-12-18",1500]
[null,"Paul","North","2021-08-14",2000]
[null,"John","North","2021-01-15",1800]
[null,"Lily","East","2021-04-12",2100]
[null,"Sam","West","2021-09-10",2600]
[null,"Tom","West","2021-04-21",2700]
[null,"Smith","North","2021-06-24",1700]
[null,"Peter","East","2021-09-25",2200]
[null,"Emily","West","2021-07-13",2300]

{"sheet":"without header","index":9,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Selecting Data from a Table Without Column Header"]
[]
[null,"Seller","Region","Date","Sales Amount"]
[null,"Alex","East","2021-12-18",1500]
[null,"Paul","North","2021-08-14",2000]
[null,"John","North","2021-01-15",1800]
[null,"Lily","East","2021-04-12",2100]
[null,"Sam","West","2021-09-10",2600]
[null,"Tom","West","2021-04-21",2700]
[null,"Smith","North","2021-06-24",1700]
[null,"Peter","East","2021-09-25",2200]
[null,"Emily","West","2021-07-13",2300]

{"sheet":"select header","index":10,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Selecting a Column Header"]
[]
[null,"Seller","Region","Date","Sales Amount"]
[null,"Alex","East","2021-12-18",1500]
[null,"Paul","North","2021-08-14",2000]
[null,"John","North","2021-01-15",1800]
[null,"Lily","East","2021-04-12",2100]
[null,"Sam","West","2021-09-10",2600]
[null,"Tom","West","2021-04-21",2700]
[null,"Smith","North","2021-06-24",1700]
[null,"Peter","East","2021-09-25",2200]
[null,"Emily","West","2021-07-13",2300]

{"sheet":"select row","index":11,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Selecting Entire Row"]
[]
[null,"Seller","Region","Date","Sales Amount"]
[null,"Alex","East","2021-12-18",1500]
[null,"Paul","North","2021-08-14",2000]
[null,"John","North","2021-01-15",1800]
[null,"Lily","East","2021-04-12",2100]
[null,"Sam","West","2021-09-10",2600]
[null,"Tom","West","2021-04-21",2700]
[null,"Smith","North","2021-06-24",1700]
[null,"Peter","East","2021-09-25",2200]
[null,"Emily","West","2021-07-13",2300]

{"sheet":"delete row and columns (2)","index":12,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Deleting Rows and Columns from a Table"]
[]
[null,"Seller","Region","Date","Sales Amount"]
[null,"Alex","East","2021-12-18",1500]
[null,"Paul","North","2021-08-14",2000]
[null,"John","North","2021-01-15",1800]
[null,"Lily","East","2021-04-12",2100]
[null,"Sam","West","2021-09-10",2600]
[null,"Tom","West","2021-04-21",2700]
[null,"Smith","North","2021-06-24",1700]
[null,"Peter","East","2021-09-25",2200]
[null,"Emily","West","2021-07-13",2300]

{"sheet":"output","index":13,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Deleting Rows and Columns from a Table"]
[]
[null,"Seller","Date","Sales Amount"]
[null,"Alex","2021-12-18",1500]
[null,"John","2021-01-15",1800]
[null,"Lily","2021-04-12",2100]
[null,"Sam","2021-09-10",2600]
[null,"Tom","2021-04-21",2700]
[null,"Smith","2021-06-24",1700]
[null,"Peter","2021-09-25",2200]
[null,"Emily","2021-07-13",2300]

{"sheet":"delete table","index":14,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Deleting a Table"]
[]
[null,"Seller","Region","Date","Sales Amount"]
[null,"Alex","East","2021-12-18",1500]
[null,"Paul","North","2021-08-14",2000]
[null,"John","North","2021-01-15",1800]
[null,"Lily","East","2021-04-12",2100]
[null,"Sam","West","2021-09-10",2600]
[null,"Tom","West","2021-04-21",2700]
[null,"Smith","North","2021-06-24",1700]
[null,"Peter","East","2021-09-25",2200]
[null,"Emily","West","2021-07-13",2300]

{"sheet":"normal range (2)","index":15,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Converting a Table to Normal Range"]
[]
[null,"Seller","Region","Date","Sales Amount"]
[null,"Alex","East","2021-12-18",1500]
[null,"Paul","North","2021-08-14",2000]
[null,"John","North","2021-01-15",1800]
[null,"Lily","East","2021-04-12",2100]
[null,"Sam","West","2021-09-10",2600]
[null,"Tom","West","2021-04-21",2700]
[null,"Smith","North","2021-06-24",1700]
[null,"Peter","East","2021-09-25",2200]
[null,"Emily","West","2021-07-13",2300]

{"sheet":" output 2","index":16,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Converting a Table to Normal Range"]
[]
[null,"Seller","Region","Date","Sales Amount"]
[null,"Alex","East","2021-12-18",1500]
[null,"Paul","North","2021-08-14",2000]
[null,"John","North","2021-01-15",1800]
[null,"Lily","East","2021-04-12",2100]
[null,"Sam","West","2021-09-10",2600]
[null,"Tom","West","2021-04-21",2700]
[null,"Smith","North","2021-06-24",1700]
[null,"Peter","East","2021-09-25",2200]
[null,"Emily","West","2021-07-13",2300]

{"sheet":"change table style (2)","index":17,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Changing Table Style"]
[]
[null,"Seller","Region","Date","Sales Amount"]
[null,"Alex","East","2021-12-18",1500]
[null,"Paul","North","2021-08-14",2000]
[null,"John","North","2021-01-15",1800]
[null,"Lily","East","2021-04-12",2100]
[null,"Sam","West","2021-09-10",2600]
[null,"Tom","West","2021-04-21",2700]
[null,"Smith","North","2021-06-24",1700]
[null,"Peter","East","2021-09-25",2200]
[null,"Emily","West","2021-07-13",2300]

{"sheet":"Output 3","index":18,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Changing Table Style"]
[]
[null,"Seller","Region","Date","Sales Amount"]
[null,"Alex","East","2021-12-18",1500]
[null,"Paul","North","2021-08-14",2000]
[null,"John","North","2021-01-15",1800]
[null,"Lily","East","2021-04-12",2100]
[null,"Sam","West","2021-09-10",2600]
[null,"Tom","West","2021-04-21",2700]
[null,"Smith","North","2021-06-24",1700]
[null,"Peter","East","2021-09-25",2200]
[null,"Emily","West","2021-07-13",2300]

{"sheet":"default style","index":19,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Setting Default Table Style"]
[]
[null,"Seller","Region","Date","Sales Amount"]
[null,"Alex","East","2021-12-18",1500]
[null,"Paul","North","2021-08-14",2000]
[null,"John","North","2021-01-15",1800]
[null,"Lily","East","2021-04-12",2100]
[null,"Sam","West","2021-09-10",2600]
[null,"Tom","West","2021-04-21",2700]
[null,"Smith","North","2021-06-24",1700]
[null,"Peter","East","2021-09-25",2200]
[null,"Emily","West","2021-07-13",2300]

{"sheet":"loop","index":20,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Looping Through All Cells in Table"]
[]
[null,"Seller","Region","Date","Sales Amount"]
[null,"Alex","East","2021-12-18",1500]
[null,"Paul","North","2021-08-14",2000]
[null,"John","North","2021-01-15",1800]
[null,"Lily","East","2021-04-12",2100]
[null,"Sam","West","2021-09-10",2600]
[null,"Tom","West","2021-04-21",2700]
[null,"Smith","North","2021-06-24",1700]
[null,"Peter","East","2021-09-25",2200]
[null,"Emily","West","2021-07-13",2300]

{"sheet":"table header visible","index":21,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Making Table Header Visible"]
[]
[null,"Seller","Region","Date","Sales Amount"]
[null,"Alex","East","2021-12-18",1500]
[null,"Paul","North","2021-08-14",2000]
[null,"John","North","2021-01-15",1800]
[null,"Lily","East","2021-04-12",2100]
[null,"Sam","West","2021-09-10",2600]
[null,"Tom","West","2021-04-21",2700]
[null,"Smith","North","2021-06-24",1700]
[null,"Peter","East","2021-09-25",2200]
[null,"Emily","West","2021-07-13",2300]

{"sheet":"count rows and colums","index":22,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Counting Rows and Columns"]
[]
[null,"Seller","Region","Date","Sales Amount"]
[null,"Alex","East","2021-12-18",1500]
[null,"Paul","North","2021-08-14",2000]
[null,"John","North","2021-01-15",1800]
[null,"Lily","East","2021-04-12",2100]
[null,"Sam","West","2021-09-10",2600]
[null,"Tom","West","2021-04-21",2700]
[null,"Smith","North","2021-06-24",1700]
[null,"Peter","East","2021-09-25",2200]
[null,"Emily","West","2021-07-13",2300]

{"sheet":"check","index":23,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Checking If There Is Any Table in Worksheet"]
[]
[null,"Seller","Region","Date","Sales Amount"]
[null,"Alex","East","2021-12-18",1500]
[null,"Paul","North","2021-08-14",2000]
[null,"John","North","2021-01-15",1800]
[null,"Lily","East","2021-04-12",2100]
[null,"Sam","West","2021-09-10",2600]
[null,"Tom","West","2021-04-21",2700]
[null,"Smith","North","2021-06-24",1700]
[null,"Peter","East","2021-09-25",2200]
[null,"Emily","West","2021-07-13",2300]

{"sheet":"copying","index":24,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Copying an Entire Table"]
[]
[null,"Seller","Region","Date","Sales Amount"]
[null,"Alex","East","2021-12-18",1500]
[null,"Paul","North","2021-08-14",2000]
[null,"John","North","2021-01-15",1800]
[null,"Lily","East","2021-04-12",2100]
[null,"Sam","West","2021-09-10",2600]
[null,"Tom","West","2021-04-21",2700]
[null,"Smith","North","2021-06-24",1700]
[null,"Peter","East","2021-09-25",2200]
[null,"Emily","West","2021-07-13",2300]

{"sheet":"Sheet8 (2)","index":25,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Filtering a Table "]
[]
[null,"Name","From","Age","Income (Year)"]
[null,"Lisa Wilson","Alabama",28,35803]
[null,"Bobby Miller","California",35,79493]
[null,"Julia Davis","Texas",30,62256]
[null,"Harry Reed","Texas",32,53501]
[null,"Kelly Lewis","Nevada",25,40421]
[null,"Susan Sanders","Nevada",24,79089]
[null,"Brad Riley","Alabama",32,47159]
[null,"Julie Hughes","California",35,36250]
[null,"Shirley Ward","Texas",30,38980]
[null,"Ann Michell","California",26,60880]

{"sheet":"Sheet8 (3)","index":26,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Filtering a Table "]
[]
[null,"Name","From","Age","Income (Year)"]
[null,"Lisa Wilson","Alabama",28,35803]
[null,"Bobby Miller","California",35,79493]
[null,"Julia Davis","Texas",30,62256]
[null,"Harry Reed","Texas",32,53501]
[null,"Kelly Lewis","Nevada",25,40421]
[null,"Susan Sanders","Nevada",24,79089]
[null,"Brad Riley","Alabama",32,47159]
[null,"Julie Hughes","California",35,36250]
[null,"Shirley Ward","Texas",30,38980]
[null,"Ann Michell","California",26,60880]