{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Welcome","Lecture"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":7,"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":"Welcome","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Lecture","index":1,"n_rows":131,"n_cols":4,"rows_kept":131,"cut":false,"hidden":false,"merged":[]}
["Lecture","หลักสูตร Excel ฉบับแจ้งเกิด","Date"]
["ก้าวแรกสู่สังเวียน"]
[1,"Open Excel","2020-05-20"]
[2,"Excel Interface","2020-05-20"]
[3,"Quick Menu","2020-05-20"]
[4,"Worksheet and Cells","2020-05-20"]
[5,"Save","2020-05-20"]
[6,"Open Excel","2020-05-20"]
[7,"Short Cut","2020-05-20"]
[8,"Key Text","2020-05-20"]
[9,"Numeric","2020-05-20"]
[10,"Date","2020-05-20"]
[11,"Cells Reference, RANDBETWEEN, Mouse Wheel Zoom in Zoom Out","2020-05-20"]
[12,"Formula Intro, Add Formula","2020-05-20"]
[13,"Relative and Absolute, Copy Paste, Percent","2020-05-27"]
[14,"Calculation Order","2020-05-29"]
[15,"Function Sum Min Max Count","2020-05-29"]
[16,"Adjacent Cells Error","2020-05-29"]
[17,"AutoSum","2020-05-29"]
[18,"AutoSum Shortcut and Autofill","2020-06-02"]
[19,"Copy/Cut Paste, Move, Add Sheet","2020-06-02"]
[20,"Insert Row Columns, Formula will Auto Adjust","2020-06-02"]
[21,"Adjust Width and Heiht","2020-06-02"]
[22,"Hide Unhide  Show Heading","2020-06-02"]
[23,"Add Rename Move Copy Delete Worksheet","2020-06-02"]
[24,"Move Copy Create to another workbook","2020-06-02"]
[25,"Format Font BG and Border","2020-06-09"]
[26,"Percent","2020-06-09"]
[27,"Format Painter","2020-06-09"]
[28,"Merge Center","2020-06-10"]
[29,"Condition Format","2020-06-10"]
[30,"Image and Shape","2020-06-11"]
[31,"Smart Art","2020-06-11"]
[32,"Basic Chart","2020-06-15"]
[33,"Print Orient Margin Scale","2020-06-17"]
[34,"Pagelayout Header Footer Print Area","2020-06-17"]
[35,"Template","2020-06-17",{"$f":"COUNT(C3:C37)","v":35}]
["ท่องยุทธภพ"]
[36,"Sort Multi Sort Customs Sort, Move to required Tab by Double Click","2020-06-22"]
[37,"Filter","2020-06-22"]
[38,"Subtotal","2020-06-25"]
[39,"Table","2020-06-25"]
[40,"Ctrl+Shift Insert Copy, Condition Format, Find Duplicate and Remove Duplicate","2020-06-25"]
[41,"Database Functon - Dsum","2020-06-26"]
[42,"DAverage, DCount/DCountA (Date also number)","2020-06-29"]
[43,"Filter and Subtotal","2020-06-29"]
[44,"Data Validation","2020-07-02"]
[45,"Import Export Text","2020-07-08"]
[46,"Import from Access","2020-07-08"]
[47,"Pivot","2020-07-09"]
[48,"Pivot, Covert Date to Year/Month","2020-07-09"]
[49,"Pivot","2020-07-09"]
[50,"Pivot, Chart, Slicer","2020-07-09"]
[51,"Power Pivot","2020-07-14"]
[52,"Freeze Pane Group Print Title Print Direction","2020-07-14"]
[53,"Cal Across Sheet and Consolidate","2020-07-14",{"$f":"COUNT(C39:C56)","v":18}]
["ยอดฝีมือ"]
[54,"Name Range","2020-07-16"]
[55,"If","2020-07-17"]
[56,"Nesting If Min","2020-07-17"]
[57,"CountIf SumIf","2020-07-17"]
[58,"IfError","2020-07-17"]
[59,"Vlookup","2020-07-21"]
[60,"Hlookup","2020-07-21"]
[61,"Index Match","2020-07-23"]
[62,"Left Right Mid Search Len","2020-07-24"]
[63,"Concatenate","2020-07-24"]
[64,"Flash Fill","2020-07-24"]
[65,"Text To Column","2020-07-30"]
[66,"Auditing","2020-07-30"]
[67,"Protection Worksheet/Workbook","2020-07-31"]
[68,"What If Goal Seek and PMT","2020-07-31"]
[69,"Solver","2020-08-07"]
[70,"Data Table","2020-08-10"]
[71,"Scenario Manager","2020-08-10"]
[72,"Macro Basic","2020-08-11"]
[73,"Macro on Job","2020-08-11",{"$f":"COUNT(C58:C77)","v":20}]
["ปรมาจารย์"]
[74,"VBA","2020-08-18"]
[75,"VBA Coding","2020-08-21"]
[76,"VBA Variable","2020-08-21"]
[77,"VBA If","2020-08-21"]
[78,"VBA Loop, Offset","2020-08-21"]
[79,"InputBox","2020-09-02"]
[80,"MsgBox, Goto, MsgBox Yes No, Interactive","2020-09-02"]
[81,"Last Row, Offset to Move Selection","2020-09-03"]
[82,"Last Row xlup, Range Select Code","2020-09-03"]
[83,"Sale Console","2020-09-11"]
[84,"Sale Console 2","2020-09-11"]
[85,"Sale Console with Adjustment Intro","2020-09-22"]
[86,"Sale Console with Adjustment 1 Macro","2020-09-22"]
[87,"Sale Console with Adjustment 2 Insert Today date and Sale InputBox","2020-09-22"]
[88,"Sale Console with Adjustment 3","2020-09-22"]
[89,"Sale Console with Adjustment 4","2020-09-22"]
[90,"Sale Console with Correction","2020-09-24"]
[91,"Sale Console with Correction 1","2020-09-24"]
[92,"Convert Report to Data Dump","2020-10-01"]
[93,"Convert Report to Data Dump 1","2020-10-01"]
[94,"Convert Report to Data Dump 2","2020-10-01"]
[95,"Filter Contain","2020-10-02"]
[96,"Double Click Set Value","2020-10-19"]
[97,"Double Click Set Value 1","2020-10-22"]
[98,"Double Click Set Value 2","2020-10-22"]
[99,"Invoice Intro","2020-10-27"]
[100,"Invoice 1 Filter Contain","2020-10-27"]
[101,"Invoice 2 Double Click to call Filter Program","2020-10-29"]
[102,"Invoice 3 Create Macro to copy data to Invoice Form","2020-10-29"]
[103,"Invoice 4 Move Cursor by Offset Function under Auto Filter","2020-11-02"]
[104,"Invoice 5 ","2020-11-02"]
[105,"Invoice 6","2020-11-13",{"$f":"COUNT(C79:C110)","v":32}]
["สูงสุดสู่สามัญ"]
[106,"Normal","2020-11-26"]
[107,"Normal 1","2020-11-26"]
[108,"Normal 2","2020-11-26"]
[109,"Normal 3","2020-11-26"]
[110,"Normal Sample","2020-11-26",{"$f":"COUNT(C112:C116)","v":5}]
["จักรวาลไร้ของเขต"]
[111,"Add New Invoice","2020-12-08"]
[112,"Add New Invoice1","2020-12-08"]
[113,"Add New Invoice2","2020-12-08"]
[114,"Edit Invoice","2020-12-09"]
[115,"Edit Invoice1","2020-12-09"]
[116,"Double Click Product to Invoice","2020-12-09"]
[117,"Quotation","2020-12-15"]
[118,"Quotation Add New","2020-12-15"]
[119,"Quotation Edit","2020-12-15"]
[120,"Purchase Order","2020-12-21"]
[121,"Purchase Order1","2020-12-21"]
[122,"Purchase Order2","2020-12-21"]
[123,"Purchase Order3","2020-12-21"]
[124,"Menu by Smart Art","2020-12-21",{"$f":"COUNT(C118:C131)","v":14}]