{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Sheet1","CHAR Function-252","CHAR Function-254","UNICHAR Function","Excel Symbol Option","Keyboard Shortcut","Conditional Formatting","AutoCorrect Option","VBA Macro-1","VBA Macro-2","Counting CheckMarks","Formatting CheckMarks","Data Validation","Deleting CheckMarks","Practice Section"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Sheet1","index":0,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Sample Dataset"]
[]
[null,"Company","Revenue","Net Income","Gross Margin","EBITDA","Audited"]
[null,"Amazon",386100,21300,0.42100000000000004,50200,"Yes"]
[null,"Coca-Cola",33000,8700,0.62,12300,"Yes"]
[null,"Tesla",31500,1100,0.21899999999999997,5500,"Yes"]
[null,"Pfizer",51800,7800,0.78599999999999992,14500,"Yes"]
[null,"Acme Inc",50200,8100,0.36899999999999999,12700,"No"]
[null,"Toyota",249900,16400,0.19800000000000001,28200,"Yes"]
[null,"BP",183700,4000,0.34200000000000003,14400,"Yes"]
[null,"Volkswagen",290200,13900,0.20899999999999999,28700,"Yes"]
[null,"ABC Corp",92100,10500,0.51200000000000001,20300,"No"]
[null,"Apple",365700,57400,0.38400000000000001,81400,"Yes"]
[null,"XYZ Company",25600,2300,0.44500000000000001,4900,"No"]

{"sheet":"CHAR Function-252","index":1,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using Character Code in CHAR Function with Font Style Wingdings"]
[]
[null,"Company","Revenue","Net Income","Gross Margin","EBITDA","Audited"]
[null,"Amazon",386100,21300,0.42100000000000004,50200,{"$f":"CHAR(252)","v":"ü"}]
[null,"Coca-Cola",33000,8700,0.62,12300,{"$f":"CHAR(252)","v":"ü"}]
[null,"Tesla",31500,1100,0.21899999999999997,5500,"ü"]
[null,"Pfizer",51800,7800,0.78599999999999992,14500,"ü"]
[null,"Acme Inc",50200,8100,0.36899999999999999,12700,{"$f":"CHAR(251)","v":"û"}]
[null,"Toyota",249900,16400,0.19800000000000001,28200,"ü"]
[null,"BP",183700,4000,0.34200000000000003,14400,"ü"]
[null,"Volkswagen",290200,13900,0.20899999999999999,28700,"ü"]
[null,"ABC Corp",92100,10500,0.51200000000000001,20300,{"$f":"CHAR(251)","v":"û"}]
[null,"Apple",365700,57400,0.38400000000000001,81400,"ü"]
[null,"XYZ Company",25600,2300,0.44500000000000001,4900,{"$f":"CHAR(251)","v":"û"}]

{"sheet":"CHAR Function-254","index":2,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using Character Code in CHAR Function to Insert Check Mark"]
[]
[null,"Company","Revenue","Net Income","Gross Margin","EBITDA","Audited"]
[null,"Amazon",386100,21300,0.42100000000000004,50200,{"$f":"IF(F5>12000,CHAR(254),CHAR(253))","v":"þ"}]
[null,"Coca-Cola",33000,8700,0.62,12300,{"$f":"IF(F6>12000,CHAR(254),CHAR(253))","v":"þ"}]
[null,"Tesla",31500,1100,0.21899999999999997,15500,"þ"]
[null,"Pfizer",51800,7800,0.78599999999999992,14500,"þ"]
[null,"Acme Inc",50200,8100,0.36899999999999999,11700,"ý"]
[null,"Toyota",249900,16400,0.19800000000000001,28200,"þ"]
[null,"BP",183700,4000,0.34200000000000003,14400,"þ"]
[null,"Volkswagen",290200,13900,0.20899999999999999,28700,"þ"]
[null,"ABC Corp",92100,10500,0.51200000000000001,2030,"ý"]
[null,"Apple",365700,57400,0.38400000000000001,81400,"þ"]
[null,"XYZ Company",25600,2300,0.44500000000000001,4900,"ý"]

{"sheet":"UNICHAR Function","index":3,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Using Character Code in UNICHAR Function to Insert Check Mark"]
[]
[null,"Company","Revenue","Net Income","Gross Margin","EBITDA","Audited (Check Mark)","Audited (Tick Mark)"]
[null,"Amazon",386100,21300,0.42100000000000004,50200,{"$f":"_xlfn.UNICHAR(254)","v":"þ"},{"$f":"_xlfn.UNICHAR(252)","v":"ü"}]
[null,"Coca-Cola",33000,8700,0.62,12300,{"$f":"_xlfn.UNICHAR(254)","v":"þ"},{"$f":"_xlfn.UNICHAR(252)","v":"ü"}]
[null,"Tesla",31500,1100,0.21899999999999997,5500,"þ","ü"]
[null,"Pfizer",51800,7800,0.78599999999999992,14500,"þ","ü"]
[null,"Acme Inc",50200,8100,0.36899999999999999,12700,{"$f":"_xlfn.UNICHAR(253)","v":"ý"},{"$f":"_xlfn.UNICHAR(251)","v":"û"}]
[null,"Toyota",249900,16400,0.19800000000000001,28200,"þ","ü"]
[null,"BP",183700,4000,0.34200000000000003,14400,"þ","ü"]
[null,"Volkswagen",290200,13900,0.20899999999999999,28700,"þ","ü"]
[null,"ABC Corp",92100,10500,0.51200000000000001,20300,{"$f":"_xlfn.UNICHAR(253)","v":"ý"},{"$f":"_xlfn.UNICHAR(251)","v":"û"}]
[null,"Apple",365700,57400,0.38400000000000001,81400,"þ","ü"]
[null,"XYZ Company",25600,2300,0.44500000000000001,4900,{"$f":"_xlfn.UNICHAR(253)","v":"ý"},{"$f":"_xlfn.UNICHAR(251)","v":"û"}]

{"sheet":"Excel Symbol Option","index":4,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Inserting Check Mark from Excel Symbol Option"]
[]
[null,"Company","Revenue","Net Income","Gross Margin","EBITDA","Audited (Check Mark)","Audited (Tick Mark)"]
[null,"Amazon",386100,21300,0.42100000000000004,50200,"þ","ü","Font Wingdings, Code 252"]
[null,"Coca-Cola",33000,8700,0.62,12300,"þ","P","Font Wingdings 2, Code 80"]
[null,"Tesla",31500,1100,0.21899999999999997,5500,"þ"]
[null,"Pfizer",51800,7800,0.78599999999999992,14500,"þ"]
[null,"Acme Inc",50200,8100,0.36899999999999999,12700,"ý"]
[null,"Toyota",249900,16400,0.19800000000000001,28200,"þ"]
[null,"BP",183700,4000,0.34200000000000003,14400,"þ"]
[null,"Volkswagen",290200,13900,0.20899999999999999,28700,"þ"]
[null,"ABC Corp",92100,10500,0.51200000000000001,20300,"ý"]
[null,"Apple",365700,57400,0.38400000000000001,81400,"þ"]
[null,"XYZ Company",25600,2300,0.44500000000000001,4900,"ý"]

{"sheet":"Keyboard Shortcut","index":5,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using Keyboard Shortcut to Insert Check Mark"]
[]
[null,"Company","Revenue","Net Income","Gross Margin","EBITDA","Audited"]
[null,"Amazon",386100,21300,0.42100000000000004,50200,"P"]
[null,"Coca-Cola",33000,8700,0.62,12300,"P","Wingdings 2, Shift+P"]
[null,"Tesla",31500,1100,0.21899999999999997,5500,"P"]
[null,"Pfizer",51800,7800,0.78599999999999992,14500,"P"]
[null,"Acme Inc",50200,8100,0.36899999999999999,12700,"O"]
[null,"Toyota",249900,16400,0.19800000000000001,28200,"P"]
[null,"BP",183700,4000,0.34200000000000003,14400,"P"]
[null,"Volkswagen",290200,13900,0.20899999999999999,28700,"P"]
[null,"ABC Corp",92100,10500,0.51200000000000001,20300,"O"]
[null,"Apple",365700,57400,0.38400000000000001,81400,"P"]
[null,"XYZ Company",25600,2300,0.44500000000000001,4900,"O"]

{"sheet":"Conditional Formatting","index":6,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Use of Conditional Formatting to Insert Check Mark with Character Code"]
[]
[null,"Company","Revenue","Net Income","Gross Margin","EBITDA","Audited"]
[null,"Amazon",386100,21300,0.42100000000000004,50200,{"$f":"IF(F5>12000,CHAR(80),CHAR(81))","v":"P"}]
[null,"Coca-Cola",33000,8700,0.62,12300,{"$f":"IF(F6>12000,CHAR(80),CHAR(81))","v":"P"}]
[null,"Tesla",31500,1100,0.21899999999999997,15500,"P"]
[null,"Pfizer",51800,7800,0.78599999999999992,14500,"P"]
[null,"Acme Inc",50200,8100,0.36899999999999999,11700,"Q"]
[null,"Toyota",249900,16400,0.19800000000000001,28200,"P"]
[null,"BP",183700,4000,0.34200000000000003,14400,"P"]
[null,"Volkswagen",290200,13900,0.20899999999999999,28700,"P"]
[null,"ABC Corp",92100,10500,0.51200000000000001,10300,"Q"]
[null,"Apple",365700,57400,0.38400000000000001,81400,"P"]
[null,"XYZ Company",25600,2300,0.44500000000000001,4900,"Q"]

{"sheet":"AutoCorrect Option","index":7,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using Excel's AutoCorrect Option to Insert Check Mark"]
[]
[null,"Company","Revenue","Net Income","Gross Margin","EBITDA","Audited"]
[null,"Amazon",386100,21300,0.42100000000000004,50200,"✓"]
[null,"Coca-Cola",33000,8700,0.62,12300,"✓"]
[null,"Tesla",31500,1100,0.21899999999999997,5500,"✓"]
[null,"Pfizer",51800,7800,0.78599999999999992,14500,"✓"]
[null,"Acme Inc",50200,8100,0.36899999999999999,12700]
[null,"Toyota",249900,16400,0.19800000000000001,28200,"✓"]
[null,"BP",183700,4000,0.34200000000000003,14400,"✓"]
[null,"Volkswagen",290200,13900,0.20899999999999999,28700,"✓"]
[null,"ABC Corp",92100,10500,0.51200000000000001,20300]
[null,"Apple",365700,57400,0.38400000000000001,81400,"✓"]
[null,"XYZ Company",25600,2300,0.44500000000000001,4900]

{"sheet":"VBA Macro-1","index":8,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using VBA Macro to Insert Check Mark"]
[]
[null,"Company","Revenue","Net Income","Gross Margin","EBITDA","Audited"]
[null,"Amazon",386100,21300,0.42100000000000004,50200,"ü"]
[null,"Coca-Cola",33000,8700,0.62,12300,"ü"]
[null,"Tesla",31500,1100,0.21899999999999997,5500,"ü"]
[null,"Pfizer",51800,7800,0.78599999999999992,14500,"ü"]
[null,"Acme Inc",50200,8100,0.36899999999999999,12700,"û"]
[null,"Toyota",249900,16400,0.19800000000000001,28200,"ü"]
[null,"BP",183700,4000,0.34200000000000003,14400,"ü"]
[null,"Volkswagen",290200,13900,0.20899999999999999,28700,"ü"]
[null,"ABC Corp",92100,10500,0.51200000000000001,20300,"û"]
[null,"Apple",365700,57400,0.38400000000000001,81400,"ü"]
[null,"XYZ Company",25600,2300,0.44500000000000001,4900,"û"]

{"sheet":"VBA Macro-2","index":9,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using VBA Macro to Insert Check Mark"]
[]
[null,"Company","Revenue","Net Income","Gross Margin","EBITDA","Audited"]
[null,"Amazon",386100,21300,0.42100000000000004,50200,"ü"]
[null,"Coca-Cola",33000,8700,0.62,12300,"ü"]
[null,"Tesla",31500,1100,0.21899999999999997,5500,"ü"]
[null,"Pfizer",51800,7800,0.78599999999999992,14500,"ü"]
[null,"Acme Inc",50200,8100,0.36899999999999999,12700]
[null,"Toyota",249900,16400,0.19800000000000001,28200,"ü"]
[null,"BP",183700,4000,0.34200000000000003,14400,"ü"]
[null,"Volkswagen",290200,13900,0.20899999999999999,28700,"ü"]
[null,"ABC Corp",92100,10500,0.51200000000000001,20300]
[null,"Apple",365700,57400,0.38400000000000001,81400,"ü"]
[null,"XYZ Company",25600,2300,0.44500000000000001,4900]

{"sheet":"Counting CheckMarks","index":10,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,6],[16,4,16,5]]}
[]
[null,"Counting Check Marks with COUNTIF Function"]
[]
[null,"Company","Revenue","Net Income","Gross Margin","EBITDA","Audited"]
[null,"Amazon",386100,21300,0.42100000000000004,50200,{"$f":"CHAR(252)","v":"ü"}]
[null,"Coca-Cola",33000,8700,0.62,12300,{"$f":"CHAR(252)","v":"ü"}]
[null,"Tesla",31500,1100,0.21899999999999997,5500,"ü"]
[null,"Pfizer",51800,7800,0.78599999999999992,14500,"ü"]
[null,"Acme Inc",50200,8100,0.36899999999999999,12700,{"$f":"CHAR(251)","v":"û"}]
[null,"Toyota",249900,16400,0.19800000000000001,28200,"ü"]
[null,"BP",183700,4000,0.34200000000000003,14400,"ü"]
[null,"Volkswagen",290200,13900,0.20899999999999999,28700,"ü"]
[null,"ABC Corp",92100,10500,0.51200000000000001,20300,{"$f":"CHAR(251)","v":"û"}]
[null,"Apple",365700,57400,0.38400000000000001,81400,"ü"]
[null,"XYZ Company",25600,2300,0.44500000000000001,4900,{"$f":"CHAR(251)","v":"û"}]
[]
[null,null,null,null,"Total Audited Company",null,{"$f":"COUNTIF(G5:G15,CHAR(252))","v":8}]

{"sheet":"Formatting CheckMarks","index":11,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Formatting Check Marks"]
[]
[null,"Company","Revenue","Net Income","Gross Margin","EBITDA","Audited"]
[null,"Amazon",386100,21300,0.42100000000000004,50200,{"$f":"CHAR(252)","v":"ü"}]
[null,"Coca-Cola",33000,8700,0.62,12300,{"$f":"CHAR(252)","v":"ü"}]
[null,"Tesla",31500,1100,0.21899999999999997,5500,"ü"]
[null,"Pfizer",51800,7800,0.78599999999999992,14500,"ü"]
[null,"Acme Inc",50200,8100,0.36899999999999999,12700,{"$f":"CHAR(251)","v":"û"}]
[null,"Toyota",249900,16400,0.19800000000000001,28200,"ü"]
[null,"BP",183700,4000,0.34200000000000003,14400,"ü"]
[null,"Volkswagen",290200,13900,0.20899999999999999,28700,"ü"]
[null,"ABC Corp",92100,10500,0.51200000000000001,20300,{"$f":"CHAR(251)","v":"û"}]
[null,"Apple",365700,57400,0.38400000000000001,81400,"ü"]
[null,"XYZ Company",25600,2300,0.44500000000000001,4900,{"$f":"CHAR(251)","v":"û"}]

{"sheet":"Data Validation","index":12,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Applying Data Validation to Insert Check Mark"]
[]
[null,"Company","Revenue","Net Income","Gross Margin","EBITDA","Audited"]
[null,"Amazon",386100,21300,0.42100000000000004,50200,"✓"]
[null,"Coca-Cola",33000,8700,0.62,12300,"✓"]
[null,"Tesla",31500,1100,0.21899999999999997,5500,"✓"]
[null,"Pfizer",51800,7800,0.78599999999999992,14500,"✓"]
[null,"Acme Inc",50200,8100,0.36899999999999999,12700,"✖"]
[null,"Toyota",249900,16400,0.19800000000000001,28200,"✓"]
[null,"BP",183700,4000,0.34200000000000003,14400,"✓"]
[null,"Volkswagen",290200,13900,0.20899999999999999,28700,"✓"]
[null,"ABC Corp",92100,10500,0.51200000000000001,20300,"✖"]
[null,"Apple",365700,57400,0.38400000000000001,81400,"✓"]
[null,"XYZ Company",25600,2300,0.44500000000000001,4900,"✖"]
[]
[null,"Cross Symbol","✖"]
[null,"Check Mark","✓"]

{"sheet":"Deleting CheckMarks","index":13,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Removing Check Marks"]
[]
[null,"Company","Revenue","Net Income","Gross Margin","EBITDA","Audited"]
[null,"Amazon",386100,21300,0.42100000000000004,50200,{"$f":"CHAR(252)","v":"ü"}]
[null,"Coca-Cola",33000,8700,0.62,12300]
[null,"Tesla",31500,1100,0.21899999999999997,5500,{"$f":"CHAR(252)","v":"ü"}]
[null,"Pfizer",51800,7800,0.78599999999999992,14500,"ü"]
[null,"Acme Inc",50200,8100,0.36899999999999999,12700]
[null,"Toyota",249900,16400,0.19800000000000001,28200,"ü"]
[null,"BP",183700,4000,0.34200000000000003,14400,"ü"]
[null,"Volkswagen",290200,13900,0.20899999999999999,28700,"ü"]
[null,"ABC Corp",92100,10500,0.51200000000000001,20300]
[null,"Apple",365700,57400,0.38400000000000001,81400,"ü"]
[null,"XYZ Company",25600,2300,0.44500000000000001,4900,{"$f":"CHAR(251)","v":"û"}]

{"sheet":"Practice Section","index":14,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Do It Yourself"]
[]
[null,"Company","Revenue","Net Income","Gross Margin","EBITDA","Audited"]
[null,"Amazon",386100,21300,0.42100000000000004,50200]
[null,"Coca-Cola",33000,8700,0.62,12300]
[null,"Tesla",31500,1100,0.21899999999999997,5500]
[null,"Pfizer",51800,7800,0.78599999999999992,14500]
[null,"Acme Inc",50200,8100,0.36899999999999999,12700]
[null,"Toyota",249900,16400,0.19800000000000001,28200]
[null,"BP",183700,4000,0.34200000000000003,14400]
[null,"Volkswagen",290200,13900,0.20899999999999999,28700]
[null,"ABC Corp",92100,10500,0.51200000000000001,20300]
[null,"Apple",365700,57400,0.38400000000000001,81400]
[null,"XYZ Company",25600,2300,0.44500000000000001,4900]