{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Cell Formatting","Error Checking","Text to Columns","Paste Special","VALUE Function","Multiply by One","Applying VBA","Power Query","Bulk Convert"],"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":"Cell Formatting","index":0,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Applying Cell Formatting",null,null,null,"Do Yourself"]
[]
[null,"Employee","Salary",null,null,"Employee","Salary"]
[null,"Adam","500",null,null,"Adam","500"]
[null,"Jhon","450",null,null,"Jhon","450"]
[null,"Justin","400",null,null,"Justin","400"]
[null,"Harry","500",null,null,"Harry","500"]
[null,"Alisa","550",null,null,"Alisa","550"]
[null,"Stuart","600",null,null,"Stuart","600"]

{"sheet":"Error Checking","index":1,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Using Error Checking ",null,null,"Do Yourself"]
[]
[null,"Employee","Salary",null,"Employee","Salary"]
[null,"Adam",500,null,"Adam","500"]
[null,"Jhon",450,null,"Jhon","450"]
[null,"Justin",400,null,"Justin","400"]
[null,"Harry",500,null,"Harry","500"]
[null,"Alisa",550,null,"Alisa","550"]
[null,"Stuart",600,null,"Stuart","600"]

{"sheet":"Text to Columns","index":2,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null," Using Text to Columns Option",null,null,"Do Yourself"]
[]
[null,"Employee","Salary",null,"Employee","Salary"]
[null,"Adam",500,null,"Adam","500"]
[null,"Jhon",450,null,"Jhon","450"]
[null,"Justin",400,null,"Justin","400"]
[null,"Harry",500,null,"Harry","500"]
[null,"Alisa",550,null,"Alisa","550"]
[null,"Stuart",600,null,"Stuart","600"]

{"sheet":"Paste Special","index":3,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null," Utilizing Paste Special Option",null,null,null,"Do Yourself"]
[]
[null,"Employee","Salary","Empty Cell",null,"Employee","Salary","Empty Cell"]
[null,"Adam",500,null,null,"Adam","500"]
[null,"Jhon",450,null,null,"Jhon","450"]
[null,"Justin",400,null,null,"Justin","400"]
[null,"Harry",500,null,null,"Harry","500"]
[null,"Alisa",550,null,null,"Alisa","550"]
[null,"Stuart",600,null,null,"Stuart","600"]

{"sheet":"VALUE Function","index":4,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Applying VALUE Function",null,null,null,"Do Yourself"]
[]
[null,"Employee","Salary","Converted to Numbers",null,"Employee","Salary","Converted to Numbers"]
[null,"Adam","500",{"$f":"VALUE(C5)","v":500},null,"Adam","500"]
[null,"Jhon","450",{"$f":"VALUE(C6)","v":450},null,"Jhon","450"]
[null,"Justin","400",400,null,"Justin","400"]
[null,"Harry","500",500,null,"Harry","500"]
[null,"Alisa","550",550,null,"Alisa","550"]
[null,"Stuart","600",600,null,"Stuart","600"]

{"sheet":"Multiply by One","index":5,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Multiplying by One ",null,null,null,"Do Yourself"]
[]
[null,"Employee","Salary","Converted to Number",null,"Employee","Salary","Converted to Numbers"]
[null,"Adam","500",{"$f":"C5*1","v":500},null,"Adam","500"]
[null,"Jhon","450",{"$f":"C6*1","v":450},null,"Jhon","450"]
[null,"Justin","400",400,null,"Justin","400"]
[null,"Harry","500",500,null,"Harry","500"]
[null,"Alisa","550",550,null,"Alisa","550"]
[null,"Stuart","600",600,null,"Stuart","600"]

{"sheet":"Applying VBA","index":6,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Applying VBA ",null,null,null,"Do Yourself"]
[]
[null,"Employee","Salary",null,null,"Employee","Salary"]
[null,"Adam",500,null,null,"Adam","500"]
[null,"Jhon",450,null,null,"Jhon","450"]
[null,"Justin",400,null,null,"Justin","400"]
[null,"Harry",500,null,null,"Harry","500"]
[null,"Alisa",550,null,null,"Alisa","550"]
[null,"Stuart",600,null,null,"Stuart","600"]

{"sheet":"Power Query","index":7,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Applying Power Query",null,null,"Do Yourself"]
[]
[null,"Employee","Salary",null,"Employee","Salary"]
[null,"Adam","500",null,"Adam","500"]
[null,"Jhon","450",null,"Jhon","450"]
[null,"Justin","400",null,"Justin","400"]
[null,"Harry","500",null,"Harry","500"]
[null,"Alisa","550",null,"Alisa","550"]
[null,"Stuart","600",null,"Stuart","600"]

{"sheet":"Bulk Convert","index":8,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Changing Cell Formatting to Bulk Convert Text to Number",null,null,null,null,"Do Yourself"]
[]
[null,"Employee","Salary","Emplty Cell",null,null,"Employee","Salary","Empty Cell"]
[null,"Adam",500,null,null,null,"Adam","500"]
[null,"Jhon",450,null,null,null,"Jhon","450"]
[null,"Justin",400,null,null,null,"Justin","400"]
[null,"Harry",500,null,null,null,"Harry","500"]
[null,"Alisa",550,null,null,null,"Alisa","550"]
[null,"Stuart",600,null,null,null,"Stuart","600"]