{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Dataset","PROPER","UPPER","LOWER","Flash Fill ","POWER QUERY","Table1","Pivot ","Sheet8","VBA(UPPER)","VBA (LOWER)","VBA (PROPER)","Practice"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":1},"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":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"How to Change Case in Excel for Entire Column"]
[]
[null,"Student ID","Name","Location"]
[null,"AB017","Franz","Tampa, Florida"]
[null,"RK021","Rodrique","Phoenix, Arizona"]
[null,"JB007","Gaile","Lafayette, Louisiana"]
[null,"JP044","Clayborne","Atlanta, Georgia"]
[null,"CJ003","Abey","Springfield, Missouri"]
[null,"SW033","Darwin","Houston, Texas"]

{"sheet":"PROPER","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of PROPER Function"]
[]
[null,"Student ID","Name","Location","Modified Location Column"]
[null,"AB017","Franz","TAMPA, FLORIDA",{"$f":"PROPER(D5)","v":"Tampa, Florida"}]
[null,"RK021","Rodrique","phoenix, arizona",{"$f":"PROPER(D6)","v":"Phoenix, Arizona"}]
[null,"JB007","Gaile","LAFAYETTE, LOUISIANA","Lafayette, Louisiana"]
[null,"JP044","Clayborne","atlanta, georgia","Atlanta, Georgia"]
[null,"CJ003","Abey","SPRINGFIELD, MISSOURI","Springfield, Missouri"]
[null,"SW033","Darwin","HOUSTON, TEXAS","Houston, Texas"]

{"sheet":"UPPER","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of UPPER Function"]
[]
[null,"Student ID","Name","Location","Modified Location Column"]
[null,"AB017","Franz","Tampa, Florida",{"$f":"UPPER(D5)","v":"TAMPA, FLORIDA"}]
[null,"RK021","Rodrique","Phoenix, Arizona",{"$f":"UPPER(D6)","v":"PHOENIX, ARIZONA"}]
[null,"JB007","Gaile","Lafayette, Louisiana","LAFAYETTE, LOUISIANA"]
[null,"JP044","Clayborne","Atlanta, Georgia","ATLANTA, GEORGIA"]
[null,"CJ003","Abey","Springfield, Missouri","SPRINGFIELD, MISSOURI"]
[null,"SW033","Darwin","Houston, Texas","HOUSTON, TEXAS"]

{"sheet":"LOWER","index":3,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Employing LOWER Function"]
[]
[null,"Student ID","Name","Location","Modified Location Column"]
[null,"AB017","Franz","Tampa, Florida",{"$f":"LOWER(D5)","v":"tampa, florida"}]
[null,"RK021","Rodrique","Phoenix, Arizona",{"$f":"LOWER(D6)","v":"phoenix, arizona"}]
[null,"JB007","Gaile","Lafayette, Louisiana","lafayette, louisiana"]
[null,"JP044","Clayborne","Atlanta, Georgia","atlanta, georgia"]
[null,"CJ003","Abey","Springfield, Missouri","springfield, missouri"]
[null,"SW033","Darwin","Houston, Texas","houston, texas"]

{"sheet":"Flash Fill ","index":4,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Adopting Flash Fill Feature"]
[]
[null,"Student ID","Name","Location","Modified Location Column"]
[null,"AB017","Franz","TAMPA, FLORIDA","Tampa, Florida"]
[null,"RK021","Rodrique","PHOENIX, ARIZONA","Phoenix, Arizona"]
[null,"JB007","Gaile","LAFAYETTE, LOUISIANA","Lafayette, Louisiana"]
[null,"JP044","Clayborne","ATLANTA, GEORGIA","Atlanta, Georgia"]
[null,"CJ003","Abey","SPRINGFIELD, MISSOURI","Springfield, Missouri"]
[null,"SW033","Darwin","HOUSTON, TEXAS","Houston, Texas"]

{"sheet":"POWER QUERY","index":5,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of POWER QUERY"]
[]
[null,"Student ID","Name","Location"]
[null,"AB017","Franz","TAMPA, FLORIDA"]
[null,"RK021","Rodrique","PHOENIX, ARIZONA"]
[null,"JB007","Gaile","Lafayette, Louisiana"]
[null,"JP044","Clayborne","Atlanta, Georgia"]
[null,"CJ003","Abey","SPRINGFIELD, MISSOURI"]
[null,"SW033","Darwin","HOUSTON, TEXAS"]

{"sheet":"Table1","index":6,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Student ID","Name","Location","lowercase","UPPERCASE","Capitalize Each Word"]
["AB017","Franz","TAMPA, FLORIDA","tampa, florida","TAMPA, FLORIDA","Tampa, Florida"]
["RK021","Rodrique","PHOENIX, ARIZONA","phoenix, arizona","PHOENIX, ARIZONA","Phoenix, Arizona"]
["JB007","Gaile","Lafayette, Louisiana","lafayette, louisiana","LAFAYETTE, LOUISIANA","Lafayette, Louisiana"]
["JP044","Clayborne","Atlanta, Georgia","atlanta, georgia","ATLANTA, GEORGIA","Atlanta, Georgia"]
["CJ003","Abey","SPRINGFIELD, MISSOURI","springfield, missouri","SPRINGFIELD, MISSOURI","Springfield, Missouri"]
["SW033","Darwin","HOUSTON, TEXAS","houston, texas","HOUSTON, TEXAS","Houston, Texas"]

{"sheet":"Pivot ","index":7,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"DAX Formula in Pivot Table"]
[]
[null,"Student ID","Name","Location"]
[null,"AB017","Franz","tampa, florida"]
[null,"RK021","Rodrique","phoenix, arizona"]
[null,"JB007","Gaile","lafayette, louisiana"]
[null,"JP044","Clayborne","atlanta, georgia"]
[null,"CJ003","Abey","springfield, missouri"]
[null,"SW033","Darwin","houston, texas"]

{"sheet":"Sheet8","index":8,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Row Labels","Lower Case"]
["atlanta, georgia","atlanta, georgia"]
["houston, texas","houston, texas"]
["lafayette, louisiana","lafayette, louisiana"]
["phoenix, arizona","phoenix, arizona"]
["springfield, missouri","springfield, missouri"]
["tampa, florida","tampa, florida"]
["Grand Total","tampa, florida, phoenix, arizona, lafayette, louisiana, atlanta, georgia, springfield, missouri, houston, texas"]

{"sheet":"VBA(UPPER)","index":9,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null," VBA for UPPER Case"]
[]
[null,"Student ID","Name","Location"]
[null,"AB017","Franz","TAMPA, FLORIDA"]
[null,"RK021","Rodrique","PHOENIX, ARIZONA"]
[null,"JB007","Gaile","LAFAYETTE, LOUISIANA"]
[null,"JP044","Clayborne","ATLANTA, GEORGIA"]
[null,"CJ003","Abey","SPRINGFIELD, MISSOURI"]
[null,"SW033","Darwin","HOUSTON, TEXAS"]

{"sheet":"VBA (LOWER)","index":10,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null," VBA for LOWER Case"]
[]
[null,"Student ID","Name","Location"]
[null,"AB017","Franz","tampa, florida"]
[null,"RK021","Rodrique","phoenix, arizona"]
[null,"JB007","Gaile","lafayette, louisiana"]
[null,"JP044","Clayborne","atlanta, georgia"]
[null,"CJ003","Abey","springfield, missouri"]
[null,"SW033","Darwin","houston, texas"]

{"sheet":"VBA (PROPER)","index":11,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null," VBA for PROPER Case"]
[]
[null,"Student ID","Name","Location"]
[null,"AB017","Franz","Tampa, Florida"]
[null,"RK021","Rodrique","Phoenix, Arizona"]
[null,"JB007","Gaile","Lafayette, Louisiana"]
[null,"JP044","Clayborne","Atlanta, Georgia"]
[null,"CJ003","Abey","Springfield, Missouri"]
[null,"SW033","Darwin","Houston, Texas"]

{"sheet":"Practice","index":12,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Try Yourself"]
[]
[null,"Student ID","Name","Location","Modified Location Column"]
[null,"AB017","Franz","TAMPA, FLORIDA"]
[null,"RK021","Rodrique","phoenix, arizona"]
[null,"JB007","Gaile","LAFAYETTE, LOUISIANA"]
[null,"JP044","Clayborne","atlanta, georgia"]
[null,"CJ003","Abey","SPRINGFIELD, MISSOURI"]
[null,"SW033","Darwin","HOUSTON, TEXAS"]