{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Overview","SUM","Paste Special","Arithmetic","AutoSum","Cell Ref","CONCATENATE","Flash Fill","VBA","Text","Digit","Special Character","Time","Date","Practice Section"],"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":"Overview","index":0,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5],[11,1,11,4]]}
[]
[null,"Excel Add to a Cell Value"]
[]
[null,"Sales Rep","Product ID","Units","Unit Price","Total Sales"]
[null,"John","A1245X",500,25,{"$f":"D5*E5","v":12500}]
[null,"Morgan","V4562Y",455,31,{"$f":"D6*E6","v":14105}]
[null,"Anderson","R7895S",345,23,7935]
[null,"Robert","W2365H",879,30,26370]
[null,"Jim","D4251L",290,40,11600]
[null,"Jill","Q2456Y",580,37,21460]
[null,"David","K2354L",650,29,18850]
[null,"Total Sales",null,null,null,{"$f":"SUM(F5:F11)","v":112820}]

{"sheet":"SUM","index":1,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5],[11,1,11,4]]}
[]
[null,"Using SUM Function"]
[]
[null,"Sales Rep","Product ID","Units","Unit Price","Total Sales"]
[null,"John","A1245X",500,25,{"$f":"D5*E5","v":12500}]
[null,"Morgan","V4562Y",455,31,{"$f":"D6*E6","v":14105}]
[null,"Anderson","R7895S",345,23,7935]
[null,"Robert","W2365H",879,30,26370]
[null,"Jim","D4251L",290,40,11600]
[null,"Jill","Q2456Y",580,37,21460]
[null,"David","K2354L",650,29,18850]
[null,"Total Sales",null,null,null,{"$f":"SUM(F5:F11)","v":112820}]

{"sheet":"Paste Special","index":2,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Applying Paste Special Feature"]
[]
[null,"Sales Rep","Product ID","Units","Unit Price","Total Sales","Add Units"]
[null,"John","A1245X",515,25,{"$f":"D5*E5","v":12875},15]
[null,"Morgan","V4562Y",470,31,14570]
[null,"Anderson","R7895S",360,23,8280]
[null,"Robert","W2365H",894,30,26820]
[null,"Jim","D4251L",305,40,12200]
[null,"Jill","Q2456Y",595,37,22015]
[null,"David","K2354L",665,29,19285]

{"sheet":"Arithmetic","index":3,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using Arithmetic Operation"]
[]
[null,"Sales Rep","Product ID","Units","Unit Price","Total Sales","Add Values"]
[null,"John","A1245X",515,25,{"$f":"D5*E5","v":12875},{"$f":"D5+15","v":530}]
[null,"Morgan","V4562Y",470,31,14570,{"$f":"D6+15","v":485}]
[null,"Anderson","R7895S",360,23,8280,375]
[null,"Robert","W2365H",894,30,26820,909]
[null,"Jim","D4251L",305,40,12200,320]
[null,"Jill","Q2456Y",595,37,22015,610]
[null,"David","K2354L",665,29,19285,680]

{"sheet":"AutoSum","index":4,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5],[11,1,11,4]]}
[]
[null,"Using AutoSum Feature"]
[]
[null,"Sales Rep","Product ID","Units","Unit Price","Total Sales"]
[null,"John","A1245X",500,25,{"$f":"D5*E5","v":12500}]
[null,"Morgan","V4562Y",455,31,{"$f":"D6*E6","v":14105}]
[null,"Anderson","R7895S",345,23,7935]
[null,"Robert","W2365H",879,30,26370]
[null,"Jim","D4251L",290,40,11600]
[null,"Jill","Q2456Y",580,37,21460]
[null,"David","K2354L",650,29,18850]
[null,"Total Sales",null,null,null,{"$f":"SUM(F5:F11)","v":112820}]

{"sheet":"Cell Ref","index":5,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Cell References"]
[]
[null,"Sales Rep","Product ID","Units","Unit Price","Total Sales"]
[null,"John","A1245X",515,25,{"$f":"D5*E5","v":12875}]
[null,"Morgan","V4562Y",470,31,{"$f":"D6*E6","v":14570}]
[null,"Anderson","R7895S",360,23,8280]
[null,"Robert","W2365H",894,30,26820]
[null,"Jim","D4251L",305,40,12200]
[null,"Jill","Q2456Y",595,37,22015]
[null,"David","K2354L",665,29,19285]

{"sheet":"CONCATENATE","index":6,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Applying CONCATENATE Function"]
[]
[null,"Sales Rep","Product ID","Units","Unit Price","Total Sales","Add Values"]
[null,"John","A1245X",515,25,{"$f":"D5*E5","v":12875},{"$f":"CONCATENATE(C5, \" sold by \", B5,\".\")","v":"A1245X sold by John."}]
[null,"Morgan","V4562Y",470,31,14570,{"$f":"CONCATENATE(C6, \" sold by \", B6,\".\")","v":"V4562Y sold by Morgan."}]
[null,"Anderson","R7895S",360,23,8280,"R7895S sold by Anderson."]
[null,"Robert","W2365H",894,30,26820,"W2365H sold by Robert."]
[null,"Jim","D4251L",305,40,12200,"D4251L sold by Jim."]
[null,"Jill","Q2456Y",595,37,22015,"Q2456Y sold by Jill."]
[null,"David","K2354L",665,29,19285,"K2354L sold by David."]

{"sheet":"Flash Fill","index":7,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using Flash Fill Feature"]
[]
[null,"Sales Rep","Product ID","Units","Unit Price","Total Sales","Add Values"]
[null,"John","A1245X",515,25,{"$f":"D5*E5","v":12875},"Total Sales: $12,875.00"]
[null,"Morgan","V4562Y",470,31,14570,"Total Sales: $14,570.00"]
[null,"Anderson","R7895S",360,23,8280,"Total Sales: $8,280.00"]
[null,"Robert","W2365H",894,30,26820,"Total Sales: $26,820.00"]
[null,"Jim","D4251L",305,40,12200,"Total Sales: $12,200.00"]
[null,"Jill","Q2456Y",595,37,22015,"Total Sales: $22,015.00"]
[null,"David","K2354L",665,29,19285,"Total Sales: $19,285.00"]

{"sheet":"VBA","index":8,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Run an Excel VBA Code"]
[]
[null,"Sales Rep","Units","Unit Price","Total Sales","Add Values"]
[null,"John",515,25,{"$f":"C5*D5","v":12875},"Total Sales of John is: 12875"]
[null,"Morgan",470,31,14570,"Total Sales of Morgan is: 14570"]
[null,"Anderson",360,23,8280,"Total Sales of Anderson is: 8280"]
[null,"Robert",894,30,26820,"Total Sales of Robert is: 26820"]
[null,"Jim",305,40,12200,"Total Sales of Jim is: 12200"]
[null,"Jill",595,37,22015,"Total Sales of Jill is: 22015"]
[null,"David",665,29,19285,"Total Sales of David is: 19285"]

{"sheet":"Text","index":9,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using Ampersand Symbol"]
[]
[null,"Sales Rep","Product ID","Units","Unit Price","Total Sales","Add Text"]
[null,"John","A1245X",515,25,{"$f":"D5*E5","v":12875},{"$f":"\"Total Sales of \"&B5& \" is \" &E5","v":"Total Sales of John is 25"}]
[null,"Morgan","V4562Y",470,31,14570,{"$f":"\"Total Sales of \"&B6& \" is \" &E6","v":"Total Sales of Morgan is 31"}]
[null,"Anderson","R7895S",360,23,8280,"Total Sales of Anderson is 23"]
[null,"Robert","W2365H",894,30,26820,"Total Sales of Robert is 30"]
[null,"Jim","D4251L",305,40,12200,"Total Sales of Jim is 40"]
[null,"Jill","Q2456Y",595,37,22015,"Total Sales of Jill is 37"]
[null,"David","K2354L",665,29,19285,"Total Sales of David is 29"]

{"sheet":"Digit","index":10,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Applying NUMBERVALUE Function"]
[]
[null,"Sales Rep","Product ID","Units","Unit Price","Total Sales","Add Digits"]
[null,"John",145263,515,25,{"$f":"D5*E5","v":12875},{"$f":"_xlfn.NUMBERVALUE(C5&\"10\")","v":14526310}]
[null,"Morgan",123564,470,31,14570,{"$f":"_xlfn.NUMBERVALUE(C6&\"10\")","v":12356410}]
[null,"Anderson",852634,360,23,8280,85263410]
[null,"Robert",753159,894,30,26820,75315910]
[null,"Jim",985674,305,40,12200,98567410]
[null,"Jill",456325,595,37,22015,45632510]
[null,"David",563218,665,29,19285,56321810]

{"sheet":"Special Character","index":11,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using CHAR Function"]
[]
[null,"Sales Rep","Product ID","Units","Unit Price","Total Sales","Add Special Character"]
[null,"John","A1245X",515,25,{"$f":"D5*E5","v":12875},{"$f":"C5&CHAR(174)","v":"A1245X®"}]
[null,"Morgan","V4562Y",470,31,14570,{"$f":"C6&CHAR(174)","v":"V4562Y®"}]
[null,"Anderson","R7895S",360,23,8280,"R7895S®"]
[null,"Robert","W2365H",894,30,26820,"W2365H®"]
[null,"Jim","D4251L",305,40,12200,"D4251L®"]
[null,"Jill","Q2456Y",595,37,22015,"Q2456Y®"]
[null,"David","K2354L",665,29,19285,"K2354L®"]

{"sheet":"Time","index":12,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Applying TIME Function"]
[]
[null,"Sales Rep","Product ID","Working Hours","Units","Unit Price","Total Sales","Add Time"]
[null,"John",145263,"07:10:00",515,25,{"$f":"E5*F5","v":12875},{"$f":"D5+TIME(1,0,0)","v":"08:10:00"}]
[null,"Morgan",123564,"07:55:00",470,31,14570,{"$f":"D6+TIME(1,0,0)","v":"08:55:00"}]
[null,"Anderson",852634,"07:50:00",360,23,8280,"08:50:00"]
[null,"Robert",753159,"08:10:00",894,30,26820,"09:10:00"]
[null,"Jim",985674,"07:30:00",305,40,12200,"08:30:00"]
[null,"Jill",456325,"08:05:00",595,37,22015,"09:05:00"]
[null,"David",563218,"06:55:00",665,29,19285,"07:55:00"]

{"sheet":"Date","index":13,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Using TEXT Function"]
[]
[null,"Sales Rep","Product ID","Start Working","Units","Unit Price","Total Sales","Add Date"]
[null,"John",145263,"2022-05-05",515,25,{"$f":"E5*F5","v":12875},{"$f":"TEXT(D5+5,\"dd/mm/yy\")","v":"10/05/22"}]
[null,"Morgan",123564,"2022-04-10",470,31,14570,{"$f":"TEXT(D6+5,\"dd/mm/yy\")","v":"15/04/22"}]
[null,"Anderson",852634,"2022-06-27",360,23,8280,"02/07/22"]
[null,"Robert",753159,"2022-08-05",894,30,26820,"10/08/22"]
[null,"Jim",985674,"2022-12-29",305,40,12200,"03/01/23"]
[null,"Jill",456325,"2023-01-10",595,37,22015,"15/01/23"]
[null,"David",563218,"2023-02-28",665,29,19285,"05/03/23"]

{"sheet":"Practice Section","index":14,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"<<  Try Yourself  >>"]
[]
[null,"Sales Rep","Product ID","Start Working","Units","Unit Price","Total Sales","Add Date"]
[null,"John",145263,"2022-05-05",515,25,{"$f":"E5*F5","v":12875},{"$f":"TEXT(D5+5,\"dd/mm/yy\")","v":"10/05/22"}]
[null,"Morgan",123564,"2022-04-10",470,31,14570,{"$f":"TEXT(D6+5,\"dd/mm/yy\")","v":"15/04/22"}]
[null,"Anderson",852634,"2022-06-27",360,23,8280,"02/07/22"]
[null,"Robert",753159,"2022-08-05",894,30,26820,"10/08/22"]
[null,"Jim",985674,"2022-12-29",305,40,12200,"03/01/23"]
[null,"Jill",456325,"2023-01-10",595,37,22015,"15/01/23"]
[null,"David",563218,"2023-02-28",665,29,19285,"05/03/23"]