{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Cover","Accounting Style","Accounting Style (an)","Column W","Column W (an)","Wrap Text","Wrap Text (an)","Table","Table (an)","Cell","Cell (an)","CF","CF (an)","HW==>>","HW(1)","HW(1an)","HW(2)","HW(2an)"],"not_rendered":{"charts":0,"images":3,"macros":0,"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":"Cover","index":0,"n_rows":11,"n_cols":16,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Excel Basics 17: Style Formatting: By Hand, Cell, Table & Conditional Formatting"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Examples:",null,null,"Office 2016 Video #29"]
[null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"'Accounting Style (an)'!A1","v":"Example 1: Accounting Style Formatting"}]
[null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"'Accounting Style (an)'!G1","v":"Example 2: Accounting Borders"}]
[null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"'Column W'!A1","v":"Example 3: Column widths!!"}]
[null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"'Wrap Text'!A1","v":"Example 4: Wrap Text in Cell: Multiple Lines in a Cell"}]
[null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"'Table (an)'!A1","v":"Example 5: Table Format button (Converts to Excel table)"}]
[null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"'Cell (an)'!A1","v":"Example 6: Cell Styles"}]
[null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"'CF (an)'!A1","v":"Example 7: Built-in Conditional Formatting to Visualize Data"}]

{"sheet":"Accounting Style","index":1,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Example 1: Accounting Style Formatting",null,null,null,null,null,"Example 2: Accounting Borders"]
[]
[null,"Jan","Feb","Mar","Apr"]
["Net Sales",5689,2569,6587,8700]
["Operating Expenses",1801.15,2099.15,4100.3,4245,null,"Date","Check #","Description","Deduction","Addition","Balance"]
["Administrating Expenses",537.79999999999995,513.80000000000007,1617.4,1740,null,"2013-10-01",null,null,null,null,5000.5]
["Other",253.35,385.34999999999997,{"$f":"D4-D5-D6","v":869.29999999999973},1305,null,"2013-10-03",2150,"Pay Rent",500,null,{"$f":"IF(G7<>\"\",L6+K7-J7,\"\")","v":4500.5}]
["Total Expenses",{"$f":"SUM(B5:B7)","v":2592.2999999999997},2998.3,6587,7290,null,"2013-10-03","ATM124","withdraw",120,null,4380.5]
["Net Income",{"$f":"B4-B8","v":3096.7000000000003},-429.30000000000018,0,1410,null,"2013-10-04",null,"Rev",null,654.25,5034.75]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"or",null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Jan","Feb","Mar","Apr"]
["Net Sales",5689,2569,6587,8700]
["Operating Expenses",1801.15,2099.15,4100.3,4245]
["Administrating Expenses",537.79999999999995,513.80000000000007,1617.4,1740]
["Other",253.35,385.34999999999997,{"$f":"D14-D15-D16","v":869.29999999999973},1305]
["Total Expenses",{"$f":"SUM(B15:B17)","v":2592.2999999999997},2998.3,6587,7290]
["Net Income",{"$f":"B14-B18","v":3096.7000000000003},-429.30000000000018,0,1410]
[]
[null,null,"or"]
[]
[null,"Jan","Feb","Mar","Apr"]
["Net Sales",5689,2569,6587,8700]
["Operating Expenses",1801.15,2099.15,4100.3,4245]
["Administrating Expenses",537.79999999999995,513.80000000000007,1617.4,1740]
["Other",253.35,385.34999999999997,{"$f":"D24-D25-D26","v":869.29999999999973},1305]
["Total Expenses",{"$f":"SUM(B25:B27)","v":2592.2999999999997},2998.3,6587,7290]
["Net Income",{"$f":"B24-B28","v":3096.7000000000003},-429.30000000000018,0,1410]
[]
[null,null,"or"]
[]
[null,"Jan","Feb","Mar","Apr"]
["Net Sales",5689,2569,6587,8700]
["Operating Expenses",1801.15,2099.15,4100.3,4245]
["Administrating Expenses",537.79999999999995,513.80000000000007,1617.4,1740]
["Other",253.35,385.34999999999997,{"$f":"D34-D35-D36","v":869.29999999999973},1305]
["Total Expenses",{"$f":"SUM(B35:B37)","v":2592.2999999999997},2998.3,6587,7290]
["Net Income",{"$f":"B34-B38","v":3096.7000000000003},-429.30000000000018,0,1410]

{"sheet":"Accounting Style (an)","index":2,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Example 1: Accounting Style Formatting",null,null,null,null,null,"Example 2: Accounting Borders"]
[]
[null,"Jan","Feb","Mar","Apr"]
["Net Sales",5689,2569,6587,8700]
["Operating Expenses",1801.15,2099.15,4100.3,4245,null,"Date","Check #","Description","Deduction","Addition","Balance"]
["Administrating Expenses",537.79999999999995,513.80000000000007,1617.4,1740,null,"2013-10-01",null,null,null,null,5000.5]
["Other",253.35,385.34999999999997,{"$f":"D4-D5-D6","v":869.29999999999973},1305,null,"2013-10-03",2150,"Pay Rent",500,null,{"$f":"IF(G7<>\"\",L6+K7-J7,\"\")","v":4500.5}]
["Total Expenses",{"$f":"SUM(B5:B7)","v":2592.2999999999997},2998.3,6587,7290,null,"2013-10-03","ATM124","withdraw",120,null,4380.5]
["Net Income",{"$f":"B4-B8","v":3096.7000000000003},-429.30000000000018,0,1410,null,"2013-10-04",null,"Rev",null,654.25,5034.75]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"or",null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Jan","Feb","Mar","Apr"]
["Net Sales",5689,2569,6587,8700]
["Operating Expenses",1801.15,2099.15,4100.3,4245]
["Administrating Expenses",537.79999999999995,513.80000000000007,1617.4,1740]
["Other",253.35,385.34999999999997,{"$f":"D14-D15-D16","v":869.29999999999973},1305]
["Total Expenses",{"$f":"SUM(B15:B17)","v":2592.2999999999997},2998.3,6587,7290]
["Net Income",{"$f":"B14-B18","v":3096.7000000000003},-429.30000000000018,0,1410]
[]
[null,null,"or"]
[]
[null,"Jan","Feb","Mar","Apr"]
["Net Sales",5689,2569,6587,8700]
["Operating Expenses",1801.15,2099.15,4100.3,4245]
["Administrating Expenses",537.79999999999995,513.80000000000007,1617.4,1740]
["Other",253.35,385.34999999999997,{"$f":"D24-D25-D26","v":869.29999999999973},1305]
["Total Expenses",{"$f":"SUM(B25:B27)","v":2592.2999999999997},2998.3,6587,7290]
["Net Income",{"$f":"B24-B28","v":3096.7000000000003},-429.30000000000018,0,1410]
[]
[null,null,"or"]
[]
[null,"Jan","Feb","Mar","Apr"]
["Net Sales",5689,2569,6587,8700]
["Operating Expenses",1801.15,2099.15,4100.3,4245]
["Administrating Expenses",537.79999999999995,513.80000000000007,1617.4,1740]
["Other",253.35,385.34999999999997,{"$f":"D34-D35-D36","v":869.29999999999973},1305]
["Total Expenses",{"$f":"SUM(B35:B37)","v":2592.2999999999997},2998.3,6587,7290]
["Net Income",{"$f":"B34-B38","v":3096.7000000000003},-429.30000000000018,0,1410]

{"sheet":"Column W","index":3,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Example 3: Column widths!!"]
[]
[]
["Date","Product","Sales"]
["2013-10-29","Flying Eagle",13490]
["2013-10-29","Smooth Arch",9077]
["2013-10-29","Flying Eagle",10167]
["2013-10-29","Flying Eagle",13248]
["2013-10-29","Smooth Arch",6360]
["2013-10-29","Smooth Arch",11740]
["2013-10-29","Flying Eagle",5325]

{"sheet":"Column W (an)","index":4,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Example 3: Column widths!!"]
[]
[]
["Date","Product","Sales"]
["2013-10-29","Flying Eagle",13490]
["2013-10-29","Smooth Arch",9077]
["2013-10-29","Flying Eagle",10167]
["2013-10-29","Flying Eagle",13248]
["2013-10-29","Smooth Arch",6360]
["2013-10-29","Smooth Arch",11740]
["2013-10-29","Flying Eagle",5325]

{"sheet":"Wrap Text","index":5,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Example 4: Wrap Text in Cell: Multiple Lines in a Cell"]
["1) While typing: Alt + Enter"]
["2) Command button in Alignment group in Home Ribbon Tab"]
[]
["Boomerang Product Name","Employee Name","Sales Amount"]
["Majestic Beaut","Jo",505]
["Delicate Arch Deluxe","Moe",657]
["Carlota Doublers","Sheliadawn",329]
["Majestic Beaut","Tina",618]
["Delicate Arch Deluxe","Tina",888]
["Delicate Arch Deluxe","Moe",138]
["Quad Freestyle","Sheliadawn",125]
["Quad Freestyle","Sheliadawn",238]

{"sheet":"Wrap Text (an)","index":6,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Example 4: Wrap Text in Cell: Multiple Lines in a Cell"]
["1) While typing: Alt + Enter"]
["2) Command button in Alignment group in Home Ribbon Tab"]
[]
["Boomerang\nProduct Name","Employee Name","Sales Amount"]
["Majestic Beaut","Jo",505]
["Delicate Arch Deluxe","Moe",657]
["Carlota Doublers","Sheliadawn",329]
["Majestic Beaut","Tina",618]
["Delicate Arch Deluxe","Tina",888]
["Delicate Arch Deluxe","Moe",138]
["Quad Freestyle","Sheliadawn",125]
["Quad Freestyle","Sheliadawn",238]
[]
[null,null,null,null,"Boomerang\nProduct"]

{"sheet":"Table","index":7,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Example 5: Table Format button (Converts to Excel table)"]
[]
[]
[]
["Date","Product","Sales"]
["2013-10-29","Flying Eagle",13490]
["2013-10-29","Smooth Arch",9077]
["2013-10-29","Flying Eagle",10167]
["2013-10-29","Flying Eagle",13248]
["2013-10-29","Smooth Arch",6360]
["2013-10-29","Smooth Arch",11740]
["2013-10-29","Flying Eagle",5325]

{"sheet":"Table (an)","index":8,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Example 5: Table Format button (Converts to Excel table)"]
[]
[]
[]
["Date","Product","Sales"]
["2013-10-29","Flying Eagle",13490]
["2013-10-29","Smooth Arch",9077]
["2013-10-29","Flying Eagle",10167]
["2013-10-29","Flying Eagle",13248]
["2013-10-29","Smooth Arch",6360]
["2013-10-29","Smooth Arch",11740]
["2013-10-29","Flying Eagle",5325]

{"sheet":"Cell","index":9,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Example 6: Cell Styles"]
["Great if you use thesame Style and Number formatting over and over"]
[]
[]
["Date","Product","Sales",null,"Boomerang Product","Employee Name","Sales Amount"]
["2013-10-29","Flying Eagle",13490,null,"Majestic Beaut","Jo",505]
["2013-10-29","Smooth Arch",9077,null,"Delicate Arch Deluxe","Moe",657]
["2013-10-29","Flying Eagle",10167,null,"Carlota Doublers","Sheliadawn",329]
["2013-10-29","Flying Eagle",13248,null,"Majestic Beaut","Tina",618]
["2013-10-29","Smooth Arch",6360,null,"Delicate Arch Deluxe","Tina",888]
["2013-10-29","Smooth Arch",11740,null,"Delicate Arch Deluxe","Moe",138]
["2013-10-29","Flying Eagle",5325,null,"Quad Freestyle","Sheliadawn",125]
[null,null,null,null,"Quad Freestyle","Sheliadawn",238]

{"sheet":"Cell (an)","index":10,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Example 6: Cell Styles"]
["Great if you use thesame Style and Number formatting over and over"]
[]
[]
["Date","Product","Sales",null,"Boomerang Product","Employee Name","Sales Amount"]
["2013-10-29","Flying Eagle",13490,null,"Majestic Beaut","Jo",505]
["2013-10-29","Smooth Arch",9077,null,"Delicate Arch Deluxe","Moe",657]
["2013-10-29","Flying Eagle",10167,null,"Carlota Doublers","Sheliadawn",329]
["2013-10-29","Flying Eagle",13248,null,"Majestic Beaut","Tina",618]
["2013-10-29","Smooth Arch",6360,null,"Delicate Arch Deluxe","Tina",888]
["2013-10-29","Smooth Arch",11740,null,"Delicate Arch Deluxe","Moe",138]
["2013-10-29","Flying Eagle",5325,null,"Quad Freestyle","Sheliadawn",125]
[null,null,null,null,"Quad Freestyle","Sheliadawn",238]

{"sheet":"CF","index":11,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Example 7: Built-in Conditional Formatting to Visualize Data"]
[null,null,null,null,"Criteria",18000]
[]
["Data Bars",null,"Top 25%",null,{"$f":"\"Greater than \"&FIXED(F2,0)","v":"Greater than 18,000"},null,null,"Losses"]
[]
["Sales",null,"Sales",null,"Sales",null,"Stock","Buy Price","Price today","Quantity","Profit"]
[18000,null,18000,null,18000,null,"GOOG",755,1015,700,{"$f":"J7*(I7-H7)","v":182000}]
[19077,null,19077,null,19077,null,"GE",22,29.1,2200,15620.000000000004]
[10167,null,10167,null,10167,null,"KO",36,32.4,300,-1080.0000000000005]
[13248,null,13248,null,13248,null,"MSFT",36,36,4000,0]
[6360,null,6360,null,6360,null,"KK",51,42,700,-6300]
[11740,null,11740,null,11740,null,"SW",31,17,400,-5600]
[5325,null,5325,null,5325]
[7873,null,7873,null,7873]
[19043,null,19043,null,19043]
[12143,null,12143,null,12143]
[22300,null,22300,null,22300]
[10145,null,10145,null,10145]
[14309,null,14309,null,14309]

{"sheet":"CF (an)","index":12,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Example 7: Built-in Conditional Formatting to Visualize Data"]
[null,null,null,null,"Criteria",18000]
[]
["Data Bars",null,"Top 25%",null,{"$f":"\"Greater than \"&FIXED(F2,0)","v":"Greater than 18,000"},null,null,"Losses"]
[]
["Sales",null,"Sales",null,"Sales",null,"Stock","Buy Price","Price today","Quantity","Profit"]
[18000,null,18000,null,18000,null,"GOOG",755,1015,700,{"$f":"J7*(I7-H7)","v":182000}]
[19077,null,19077,null,19077,null,"GE",22,29.1,2200,15620.000000000004]
[10167,null,10167,null,10167,null,"KO",36,32.4,300,-1080.0000000000005]
[13248,null,13248,null,13248,null,"MSFT",36,36,4000,0]
[6360,null,6360,null,6360,null,"KK",51,42,700,-6300]
[11740,null,11740,null,11740,null,"SW",31,17,400,-5600]
[5325,null,5325,null,5325]
[7873,null,7873,null,7873]
[19043,null,19043,null,19043]
[12143,null,12143,null,12143]
[22300,null,22300,null,22300]
[10145,null,10145,null,10145]
[14309,null,14309,null,14309]

{"sheet":"HW==>>","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"HW(1)","index":14,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Add some Style and Number Formatting to this report. You can add the formatting that you would like."]
[]
[]
[null,"Jan","Feb","Mar","Apr"]
["Net Sales",5689,2569,6587,8700]
["Operating Expenses",1801.15,2099.15,4100.3,4245]
["Administrating Expenses",537.79999999999995,513.80000000000007,1617.4,1740]
["Other",253.35,385.34999999999997,{"$f":"D5-D6-D7","v":869.29999999999973},1305]
["Total Expenses",{"$f":"SUM(B6:B8)","v":2592.2999999999997},2998.3,6587,7290]
["Net Income",{"$f":"B5-B9","v":3096.7000000000003},-429.30000000000018,0,1410]

{"sheet":"HW(1an)","index":15,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Add some Style and Number Formatting to this report. You can add the formatting that you would like."]
[]
[]
[null,"Jan","Feb","Mar","Apr"]
["Net Sales",5689,2569,6587,8700]
["Operating Expenses",1801.15,2099.15,4100.3,4245]
["Administrating Expenses",537.79999999999995,513.80000000000007,1617.4,1740]
["Other",253.35,385.34999999999997,{"$f":"D5-D6-D7","v":869.29999999999973},1305]
["Total Expenses",{"$f":"SUM(B6:B8)","v":2592.2999999999997},2998.3,6587,7290]
["Net Income",{"$f":"B5-B9","v":3096.7000000000003},-429.30000000000018,0,1410]

{"sheet":"HW(2)","index":16,"n_rows":19,"n_cols":1,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Following Excel's Golden Rule, Add Conditionally Formatting so that Numbers Over $112,500 get the formatting."]
[]
[]
[]
[]
["Sales"]
[118000]
[119077]
[110167]
[113248]
[106360]
[111740]
[105325]
[107873]
[119043]
[112143]
[122300]
[110145]
[114309]

{"sheet":"HW(2an)","index":17,"n_rows":19,"n_cols":1,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Following Excel's Golden Rule, Add Conditionally Formatting so that Numbers Over $112,500 get the formatting."]
[]
["Hurdle:"]
[112500]
[]
["Sales"]
[118000]
[119077]
[110167]
[113248]
[106360]
[111740]
[105325]
[107873]
[119043]
[112143]
[122300]
[110145]
[114309]