{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Dataset","AutoSum","SubTotal","SUBTOTAL Function","Sort & Filter","Slicers","Table","SUMIF","Descriptive Statistics","Consolidate","VBA"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset"]
[]
[null,"Participants","Amount"]
[null,"Pamela",300]
[null,"Kelly",35]
[null,"Phyllis",15]
[null,"Meredith",250]
[null,"Erin",30]
[null,"Kelly",60]
[null,"Phyllis",250]
[null,"Pamela",200]
[null,"Erin",30]
[null,"Erin",50]

{"sheet":"AutoSum","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of AutoSum Tool"]
[]
[null,"Participants","Amount"]
[null,"Pamela",300]
[null,"Kelly",35]
[null,"Phyllis",15]
[null,"Meredith",250]
[null,"Erin",30]
[null,"Kelly",60]
[null,"Phyllis",250]
[null,"Pamela",200]
[null,"Erin",30]
[null,"Erin",50]

{"sheet":"SubTotal","index":2,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using SubTotal Feature"]
[]
[null,"Participants","Amount"]
[null,"Pamela",300]
[null,"Kelly",35]
[null,"Phyllis",15]
[null,"Meredith",250]
[null,"Erin",30]
[null,"Kelly",60]
[null,"Phyllis",250]
[null,"Pamela",200]
[null,"Erin",30]
[null,"Erin",50]

{"sheet":"SUBTOTAL Function","index":3,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying SUBTOTAL Function"]
[]
[null,"Participants","Amount"]
[null,"Pamela",300]
[null,"Kelly",35]
[null,"Phyllis",15]
[null,"Meredith",250]
[null,"Erin",30]
[null,"Kelly",60]
[null,"Phyllis",250]
[null,"Pamela",200]
[null,"Erin",30]
[null,"Erin",50]

{"sheet":"Sort & Filter","index":4,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Sort & Filter Tool"]
[]
[null,"Participants","Amount"]
[null,"Pamela",300]
[null,"Kelly",35]
[null,"Phyllis",15]
[null,"Meredith",250]
[null,"Erin",30]
[null,"Kelly",60]
[null,"Phyllis",250]
[null,"Pamela",200]
[null,"Erin",30]
[null,"Erin",50]

{"sheet":"Slicers","index":5,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Slicers"]
[]
[null,"Participants","Amount"]
[null,"Pamela",300]
[null,"Kelly",35]
[null,"Phyllis",15]
[null,"Meredith",250]
[null,"Erin",30]
[null,"Kelly",60]
[null,"Phyllis",250]
[null,"Pamela",200]
[null,"Erin",30]
[null,"Erin",50]

{"sheet":"Table","index":6,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Inserting Excel Table"]
[]
[null,"Participants","Amount"]
[null,"Pamela",300]
[null,"Kelly",35]
[null,"Phyllis",15]
[null,"Meredith",250]
[null,"Erin",30]
[null,"Kelly",60]
[null,"Phyllis",250]
[null,"Pamela",200]
[null,"Erin",30]
[null,"Erin",50]

{"sheet":"SUMIF","index":7,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Inserting SUMIF Function"]
[]
[null,"Participants","Amount"]
[null,"Pamela",300]
[null,"Kelly",35]
[null,"Phyllis",15]
[null,"Meredith",250]
[null,"Erin",30]
[null,"Kelly",60]
[null,"Phyllis",250]
[null,"Pamela",200]
[null,"Erin",30]
[null,"Erin",50]

{"sheet":"Descriptive Statistics","index":8,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying Descriptive Statistics"]
[]
[null,"Participants","Amount"]
[null,"Pamela",300]
[null,"Kelly",35]
[null,"Phyllis",15]
[null,"Meredith",250]
[null,"Erin",30]
[null,"Kelly",60]
[null,"Phyllis",250]
[null,"Pamela",200]
[null,"Erin",30]
[null,"Erin",50]

{"sheet":"Consolidate","index":9,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Consolidate Tool"]
[]
[null,"Participants","Amount"]
[null,"Pamela",300]
[null,"Kelly",35]
[null,"Phyllis",15]
[null,"Meredith",250]
[null,"Erin",30]
[null,"Kelly",60]
[null,"Phyllis",250]
[null,"Pamela",200]
[null,"Erin",30]
[null,"Erin",50]

{"sheet":"VBA","index":10,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying Excel VBA"]
[]
[null,"Participants","Amount"]
[null,"Pamela",300]
[null,"Kelly",35]
[null,"Phyllis",15]
[null,"Meredith",250]
[null,"Erin",30]
[null,"Kelly",60]
[null,"Phyllis",250]
[null,"Pamela",200]
[null,"Erin",30]
[null,"Erin",50]