{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset Overview","Flipping Data Only Vertically","Flipping Data Only Horizontally","Using INDEX Function ","Using SORTBY Function ","Applying VBA Code ","Reversing Axis in Excel Chart","February","March"],"not_rendered":{"charts":6,"images":0,"macros":1,"external_links":0,"defined_names":26,"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 Overview","index":0,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9],[3,4,3,5],[4,4,4,5]]}
[]
[null,"Dataset Overview",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Salesperson","Sales",null,null,null,null,null,"Salesperson","Sales"]
[null,"Luka",34543,null,null,null,null,null,"Pam",34543]
[null,"Oliver",45324,null,null,null,null,null,"Michael",45324]
[null,"Robin",65476,null,null,null,null,null,"Ron",65476]
[null,"Aron",66783,null,null,null,null,null,"Erik",66783]
[null,"Leo",47167,null,null,null,null,null,"Lucy",47167]
[null,"Henry",46548,null,null,null,null,null,"Harry",46548]
[null,"James",88673,null,null,null,null,null,"Lily",88673]

{"sheet":"Flipping Data Only Vertically","index":1,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9],[3,4,3,5],[4,4,4,5]]}
[]
[null,"Flipping Data Only Vertically",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Salesperson","Sales",null,null,null,null,null,"Salesperson","Sales"]
[null,"James",88673,null,null,null,null,null,"Pam",34543]
[null,"Aron",66783,null,null,null,null,null,"Michael",45324]
[null,"Robin",65476,null,null,null,null,null,"Ron",65476]
[null,"Leo",47167,null,null,null,null,null,"Erik",66783]
[null,"Henry",46548,null,null,null,null,null,"Lucy",47167]
[null,"Oliver",45324,null,null,null,null,null,"Harry",46548]
[null,"Luka",34543,null,null,null,null,null,"Lily",88673]

{"sheet":"Flipping Data Only Horizontally","index":2,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9],[3,4,3,5],[4,4,4,5]]}
[]
[null,"Flipping Data Only Horizontally",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Sales","Salesperson",null,null,null,null,null,"Salesperson","Sales"]
[null,34543,"Luka",null,null,null,null,null,"Pam",34543]
[null,45324,"Oliver",null,null,null,null,null,"Michael",45324]
[null,65476,"Robin",null,null,null,null,null,"Ron",65476]
[null,66783,"Aron",null,null,null,null,null,"Erik",66783]
[null,47167,"Leo",null,null,null,null,null,"Lucy",47167]
[null,46548,"Henry",null,null,null,null,null,"Harry",46548]
[null,88673,"James",null,null,null,null,null,"Lily",88673]

{"sheet":"Using INDEX Function ","index":3,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,11,1,12],[1,1,1,5]]}
[]
[null,"Using INDEX Function ",null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Salesperson","Sales",null,"Salesperson","Sales",null,null,null,null,null,"Salesperson","Sales"]
[null,"Luka",34543,null,{"$f":"INDEX($B$5:$C$11,ROWS(B5:$B$11),COLUMNS($B$5:B5))","v":"James"},{"$f":"INDEX($B$5:$C$11,ROWS($B5:C$11),COLUMNS($B$5:C5))","v":88673},null,null,null,null,null,"Pam",34543]
[null,"Oliver",45324,null,{"$f":"INDEX($B$5:$C$11,ROWS(B6:$B$11),COLUMNS($B$5:B6))","v":"Henry"},{"$f":"INDEX($B$5:$C$11,ROWS($B6:C$11),COLUMNS($B$5:C6))","v":46548},null,null,null,null,null,"Michael",45324]
[null,"Robin",65476,null,{"$f":"INDEX($B$5:$C$11,ROWS(B7:$B$11),COLUMNS($B$5:B7))","v":"Leo"},{"$f":"INDEX($B$5:$C$11,ROWS($B7:C$11),COLUMNS($B$5:C7))","v":47167},null,null,null,null,null,"Ron",65476]
[null,"Aron",66783,null,{"$f":"INDEX($B$5:$C$11,ROWS(B8:$B$11),COLUMNS($B$5:B8))","v":"Aron"},{"$f":"INDEX($B$5:$C$11,ROWS($B8:C$11),COLUMNS($B$5:C8))","v":66783},null,null,null,null,null,"Erik",66783]
[null,"Leo",47167,null,{"$f":"INDEX($B$5:$C$11,ROWS(B9:$B$11),COLUMNS($B$5:B9))","v":"Robin"},{"$f":"INDEX($B$5:$C$11,ROWS($B9:C$11),COLUMNS($B$5:C9))","v":65476},null,null,null,null,null,"Lucy",47167]
[null,"Henry",46548,null,{"$f":"INDEX($B$5:$C$11,ROWS(B10:$B$11),COLUMNS($B$5:B10))","v":"Oliver"},{"$f":"INDEX($B$5:$C$11,ROWS($B10:C$11),COLUMNS($B$5:C10))","v":45324},null,null,null,null,null,"Harry",46548]
[null,"James",88673,null,{"$f":"INDEX($B$5:$C$11,ROWS(B11:$B$11),COLUMNS($B$5:B11))","v":"Luka"},{"$f":"INDEX($B$5:$C$11,ROWS($B11:C$11),COLUMNS($B$5:C11))","v":34543},null,null,null,null,null,"Lily",88673]

{"sheet":"Using SORTBY Function ","index":4,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,12]]}
[]
[null,"Using SORTBY Function ",null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Salesperson","Sales",null,"Salesperson","Sales",null,null,null,null,null,"Salesperson","Sales"]
[null,"Luka",34543,null,{"$f":"_xlfn.SORTBY($B$5:$B$11,ROW(B5:B11),-1)","v":"James"},{"$f":"_xlfn.SORTBY($C$5:$C$11,ROW(B5:B11),-1)","v":88673},null,null,null,null,null,"Pam",34543]
[null,"Oliver",45324,null,"Henry",46548,null,null,null,null,null,"Michael",45324]
[null,"Robin",65476,null,"Leo",47167,null,null,null,null,null,"Ron",65476]
[null,"Aron",66783,null,"Aron",66783,null,null,null,null,null,"Erik",66783]
[null,"Leo",47167,null,"Robin",65476,null,null,null,null,null,"Lucy",47167]
[null,"Henry",46548,null,"Oliver",45324,null,null,null,null,null,"Harry",46548]
[null,"James",88673,null,"Luka",34543,null,null,null,null,null,"Lily",88673]

{"sheet":"Applying VBA Code ","index":5,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9],[3,4,3,5],[4,4,4,5]]}
[]
[null,"Applying VBA Code ",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Salesperson","Sales",null,null,null,null,null,"Salesperson","Sales"]
[null,"James",88673,null,null,null,null,null,"Pam",34543]
[null,"Henry",46548,null,null,null,null,null,"Michael",45324]
[null,"Leo",47167,null,null,null,null,null,"Ron",65476]
[null,"Aron",66783,null,null,null,null,null,"Erik",66783]
[null,"Robin",65476,null,null,null,null,null,"Lucy",47167]
[null,"Oliver",45324,null,null,null,null,null,"Harry",46548]
[null,"Luka",34543,null,null,null,null,null,"Lily",88673]

{"sheet":"Reversing Axis in Excel Chart","index":6,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9],[3,4,3,5],[4,4,4,5]]}
[]
[null,"Reversing Axis in Excel Chart",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Salesperson","Sales",null,null,null,null,null,"Salesperson","Sales"]
[null,"Luka",34543,null,null,null,null,null,"Pam",34543]
[null,"Oliver",45324,null,null,null,null,null,"Michael",45324]
[null,"Robin",65476,null,null,null,null,null,"Ron",65476]
[null,"Aron",66783,null,null,null,null,null,"Erik",66783]
[null,"Leo",47167,null,null,null,null,null,"Lucy",47167]
[null,"Henry",46548,null,null,null,null,null,"Harry",46548]
[null,"James",88673,null,null,null,null,null,"Lily",88673]

{"sheet":"February","index":7,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":true,"merged":[[1,1,1,3]]}
[]
[null,"Applying Inspect Document Function"]
[]
[null,"Salesperson","Region","Sales"]
[null,"Luka","Canada",67463]
[null,"Oliver","UK",78453]
[null,"Robin","London",48763]
[null,"Aron","UK",38725]
[null,"Leo","USA",78435]
[null,"Henry","USA",67329]
[null,"James","London",27854]

{"sheet":"March","index":8,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":true,"merged":[[1,1,1,3]]}
[]
[null,"Applying Inspect Document Function"]
[]
[null,"Salesperson","Region","Sales"]
[null,"Luka","Canada",82564]
[null,"Oliver","UK",19845]
[null,"Robin","London",67342]
[null,"Aron","UK",67453]
[null,"Leo","USA",89163]
[null,"Henry","USA",78236]
[null,"James","London",78345]