{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Overview","Basic Dataset","Keyboard","Go To Special","Find and Replace","Filter","Advanced Filter","FILTER function","Sort","Table3","Power Query","VBA"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":6,"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":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[3,1,3,4],[3,6,3,7],[1,1,1,7]]}
[]
[null,"Delete Empty Cells in Excel"]
[]
[null,"Student Mark Sheet",null,null,null,null,"Method Overview"]
[]
[null,"Name","CSE 1109","EEE 1105","Math 1107",null,"Method","Decsription"]
[null,"Ricky Ben",86,71,67,null,1,"Keyboard Shortcut"]
[null,"Ruby Jason",87,71,88,null,2,"Go To Special Feature"]
[null,"Erik Bawn",93,65,60,null,3,"Find and Replace Command"]
[null,"Edward Seel",89,99,84,null,4,"Filter Option"]
[null,"Kyra Hoots",69,60,74,null,5,"Advanced Filter Feature"]
[null,"James Smith",91,84,74,null,6,"FILTER Function"]
[null,null,null,null,null,null,7,"Sort Option"]
[null,null,null,null,null,null,8,"Power Query"]
[null,"Maria Martinez",74,88,61]

{"sheet":"Basic Dataset","index":1,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Student Mark Sheet"]
[]
[null,"Name","CSE 1109","EEE 1105","Math 1107"]
[null,"Ricky Ben",86,71,67]
[null,"Ruby Jason",87,71,88]
[null,"Erik Bawn",93,65,60]
[null,"Edward Seel",89,99,84]
[null,"Kyra Hoots",69,60,74]
[null,"James Smith",91,84,74]
[]
[]
[null,"Maria Martinez",74,88,61]

{"sheet":"Keyboard","index":2,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Using Keyboard Shortcut",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","CSE 1109","EEE 1105","Math 1107",null,null,null,"Name","CSE 1109","EEE 1105","Math 1107"]
[null,"Ricky Ben",86,71,67,null,null,null,"Ricky Ben",86,71,67]
[null,"Ruby Jason",87,71,88,null,null,null,"Ruby Jason",87,71,88]
[null,"Erik Bawn",93,65,60,null,null,null,"Erik Bawn",93,65,60]
[null,"Edward Seel",89,99,84,null,null,null,"Edward Seel",89,99,84]
[null,"Kyra Hoots",69,60,74,null,null,null,"Kyra Hoots",69,60,74]
[null,"James Smith",91,84,74,null,null,null,"James Smith",91,23,74]
[null,"Maria Martinez",74,88,61]
[]
[null,null,null,null,null,null,null,null,"Maria Martinez",74,88,35]

{"sheet":"Go To Special","index":3,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Use of Go To Special",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","CSE 1109","EEE 1105","Math 1107",null,null,null,"Name","CSE 1109","EEE 1105","Math 1107"]
[null,"Ricky Ben",86,71,67,null,null,null,"Ricky Ben",86,71,67]
[null,"Ruby Jason",87,71,88,null,null,null,"Ruby Jason",87,71,88]
[null,"Erik Bawn",93,65,60,null,null,null,"Erik Bawn",93,65,60]
[null,"Edward Seel",89,99,84,null,null,null,"Edward Seel",89,99,84]
[null,"Kyra Hoots",69,60,74,null,null,null,"Kyra Hoots",69,60,74]
[null,"James Smith",91,84,74,null,null,null,"James Smith",91,84,74]
[null,"Maria Martinez",74,88,61]
[]
[null,null,null,null,null,null,null,null,"Maria Martinez",74,88,61]

{"sheet":"Find and Replace","index":4,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Utilizing Find and Replace Command",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","CSE 1109","EEE 1105","Math 1107",null,null,null,"Name","CSE 1109","EEE 1105","Math 1107"]
[null,"Ricky Ben",86,71,67,null,null,null,"Ricky Ben",86,71,67]
[null,"Ruby Jason",87,71,88,null,null,null,"Ruby Jason",87,71,88]
[null,"Erik Bawn",93,65,60,null,null,null,"Erik Bawn",93,65,60]
[null,"Edward Seel",89,99,84,null,null,null,"Edward Seel",89,99,84]
[null,"Kyra Hoots",69,60,74,null,null,null,"Kyra Hoots",69,60,74]
[null,"James Smith",91,84,74,null,null,null,"James Smith",91,54,74]
[null,"Maria Martinez",74,88,61]
[]
[null,null,null,null,null,null,null,null,"Maria Martinez",74,88,67]

{"sheet":"Filter","index":5,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Using Filter Option",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","CSE 1109","EEE 1105","Math 1107",null,null,null,"Name","CSE 1109","EEE 1105","Math 1107"]
[null,"Ricky Ben",86,71,67,null,null,null,"Ricky Ben",86,71,67]
[null,"Ruby Jason",87,71,88,null,null,null,"Ruby Jason",87,71,88]
[null,"Erik Bawn",93,65,60,null,null,null,"Erik Bawn",93,65,60]
[null,"Edward Seel",89,99,84,null,null,null,"Edward Seel",89,99,84]
[null,"Kyra Hoots",69,60,74,null,null,null,"Kyra Hoots",69,60,74]
[null,"James Smith",91,84,74,null,null,null,"James Smith",91,84,74]
[null,"Maria Martinez",74,88,61]
[]
[null,null,null,null,null,null,null,null,"Maria Martinez",74,88,61]

{"sheet":"Advanced Filter","index":6,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,9,1,12],[1,1,1,6]]}
[]
[null,"Employing Advanced Filter Feature",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","CSE 1109","EEE 1105","Math 1107",null,"Name",null,null,"Name","CSE 1109","EEE 1105","Math 1107"]
[null,"Ricky Ben",86,71,67,null,{"$f":"\"\"","v":""},null,null,"Ricky Ben",86,71,67]
[null,"Ruby Jason",87,71,88,null,null,null,null,"Ruby Jason",87,71,88]
[null,"Erik Bawn",93,65,60,null,null,null,null,"Erik Bawn",93,65,60]
[null,"Edward Seel",89,99,84,null,null,null,null,"Edward Seel",89,99,84]
[null,"Kyra Hoots",69,60,74,null,null,null,null,"Kyra Hoots",69,60,74]
[null,"James Smith",91,84,74,null,null,null,null,"James Smith",91,84,74]
[]
[]
[null,"Maria Martinez",74,88,61,null,null,null,null,"Maria Martinez",74,88,61]

{"sheet":"FILTER function","index":7,"n_rows":13,"n_cols":21,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,9],[1,12,1,20]]}
[]
[null,"Applying FILTER Function",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","CSE 1109","EEE 1105","Math 1107",null,"Name","CSE 1109","EEE 1105","Math 1107",null,null,"Name","CSE 1109","EEE 1105","Math 1107",null,"Name","CSE 1109","EEE 1105","Math 1107"]
[null,"Ricky Ben",86,71,67,null,{"$f":"_xlfn._xlws.FILTER(B5:E13,(B5:B13<>\"\")*(C5:C13<>\"\")*(D5:D13<>\"\")*(E5:E13<>\"\"))","v":"Ricky Ben"},86,71,67,null,null,"Ricky Ben",86,71,67,null,{"$f":"_xlfn._xlws.FILTER(M5:P13,(M5:M13<>\"\")*(N5:N13<>\"\")*(O5:O13<>\"\")*(P5:P13<>\"\"))","v":"Ricky Ben"},86,71,67]
[null,"Ruby Jason",87,71,88,null,"Ruby Jason",87,71,88,null,null,"Ruby Jason",87,71,88,null,"Ruby Jason",87,71,88]
[null,"Erik Bawn",93,65,60,null,"Erik Bawn",93,65,60,null,null,"Erik Bawn",93,65,60,null,"Erik Bawn",93,65,60]
[null,"Edward Seel",89,99,84,null,"Edward Seel",89,99,84,null,null,"Edward Seel",89,99,84,null,"Edward Seel",89,99,84]
[null,"Kyra Hoots",69,60,74,null,"Kyra Hoots",69,60,74,null,null,"Kyra Hoots",69,60,74,null,"Kyra Hoots",69,60,74]
[null,"James Smith",91,84,74,null,"James Smith",91,84,74,null,null,"James Smith",91,null,74]
[null,null,null,null,null,null,"Maria Martinez",74,88,61]
[]
[null,"Maria Martinez",74,88,61,null,null,null,null,null,null,null,"Maria Martinez",74,88]

{"sheet":"Sort","index":8,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Implementing Sort Option",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","CSE 1109","EEE 1105","Math 1107",null,null,null,"Name","CSE 1109","EEE 1105","Math 1107"]
[null,"Edward Seel",89,99,84,null,null,null,"Ricky Ben",86,71,67]
[null,"Erik Bawn",93,65,60,null,null,null,"Ruby Jason",87,71,88]
[null,"James Smith",91,45,74,null,null,null,"Erik Bawn",93,65,60]
[null,"Kyra Hoots",69,60,74,null,null,null,"Edward Seel",89,99,84]
[null,"Maria Martinez",74,88,56,null,null,null,"Kyra Hoots",69,60,74]
[null,"Ricky Ben",86,71,67,null,null,null,"James Smith",91,84,74]
[null,"Ruby Jason",87,71,88]
[]
[null,null,null,null,null,null,null,null,"Maria Martinez",74,88,61]

{"sheet":"Table3","index":9,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Applying Power Query"]
[]
[null,"Name","CSE 1109","EEE 1105","Math 1107"]
[null,"Ricky Ben",86,71,67]
[null,"Ruby Jason",87,71,88]
[null,"Erik Bawn",93,65,60]
[null,"Edward Seel",89,99,84]
[null,"Kyra Hoots",69,60,74]
[null,"James Smith",91,84,74]
[null,"Maria Martinez",74,88,61]

{"sheet":"Power Query","index":10,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Applying Power Query"]
[]
[null,"Name","CSE 1109","EEE 1105","Math 1107"]
[null,"Ricky Ben",86,71,67]
[null,"Ruby Jason",87,71,88]
[null,"Erik Bawn",93,65,60]
[null,"Edward Seel",89,99,84]
[null,"Kyra Hoots",69,60,74]
[null,"James Smith",91,84,74]
[]
[]
[null,"Maria Martinez",74,88,61]

{"sheet":"VBA","index":11,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,1,1,4],[25,8,25,11]]}
[]
[null,"Using VBA Code"]
[]
[null,"Name","CSE 1109","EEE 1105","Math 1107"]
[null,"Ricky Ben",86,71,67]
[null,"Ruby Jason",87,71,88]
[null,"Erik Bawn",93,65,60]
[null,"Edward Seel",89,99,84]
[null,"Kyra Hoots",69,60,74]
[null,"James Smith",91,84,74]
[null,"Maria Martinez",74,88,61]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,null,null,null,null,null,null,null,"Name","CSE 1109","EEE 1105","Math 1107"]
[null,null,null,null,null,null,null,null,"Ricky Ben",86,71,67]
[null,null,null,null,null,null,null,null,"Ruby Jason",87,71,88]
[null,null,null,null,null,null,null,null,"Erik Bawn",93,65,60]
[null,null,null,null,null,null,null,null,"Edward Seel",89,99,84]
[null,null,null,null,null,null,null,null,"Kyra Hoots",69,60,74]
[null,null,null,null,null,null,null,null,"James Smith",91,84,74]
[]
[]
[null,null,null,null,null,null,null,null,"Maria Martinez",74,88,61]