{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Dataset","Overview","SEQUENCE and COUNTA","vba","Table","Fill Handle","Fill Series","ROW Function","COUNTA Function","Adding Number","SUBTOTAL","OFFSET","Sheet13"],"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":"Dataset","index":0,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Automatically Number Rows in Excel"]
[]
[null,"Employee Name","Basic Salary","Increment","New Salary"]
[null,"John",1200,100,{"$f":"C5+D5","v":1300}]
[null,"Clerk",1280,120,{"$f":"C6+D6","v":1400}]
[null,"Tom",1400,150,1550]
[null,"Betty",1483,110,1593]
[null,"Silvia",1500,156,1656]
[null,"Brad",1790,180,1970]
[null,"Jane",1597,170,1767]
[null,"Julia",1850,156,2006]
[null,"Joly",1900,178,2078]
[null,"Rocky",2000,163,2163]
[null,"Cane",2200,140,2340]
[null,"Robert",2230,130,2360]

{"sheet":"Overview","index":1,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Automatically Adding Row Number"]
[]
[null,"Serial","Employee Name","Basic Salary","Increment","New Salary"]
[null,1,"John",1200,100,{"$f":"D5+E5","v":1300}]
[null,2,"Clerk",1280,120,{"$f":"D6+E6","v":1400}]
[null,3,"Tom",1400,150,1550]
[null,4,"Betty",1483,110,1593]
[null,5,"Silvia",1500,156,1656]
[null,6,"Brad",1790,180,1970]
[null,7,"Jane",1597,170,1767]
[null,8,"Julia",1850,156,2006]
[null,9,"Joly",1900,178,2078]
[null,10,"Rocky",2000,163,2163]
[null,11,"Cane",2200,140,2340]
[null,12,"Robert",2230,130,2360]

{"sheet":"SEQUENCE and COUNTA","index":2,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using SEQUENCE and COUNTA Function"]
[]
[null,"Serial","Employee Name","Basic Salary","Increment","New Salary"]
[null,{"$f":"_xlfn.SEQUENCE(COUNTA(C:C)-1)","v":1},"John",1200,100,{"$f":"D5+E5","v":1300}]
[null,2,"Clerk",1280,120,{"$f":"D6+E6","v":1400}]
[null,3,"Tom",1400,150,1550]
[null,4,"Betty",1483,110,1593]
[null,5,"Silvia",1500,156,1656]
[null,6,"Brad",1790,180,1970]
[null,7,"Jane",1597,170,1767]
[null,8,"Julia",1850,156,2006]
[null,9,"Joly",1900,178,2078]
[null,10,"Rocky",2000,163,2163]
[null,11,"Cane",2200,140,2340]
[null,12,"Robert",2230,130,2360]
[null,13,"Steve"]

{"sheet":"vba","index":3,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Applying VBA"]
[]
[null,"Serial","Employee Name","Basic Salary","Increment","New Salary"]
[null,1,"John",1200,100,{"$f":"D5+E5","v":1300}]
[null,2,"Clerk",1280,120,{"$f":"D6+E6","v":1400}]
[null,3,"Tom",1400,150,1550]
[null,4,"Betty",1483,110,1593]
[null,5,"Silvia",1500,156,1656]
[null,6,"Brad",1790,180,1970]
[null,7,"Jane",1597,170,1767]
[null,8,"Julia",1850,156,2006]
[null,9,"Joly",1900,178,2078]
[null,10,"Rocky",2000,163,2163]
[null,11,"Cane",2200,140,2340]
[null,12,"Robert",2230,130,2360]

{"sheet":"Table","index":4,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Inserting Table"]
[]
[null,"Serial","Employee Name","Basic Salary","Increment","New Salary"]
[null,{"$f":"ROW(Table2[])-4","v":1},"John",1200,100,{"$f":"D5+E5","v":1300}]
[null,2,"Clerk",1280,120,{"$f":"D6+E6","v":1400}]
[null,3,"Tom",1400,150,1550]
[null,4,"Betty",1483,110,1593]
[null,5,"Silvia",1500,156,1656]
[null,6,"Brad",1790,180,1970]
[null,7,"Jane",1597,170,1767]
[null,8,"Julia",1850,156,2006]
[null,9,"Joly",1900,178,2078]
[null,10,"Rocky",2000,163,2163]
[null,11,"Cane",2200,140,2340]
[null,12,"Robert",2230,130,2360]

{"sheet":"Fill Handle","index":5,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Fill Handle Tool"]
[]
[null,"Serial","Employee Name","Basic Salary","Increment","New Salary"]
[null,1,"John",1200,100,{"$f":"D5+E5","v":1300}]
[null,2,"Clerk",1280,120,{"$f":"D6+E6","v":1400}]
[null,3,"Tom",1400,150,1550]
[null,4,"Betty",1483,110,1593]
[null,5,"Silvia",1500,156,1656]
[null,6,"Brad",1790,180,1970]
[null,7,"Jane",1597,170,1767]
[null,8,"Julia",1850,156,2006]
[null,9,"Joly",1900,178,2078]
[null,10,"Rocky",2000,163,2163]
[null,11,"Cane",2200,140,2340]
[null,12,"Robert",2230,130,2360]

{"sheet":"Fill Series","index":6,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Use of Fill Series Feature"]
[]
[null,"Serial","Employee Name","Basic Salary","Increment","New Salary"]
[null,1,"John",1200,100,{"$f":"D5+E5","v":1300}]
[null,2,"Clerk",1280,120,{"$f":"D6+E6","v":1400}]
[null,3,"Tom",1400,150,1550]
[null,4,"Betty",1483,110,1593]
[null,5,"Silvia",1500,156,1656]
[null,6,"Brad",1790,180,1970]
[null,7,"Jane",1597,170,1767]
[null,8,"Julia",1850,156,2006]
[null,9,"Joly",1900,178,2078]
[null,10,"Rocky",2000,163,2163]
[null,11,"Cane",2200,140,2340]
[null,12,"Robert",2230,130,2360]

{"sheet":"ROW Function","index":7,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Applying ROW Function"]
[]
[null,"Serial","Employee Name","Basic Salary","Increment","New Salary"]
[null,{"$f":"ROW()-4","v":1},"John",1200,100,{"$f":"D5+E5","v":1300}]
[null,{"$f":"ROW()-4","v":2},"Clerk",1280,120,{"$f":"D6+E6","v":1400}]
[null,3,"Tom",1400,150,1550]
[null,4,"Betty",1483,110,1593]
[null,5,"Silvia",1500,156,1656]
[null,6,"Brad",1790,180,1970]
[null,7,"Jane",1597,170,1767]
[null,8,"Julia",1850,156,2006]
[null,9,"Joly",1900,178,2078]
[null,10,"Rocky",2000,163,2163]
[null,11,"Cane",2200,140,2340]
[null,12,"Robert",2230,130,2360]

{"sheet":"COUNTA Function","index":8,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Inserting COUNTA Function"]
[]
[null,"Serial","Employee Name","Basic Salary","Increment","New Salary"]
[null,{"$f":"COUNTA($C$5:C5)","v":1},"John",1200,100,{"$f":"D5+E5","v":1300}]
[null,{"$f":"COUNTA($C$5:C6)","v":2},"Clerk",1280,120,{"$f":"D6+E6","v":1400}]
[null,{"$f":"COUNTA($C$5:C7)","v":3},"Tom",1400,150,1550]
[null,{"$f":"COUNTA($C$5:C8)","v":4},"Betty",1483,110,1593]
[null,{"$f":"COUNTA($C$5:C9)","v":5},"Silvia",1500,156,1656]
[null,{"$f":"COUNTA($C$5:C10)","v":6},"Brad",1790,180,1970]
[null,{"$f":"COUNTA($C$5:C11)","v":7},"Jane",1597,170,1767]
[null,{"$f":"COUNTA($C$5:C12)","v":8},"Julia",1850,156,2006]
[null,{"$f":"COUNTA($C$5:C13)","v":9},"Joly",1900,178,2078]
[null,{"$f":"COUNTA($C$5:C14)","v":10},"Rocky",2000,163,2163]
[null,{"$f":"COUNTA($C$5:C15)","v":11},"Cane",2200,140,2340]
[null,{"$f":"COUNTA($C$5:C16)","v":12},"Robert",2230,130,2360]

{"sheet":"Adding Number","index":9,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Adding Number"]
[]
[null,"Serial","Employee Name","Basic Salary","Increment","New Salary"]
[null,{"$f":"COUNTA($C$5:C5)","v":1},"John",1200,100,{"$f":"D5+E5","v":1300}]
[null,{"$f":"B5+1","v":2},"Clerk",1280,120,{"$f":"D6+E6","v":1400}]
[null,{"$f":"B6+1","v":3},"Tom",1400,150,1550]
[null,4,"Betty",1483,110,1593]
[null,5,"Silvia",1500,156,1656]
[null,6,"Brad",1790,180,1970]
[null,7,"Jane",1597,170,1767]
[null,8,"Julia",1850,156,2006]
[null,9,"Joly",1900,178,2078]
[null,10,"Rocky",2000,163,2163]
[null,11,"Cane",2200,140,2340]
[null,12,"Robert",2230,130,2360]

{"sheet":"SUBTOTAL","index":10,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Applying SUBTOTAL Function"]
[]
[null,"Serial","Employee Name","Basic Salary","Increment","New Salary"]
[null,{"$f":"SUBTOTAL(3,$C$5:C5)","v":1},"John",1200,100,{"$f":"D5+E5","v":1300}]
[null,{"$f":"SUBTOTAL(3,$C$5:C6)","v":2},"Clerk",1280,120,{"$f":"D6+E6","v":1400}]
[null,{"$f":"SUBTOTAL(3,$C$5:C7)","v":3},"Tom",1400,150,1550]
[null,{"$f":"SUBTOTAL(3,$C$5:C8)","v":4},"Betty",1483,110,1593]
[null,{"$f":"SUBTOTAL(3,$C$5:C9)","v":5},"Silvia",1500,156,1656]
[null,{"$f":"SUBTOTAL(3,$C$5:C10)","v":6},"Brad",1790,180,1970]
[null,{"$f":"SUBTOTAL(3,$C$5:C11)","v":7},"Jane",1597,170,1767]
[null,{"$f":"SUBTOTAL(3,$C$5:C12)","v":8},"Julia",1850,156,2006]
[null,{"$f":"SUBTOTAL(3,$C$5:C13)","v":9},"Joly",1900,178,2078]
[null,{"$f":"SUBTOTAL(3,$C$5:C14)","v":10},"Rocky",2000,163,2163]
[null,{"$f":"SUBTOTAL(3,$C$5:C15)","v":11},"Cane",2200,140,2340]
[null,{"$f":"SUBTOTAL(3,$C$5:C16)","v":12},"Robert",2230,130,2360]

{"sheet":"OFFSET","index":11,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using OFFSET Function"]
[]
[null,null,"Employee Name","Basic Salary","Increment","New Salary"]
[null,{"$f":"OFFSET(B5,-1,0)+1","v":1},"John",1200,100,{"$f":"D5+E5","v":1300}]
[null,{"$f":"OFFSET(B6,-1,0)+1","v":2},"Clerk",1280,120,{"$f":"D6+E6","v":1400}]
[null,3,"Tom",1400,150,1550]
[null,4,"Betty",1483,110,1593]
[null,5,"Silvia",1500,156,1656]
[null,6,"Brad",1790,180,1970]
[null,7,"Jane",1597,170,1767]
[null,8,"Julia",1850,156,2006]
[null,9,"Joly",1900,178,2078]
[null,10,"Rocky",2000,163,2163]
[null,11,"Cane",2200,140,2340]
[null,12,"Robert",2230,130,2360]

{"sheet":"Sheet13","index":12,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Display or Hiding Fill Handle Tool"]
[]
[null,"Serial","Employee Name","Basic Salary","Increment","New Salary"]
[null,1,"John",1200,100,{"$f":"D5+E5","v":1300}]
[null,2,"Clerk",1280,120,{"$f":"D6+E6","v":1400}]
[null,3,"Tom",1400,150,1550]
[null,4,"Betty",1483,110,1593]
[null,5,"Silvia",1500,156,1656]
[null,6,"Brad",1790,180,1970]
[null,7,"Jane",1597,170,1767]
[null,8,"Julia",1850,156,2006]
[null,9,"Joly",1900,178,2078]
[null,10,"Rocky",2000,163,2163]
[null,11,"Cane",2200,140,2340]
[null,12,"Robert",2230,130,2360]