{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Filter feature","FILTER","IF","Find Command","SWITCH"," CHOOSE and MATCH","VBA","Paste","Automatically"],"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":"Filter feature","index":0,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,14]]}
[]
[null,"Apply Filter Feature",null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Salesman","Product","Net Sales",null,null,null,null,null,null,null,null,"Salesman","Product","Net Sales"]
[null,"Wilham","AC",10000,null,null,null,null,null,null,null,null,"Wilham","AC",10000]
[null,"Simon","TV",11500,null,null,null,null,null,null,null,null,"Simon","TV",11500]
[null,"Frank","AC",13500,null,null,null,null,null,null,null,null,"Frank","AC",13500]
[null,"Nathan","TV",17000,null,null,null,null,null,null,null,null,"Nathan","TV",17000]
[null,"Jaxson","AC",15000,null,null,null,null,null,null,null,null,"Jaxson","AC",15000]
[null,"Anthony","TV",12500,null,null,null,null,null,null,null,null,"Anthony","TV",12500]

{"sheet":"FILTER","index":1,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,14]]}
[]
[null,"Using FILTER Function",null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Salesman","Product","Net Sales",null,null,null,null,null,null,null,null,"Salesman","Product","Net Sales"]
[null,"Wilham","AC",10000,null,null,null,null,null,null,null,null,"Wilham","AC",10000]
[null,"Simon","TV",11500,null,null,null,null,null,null,null,null,"Simon","TV",11500]
[null,"Frank","AC",13500,null,null,null,null,null,null,null,null,"Frank","AC",13500]
[null,"Nathan","TV",17000,null,null,null,null,null,null,null,null,"Nathan","TV",17000]
[null,"Jaxson","AC",15000,null,null,null,null,null,null,null,null,"Jaxson","AC",15000]
[null,"Anthony","TV",12500,null,null,null,null,null,null,null,null,"Anthony","TV",12500]
[]
[null,{"$f":"_xlfn._xlws.FILTER(B5:D10,C5:C10=C5)","v":"Wilham"},"AC",10000]
[null,"Frank","AC",13500]
[null,"Jaxson","AC",15000]

{"sheet":"IF","index":2,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,14]]}
[]
[null,"Insert IF Function",null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Salesman","Product","Net Sales",null,null,null,null,null,null,null,null,"Salesman","Product","Net Sales"]
[null,"Wilham","AC",10000,null,null,null,null,null,null,null,null,"Wilham","AC",10000]
[null,"Simon","TV",11500,null,null,null,null,null,null,null,null,"Simon","TV",11500]
[null,"Frank","AC",13500,null,null,null,null,null,null,null,null,"Frank","AC",13500]
[null,"Nathan","TV",17000,null,null,null,null,null,null,null,null,"Nathan","TV",17000]
[null,"Jaxson","AC",15000,null,null,null,null,null,null,null,null,"Jaxson","AC",15000]
[null,"Anthony","TV",12500,null,null,null,null,null,null,null,null,"Anthony","TV",12500]
[]
[null,{"$f":"IF($C5=\"AC\",B5,\"\")","v":"Wilham"},{"$f":"IF($C5=\"AC\",C5,\"\")","v":"AC"},10000]
[null,{"$f":"IF($C6=\"AC\",B6,\"\")","v":""},"",""]
[null,{"$f":"IF($C7=\"AC\",B7,\"\")","v":"Frank"},"AC",13500]
[null,{"$f":"IF($C8=\"AC\",B8,\"\")","v":""},{"$f":"IF($C8=\"AC\",C8,\"\")","v":""},""]
[null,{"$f":"IF($C9=\"AC\",B9,\"\")","v":"Jaxson"},"AC",15000]

{"sheet":"Find Command","index":3,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,14]]}
[]
[null,"Using Find Command",null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Salesman","Product","Net Sales",null,null,null,null,null,null,null,null,"Salesman","Product","Net Sales"]
[null,"Wilham","AC",10000,null,null,null,null,null,null,null,null,"Wilham","AC",10000]
[null,"Simon","TV",11500,null,null,null,null,null,null,null,null,"Simon","TV",11500]
[null,"Frank","AC",13500,null,null,null,null,null,null,null,null,"Frank","AC",13500]
[null,"Nathan","TV",17000,null,null,null,null,null,null,null,null,"Nathan","TV",17000]
[null,"Jaxson","AC",15000,null,null,null,null,null,null,null,null,"Jaxson","AC",15000]
[null,"Anthony","TV",12500,null,null,null,null,null,null,null,null,"Anthony","TV",12500]

{"sheet":"SWITCH","index":4,"n_rows":17,"n_cols":15,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,14]]}
[]
[null,"Input SWITCH Function",null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Salesman","Product","Net Sales",null,null,null,null,null,null,null,null,"Salesman","Product","Net Sales"]
[null,"Wilham","AC",10000,null,null,null,null,null,null,null,null,"Wilham","AC",10000]
[null,"Simon","TV",11500,null,null,null,null,null,null,null,null,"Simon","TV",11500]
[null,"Frank","AC",13500,null,null,null,null,null,null,null,null,"Frank","AC",13500]
[null,"Nathan","TV",17000,null,null,null,null,null,null,null,null,"Nathan","TV",17000]
[null,"Jaxson","AC",15000,null,null,null,null,null,null,null,null,"Jaxson","AC",15000]
[null,"Anthony","TV",12500,null,null,null,null,null,null,null,null,"Anthony","TV",12500]
[]
[null,{"$f":"_xlfn.SWITCH(TRUE,$D5>10000,B5,\"\")","v":""},{"$f":"_xlfn.SWITCH(TRUE,$D5>10000,C5,\"\")","v":""},{"$f":"_xlfn.SWITCH(TRUE,$D5>10000,D5,\"\")","v":""}]
[null,{"$f":"_xlfn.SWITCH(TRUE,$D6>10000,B6,\"\")","v":"Simon"},{"$f":"_xlfn.SWITCH(TRUE,$D6>10000,C6,\"\")","v":"TV"},{"$f":"_xlfn.SWITCH(TRUE,$D6>10000,D6,\"\")","v":11500}]
[null,{"$f":"_xlfn.SWITCH(TRUE,$D7>10000,B7,\"\")","v":"Frank"},{"$f":"_xlfn.SWITCH(TRUE,$D7>10000,C7,\"\")","v":"AC"},{"$f":"_xlfn.SWITCH(TRUE,$D7>10000,D7,\"\")","v":13500}]
[null,{"$f":"_xlfn.SWITCH(TRUE,$D8>10000,B8,\"\")","v":"Nathan"},{"$f":"_xlfn.SWITCH(TRUE,$D8>10000,C8,\"\")","v":"TV"},{"$f":"_xlfn.SWITCH(TRUE,$D8>10000,D8,\"\")","v":17000}]
[null,{"$f":"_xlfn.SWITCH(TRUE,$D9>10000,B9,\"\")","v":"Jaxson"},{"$f":"_xlfn.SWITCH(TRUE,$D9>10000,C9,\"\")","v":"AC"},{"$f":"_xlfn.SWITCH(TRUE,$D9>10000,D9,\"\")","v":15000}]
[null,{"$f":"_xlfn.SWITCH(TRUE,$D10>10000,B10,\"\")","v":"Anthony"},{"$f":"_xlfn.SWITCH(TRUE,$D10>10000,C10,\"\")","v":"TV"},{"$f":"_xlfn.SWITCH(TRUE,$D10>10000,D10,\"\")","v":12500}]

{"sheet":" CHOOSE and MATCH","index":5,"n_rows":17,"n_cols":15,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,14]]}
[]
[null,"Combine CHOOSE and MATCH Functions",null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Salesman","Product","Net Sales",null,null,null,null,null,null,null,null,"Salesman","Product","Net Sales"]
[null,"Wilham","AC",10000,null,null,null,null,null,null,null,null,"Wilham","AC",10000]
[null,"Simon","TV",11500,null,null,null,null,null,null,null,null,"Simon","TV",11500]
[null,"Frank","AC",13500,null,null,null,null,null,null,null,null,"Frank","AC",13500]
[null,"Nathan","TV",17000,null,null,null,null,null,null,null,null,"Nathan","TV",17000]
[null,"Jaxson","AC",15000,null,null,null,null,null,null,null,null,"Jaxson","AC",15000]
[null,"Anthony","TV",12500,null,null,null,null,null,null,null,null,"Anthony","TV",12500]
[]
[null,{"$f":"CHOOSE(MATCH($C5,$C$5:$C$10,0),B5,\"\")","v":"Wilham"},{"$f":"CHOOSE(MATCH($C5,$C$5:$C$10,0),C5,\"\")","v":"AC"},10000]
[null,{"$f":"CHOOSE(MATCH($C6,$C$5:$C$10,0),B6,\"\")","v":""},"",""]
[null,{"$f":"CHOOSE(MATCH($C7,$C$5:$C$10,0),B7,\"\")","v":"Frank"},"AC",13500]
[null,{"$f":"CHOOSE(MATCH($C8,$C$5:$C$10,0),B8,\"\")","v":""},"",""]
[null,{"$f":"CHOOSE(MATCH($C9,$C$5:$C$10,0),B9,\"\")","v":"Jaxson"},"AC",15000]
[null,{"$f":"CHOOSE(MATCH($C10,$C$5:$C$10,0),B10,\"\")","v":""},"",""]

{"sheet":"VBA","index":6,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,14]]}
[]
[null,"Run Excel VBA",null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Salesman","Product","Net Sales",null,null,null,null,null,null,null,null,"Salesman","Product","Net Sales"]
[null,"Wilham","AC",10000,null,null,null,null,null,null,null,null,"Wilham","AC",10000]
[null,"Simon","TV",11500,null,null,null,null,null,null,null,null,"Simon","TV",11500]
[null,"Frank","AC",13500,null,null,null,null,null,null,null,null,"Frank","AC",13500]
[null,"Nathan","TV",17000,null,null,null,null,null,null,null,null,"Nathan","TV",17000]
[null,"Jaxson","AC",15000,null,null,null,null,null,null,null,null,"Jaxson","AC",15000]
[null,"Anthony","TV",12500,null,null,null,null,null,null,null,null,"Anthony","TV",12500]

{"sheet":"Paste","index":7,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Simon","TV",11500]
[null,"Frank","AC",13500]
[null,"Nathan","TV",17000]
[null,"Jaxson","AC",15000]
[null,"Anthony","TV",12500]

{"sheet":"Automatically","index":8,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,14]]}
[]
[null,"Automatically Copying Cell Value",null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Salesman","Product","Net Sales",null,null,null,null,null,null,null,null,"Salesman","Product","Net Sales"]
[null,"Wilham","AC",10000,null,null,null,null,null,null,null,null,"Wilham","AC",10000]
[null,"Simon","TV",11500,null,null,null,null,null,null,null,null,"Simon","TV",11500]
[null,"Frank","AC",13500,null,null,null,null,null,null,null,null,"Frank","AC",13500]
[null,"Nathan","TV",17000,null,null,null,null,null,null,null,null,"Nathan","TV",17000]
[null,"Jaxson","AC",15000,null,null,null,null,null,null,null,null,"Jaxson","AC",15000]
[null,"Anthony","TV",12500,null,null,null,null,null,null,null,null,"Anthony","TV",12500]
[]
[null,{"$f":"B5","v":"Wilham"},{"$f":"C5","v":"AC"},10000]