{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Sample Dataset","Select and Delete","Excel Editing Tools","Use of “COUNTA” Formula","Apply VBA Code"],"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":"Sample Dataset","index":0,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Sample Dataset"]
[]
[null,"ID","Name",null,null,"Grade",null,"Year"]
[null,1,"John",null,null,"A+",null,2010]
[null,2,"Roman",null,null,"A",null,2011]
[null,3,"Seth",null,null,"A-",null,2012]
[null,4,"Dean",null,null,"B+",null,2013]
[null,5,"Finn",null,null,"B",null,2014]

{"sheet":"Select and Delete","index":1,"n_rows":9,"n_cols":16,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,15]]}
[]
[null,"Selecting and Deleing Blank Columns",null,null,null,null,null,null,null,"Practice Yourself Here"]
[]
[null,"ID","Name","Grade","Year",null,null,null,null,"ID","Name",null,null,"Grade",null,"Year"]
[null,1,"John","A+",2010,null,null,null,null,1,"John",null,null,"A+",null,2010]
[null,2,"Roman","A",2011,null,null,null,null,2,"Roman",null,null,"A",null,2011]
[null,3,"Seth","A-",2012,null,null,null,null,3,"Seth",null,null,"A-",null,2012]
[null,4,"Dean","B+",2013,null,null,null,null,4,"Dean",null,null,"B+",null,2013]
[null,5,"Finn","B",2014,null,null,null,null,5,"Finn",null,null,"B",null,2014]

{"sheet":"Excel Editing Tools","index":2,"n_rows":9,"n_cols":19,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,7],[1,12,1,18]]}
[]
[null,"Using Excel Editing Tools to Delete Blank Columns",null,null,null,null,null,null,null,null,null,null,"Practice Yourself Here"]
[]
[null,"ID","Name","Grade","Year",null,null,null,null,null,null,null,"ID","Name",null,null,"Grade",null,"Year"]
[null,1,"John","A+",2010,null,null,null,null,null,null,null,1,"John",null,null,"A+",null,2010]
[null,2,"Roman","A",2011,null,null,null,null,null,null,null,2,"Roman",null,null,"A",null,2011]
[null,3,"Seth","A-",2012,null,null,null,null,null,null,null,3,"Seth",null,null,"A-",null,2012]
[null,4,"Dean","B+",2013,null,null,null,null,null,null,null,4,"Dean",null,null,"B+",null,2013]
[null,5,"Finn","B",2014,null,null,null,null,null,null,null,5,"Finn",null,null,"B",null,2014]

{"sheet":"Use of “COUNTA” Formula","index":3,"n_rows":9,"n_cols":16,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,15]]}
[]
[null,"Using “COUNTA” Formula to Delete Blank Columns",null,null,null,null,null,null,null,"Practice Yourself Here"]
[]
[null,"ID","Name","Grade","Year",null,null,null,null,"ID","Name",null,null,"Grade",null,"Year"]
[null,1,"John","A+",2010,null,null,null,null,1,"John",null,null,"A+",null,2010]
[null,2,"Roman","A",2011,null,null,null,null,2,"Roman",null,null,"A",null,2011]
[null,3,"Seth","A-",2012,null,null,null,null,3,"Seth",null,null,"A-",null,2012]
[null,4,"Dean","B+",2013,null,null,null,null,4,"Dean",null,null,"B+",null,2013]
[null,5,"Finn","B",2014,null,null,null,null,5,"Finn",null,null,"B",null,2014]

{"sheet":"Apply VBA Code","index":4,"n_rows":9,"n_cols":16,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,9,1,15],[1,1,1,4]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,null,null,"Practice Yourself Here"]
[]
[null,"ID","Name","Grade","Year",null,null,null,null,"ID","Name",null,null,"Grade",null,"Year"]
[null,1,"John","A+",2010,null,null,null,null,1,"John",null,null,"A+",null,2010]
[null,2,"Roman","A",2011,null,null,null,null,2,"Roman",null,null,"A",null,2011]
[null,3,"Seth","A-",2012,null,null,null,null,3,"Seth",null,null,"A-",null,2012]
[null,4,"Dean","B+",2013,null,null,null,null,4,"Dean",null,null,"B+",null,2013]
[null,5,"Finn","B",2014,null,null,null,null,5,"Finn",null,null,"B",null,2014]