{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Overview","Dataset","LOWER Function","Removing Helper Column","Flash Fill","VBA","Microsoft Word","Data Validation","Sheet4","Table2","Proper Case","Upper Case"],"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":"Overview","index":0,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[4,1,7,1],[8,1,10,1],[11,1,14,1]]}
[]
[null,"Changing Upper Case to Lower Case in Excel"]
[]
[null,"Car Brand","User Profession","Name in Uppercase","Name in Lowercase"]
[null,"Audi","Businessman","JANE KAT",{"$f":"LOWER(D5)","v":"jane kat"}]
[null,null,"Businessman","WILLIAM MARK",{"$f":"LOWER(D6)","v":"william mark"}]
[null,null,"Doctor","MARK HENRY","mark henry"]
[null,null,"Lawyer","KEVIN PIETERSON","kevin pieterson"]
[null,"Range Rover","Lawyer","JASON GOLD","jason gold"]
[null,null,"Cricketer","HARRY DSUJA","harry dsuja"]
[null,null,"Actor","NICOLAS TOM","nicolas tom"]
[null,"Marcedes Benz","Engineer","ROB BILLY","rob billy"]
[null,null,"Businessman","JIMMY HARDER","jimmy harder"]
[null,null,"Businessman","TOM PAIN","tom pain"]
[null,null,"Doctor","STEVE SMITH","steve smith"]

{"sheet":"Dataset","index":1,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,1,7,1],[8,1,10,1],[11,1,14,1]]}
[]
[null,"Dataset"]
[]
[null,"Car Brand","User Profession","Name in Uppercase"]
[null,"Audi","Businessman","JANE KAT"]
[null,null,"Businessman","WILLIAM MARK"]
[null,null,"Doctor","MARK HENRY"]
[null,null,"Lawyer","KEVIN PIETERSON"]
[null,"Range Rover","Lawyer","JASON GOLD"]
[null,null,"Cricketer","HARRY DSUJA"]
[null,null,"Actor","NICOLAS TOM"]
[null,"Marcedes Benz","Engineer","ROB BILLY"]
[null,null,"Businessman","JIMMY HARDER"]
[null,null,"Businessman","TOM PAIN"]
[null,null,"Doctor","STEVE SMITH"]

{"sheet":"LOWER Function","index":2,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[4,1,7,1],[8,1,10,1],[11,1,14,1]]}
[]
[null,"Using LOWER Function"]
[]
[null,"Car Brand","User Profession","Name in Uppercase","Name in Lowercase"]
[null,"Audi","Businessman","JANE KAT",{"$f":"LOWER(D5)","v":"jane kat"}]
[null,null,"Businessman","WILLIAM MARK",{"$f":"LOWER(D6)","v":"william mark"}]
[null,null,"Doctor","MARK HENRY","mark henry"]
[null,null,"Lawyer","KEVIN PIETERSON","kevin pieterson"]
[null,"Range Rover","Lawyer","JASON GOLD","jason gold"]
[null,null,"Cricketer","HARRY DSUJA","harry dsuja"]
[null,null,"Actor","NICOLAS TOM","nicolas tom"]
[null,"Marcedes Benz","Engineer","ROB BILLY","rob billy"]
[null,null,"Businessman","JIMMY HARDER","jimmy harder"]
[null,null,"Businessman","TOM PAIN","tom pain"]
[null,null,"Doctor","STEVE SMITH","steve smith"]

{"sheet":"Removing Helper Column","index":3,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,1,7,1],[8,1,10,1],[11,1,14,1]]}
[]
[null,"Removing Helper Column"]
[]
[null,"Car Brand","User Profession","Name in Lowercase"]
[null,"Audi","Businessman","jane kat"]
[null,null,"Businessman","william mark"]
[null,null,"Doctor","mark henry"]
[null,null,"Lawyer","kevin pieterson"]
[null,"Range Rover","Lawyer","jason gold"]
[null,null,"Cricketer","harry dsuja"]
[null,null,"Actor","nicolas tom"]
[null,"Marcedes Benz","Engineer","rob billy"]
[null,null,"Businessman","jimmy harder"]
[null,null,"Businessman","tom pain"]
[null,null,"Doctor","steve smith"]

{"sheet":"Flash Fill","index":4,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[4,1,7,1],[8,1,10,1],[11,1,14,1]]}
[]
[null,"Applying Flash Fill"]
[]
[null,"Car Brand","User Profession","Name in Uppercase","Name in Lowercase"]
[null,"Audi","Businessman","JANE KAT","jane kat"]
[null,null,"Businessman","WILLIAM MARK","william mark"]
[null,null,"Doctor","MARK HENRY","mark henry"]
[null,null,"Lawyer","KEVIN PIETERSON","kevin pieterson"]
[null,"Range Rover","Lawyer","JASON GOLD","jason gold"]
[null,null,"Cricketer","HARRY DSUJA","harry dsuja"]
[null,null,"Actor","NICOLAS TOM","nicolas tom"]
[null,"Marcedes Benz","Engineer","ROB BILLY","rob billy"]
[null,null,"Businessman","JIMMY HARDER","jimmy harder"]
[null,null,"Businessman","TOM PAIN","tom pain"]
[null,null,"Doctor","STEVE SMITH","steve smith"]

{"sheet":"VBA","index":5,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[4,1,7,1],[8,1,10,1],[11,1,14,1]]}
[]
[null,"Applying VBA"]
[]
[null,"Car Brand","User Profession","Name in Uppercase","Name in Lowercase"]
[null,"Audi","Businessman","JANE KAT","jane kat"]
[null,null,"Businessman","WILLIAM MARK","william mark"]
[null,null,"Doctor","MARK HENRY","mark henry"]
[null,null,"Lawyer","KEVIN PIETERSON","kevin pieterson"]
[null,"Range Rover","Lawyer","JASON GOLD","jason gold"]
[null,null,"Cricketer","HARRY DSUJA","harry dsuja"]
[null,null,"Actor","NICOLAS TOM","nicolas tom"]
[null,"Marcedes Benz","Engineer","ROB BILLY","rob billy"]
[null,null,"Businessman","JIMMY HARDER","jimmy harder"]
[null,null,"Businessman","TOM PAIN","tom pain"]
[null,null,"Doctor","STEVE SMITH","steve smith"]

{"sheet":"Microsoft Word","index":6,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[4,1,7,1],[8,1,10,1],[11,1,14,1]]}
[]
[null,"Using Microsoft Word"]
[]
[null,"Car Brand","User Profession","Name in Uppercase","Name in Lowercase"]
[null,"Audi","Businessman","JANE KAT","jane kat"]
[null,null,"Businessman","WILLIAM MARK","william mark"]
[null,null,"Doctor","MARK HENRY","mark henry"]
[null,null,"Lawyer","KEVIN PIETERSON","kevin pieterson"]
[null,"Range Rover","Lawyer","JASON GOLD","jason gold"]
[null,null,"Cricketer","HARRY DSUJA","harry dsuja"]
[null,null,"Actor","NICOLAS TOM","nicolas tom"]
[null,"Marcedes Benz","Engineer","ROB BILLY","rob billy"]
[null,null,"Businessman","JIMMY HARDER","jimmy harder"]
[null,null,"Businessman","TOM PAIN","tom pain"]
[null,null,"Doctor","STEVE SMITH","steve smith"]

{"sheet":"Data Validation","index":7,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[4,1,7,1],[8,1,10,1],[11,1,14,1]]}
[]
[null,"Use of Data Validation Feature"]
[]
[null,"Car Brand","User Profession","Name in Uppercase","Name in Lowercase"]
[null,"Audi","Businessman","JANE KAT","jane kat"]
[null,null,"Businessman","WILLIAM MARK","william mark"]
[null,null,"Doctor","MARK HENRY","mark henry"]
[null,null,"Lawyer","KEVIN PIETERSON","kevin pieterson"]
[null,"Range Rover","Lawyer","JASON GOLD","jason gold"]
[null,null,"Cricketer","HARRY DSUJA","harry dsuja"]
[null,null,"Actor","NICOLAS TOM","nicolas tom"]
[null,"Marcedes Benz","Engineer","ROB BILLY","rob billy"]
[null,null,"Businessman","JIMMY HARDER","jimmy harder"]
[null,null,"Businessman","TOM PAIN","tom pain"]
[null,null,"Doctor","STEVE SMITH","steve smith"]

{"sheet":"Sheet4","index":8,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of Power Query"]
[]
[null,"Car Brand","User Profession","Name in Uppercase"]
[null,"Audi","Businessman","JANE KAT"]
[null,null,"Businessman","WILLIAM MARK"]
[null,null,"Doctor","MARK HENRY"]
[null,null,"Lawyer","KEVIN PIETERSON"]
[null,"Range Rover","Lawyer","JASON GOLD"]
[null,null,"Cricketer","HARRY DSUJA"]
[null,null,"Actor","NICOLAS TOM"]
[null,"Marcedes Benz","Engineer","ROB BILLY"]
[null,null,"Businessman","JIMMY HARDER"]
[null,null,"Businessman","TOM PAIN"]
[null,null,"Doctor","STEVE SMITH"]

{"sheet":"Table2","index":9,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Car Brand","Profession","Name in Uppercase","lowercase"]
["Audi","Businessman","JANE KAT","jane kat"]
[null,"Businessman","WILLIAM MARK","william mark"]
[null,"Doctor","MARK HENRY","mark henry"]
[null,"Lawyer","KEVIN PIETERSON","kevin pieterson"]
["Range Rover","Lawyer","JASON GOLD","jason gold"]
[null,"Cricketer","HARRY DSUJA","harry dsuja"]
[null,"Actor","NICOLAS TOM","nicolas tom"]
["Marcedes Benz","Engineer","ROB BILLY","rob billy"]
[null,"Businessman","JIMMY HARDER","jimmy harder"]
[null,"Businessman","TOM PAIN","tom pain"]
[null,"Doctor","STEVE SMITH","steve smith"]

{"sheet":"Proper Case","index":10,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[4,1,7,1],[8,1,10,1],[11,1,14,1]]}
[]
[null,"Converting Upper Case to Proper Case"]
[]
[null,"Car Brand","User Profession","Name in Uppercase","Name in Propercase"]
[null,"Audi","Businessman","JANE KAT",{"$f":"PROPER(D5)","v":"Jane Kat"}]
[null,null,"Businessman","WILLIAM MARK",{"$f":"PROPER(D6)","v":"William Mark"}]
[null,null,"Doctor","MARK HENRY","Mark Henry"]
[null,null,"Lawyer","KEVIN PIETERSON","Kevin Pieterson"]
[null,"Range Rover","Lawyer","JASON GOLD","Jason Gold"]
[null,null,"Cricketer","HARRY DSUJA","Harry Dsuja"]
[null,null,"Actor","NICOLAS TOM","Nicolas Tom"]
[null,"Marcedes Benz","Engineer","ROB BILLY","Rob Billy"]
[null,null,"Businessman","JIMMY HARDER","Jimmy Harder"]
[null,null,"Businessman","TOM PAIN","Tom Pain"]
[null,null,"Doctor","STEVE SMITH","Steve Smith"]

{"sheet":"Upper Case","index":11,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[4,1,7,1],[8,1,10,1],[11,1,14,1]]}
[]
[null,"Changing Lower Case to Upper Case"]
[]
[null,"Car Brand","User Profession","Name in Lowercase","Name in Uppercase"]
[null,"Audi","Businessman","Jane Kat",{"$f":"UPPER(D5)","v":"JANE KAT"}]
[null,null,"Businessman","William Mark",{"$f":"UPPER(D6)","v":"WILLIAM MARK"}]
[null,null,"Doctor","Mark Henry","MARK HENRY",null,null,null,null,"L"]
[null,null,"Lawyer","Kevin Pieterson","KEVIN PIETERSON"]
[null,"Range Rover","Lawyer","Jason Gold","JASON GOLD"]
[null,null,"Cricketer","Harry Dsuja","HARRY DSUJA"]
[null,null,"Actor","Nicolas Tom","NICOLAS TOM"]
[null,"Marcedes Benz","Engineer","Rob Billy","ROB BILLY"]
[null,null,"Businessman","Jimmy Harder","JIMMY HARDER"]
[null,null,"Businessman","Tom Pain","TOM PAIN"]
[null,null,"Doctor","Steve Smith","STEVE SMITH"]