{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["main","upper","Flash Fill","power query","DAX","VBA Pre selection","VBA Post Selection"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"main","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Change Lowercase to Uppercase"]
[]
[null,"Name","Car Maker"]
[null,"Joycelin Ongin","land rover"]
[null,"Norrie Strodder","pontiac"]
[null,"Tadio Batchelar","mercury"]
[null,"Kelcy Averill","buick"]
[null,"Peadar Nicholls","ford"]
[null,"Niki Goodale","volkswagen"]

{"sheet":"upper","index":1,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,8,1,10],[1,1,1,3]]}
[]
[null,"Using the UPPER function",null,null,null,null,null,null,"Practice"]
[]
[null,"Name","Car Maker (lowercase)","Car Maker (Uppercase)",null,null,null,null,"Name","Car Maker (lowercase)","Car Maker (Uppercase)"]
[null,"Joycelin Ongin","land rover",{"$f":"UPPER(C5)","v":"LAND ROVER"},null,null,null,null,"Joycelin Ongin","land rover"]
[null,"Norrie Strodder","pontiac",{"$f":"UPPER(C6)","v":"PONTIAC"},null,null,null,null,"Norrie Strodder","pontiac"]
[null,"Tadio Batchelar","mercury","MERCURY",null,null,null,null,"Tadio Batchelar","mercury"]
[null,"Kelcy Averill","buick","BUICK",null,null,null,null,"Kelcy Averill","buick"]
[null,"Peadar Nicholls","ford","FORD",null,null,null,null,"Peadar Nicholls","ford"]
[null,"Niki Goodale","volkswagen","VOLKSWAGEN",null,null,null,null,"Niki Goodale","volkswagen"]

{"sheet":"Flash Fill","index":2,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Utlizing the Flash Fill",null,null,null,null,null,null,null,"Practice"]
[]
[null,"Name","Car Maker (lowercase)","Car Maker (Uppercase)",null,null,null,null,null,"Name","Car Maker (lowercase)","Car Maker (Uppercase)"]
[null,"Joycelin Ongin","land rover","LAND ROVER",null,null,null,null,null,"Joycelin Ongin","land rover"]
[null,"Norrie Strodder","pontiac","PONTIAC",null,null,null,null,null,"Norrie Strodder","pontiac"]
[null,"Tadio Batchelar","mercury","MERCURY",null,null,null,null,null,"Tadio Batchelar","mercury"]
[null,"Kelcy Averill","buick","BUICK",null,null,null,null,null,"Kelcy Averill","buick"]
[null,"Peadar Nicholls","ford","FORD",null,null,null,null,null,"Peadar Nicholls","ford"]
[null,"Niki Goodale","volkswagen","VOLKSWAGEN",null,null,null,null,null,"Niki Goodale","volkswagen"]

{"sheet":"power query","index":3,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Using Power Query",null,null,null,null,"Practice"]
[]
[null,"Name","Car Maker",null,null,null,"Name","Car Maker"]
[null,"Joycelin Ongin","LAND ROVER",null,null,null,"Joycelin Ongin","land rover"]
[null,"Norrie Strodder","PONTIAC",null,null,null,"Norrie Strodder","pontiac"]
[null,"Tadio Batchelar","MERCURY",null,null,null,"Tadio Batchelar","mercury"]
[null,"Kelcy Averill","BUICK",null,null,null,"Kelcy Averill","buick"]
[null,"Peadar Nicholls","FORD",null,null,null,"Peadar Nicholls","ford"]
[null,"Niki Goodale","VOLKSWAGEN",null,null,null,"Niki Goodale","volkswagen"]
[]
[]
[null,"Name","Car Maker","UPPERCASE"]
[null,"Joycelin Ongin","land rover","LAND ROVER"]
[null,"Norrie Strodder","pontiac","PONTIAC"]
[null,"Tadio Batchelar","mercury","MERCURY"]
[null,"Kelcy Averill","buick","BUICK"]
[null,"Peadar Nicholls","ford","FORD"]
[null,"Niki Goodale","volkswagen","VOLKSWAGEN"]

{"sheet":"DAX","index":4,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Applying DAX Formula",null,null,null,"Practice"]
[]
[null,"Name","Car Maker (lowercase)","Car Maker (Uppercase)",null,"Name","Car Maker (lowercase)","Car Maker (Uppercase)"]
[null,"Kelcy Averill","buick","BUICK",null,"Joycelin Ongin","land rover"]
[null,"Peadar Nicholls","ford","FORD",null,"Norrie Strodder","pontiac"]
[null,"Joycelin Ongin","land rover","LAND ROVER",null,"Tadio Batchelar","mercury"]
[null,"Tadio Batchelar","mercury","MERCURY",null,"Kelcy Averill","buick"]
[null,"Norrie Strodder","pontiac","PONTIAC",null,"Peadar Nicholls","ford"]
[null,"Niki Goodale","volkswagen","VOLKSWAGEN",null,"Niki Goodale","volkswagen"]
[]
[null,"Row Labels","uppercase"]
[null,"buick","BUICK"]
[null,"ford","FORD"]
[null,"land rover","LAND ROVER"]
[null,"mercury","MERCURY"]
[null,"pontiac","PONTIAC"]
[null,"volkswagen","VOLKSWAGEN"]
[null,"Grand Total","LAND ROVER, PONTIAC, MERCURY, BUICK, FORD, VOLKSWAGEN"]

{"sheet":"VBA Pre selection","index":5,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Using VBA Ucase Function (Range Selection Before Running the Code)",null,null,null,null,"Practice"]
[]
[null,"Name","Car Maker",null,null,null,"Name","Car Maker"]
[null,"Joycelin Ongin","LAND ROVER",null,null,null,"Joycelin Ongin","land rover"]
[null,"Norrie Strodder","PONTIAC",null,null,null,"Norrie Strodder","pontiac"]
[null,"Tadio Batchelar","MERCURY",null,null,null,"Tadio Batchelar","mercury"]
[null,"Kelcy Averill","BUICK",null,null,null,"Kelcy Averill","buick"]
[null,"Peadar Nicholls","FORD",null,null,null,"Peadar Nicholls","ford"]
[null,"Niki Goodale","VOLKSWAGEN",null,null,null,"Niki Goodale","volkswagen"]

{"sheet":"VBA Post Selection","index":6,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Applying VBA Code (Selection After Running the Code)",null,null,null,null,null,null,"Practice"]
[]
[null,"Name","Car Maker",null,null,null,null,null,"Name","Car Maker (lowercase)"]
[null,"Joycelin Ongin","LAND ROVER",null,null,null,null,null,"Joycelin Ongin","land rover"]
[null,"Norrie Strodder","PONTIAC",null,null,null,null,null,"Norrie Strodder","pontiac"]
[null,"Tadio Batchelar","MERCURY",null,null,null,null,null,"Tadio Batchelar","mercury"]
[null,"Kelcy Averill","BUICK",null,null,null,null,null,"Kelcy Averill","buick"]
[null,"Peadar Nicholls","FORD",null,null,null,null,null,"Peadar Nicholls","ford"]
[null,"Niki Goodale","VOLKSWAGEN",null,null,null,null,null,"Niki Goodale","volkswagen"]