{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Welcome","Main","1"],"not_rendered":{"images":4,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Welcome","index":0,"n_rows":27,"n_cols":5,"rows_kept":27}
["Excel","is","a","fun","tool"]
[]
["This program requires macro to work, so do enable it to start using."]
[]
["1. The basics of keying a formula is to start with an \"equal\" sign!"]
[" ="]
[]
["2. You should then key in the formula name after the equal sign (SUM for eg.)"]
[" =SUM"]
[]
["3. An open parenthesis (or bracket) is then needed:"]
[" =SUM("]
[]
["4. You will then see a screen tip pop up.  Every formula has different number of arguments (i.e. your inputs for the formula).  If you don't know what to fill in, this is where I will help you with!"]
[]
[]
[]
[]
[]
["5. After the open parenthesis, you are suppose to key in relevant information to make your formula work.  For simplicity, use cells A1:E1 if you don't know what to fill in.  If there is 1 argument, put"]
["A1.  If there's 2, put A1,B1.  And so on...  And last parenthesis (close bracket).  My guide will then explain to you what you are doing with the formula."]
[" =DAY(A1)"]
[" =COUNTIF(A1,B1)"]
[" =MATCH(A1,B1,C1)"]
[]
["Beware!  Some formulas like MATCH has an optional argument like you see above.  Optional arguments may have a default value.  It doesn't mean that you can leave it blank.  We'll get to that in the individual"]
["formula sheets.  So be sure to key in all the arguments even though if it's optional.  Click on the \"Let's Start\" button when you are ready!"]

{"sheet":"Main","index":1,"n_rows":5,"n_cols":4,"rows_kept":5}
["Content Page"]
[null,"Topic",null,"Arguments"]
[{"$f":"ROW()-2","v":1},{"$f":"INDIRECT(A3&\"!A3\")","v":"VLOOKUP"},{"$f":"HYPERLINK(\"#\"&A3&\"!A1\",\"Go\")","v":"Go"},4]
[{"$nulls":3},2]
[{"$nulls":3},3]

{"sheet":"1","index":2,"n_rows":24,"n_cols":16,"rows_kept":24}
["Excel","does",1000,"things!",{"$nulls":8},"Table 2"]
[{"$nulls":12},"Serial Num","Date Purchased","Cost","Selling Price"]
["VLOOKUP",{"$nulls":11},"165148X","2010-01-14",790,870]
["1. Your client ordered 5 items from you & gives you the serial numbers (Table 1 in A19:A23).  You are suppose to find the",{"$nulls":11},"171913F","2010-02-01",960,1320]
["selling price of those 5 items from your list of many items from column M:P (Table 2).",{"$nulls":11},"247899F","2010-02-23",670,780]
[{"$nulls":12},"250892J","2010-10-04",190,230]
["2. Always imagine how would you do it manually.  You must be able to find the serial numbers your client give you",{"$nulls":11},"367487D","2011-03-04",620,860]
["somewhere else in another list.  So you are supposed to find the serial numbers (blue cell in the table below) among the",{"$nulls":11},"368341A","2011-05-13",680,910]
["cells in green.  Once found, take the Selling Price in Purple.  Sounds simple?  Now you just have to translate them into a",{"$nulls":11},"390161C","2011-06-23",380,500]
["formula.",{"$nulls":11},"413442P","2011-08-21",660,850]
[{"$nulls":12},"421632R","2011-09-27",180,210]
["3. As seen from the picture below, VLOOKUP has 4 arguments.  As I mentioned, fill up all the arguments (inside yellow cell",{"$nulls":11},"429062O","2012-08-07",560,620]
["in B19).  If you DO NOT know what to fill in, simply use VLOOKUP(A1,B1,C1,D1) as suggested.  Use the guide to help you.",{"$nulls":11},"503022K","2012-08-17",220,250]
[{"$nulls":12},"541675N","2012-08-28",220,250]
[{"$nulls":12},"550593F","2013-08-04",750,950]
[{"$nulls":12},"602029N","2013-08-22",280,330]
["Table 1",{"$nulls":11},"620688B","2013-12-14",460,510]
["Serial Num","Selling Price",{"$nulls":10},"665482Z","2013-12-26",710,990]
["247899F",{"$nulls":11},"729989P","2014-02-10",500,600]
["429062O",{"$nulls":11},"734141F","2014-03-22",210,290]
["541675N",null," ",{"$nulls":9},"872587L","2014-05-21",570,650]
["602029N",{"$nulls":11},"877451M","2014-06-28",580,740]
["729989P",{"$nulls":11},"882626I","2014-10-03",100,120]
[{"$nulls":12},"906268V","2014-10-26",880,1130]