{"text_format":"1","workbook":"xlsx","n_sheets":28,"sheets":["Topics","Style Formatting","Style Formatting (an)","Number Formatting","Number Formatting (an)","ROUND","ROUND (an)","Formulas","Formulas (an)","Math","Math (an)","Entering Cell References","Entering Cell References (an)","FlashFill","FlashFill (an)","HW ==>>","HW(1)","HW(1an)","HW(2)","HW(2an)","HW(3)","HW(3an)","HW(4)","HW(4an)","HW(5)","HW(5an)","HW(6)","HW(6an)"],"not_rendered":{"charts":0,"images":5,"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":"Topics","index":0,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Topics","Office Video #","Excel Basics Video #"]
["Style Formatting",28,10]
["Number Formatting",29,11]
["ROUND Function",30,12]
["Formula Elements and Types",31,13]
["Math",32,14]
["Entering Cell References Into Formulas",33,15]
["Flash Fill (New in Excel 2013)",34,16]

{"sheet":"Style Formatting","index":1,"n_rows":54,"n_cols":41,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Office 2013 Class #28: Excel Basics 10:"]
["Style Formatting: By Hand, Cell, Table & Conditional Formatting"]
[]
["Style Formatting: Bold labels and use Borders",null,null,null,null,null,"Wrap Text in cell: multiple line in a cell",null,null,null,"Style: Column width",null,null,null,"Accounting Borders",null,null,null,null,null,null,"Table Format",null,null,null,null,"Cell Styles are great if you use the",null,null,null,"Built-in Conditional Formatting",null,null,null,"Criteria",18000]
["Number Formatting: Accounting",null,null,null,null,null,"1) While typing: Alt + Enter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(really just a proper data set converted to an Excel Table)",null,null,null,null,"same Style and Number formatting over and over"]
[null,null,null,null,null,null,"20 Command button in Alignment group in Home Ribbon Tab",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data Bars",null,"Top 10%",null,{"$f":"\"Greater than \"&FIXED(AJ4,0)","v":"Greater than 18,000"},null,null,"Losses"]
[]
[null,"Jan","Feb","Mar","Apr",null,"Boomerang\nProduct Name","Employee Name","Sales Amount",null,"Date","Product","Sales",null,"Date","Check #","Description","Deduction","Addition","Balance",null,"Date","Product","Sales",null,null,"Date","Product","Sales",null,"Sales",null,"Sales",null,"Sales",null,"Stock","Buy Price","Price today","Quantity","Profit"]
["Net Sales",5689,2569,6587,8700,null,"Majestic Beaut","Jo",505,null,"2013-10-29","Flying Eagle",13490,null,"2013-10-01",null,null,null,null,5000.5,null,"2013-10-29","Flying Eagle",13490,null,null,"2013-10-29","Flying Eagle",13490,null,13490,null,13490,null,18000,null,"GOOG",755,1015,700,{"$f":"AN9*(AM9-AL9)","v":182000}]
["Operating Expenses",1801.15,2099.15,4100.3,4245,null,"Delicate Arch Deluxe","Moe",657,null,"2013-10-29","Smooth Arch",9077,null,"2013-10-03",2150,"Pay Rent",500,null,{"$f":"IF(O10<>\"\",T9+S10-R10,\"\")","v":4500.5},null,"2013-10-29","Smooth Arch",9077,null,null,"2013-10-29","Smooth Arch",9077,null,9077,null,9077,null,9077,null,"GE",22,29.1,2200,15620.000000000004]
["Administrating Expenses",537.79999999999995,513.80000000000007,1617.4,1740,null,"Carlota Doublers","Sheliadawn",329,null,"2013-10-29","Flying Eagle",10167,null,"2013-10-03","ATM124","withdraw",120,null,4380.5,null,"2013-10-29","Flying Eagle",10167,null,null,"2013-10-29","Flying Eagle",10167,null,10167,null,10167,null,10167,null,"KO",36,32.4,300,-1080.0000000000005]
["Other",253.35,385.34999999999997,{"$f":"D9-D10-D11","v":869.29999999999973},1305,null,"Majestic Beaut","Tina",618,null,"2013-10-29","Flying Eagle",13248,null,"2013-10-04",null,"Rev",null,654.25,5034.75,null,"2013-10-29","Flying Eagle",13248,null,null,"2013-10-29","Flying Eagle",13248,null,13248,null,13248,null,13248,null,"MSFT",36,36,4000,0]
["Total Expenses",{"$f":"SUM(B10:B12)","v":2592.2999999999997},2998.3,6587,7290,null,"Delicate Arch Deluxe","Tina",888,null,"2013-10-29","Smooth Arch",6360,null,null,null,null,null,null,"",null,"2013-10-29","Smooth Arch",6360,null,null,"2013-10-29","Smooth Arch",6360,null,6360,null,6360,null,6360,null,"KK",51,42,700,-6300]
["Net Income",{"$f":"B9-B13","v":3096.7000000000003},-429.30000000000018,0,1410,null,"Delicate Arch Deluxe","Moe",138,null,"2013-10-29","Smooth Arch",11740,null,null,null,null,null,null,"",null,"2013-10-29","Smooth Arch",11740,null,null,"2013-10-29","Smooth Arch",11740,null,11740,null,11740,null,11740,null,"SW",31,17,400,-5600]
[null,null,null,null,null,null,"Quad Freestyle","Sheliadawn",125,null,"2013-10-29","Flying Eagle",5325,null,null,null,null,null,null,"",null,"2013-10-29","Flying Eagle",5325,null,null,"2013-10-29","Flying Eagle",5325,null,5325,null,5325,null,5325]
[null,null,"or",null,null,null,"Quad Freestyle","Sheliadawn",238,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7873,null,7873,null,7873]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19043,null,19043,null,19043]
[null,"Jan","Feb","Mar","Apr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12143,null,12143,null,12143]
["Net Sales",5689,2569,6587,8700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10300,null,10300,null,10300]
["Operating Expenses",1801.15,2099.15,4100.3,4245,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10145,null,10145,null,10145]
["Administrating Expenses",537.79999999999995,513.80000000000007,1617.4,1740,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14309,null,14309,null,14309]
["Other",253.35,385.34999999999997,{"$f":"D19-D20-D21","v":869.29999999999973},1305,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11711,null,11711,null,11711]
["Total Expenses",{"$f":"SUM(B20:B22)","v":2592.2999999999997},2998.3,6587,7290,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19160,null,19160,null,19160]
["Net Income",{"$f":"B19-B23","v":3096.7000000000003},-429.30000000000018,0,1410,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19310,null,19310,null,19310]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13628,null,13628,null,13628]
[null,null,"or",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19347,null,19347,null,19347]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10107,null,10107,null,10107]
[null,"Jan","Feb","Mar","Apr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18719,null,18719,null,18719]
["Net Sales",5689,2569,6587,8700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13426,null,13426,null,13426]
["Operating Expenses",1801.15,2099.15,4100.3,4245,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12627,null,12627,null,12627]
["Administrating Expenses",537.79999999999995,513.80000000000007,1617.4,1740,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11723,null,11723,null,11723]
["Other",253.35,385.34999999999997,{"$f":"D29-D30-D31","v":869.29999999999973},1305,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7981,null,7981,null,7981]
["Total Expenses",{"$f":"SUM(B30:B32)","v":2592.2999999999997},2998.3,6587,7290]
["Net Income",{"$f":"B29-B33","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":"D39-D40-D41","v":869.29999999999973},1305]
["Total Expenses",{"$f":"SUM(B40:B42)","v":2592.2999999999997},2998.3,6587,7290]
["Net Income",{"$f":"B39-B43","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":"D49-D50-D51","v":869.29999999999973},1305]
["Total Expenses",{"$f":"SUM(B50:B52)","v":2592.2999999999997},2998.3,6587,7290]
["Net Income",{"$f":"B49-B53","v":3096.7000000000003},-429.30000000000018,0,1410]

{"sheet":"Style Formatting (an)","index":2,"n_rows":54,"n_cols":42,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Office 2013 Class #28: Excel Basics 10:"]
["Style Formatting: By Hand, Cell, Table & Conditional Formatting"]
[]
["Style Formatting: Bold labels and use Borders",null,null,null,null,null,"Wrap Text in cell: multiple line in a cell",null,null,null,"Style: Column width, Fill, Font, Border, Number",null,null,null,"Accounting Borders",null,null,null,null,null,null,"Table Format",null,null,null,null,"Cell Styles are great if you use the",null,null,null,"Built-in Conditional Formatting",null,null,null,null,"Criteria",18000]
["Number Formatting: Accounting",null,null,null,null,null,"1) While typing: Alt + Enter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(really just a proper data set converted to an Excel Table)",null,null,null,null,"same Style and Number formatting over and over"]
[null,null,null,null,null,null,"20 Command button in Alignment group in Home Ribbon Tab",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data Bars",null,null,"Top 10%",null,{"$f":"\"Greater than \"&FIXED(AK4,0)","v":"Greater than 18,000"},null,null,"Losses"]
[]
[null,"Jan","Feb","Mar","Apr",null,"Boomerang\nProduct Name","Employee Name","Sales Amount",null,"Date","Product","Sales",null,"Date","Check #","Description","Deduction","Addition","Balance",null,"Date","Product","Sales",null,null,"Date","Product","Sales",null,"Sales","Sales",null,"Sales",null,"Sales",null,"Stock","Buy Price","Price today","Quantity","Profit"]
["Net Sales",5689,2569,6587,8700,null,"Majestic Beaut","Jo",505,null,"2013-10-29","Flying Eagle",13490,null,"2013-10-01",null,null,null,null,5000.5,null,"2013-10-29","Flying Eagle",13490,null,null,"2013-10-29","Flying Eagle",13490,null,13490,{"$f":"AE9","v":13490},null,13490,null,18000,null,"GOOG",755,1015,700,{"$f":"AO9*(AN9-AM9)","v":182000}]
["Operating Expenses",1801.15,2099.15,4100.3,4245,null,"Delicate Arch Deluxe","Moe",657,null,"2013-10-29","Smooth Arch",9077,null,"2013-10-03",2150,"Pay Rent",500,null,{"$f":"IF(O10<>\"\",T9+S10-R10,\"\")","v":4500.5},null,"2013-10-29","Smooth Arch",9077,null,null,"2013-10-29","Smooth Arch",9077,null,9077,{"$f":"AE10","v":9077},null,9077,null,9077,null,"GE",22,29.1,2200,15620.000000000004]
["Administrating Expenses",537.79999999999995,513.80000000000007,1617.4,1740,null,"Carlota Doublers","Sheliadawn",329,null,"2013-10-29","Flying Eagle",10167,null,"2013-10-03","ATM124","withdraw",120,null,4380.5,null,"2013-10-29","Flying Eagle",10167,null,null,"2013-10-29","Flying Eagle",10167,null,10167,{"$f":"AE11","v":10167},null,10167,null,10167,null,"KO",36,37,300,300]
["Other",253.35,385.34999999999997,{"$f":"D9-D10-D11","v":869.29999999999973},1305,null,"Majestic Beaut","Tina",618,null,"2013-10-29","Flying Eagle",13248,null,"2013-10-04",null,"Rev",null,654.25,5034.75,null,"2013-10-29","Flying Eagle",13248,null,null,"2013-10-29","Flying Eagle",13248,null,13248,{"$f":"AE12","v":13248},null,13248,null,13248,null,"MSFT",36,36,4000,0]
["Total Expenses",{"$f":"SUM(B10:B12)","v":2592.2999999999997},2998.3,6587,7290,null,"Delicate Arch Deluxe","Tina",888,null,"2013-10-29","Smooth Arch",6360,null,null,null,null,null,null,"",null,"2013-10-29","Smooth Arch",6360,null,null,"2013-10-29","Smooth Arch",6360,null,6360,{"$f":"AE13","v":6360},null,6360,null,6360,null,"KK",51,42,700,-6300]
["Net Income",{"$f":"B9-B13","v":3096.7000000000003},-429.30000000000018,0,1410,null,"Delicate Arch Deluxe","Moe",138,null,"2013-10-29","Smooth Arch",11740,null,null,null,null,null,null,"",null,"2013-10-29","Smooth Arch",11740,null,null,"2013-10-29","Smooth Arch",11740,null,11740,{"$f":"AE14","v":11740},null,11740,null,11740,null,"SW",31,17,400,-5600]
[null,null,null,null,null,null,"Quad Freestyle","Sheliadawn",125,null,"2013-10-29","Flying Eagle",5325,null,null,null,null,null,null,"",null,"2013-10-29","Flying Eagle",5325,null,null,"2013-10-29","Flying Eagle",5325,null,5325,{"$f":"AE15","v":5325},null,5325,null,5325]
[null,null,"or",null,null,null,"Quad Freestyle","Sheliadawn",238,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7873,{"$f":"AE16","v":7873},null,7873,null,7873]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19043,{"$f":"AE17","v":19043},null,19043,null,19043]
[null,"Jan","Feb","Mar","Apr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12143,{"$f":"AE18","v":12143},null,12143,null,12143]
["Net Sales",5689,2569,6587,8700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10300,{"$f":"AE19","v":10300},null,10300,null,10300]
["Operating Expenses",1801.15,2099.15,4100.3,4245,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10145,{"$f":"AE20","v":10145},null,10145,null,10145]
["Administrating Expenses",537.79999999999995,513.80000000000007,1617.4,1740,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14309,{"$f":"AE21","v":14309},null,14309,null,14309]
["Other",253.35,385.34999999999997,{"$f":"D19-D20-D21","v":869.29999999999973},1305,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11711,{"$f":"AE22","v":11711},null,11711,null,11711]
["Total Expenses",{"$f":"SUM(B20:B22)","v":2592.2999999999997},2998.3,6587,7290,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19160,{"$f":"AE23","v":19160},null,19160,null,19160]
["Net Income",{"$f":"B19-B23","v":3096.7000000000003},-429.30000000000018,0,1410,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19310,{"$f":"AE24","v":19310},null,19310,null,19310]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13628,{"$f":"AE25","v":13628},null,13628,null,13628]
[null,null,"or",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19347,{"$f":"AE26","v":19347},null,19347,null,19347]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10107,{"$f":"AE27","v":10107},null,10107,null,10107]
[null,"Jan","Feb","Mar","Apr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18719,{"$f":"AE28","v":18719},null,18719,null,18719]
["Net Sales",5689,2569,6587,8700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13426,{"$f":"AE29","v":13426},null,13426,null,13426]
["Operating Expenses",1801.15,2099.15,4100.3,4245,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12627,{"$f":"AE30","v":12627},null,12627,null,12627]
["Administrating Expenses",537.79999999999995,513.80000000000007,1617.4,1740,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11723,{"$f":"AE31","v":11723},null,11723,null,11723]
["Other",253.35,385.34999999999997,{"$f":"D29-D30-D31","v":869.29999999999973},1305,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7981,{"$f":"AE32","v":7981},null,7981,null,7981]
["Total Expenses",{"$f":"SUM(B30:B32)","v":2592.2999999999997},2998.3,6587,7290]
["Net Income",{"$f":"B29-B33","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":"D39-D40-D41","v":869.29999999999973},1305]
["Total Expenses",{"$f":"SUM(B40:B42)","v":2592.2999999999997},2998.3,6587,7290]
["Net Income",{"$f":"B39-B43","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":"D49-D50-D51","v":869.29999999999973},1305]
["Total Expenses",{"$f":"SUM(B50:B52)","v":2592.2999999999997},2998.3,6587,7290]
["Net Income",{"$f":"B49-B53","v":3096.7000000000003},-429.30000000000018,0,1410]

{"sheet":"Number Formatting","index":3,"n_rows":143,"n_cols":10,"rows_kept":143,"cut":false,"hidden":false,"merged":[]}
["Office 2013 Class #29: Excel Basics 11:"]
["Number Formatting & Formulas, Don't Get Tricked By The Façade"]
["Accounting, Currency, Date, Time, Percentage, Date Math, Time Math"]
[]
["Number Formatting:"]
["Number Formatting is a Façade that sits on top of numbers."]
["With Number Formatting, what you see on top of the cells can sometimes be different than the actual number that is in the cell."]
["Formulas will not look at the Number Formatting, but instead they will look at the numbers that are actually in the cells, under the Number Formatting."]
["Formulas make their calculation on the actual numbers in the cells, not the numbers that you see on the surface of the cells, on the surface of the worksheet."]
[]
["Examples:","Number","Multiply"]
[8.5599600000000002,100,null,null,"Formulas don't see number formatting"]
[2.5000000000000001E-2,100,null,null,"Formulas see underlying number"]
[]
["General Number Format: Shows the actual number that is in the cell"]
["Keyboard for General Number Formatting: Ctrl + Shift + ` ~   (key to left of Number 1)"]
[]
["Examples:","Number","Multiply"]
[8.5599600000000002,100]
[2.5000000000000001E-2,100]
["or"]
["Sometimes you want to just increase decimals:"]
[2.5000000000000001E-2,100]
[]
["Keyboard for Format Cells dialog box = Ctrl + 1"]
[]
["Accounting Number Format: Fixed dollar sign (left edge of cell), negatives are in parenthesis, zeros are dashes, decimals line up."]
["Currency Number Formatting: Floating dollar sign, you choose how to show negatives, zeros are zeroes, decimals usually line up"]
["Keyboard for Currency: Ctrl + Shift + 4"]
[]
[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":"D32-D33-D34","v":869.29999999999973},1305]
["Total Expenses",{"$f":"SUM(B33:B35)","v":2592.2999999999997},2998.3,6587,7290]
["Net Income",{"$f":"B32-B36","v":3096.7000000000003},-429.30000000000018,0,1410]
[]
[]
[null,"Jan","Feb","Mar","Apr"]
["Net Sales",{"$f":"B32","v":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,869.29999999999973,1305]
["Total Expenses",2592.2999999999997,2998.3,6587,7290]
["Net Income",3096.7000000000003,-429.30000000000018,0,1410]
[]
["Date Number Formatting: Under dates, there are serial numbers, which are the number of days since Dec 31, 1899."]
[]
["Date","Actual Number in Cell"]
["1900-01-01",1,null,50.255000000000003]
["1900-01-02",2]
["2013-10-30",41577]
[]
["Why? So we can do Date Math!"]
[]
["Invoice due date",null,null,"Enter dates with forward slashes (there are other ways also)"]
["Today",null,null,"Keyboard for today's date: Ctrl + ;"]
["Days past due",null,null,"Important Formula: Days between dates = Later Date - Earlier Date"]
[]
["Loan issue date","2013-09-02"]
["Days until loan due",120]
["Maturity Date",null,null,"You can add numbers to dates"]
[]
["Your birthday",null,null,"Enter dates with forward slashes (there are other ways also)"]
["Today",null,null,"TODAY function will update each day you open workbook file"]
["Days You've been alive"]
[]
["Project Start Date","2013-10-30"]
["Project End Date","2014-01-13"]
["# days for project",null,null,"Important Formula: Days between dates where start date IS included= Later Date - Earlier Date + 1"]
[]
[]
["Time Number Format: Proportion of the 24 hour day"]
[]
["Time","Proportion of 24 hour day",null,null,"Actual Number in Cell"]
["08:00:00",{"$f":"8/24","v":0.33333333333333331},{"$f":"1/3","v":0.33333333333333331},null,{"$f":"8/24","v":0.33333333333333331}]
["12:00:00",{"$f":"12/24","v":0.5},{"$f":"1/2","v":0.5},null,{"$f":"12/24","v":0.5}]
["15:00:00","(12+3)/24",{"$f":"15/24","v":0.625},{"$f":"15/24","v":0.625},{"$f":"15/24","v":0.625},null,"15:00:00"]
[]
["Enter time as hour, colon, minutes, colon, seconds, then a space, and AM or PM (there are other methods also)",null,null,null,null,null,null,null,"Time","Actual Number in Cell"]
["Time","Actual Number in Cell",null,null,null,null,null,null,"00:00:00",{"$f":"I82","v":0}]
["08:00:00",0.33333333333333331,null,null,null,null,null,null,1,{"$f":"I83","v":1}]
["12:00:00",0.5,null,null,null,null,null,null,"08:00:00",{"$f":"I84","v":0.33333333333333331}]
["15:00:00",0.625,null,null," ==>> more examples of time ==>>",null,null,null,"12:00:00",0.5]
["15:15:00",0.63541666666666663,null,null,null,null,null,null,"15:00:00",0.625]
[null,null,null,null,null,null,null,null,"15:15:00",0.63541666666666663]
["Notice that we took a number and divided by 24!!!!"]
["This means that if we want to do Time Math and get hours as a result, we must multiply the decimal time answer by 24!!!!"]
[]
["Wage per hour",21.25]
["Time In",null,null,"Enter time as hour, colon, minutes, colon, seconds, then a space, and AM or PM (there are other methods also)"]
["Time Out"]
["Total Hours worked"]
["Gross Pay",null,null,"Important Formula: Hours Worked = (Later Time - Earlier Time)*24"]
[]
["Homework tracker:"]
["Start Time"]
["End Time"]
["Hours worked"]
["Start Time"]
["End Time"]
["Hours worked"]
["Total"]
[null,"or"]
["Total"]
[]
["Percentage Number Formatting"]
["What is a percentage?"]
["How many parts out of 100?"]
["How many pennies for every 100 pennies you need to pay?"]
[]
["Pennies you must pay:","one hundred","Decimal\nequivalent","Percentage"]
[2,100]
[9.9,100]
[7.65,100]
[null,null,">\n>\n>"]
[null,null,"This is the number that calculations are based on"]
["To format a number as a percentage: 1) slide decimal two places to the right, 2) add a % symbol"]
[]
["Ways to enter percentages:"]
["Type .03 in cell, then add % format"]
["Type 3 in cell, then add % format",null,null,null,3]
["Add % format, then type 3, Enter"]
["Add % format, then type .03, Enter"]
["Add % format as you type"]
["Type .025, then add % from ribbon"]
[]
["Increase Decrease Decimals Number Formatting or Currency or Accounting Number Formatting"]
[]
["Payroll:"]
["Employee","Gross Pay","Tax Deduction"]
["Lillian  Holt",689.25]
["Jasmine  Phelps",765.71]
["Sadie  Hudson",687.43]
[]
["Tax Rate"]
[7.6499999999999999E-2,null,"Accounting Number Format has made it look like we have rounded to penny."]
[null,null,"BUT WE HAVE NOT!!!!!!!!"]
["Type what you see:",null,"Decimals are being hidden by Number Formatting."]
[null,null,"Because formulas calculate on the numbers that are actually in the cell and not the Formatted Numbers,"]
[null,null,"formulas sometimes will show the incorrect answer."]
[null,null,"Next video: the solution: ROUND function"]

{"sheet":"Number Formatting (an)","index":4,"n_rows":144,"n_cols":10,"rows_kept":144,"cut":false,"hidden":false,"merged":[]}
["Office 2013 Class #29: Excel Basics 11:"]
["Number Formatting & Formulas, Don't Get Tricked By The Façade"]
["Accounting, Currency, Date, Time, Percentage, Date Math, Time Math"]
[]
["Number Formatting:"]
["Number Formatting is a Façade that sits on top of numbers."]
["With Number Formatting, what you see on top of the cells can sometimes be different than the actual number that is in the cell."]
["Formulas will not look at the Number Formatting, but instead they will look at the numbers that are actually in the cells, under the Number Formatting."]
["Formulas make their calculation on the actual numbers in the cells, not the numbers that you see on the surface of the cells, on the surface of the worksheet."]
[]
["Examples:","Number","Multiply"]
[8.5599600000000002,100,{"$f":"B12*A12","v":855.99599999999998},null,"Formulas don't see number formatting"]
[2.5000000000000001E-2,100,{"$f":"B13*A13","v":2.5},null,"Formulas see underlying number"]
[]
["General Number Format: Shows the actual number that is in the cell"]
["Keyboard for General Number Formatting: Ctrl + Shift + ` ~   (key to left of Number 1)"]
[]
["Examples:","Number","Multiply"]
[8.5599600000000002,100,{"$f":"B19*A19","v":855.99599999999998}]
[2.5000000000000001E-2,100,{"$f":"B20*A20","v":2.5}]
["or"]
["Sometimes you want to just increase decimals:"]
[2.5000000000000001E-2,100,{"$f":"B23*A23","v":2.5}]
[]
["Keyboard for Format Cells dialog box = Ctrl + 1"]
[]
["Accounting Number Format: Fixed dollar sign (left edge of cell), negatives are in parenthesis, zeros are dashes, decimals line up."]
["Currency Number Formatting: Floating dollar sign, you choose how to show negatives, zeros are zeroes, decimals usually line up"]
["Keyboard for Currency: Ctrl + Shift + 4"]
[]
[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":"D32-D33-D34","v":869.29999999999973},1305]
["Total Expenses",{"$f":"SUM(B33:B35)","v":2592.2999999999997},2998.3,6587,7290]
["Net Income",{"$f":"B32-B36","v":3096.7000000000003},-429.30000000000018,0,1410]
[]
[]
[null,"Jan","Feb","Mar","Apr"]
["Net Sales",{"$f":"B32","v":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,869.29999999999973,1305]
["Total Expenses",2592.2999999999997,2998.3,6587,7290]
["Net Income",3096.7000000000003,-429.30000000000018,0,1410]
[]
["Date Number Formatting: Under dates, there are serial numbers, which are the number of days since Dec 31, 1899."]
[]
["Date","Actual Number in Cell"]
["1900-01-01",1,null,50.255000000000003]
["1900-01-02",2]
["2013-10-30",41577,null,"2013-10-30"]
[]
["Why? So we can do Date Math!"]
[]
["Invoice due date","2013-09-09",null,"Enter dates with forward slashes (there are other ways also)"]
["Today","2013-10-30",null,"Keyboard for today's date: Ctrl + ;"]
["Days past due",{"$f":"B58-B57","v":51},null,"Important Formula: Days between dates = Later Date - Earlier Date"]
[]
["Loan issue date","2013-09-02"]
["Days until loan due",120]
["Maturity Date",{"$f":"B61+B62","v":"2013-12-31"},null,"You can add numbers to dates"]
[]
["Your birthday","1975-05-02",null,"Enter dates with forward slashes (there are other ways also)"]
["Today",{"$f":"TODAY()","v":"2013-10-31"},null,"TODAY function will update each day you open workbook file"]
["Days You've been alive",{"$f":"B66-B65","v":14062}]
[]
["Project Start Date","2013-10-30"]
["Project End Date","2014-01-13"]
["# days for project",{"$f":"B70-B69+1","v":76},null,"Important Formula: Days between dates where start date IS included= Later Date - Earlier Date + 1"]
[]
[]
["Time Number Format: Proportion of the 24 hour day"]
[]
["Time","Proportion of 24 hour day",null,null,"Actual Number in Cell"]
["08:00:00",{"$f":"8/24","v":0.33333333333333331},{"$f":"1/3","v":0.33333333333333331},null,{"$f":"8/24","v":0.33333333333333331}]
["12:00:00",{"$f":"12/24","v":0.5},{"$f":"1/2","v":0.5},null,{"$f":"12/24","v":0.5}]
["15:00:00","(12+3)/24",{"$f":"15/24","v":0.625},{"$f":"15/24","v":0.625},{"$f":"15/24","v":0.625},null,"15:00:00"]
[]
["Enter time as hour, colon, minutes, colon, seconds, then a space, and AM or PM (there are other methods also)",null,null,null,null,null,null,null,"Time","Actual Number in Cell"]
["Time","Actual Number in Cell",null,null,null,null,null,null,"00:00:00",{"$f":"I82","v":0}]
["08:00:00",0.33333333333333331,null,null,"08:00:00",null,null,null,1,{"$f":"I83","v":1}]
["12:00:00",0.5,null,null,null,null,null,null,"08:00:00",{"$f":"I84","v":0.33333333333333331}]
["15:00:00",0.625,null,null," ==>> more examples of time ==>>",null,null,null,"12:00:00",0.5]
["15:15:00",0.63541666666666663,null,null,null,null,null,null,"15:00:00",0.625]
[null,null,null,null,null,null,null,null,"15:15:00",0.63541666666666663]
["Notice that we took a number and divided by 24!!!!"]
["This means that if we want to do Time Math and get hours as a result, we must multiply the decimal time answer by 24!!!!"]
[]
["Wage per hour",21.25]
["Time In","08:00:00",null,"Enter time as hour, colon, minutes, colon, seconds, then a space, and AM or PM (there are other methods also)"]
["Time Out","14:30:00"]
["Total Hours worked",{"$f":"(B93-B92)*24","v":6.5}]
["Gross Pay",{"$f":"B94*B91","v":138.125},null,"Important Formula: Hours Worked = (Later Time - Earlier Time)*24"]
[]
["Homework tracker:"]
["Start Time","08:30:00"]
["End Time","11:00:00"]
["Hours worked",{"$f":"(B99-B98)*24","v":2.4999999999999991}]
["Start Time","22:00:00"]
["End Time","23:15:00"]
["Hours worked",{"$f":"24*(B102-B101)","v":1.2500000000000009}]
["Total",{"$f":"B103+B100","v":3.75}]
[null,"or"]
["Total",{"$f":"SUM(B99-B98,B102-B101)*24","v":3.75}]
[]
["Percentage Number Formatting"]
["What is a percentage?"]
["How many parts out of 100?"]
["How many pennies for every 100 pennies you need to pay?"]
[]
["Pennies you must pay:","one hundred","Decimal\nequivalent","Percentage"]
[2,100,{"$f":"A114/B114","v":0.02},{"$f":"C114","v":0.02},null,"2.00%"]
[9.9,100,{"$f":"A115/B115","v":9.9000000000000005E-2},{"$f":"C115","v":9.9000000000000005E-2}]
[7.65,100,7.6499999999999999E-2,7.6499999999999999E-2]
[null,null,">\n>\n>"]
[null,null,"This is the number that calculations are based on"]
["To format a number as a percentage: 1) slide decimal two places to the right, 2) add a % symbol"]
[]
["Ways to enter percentages:"]
["Type .03 in cell, then add % format",null,0.03]
["Type 3 in cell, then add % format",null,3,null,3]
["Add % format, then type 3, Enter",null,0.03]
["Add % format, then type .03, Enter",null,0.03]
["Add % format as you type",null,3.5499999999999997E-2]
["Type .025, then add % from ribbon",null,2.5000000000000001E-2]
[]
["Increase Decrease Decimals Number Formatting or Currency or Accounting Number Formatting"]
[]
["Payroll:"]
["Employee","Gross Pay","Tax Deduction"]
["Lillian  Holt",689.25,{"$f":"B133*$A$138","v":52.727624999999996}]
["Jasmine  Phelps",765.71,{"$f":"B134*$A$138","v":58.576815000000003}]
["Sadie  Hudson",687.43,52.588394999999998]
[null,null,{"$f":"SUM(C133:C135)","v":163.89283499999999}]
["Tax Rate"]
[7.6499999999999999E-2,null,"Accounting Number Format has made it look like we have rounded to penny."]
[null,null,"BUT WE HAVE NOT!!!!!!!!"]
["Type what you see:",null,"Decimals are being hidden by Number Formatting."]
[52.73,null,"Because formulas calculate on the numbers that are actually in the cell and not the Formatted Numbers,"]
[58.58,null,"formulas sometimes will show the incorrect answer."]
[52.59,null,"Next video: the solution: ROUND function"]
[{"$f":"SUM(A141:A143)","v":163.9}]

{"sheet":"ROUND","index":5,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["Office 2013 Class #30: Excel Basics 12:"]
["ROUND function: When and How to use it in Business"]
[]
["How to round by hand?"]
["1) Pick position you want to round to"]
["2) look at digit to right:"]
["5 or bigger ==>>  add one to position you are rounding to and remove unwanted digits"]
["4 or less     ==>>  remove unwanted digits"]
[]
[52.724584,"52.724584","52.724584","52.7(2+0)7625",52.72]
[52.727624999999996,"52.727625","52.727625","52.7(2+1)4584",52.73]
[]
["We can use the ROUND function to remove unwanted decimals"]
["When to use ROUND:"]
["1) When you are multiplying or dividing decimals and run the risk of extraneous decimals, AND"]
["2) you will be using the numbers in subsequent formulas, use the ROUND function."]
["Examples:"]
["Payroll"]
["Invoices"]
["Taxes"]
[]
["Payroll:"]
["Employee","Gross Pay","Tax Deduction",null,"Type what you see"]
["Lillian  Holt",689.25,null,null,52.73]
["Jasmine  Phelps",765.71,null,null,58.58]
["Sadie  Hudson",687.43,null,null,52.59]
[null,null,null,null,{"$f":"SUM(E24:E26)","v":163.9}]
["Tax Rate"]
[7.6499999999999999E-2,null,"Rules for ROUND:"]
[null,null,"Round to penny (hundredths position) use 2"]
[null,null,"Round to dollar (ones position) use 0"]
[null,null,"Round to thousands (thousands position) use -3"]
["Invoicing and Payroll Tax:"]
["Invoice Number",1025]
["Item","Price","Units","Total"]
["1'' screws",5.7500000000000002E-2,81,{"$f":"ROUND(C36*B36,2)","v":4.66}]
["6\" lock pads",1.05,24,{"$f":"ROUND(C37*B37,2)","v":25.2},null,"Tax Rate"]
[null,null,"Subtotal",{"$f":"SUM(D36:D37)","v":29.86},null,9.9000000000000005E-2]
[null,null,"Tax",{"$f":"ROUND(D38*F38,2)","v":2.96}]
[null,null,"Total",{"$f":"SUM(D38:D39)","v":32.82}]
["Thanks for your Order!"]
[]
["**Payroll Taxes and Invoices often times have to round to the penny."]
["**Sometimes for INCOME TAXES you have to round to the dollar."]
[]
["Taxable Amount","Tax\nrounded to dollar",null,"Tax Rate"]
[2345.98,null,null,0.155]
[345.9]
[235.8]
[2541.12]

{"sheet":"ROUND (an)","index":6,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["Office 2013 Class #30: Excel Basics 12:"]
["ROUND function: When and How to use it in Business"]
[]
["How to round by hand?"]
["1) Pick position you want to round to"]
["2) look at digit to right:"]
["5 or bigger ==>>  add one to position you are rounding to and remove unwanted digits"]
["4 or less     ==>>  remove unwanted digits"]
[]
[52.724584,"52.724584","52.724584","52.7(2+0)7625",52.72]
[52.727624999999996,"52.727625","52.727625","52.7(2+1)4584",52.73]
[]
["We can use the ROUND function to remove unwanted decimals"]
["When to use ROUND:"]
["1) When you are multiplying or dividing decimals and run the risk of extraneous decimals, AND"]
["2) you will be using the numbers in subsequent formulas, use the ROUND function."]
["Examples:"]
["Payroll"]
["Invoices"]
["Taxes"]
[]
["Payroll:"]
["Employee","Gross Pay","Tax Deduction",null,"Type what you see"]
["Lillian  Holt",689.25,{"$f":"ROUND(B24*$A$29,2)","v":52.73},null,52.73]
["Jasmine  Phelps",765.71,{"$f":"ROUND(B25*$A$29,2)","v":58.58},null,58.58]
["Sadie  Hudson",687.43,52.59,null,52.59]
[null,null,{"$f":"SUM(C24:C26)","v":163.9},null,{"$f":"SUM(E24:E26)","v":163.9}]
["Tax Rate"]
[7.6499999999999999E-2,null,"Rules for ROUND:"]
[null,null,"Round to penny (hundredths position) use 2"]
[null,null,"Round to dollar (ones position) use 0"]
[null,null,"Round to thousands (thousands position) use -3"]
["Invoicing and Payroll Tax:"]
["Invoice Number",1025]
["Item","Price","Units","Total"]
["1'' screws",5.7500000000000002E-2,81,{"$f":"ROUND(C36*B36,2)","v":4.66}]
["6\" lock pads",1.05,24,{"$f":"ROUND(C37*B37,2)","v":25.2},null,"Tax Rate"]
[null,null,"Subtotal",{"$f":"SUM(D36:D37)","v":29.86},null,9.9000000000000005E-2]
[null,null,"Tax",{"$f":"ROUND(D38*F38,2)","v":2.96}]
[null,null,"Total",{"$f":"SUM(D38:D39)","v":32.82}]
["Thanks for your Order!"]
[]
["**Payroll Taxes and Invoices often times have to round to the penny."]
["**Sometimes for INCOME TAXES you have to round to the dollar."]
[]
["Taxable Amount","Tax\nrounded to dollar",null,"Tax Rate"]
[2345.98,{"$f":"ROUND(A47*$D$47,0)","v":364},null,0.155]
[345.9,{"$f":"ROUND(A48*$D$47,0)","v":54}]
[235.8,37]
[2541.12,{"$f":"ROUND(A50*$D$47,0)","v":394}]

{"sheet":"Formulas","index":7,"n_rows":98,"n_cols":6,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
["Office 2013 Class #31: Excel Basics 13: "]
["What Can Go Into Formulas: Examples of Formula Elements"]
[]
["Formulas:"]
["Calculations we can make in the cells and other locations."]
["Examples:"]
["Adding a column of expenses"]
["Adding with one condition"]
["Joining a first and last name"]
["Checking whether two numbers are in balance"]
["All formulas start with an equal sign as the first character in the cell"]
["Formulas elements (things that can go into formulas):"]
["Equal signs"]
["Cell References"]
["Math operators"]
["Numbers (if the number won't change like 12 for months in a year)"]
["Built-in functions (like SUM, SUMIFS, AVERAGE)"]
["Comparative operators (like > and <)"]
["Join Symbol: & (Ampersand)"]
["Text in double quotes (like \"Revenue\" or \", \")"]
[]
["Example 1:"]
["Adding a column of expenses: 1) equal sign, 2) SUM function, 3) range of cells"]
["Expenses","Totals for year"]
["Rent",{"$f":"950*12","v":11400}]
["Operations",{"$f":"12*5423","v":65076}]
["Admin",{"$f":"12*7000","v":84000}]
["COGS",{"$f":"100000*0.7556","v":75560}]
["Other",5987]
["Total"]
[]
["Example 2:"]
["Adding with one condition: 1) equal sign, 2) SUMIFS, 3) range of cells, 4) \"Text\" in quotes"]
["Type","Amounts",null,"Total Revenue"]
["Revenue",548.20000000000005]
["Credit",-158.25]
["Revenue",19.5]
["Revenue",250.23]
["Credit",-25]
[]
["Example 3:"]
["Adding with one condition: 1) equal sign, 2) SUMIF, 3) range of cells, 4) cell with number and comparative operator"]
[null,"Amounts",null,"Criteria"]
[null,548.20000000000005,null,">0"," <<== Notice that when we put comparative operator and zero in a cell, Excel considers it Text."]
[null,-158.25,null,"Total Revenue"]
[null,19.5,null,null,"** If the sum range and criteria range are the same, use SUMIF cuz it's less to type"]
[null,250.23,null,"or","** if the sum range and criteria range are the same, only enter numbers into range argument"]
[null,-25,null,"Total Revenue"]
[null,null,null,null," <<== If criteria will not change (Excel's Golden Rule), you can type it into formula"]
[]
[]
[]
["Example 4:"]
["Joining a first and last name: 1) equal sign, 2) cell, 3) Join Symbol, 4) Text in quotes"]
["First","Last","Join",null,"Last, First"]
["Jimmy","Garza",null,"or",null,"Called: Text Formula"]
["Emma","Potter"]
["Rolando","Robbins"]
["Louise","Maado"]
["Felicia","Cohen"]
["Henry","Wagner"]
["Wesley","Baldwin"]
["Sophie","Walsh"]
["Evelyn","Scott"]
["Hugh","Mason"]
[]
["Example 5:"]
["Check whether two cells are equal"]
["Checking whether two numbers are in balance: 1) equal sign, 2) cell, 3) equal sign as comparative operator, 4) cell"]
[null,"DR","CR"]
[null,65.25]
[null,null,65.25]
[null,589.00099999999998]
[null,null,589]
[null,12.25]
[null,null,12.25]
["Total",{"$f":"SUM(B71:B76)","v":666.50099999999998},666.5]
[]
["Balance?",null,"Called: Logical Formula"]
[]
[]
[]
[]
[{"$f":"E84&\" ==>>\"","v":"Math Operators ==>>"},null,null,null,"Math Operators"]
[null,null,null,null," ( ) represents Parentheses"," Shift + 9 and Shift + 0"]
[null,null,null,null," ^ represents Exponents (powers and roots)"," Shift + 6"]
[null,null,null,null," * represents Multiplication"," * on Number pad"]
[null,null,null,null," /  represents Division"," / on Number pad"]
[null,null,null,null," + represents Addition"," + on Number pad"]
[null,null,null,null," – represents Subtraction"," - on Number pad"]
[]
[{"$f":"E92&\" ==>>\"","v":"Comparative Operators ==>>"},null,null,null,"Comparative Operators"]
[null,null,null,null," > Greater Than"]
[null,null,null,null," >= Greater Than Or Equal To"]
[null,null,null,null," < Less Than"]
[null,null,null,null," <= Less Than Or Equal To"]
[null,null,null,null," = Equal To"]
[null,null,null,null," <> Not Equal To"]

{"sheet":"Formulas (an)","index":8,"n_rows":98,"n_cols":6,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
["Office 2013 Class #31: Excel Basics 13: "]
["What Can Go Into Formulas: Examples of Formula Elements"]
[]
["Formulas:"]
["Calculations we can make in the cells and other locations."]
["Examples:"]
["Adding a column of expenses"]
["Adding with one condition"]
["Joining a first and last name"]
["Checking whether two numbers are in balance"]
["All formulas start with an equal sign as the first character in the cell"]
["Formulas elements (things that can go into formulas):"]
["Equal signs"]
["Cell References"]
["Math operators"]
["Numbers (if the number won't change like 12 for months in a year)"]
["Built-in functions (like SUM, SUMIFS, AVERAGE)"]
["Comparative operators (like > and <)"]
["Join Symbol: & (Ampersand)"]
["Text in double quotes (like \"Revenue\" or \", \")"]
[]
["Example 1:"]
["Adding a column of expenses: 1) equal sign, 2) SUM function, 3) range of cells"]
["Expenses","Totals for year"]
["Rent",{"$f":"950*12","v":11400}]
["Operations",{"$f":"12*5423","v":65076}]
["Admin",{"$f":"12*7000","v":84000}]
["COGS",{"$f":"100000*0.7556","v":75560}]
["Other",5987]
["Total",{"$f":"SUM(B25:B29)","v":242023}]
[]
["Example 2:"]
["Adding with one condition: 1) equal sign, 2) SUMIFS, 3) range of cells, 4) \"Text\" in quotes"]
["Type","Amounts",null,"Total Revenue"]
["Revenue",548.20000000000005,null,{"$f":"SUMIFS(B35:B39,A35:A39,\"Revenue\")","v":817.93000000000006}]
["Credit",-158.25]
["Revenue",19.5]
["Revenue",250.23]
["Credit",-25]
[]
["Example 3:"]
["Adding with one condition: 1) equal sign, 2) SUMIF, 3) range of cells, 4) cell with number and comparative operator"]
[null,"Amounts",null,"Criteria"]
[null,548.20000000000005,null,">0"," <<== Notice that when we put comparative operator and zero in a cell, Excel considers it Text."]
[null,-158.25,null,"Total Revenue"]
[null,19.5,null,{"$f":"SUMIF(B44:B48,D44)","v":817.93000000000006},"** If the sum range and criteria range are the same, use SUMIF cuz it's less to type"]
[null,250.23,null,"or","** if the sum range and criteria range are the same, only enter numbers into range argument"]
[null,-25,null,"Total Revenue"]
[null,null,null,{"$f":"SUMIF(B44:B48,\">0\")","v":817.93000000000006}," <<== If criteria will not change (Excel's Golden Rule), you can type it into formula"]
[]
[]
[]
["Example 4:"]
["Joining a first and last name: 1) equal sign, 2) cell, 3) Join Symbol, 4) Text in quotes"]
["First","Last","Join",null,"Last, First"]
["Jimmy","Garza",{"$f":"A56&\" \"&B56","v":"Jimmy Garza"},"or",{"$f":"B56&\", \"&A56","v":"Garza, Jimmy"},"Called: Text Formula"]
["Emma","Potter",{"$f":"A57&\" \"&B57","v":"Emma Potter"},null,{"$f":"B57&\", \"&A57","v":"Potter, Emma"}]
["Rolando","Robbins","Rolando Robbins",null,"Robbins, Rolando"]
["Louise","Maado","Louise Maado",null,"Maado, Louise"]
["Felicia","Cohen","Felicia Cohen",null,"Cohen, Felicia"]
["Henry","Wagner","Henry Wagner",null,"Wagner, Henry"]
["Wesley","Baldwin","Wesley Baldwin",null,"Baldwin, Wesley"]
["Sophie","Walsh","Sophie Walsh",null,"Walsh, Sophie"]
["Evelyn","Scott","Evelyn Scott",null,"Scott, Evelyn"]
["Hugh","Mason","Hugh Mason",null,"Mason, Hugh"]
[]
["Example 5:"]
["Check whether two cells are equal"]
["Checking whether two numbers are in balance: 1) equal sign, 2) cell, 3) equal sign as comparative operator, 4) cell"]
[null,"DR","CR"]
[null,65.25]
[null,null,65.25]
[null,589.00099999999998]
[null,null,589]
[null,12.25]
[null,null,12.25]
["Total",{"$f":"SUM(B71:B76)","v":666.50099999999998},666.5]
[]
["Balance?",{"$f":"B77=C77","v":false},"Called: Logical Formula"]
[]
[]
[]
[]
[{"$f":"E84&\" ==>>\"","v":"Math Operators ==>>"},null,null,null,"Math Operators"]
[null,null,null,null," ( ) represents Parentheses"," Shift + 9 and Shift + 0"]
[null,null,null,null," ^ represents Exponents (powers and roots)"," Shift + 6"]
[null,null,null,null," * represents Multiplication"," * on Number pad"]
[null,null,null,null," /  represents Division"," / on Number pad"]
[null,null,null,null," + represents Addition"," + on Number pad"]
[null,null,null,null," – represents Subtraction"," - on Number pad"]
[]
[{"$f":"E92&\" ==>>\"","v":"Comparative Operators ==>>"},null,null,null,"Comparative Operators"]
[null,null,null,null," > Greater Than"]
[null,null,null,null," >= Greater Than Or Equal To"]
[null,null,null,null," < Less Than"]
[null,null,null,null," <= Less Than Or Equal To"]
[null,null,null,null," = Equal To"]
[null,null,null,null," <> Not Equal To"]

{"sheet":"Math","index":9,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Office 2013 Class #32: Excel Basics 14: Math and Order of Operations in Excel Formulas"]
[]
["8+2*2",null,"8+2*2"]
[{"$f":"(8+2)*2","v":20},null,{"$f":"8+2*2","v":12}]
[]
["8+2*2",null,"8+2*2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Beg Qty","End Qty","Value Each","COGS",null,"COGS calculation",null,null,null,null,null,null,"Formula Inputs:"]
[{"$f":"M18","v":10},{"$f":"N18","v":3},{"$f":"O18","v":5},null,null,{"$f":"A20&\" - \"&B20&\" * \"&C20&\" = \"&A20-B20*C20","v":"10 - 3 * 5 = -5"},null,null,null,null,null,null,10,3,5]
["Beg Qty","End Qty","Value Each","COGS",null,{"$f":"M18&\" - \"&N18*O18&\" = \"&M18-N18*O18","v":"10 - 15 = -5"},null,null,null,null,null,null,10,3,5]
[{"$f":"M19","v":10},{"$f":"N19","v":3},{"$f":"O19","v":5},null,null,{"$f":"M19-N19*O19&\" = \"&M19-N19*O19","v":"-5 = -5"}]

{"sheet":"Math (an)","index":10,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Office 2013 Class #32: Excel Basics 14: Math and Order of Operations in Excel Formulas"]
[]
["8+2*2",null,"8+2*2"]
[{"$f":"(8+2)*2","v":20},null,{"$f":"8+2*2","v":12}]
[]
["8+2*2",null,"8+2*2"]
[{"$f":"(8+2)*2","v":20},null,{"$f":"8+2*2","v":12}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Beg Qty","End Qty","Value Each","COGS",null,"COGS calculation",null,null,null,null,null,null,"Formula Inputs:"]
[{"$f":"M18","v":10},{"$f":"N18","v":3},{"$f":"O18","v":5},{"$f":"A18-B18*C18","v":-5},null,{"$f":"A20&\" - \"&B20&\" * \"&C20&\" = \"&A20-B20*C20","v":"10 - 3 * 5 = -5"},null,null,null,null,null,null,10,3,5]
["Beg Qty","End Qty","Value Each","COGS",null,{"$f":"M18&\" - \"&N18*O18&\" = \"&M18-N18*O18","v":"10 - 15 = -5"},null,null,null,null,null,null,10,3,5]
[{"$f":"M19","v":10},{"$f":"N19","v":3},{"$f":"O19","v":5},{"$f":"(A20-B20)*C20","v":35},null,{"$f":"M19-N19*O19&\" = \"&M19-N19*O19","v":"-5 = -5"}]

{"sheet":"Entering Cell References","index":11,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Office 2013 Class #33: Excel Basics 15:"]
["Entering Cell References into Formulas & Edit Mode Status Bar"]
[]
["3 ways to enter cell references into formulas:"]
["1) Type. Be careful, though, errors may occur."]
["2) Mouse: Great for when cell reference is far away."]
["3) Arrow keys: great for when cell references are close."]
["As long as \"Dancing Ants\" are dancing, the arrow keys will keep moving the cell reference."]
["Lower left corner of Status Bar shows the \"Formula Editing Mode\""]
["Ready = cell is selected."]
["Enter = Arrow keys will work to put cell references in formulas."]
["Point = Arrows keys are working to get cell reference and \"Dancing Ants\" are dancing."]
["Edit = Arrow keys will move through formula characters. To get into this mode click I-beam cursor in formula."]
["You can toggle between these modes with the F2 key."]
[]
["Names","Gross Pay",{"$f":"C24","v":"Deduction 1"},{"$f":"D24","v":"Deduction 2"},"Total Deductions","Net Pay"]
["Sioux Chin",3500,{"$f":"$B17*C$25","v":217},{"$f":"$B17*D$25","v":50.75},{"$f":"SUM(C17:D17)","v":267.75}]
["Isaac Viet",3784.32,234.62784000000002,54.872640000000004,{"$f":"SUM(C18:D18)","v":289.50048000000004}]
["Dennis Ho",8565.51,531.06162000000006,124.19989500000001,{"$f":"SUM(C19:D19)","v":655.26151500000003}]
["Hien Luong Pham",2627.99,162.93537999999998,38.105854999999998,{"$f":"SUM(C20:D20)","v":201.04123499999997}]
["Tom Carolan",9069.66,562.31891999999993,131.51007000000001,{"$f":"SUM(C21:D21)","v":693.82898999999998}]
[]
[null,null,"Assumptions"]
[null,null,"Deduction 1","Deduction 2"]
[null,null,6.2E-2,1.4500000000000001E-2]

{"sheet":"Entering Cell References (an)","index":12,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Office 2013 Class #33: Excel Basics 15:"]
["Entering Cell References into Formulas & Edit Mode Status Bar"]
[]
["3 ways to enter cell references into formulas:"]
["1) Type. Be careful, though, errors may occur."]
["2) Mouse: Great for when cell reference is far away."]
["3) Arrow keys: great for when cell references are close."]
["As long as \"Dancing Ants\" are dancing, the arrow keys will keep moving the cell reference."]
["Lower left corner of Status Bar shows the \"Formula Editing Mode\""]
["Ready = cell is selected."]
["Enter = Arrow keys will work to put cell references in formulas."]
["Point = Arrows keys are working to get cell reference and \"Dancing Ants\" are dancing."]
["Edit = Arrow keys will move through formula characters. To get into this mode click I-beam cursor in formula."]
["You can toggle between these modes with the F2 key."]
[]
["Names","Gross Pay",{"$f":"C24","v":"Deduction 1"},{"$f":"D24","v":"Deduction 2"},"Total Deductions","Net Pay"]
["Sioux Chin",3500,{"$f":"$B17*C$25","v":217},{"$f":"$B17*D$25","v":50.75},{"$f":"SUM(C17:D17)","v":267.75},{"$f":"B17-E17","v":3232.25}]
["Isaac Viet",3784.32,234.62784000000002,54.872640000000004,{"$f":"SUM(C18:D18)","v":289.50048000000004},{"$f":"B18-E18","v":3494.81952}]
["Dennis Ho",8565.51,531.06162000000006,124.19989500000001,{"$f":"SUM(C19:D19)","v":655.26151500000003},7910.2484850000001]
["Hien Luong Pham",2627.99,162.93537999999998,38.105854999999998,{"$f":"SUM(C20:D20)","v":201.04123499999997},2426.9487649999996]
["Tom Carolan",9069.66,562.31891999999993,131.51007000000001,{"$f":"SUM(C21:D21)","v":693.82898999999998},8375.8310099999999]
[]
[null,null,"Assumptions"]
[null,null,"Deduction 1","Deduction 2"]
[null,null,6.2E-2,1.4500000000000001E-2]

{"sheet":"FlashFill","index":13,"n_rows":89,"n_cols":5,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
["Office 2013 Class #34: Excel Basics 16: Flash Fill To Combine or Extract Text"]
[]
["Example 4 from Video Excel Basics 13:"]
["Joining a first and last name: 1) equal sign, 2) cell, 3) Join Symbol, 4) Text in quotes"]
["First","Last","Join",null,"Last, First"]
["Jimmy","Garza",{"$f":"A6&\" \"&B6","v":"Jimmy Garza"},"or",{"$f":"B6&\", \"&A6","v":"Garza, Jimmy"}]
["Emma","Potter",{"$f":"A7&\" \"&B7","v":"Emma Potter"},null,"Potter, Emma"]
["Rolando","Robbins","Rolando Robbins",null,"Robbins, Rolando"]
["Louise","Maado","Louise Maado",null,"Maado, Louise"]
["Felicia","Cohen","Felicia Cohen",null,"Cohen, Felicia"]
["Henry","Wagner","Henry Wagner",null,"Wagner, Henry"]
["Wesley","Baldwin","Wesley Baldwin",null,"Baldwin, Wesley"]
["Sophie","Walsh","Sophie Walsh",null,"Walsh, Sophie"]
["Evelyn","Scott","Evelyn Scott",null,"Scott, Evelyn"]
["Hugh","Mason","Hugh Mason",null,"Mason, Hugh"]
[]
["What use formulas?"]
["If the source data will be changing."]
["In our case we had a template where we always changed the names and so formulas worked great form automatically updating."]
[]
["But if it is a ONE-TIME EVENT, use Flash Fill (New In Excel 2013)"]
["Flash Fill = Program by example"]
["You give Excel one or more examples, and it tries to figure out what you want."]
["If Excel can see your \"Pattern\", it will do the action."]
[]
["Combine:"]
["First","Last",{"$f":"A27&\" \"& B27","v":"First Last"}]
["Jimmy","Garza"]
["Emma","Potter"]
["Rolando","Robbins"]
["Louise","Maado"]
["Felicia","Cohen"]
["Henry","Wagner"]
["Wesley","Baldwin"]
["Sophie","Walsh"]
["Evelyn","Scott"]
["Hugh","Mason"]
[]
["Combine and add text:"]
["First","Last",{"$f":"B40&\", \"&A40","v":"Last, First"}]
["Jimmy","Garza"]
["Emma","Potter"]
["Rolando","Robbins"]
["Louise","Maado"]
["Felicia","Cohen"]
["Henry","Wagner"]
["Wesley","Baldwin"]
["Sophie","Walsh"]
["Evelyn","Scott"]
["Hugh","Mason"]
[]
["Extract first name and capitalize only first letter:"]
["Names","First"]
["JIMMY GARZA"]
["EMMA ELLA POTTER"]
["ROLANDO ROBBINS"]
["LOUISE MAADO"]
["FELICIA J COHEN"]
["HENRY WAGNER"]
["WESLEY BALDWIN"]
["SOPHIE THOMAS WALSH"]
["EVELYN SCOTT"]
["HUGH MASON"]
[]
["Extract first and middle name: Important to give it more than one example."]
["Names","First"]
["JIMMY GARZA"]
["EMMA ELLA POTTER"]
["ROLANDO ROBBINS"]
["LOUISE MAADO"]
["FELICIA J COHEN"]
["HENRY WAGNER"]
["WESLEY BALDWIN"]
["SOPHIE THOMAS WALSH"]
["EVELYN SCOTT"]
["HUGH MASON"]
[]
["Extract years:"]
["Dates","Years"]
["2013-10-30"]
["2014-10-30"]
["2015-10-30"]
["2016-10-30"]
["2017-10-30"]
["2018-10-30"]
[]
["For more examples about how Flash Fill works:"]
["What's New In Excel 2013: Flash Fill, Functions, Data Model, PowerPivot, New Charts, Table Slicers.. "]
["Flash Fill (0:33:54 min mark)"]

{"sheet":"FlashFill (an)","index":14,"n_rows":87,"n_cols":5,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
["Example 4 from Video Excel Basics 13:"]
["Joining a first and last name: 1) equal sign, 2) cell, 3) Join Symbol, 4) Text in quotes"]
["First","Last","Join",null,"Last, First"]
["Jimmy","Garza",{"$f":"A4&\" \"&B4","v":"Jimmy Garza"},"or",{"$f":"B4&\", \"&A4","v":"Garza, Jimmy"}]
["Emma","Potter",{"$f":"A5&\" \"&B5","v":"Emma Potter"},null,"Potter, Emma"]
["Rolando","Robbins","Rolando Robbins",null,"Robbins, Rolando"]
["Louise","Maado","Louise Maado",null,"Maado, Louise"]
["Felicia","Cohen","Felicia Cohen",null,"Cohen, Felicia"]
["Henry","Wagner","Henry Wagner",null,"Wagner, Henry"]
["Wesley","Baldwin","Wesley Baldwin",null,"Baldwin, Wesley"]
["Sophie","Walsh","Sophie Walsh",null,"Walsh, Sophie"]
["Evelyn","Scott","Evelyn Scott",null,"Scott, Evelyn"]
["Hugh","Mason","Hugh Mason",null,"Mason, Hugh"]
[]
["What use formulas?"]
["If the source data will be changing."]
["In our case we had a template where we always changed the names and so formulas worked great form automatically updating."]
[]
["But if it is a ONE-TIME EVENT, use Flash Fill (New In Excel 2013)"]
["Flash Fill = Program by example"]
["You give Excel one or more examples, and it tries to figure out what you want."]
["If Excel can see your \"Pattern\", it will do the action."]
[]
["Combine:"]
["First","Last",{"$f":"A25&\" \"& B25","v":"First Last"}]
["Jimmy","Garza"]
["Emma","Potter"]
["Rolando","Robbins"]
["Louise","Maado"]
["Felicia","Cohen"]
["Henry","Wagner"]
["Wesley","Baldwin"]
["Sophie","Walsh"]
["Evelyn","Scott"]
["Hugh","Mason"]
[]
["Combine and add text:"]
["First","Last",{"$f":"B38&\", \"&A38","v":"Last, First"}]
["Jimmy","Garza"]
["Emma","Potter"]
["Rolando","Robbins"]
["Louise","Maado"]
["Felicia","Cohen"]
["Henry","Wagner"]
["Wesley","Baldwin"]
["Sophie","Walsh"]
["Evelyn","Scott"]
["Hugh","Mason"]
[]
["Extract first name and capitalize only first letter:"]
["Names","First"]
["JIMMY GARZA"]
["EMMA ELLA POTTER"]
["ROLANDO ROBBINS"]
["LOUISE MAADO"]
["FELICIA J COHEN"]
["HENRY WAGNER"]
["WESLEY BALDWIN"]
["SOPHIE THOMAS WALSH"]
["EVELYN SCOTT"]
["HUGH MASON"]
[]
["Extract first and middle name: Important to give it more than one example."]
["Names","First"]
["JIMMY GARZA"]
["EMMA ELLA POTTER"]
["ROLANDO ROBBINS"]
["LOUISE MAADO"]
["FELICIA J COHEN"]
["HENRY WAGNER"]
["WESLEY BALDWIN"]
["SOPHIE THOMAS WALSH"]
["EVELYN SCOTT"]
["HUGH MASON"]
[]
["Extract years:"]
["Dates","Years"]
["2013-10-30"]
["2014-10-30"]
["2015-10-30"]
["2016-10-30"]
["2017-10-30"]
["2018-10-30"]
[]
["For more examples about how Flash Fill works:"]
["What's New In Excel 2013: Flash Fill, Functions, Data Model, PowerPivot, New Charts, Table Slicers.. "]
["Flash Fill (0:33:54 min mark)"]

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

{"sheet":"HW(1)","index":16,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Use Style and Number formatting to make this Income Statement easy to understand."]
[]
[]
[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":17,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Use Style and Number formatting to make this Income Statement easy to understand."]
[]
[]
[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]
[]
[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":"D15-D16-D17","v":869.29999999999973},1305]
["Total Expenses",{"$f":"SUM(B16:B18)","v":2592.2999999999997},2998.3,6587,7290]
["Net Income",{"$f":"B15-B19","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":"D25-D26-D27","v":869.29999999999973},1305]
["Total Expenses",{"$f":"SUM(B26:B28)","v":2592.2999999999997},2998.3,6587,7290]
["Net Income",{"$f":"B25-B29","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":"D35-D36-D37","v":869.29999999999973},1305]
["Total Expenses",{"$f":"SUM(B36:B38)","v":2592.2999999999997},2998.3,6587,7290]
["Net Income",{"$f":"B35-B39","v":3096.7000000000003},-429.30000000000018,0,1410]

{"sheet":"HW(2)","index":18,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Icrease the column widths and add Word Wrap to the filed names at the top of each column."]
[]
["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":"HW(2an)","index":19,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Icrease the column widths and add Word Wrap to the filed names at the top of each column."]
[]
["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]

{"sheet":"HW(3)","index":20,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["1) Create a Proper data set with the field names Invoice Date, Invoice number, Due Date, TODAY and Days Past Due."]
["2) Enter the records as seen in the picture to the right."]
["3) In the TODAY column create a formula that uses the TODAY function ."]
["4) In the Days Past Due column create a formulas that calculates the number of days that the invoice is late."]
["5)  In the Days Past Due column add a conditional formatting that shows invoice that are 70 days or more past due."]

{"sheet":"HW(3an)","index":21,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["1) Create a Proper data set with the field names Invoice Date, Invoice number, Due Date, TODAY and Days Past Due."]
["2) Enter the records as seen in the picture to the right."]
["3) In the TODAY column create a formula that uses the TODAY function ."]
["4) In the Days Past Due column create a formulas that calculates the number of days that the invoice is late."]
["5)  In the Days Past Due column add a conditional formatting that shows invoice that are 70 days or more past due."]
[]
[]
["Invoice Date"," Invoice number"," Due Date"," TODAY","Days Past Due"]
["2013-07-12",54891,"2013-07-27",{"$f":"TODAY()","v":"2013-10-31"},{"$f":"D9-C9","v":96}]
["2013-08-06",54901,"2013-08-21","2013-10-31",71]
["2013-09-04",54948,"2013-09-19","2013-10-31",42]
["2013-09-25",54984,"2013-10-10","2013-10-31",21]
["2013-10-01",55023,"2013-10-16","2013-10-31",15]
[]
[null,null,null,null,"or"]
[]
["Invoice Date"," Invoice number"," Due Date"," TODAY","Days Past Due",null,"Criteria:"]
["2013-07-12",54891,"2013-07-27",{"$f":"TODAY()","v":"2013-10-31"},{"$f":"D18-C18","v":96},null,70]
["2013-08-06",54901,"2013-08-21","2013-10-31",71]
["2013-09-04",54948,"2013-09-19","2013-10-31",42]
["2013-09-25",54984,"2013-10-10","2013-10-31",21]
["2013-10-01",55023,"2013-10-16","2013-10-31",15]

{"sheet":"HW(4)","index":22,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["1) In the green cells in the Employee column, create a formula to join the first and last name with a space between the first and last name."]
["2) In the green cells in the Hours Worked column, create a formula that calculate the number of hours worked,"]
["3) In the green cells in the Gross Pay column, create a formula that multiplies Hours Worked by Wage. Use the ROUND function and round to the penny."]
["4) In the green cells in the Deduction column, create a formula that multiplies Gross Pay by Tax Rate. Use the ROUND function and round to the penny."]
["5) In the green cells in the Day's Pay column, create a formula to calculate Gross Pay minus Deduction."]
[null,null,null,null,null,null,null,null,null,"Tax Rate"]
[null,null,null,null,null,null,null,null,null,7.6499999999999999E-2]
[]
["First","Last",null,"Employee","Wage","Time In","Time Out","Hours Worked","Gross Pay","Deduction","Day's Pay"]
["Carroll"," Stanley",null,null,24.94,"08:00:00","15:30:00"]
["Anne"," Ramos",null,null,18.14,"09:00:00","14:30:00"]
["Blanche"," Sanchez",null,null,17.940000000000001,"07:30:00","15:00:00"]
["Karla"," Fletcher",null,null,26.7,"08:00:00","13:30:00"]
["Devin"," Smith",null,null,24.3,"09:00:00","14:30:00"]
["Edna"," Hansen",null,null,22.85,"08:00:00","18:00:00"]
["Moses"," Swanson",null,null,26.98,"06:30:00","11:30:00"]
["Sherman"," Moss",null,null,17.71,"08:00:00","13:00:00"]
["Amber"," Rios",null,null,20.12,"07:00:00","16:30:00"]
["Lindsey"," Powers",null,null,23.69,"08:00:00","15:00:00"]

{"sheet":"HW(4an)","index":23,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["1) In the green cells in the Employee column, create a formula to join the first and last name with a space between the first and last name."]
["2) In the green cells in the Hours Worked column, create a formula that calculate the number of hours worked,"]
["3) In the green cells in the Gross Pay column, create a formula that multiplies Hours Worked by Wage. Use the ROUND function and round to the penny."]
["4) In the green cells in the Deduction column, create a formula that multiplies Gross Pay by Tax Rate. Use the ROUND function and round to the penny."]
["5) In the green cells in the Day's Pay column, create a formula to calculate Gross Pay minus Deduction."]
[null,null,null,null,null,null,null,null,null,"Tax Rate"]
[null,null,null,null,null,null,null,null,null,7.6499999999999999E-2]
[]
["First","Last",null,"Employee","Wage","Time In","Time Out","Hours Worked","Gross Pay","Deduction","Day's Pay"]
["Carroll"," Stanley",null,{"$f":"A10&\" \"&B10","v":"Carroll  Stanley"},24.94,"08:00:00","15:30:00",{"$f":"(G10-F10)*24","v":7.5000000000000018},{"$f":"ROUND(H10*E10,2)","v":187.05},{"$f":"ROUND(I10*$J$7,2)","v":14.31},{"$f":"I10-J10","v":172.74}]
["Anne"," Ramos",null,"Anne  Ramos",18.14,"09:00:00","14:30:00",5.5000000000000018,99.77,7.63,92.14]
["Blanche"," Sanchez",null,"Blanche  Sanchez",17.940000000000001,"07:30:00","15:00:00",7.5000000000000027,134.55000000000001,10.29,124.26000000000002]
["Karla"," Fletcher",null,"Karla  Fletcher",26.7,"08:00:00","13:30:00",5.5,146.85,11.23,135.62]
["Devin"," Smith",null,"Devin  Smith",24.3,"09:00:00","14:30:00",5.5000000000000018,133.65,10.220000000000001,123.43]
["Edna"," Hansen",null,"Edna  Hansen",22.85,"08:00:00","18:00:00",10,228.5,17.48,211.02]
["Moses"," Swanson",null,"Moses  Swanson",26.98,"06:30:00","11:30:00",5,134.9,10.32,124.58000000000001]
["Sherman"," Moss",null,"Sherman  Moss",17.71,"08:00:00","13:00:00",5,88.55,6.77,81.78]
["Amber"," Rios",null,"Amber  Rios",20.12,"07:00:00","16:30:00",9.5000000000000018,191.14,14.62,176.51999999999998]
["Lindsey"," Powers",null,"Lindsey  Powers",23.69,"08:00:00","15:00:00",7,165.83,12.69,153.14000000000001]

{"sheet":"HW(5)","index":24,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Fix the formula in cell D5."]
[]
[]
["Beg Qty","End Qty","Value Each","COGS"]
[545,274,105,{"$f":"A5-B5*C5","v":-28225}]

{"sheet":"HW(5an)","index":25,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Fix the formula in cell D5."]
[]
[]
["Beg Qty","End Qty","Value Each","COGS"]
[545,274,105,{"$f":"(A5-B5)*C5","v":28455}]

{"sheet":"HW(6)","index":26,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Extract first and middle name: Important to give it more than one example."]
["Names","First"]
["JIMMY GARZA"]
["EMMA ELLA POTTER"]
["ROLANDO ROBBINS"]
["LOUISE MAADO"]
["FELICIA J COHEN"]
["HENRY WAGNER"]
["WESLEY BALDWIN"]
["SOPHIE THOMAS WALSH"]
["EVELYN SCOTT"]
["HUGH MASON"]
[]
["Extract years:"]
["Dates","Years"]
["2013-10-30"]
["2014-10-30"]
["2015-10-30"]
["2016-10-30"]
["2017-10-30"]
["2018-10-30"]

{"sheet":"HW(6an)","index":27,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Extract first and middle name: Important to give it more than one example."]
[null,"Flash Fill:"]
["Names","First"]
["JIMMY GARZA","Jimmy"]
["EMMA ELLA POTTER","Emma Ella"]
["ROLANDO ROBBINS","Rolando"]
["LOUISE MAADO","Louise"]
["FELICIA J COHEN","Felicia J"]
["HENRY WAGNER","Henry"]
["WESLEY BALDWIN","Wesley"]
["SOPHIE THOMAS WALSH","Sophie Thomas"]
["EVELYN SCOTT","Evelyn"]
["HUGH MASON","Hugh"]
[]
["Extract years:"]
[null,"Flash Fill:"]
["Dates","Years"]
["2013-10-30",2013]
["2014-10-30",2014]
["2015-10-30",2015]
["2016-10-30",2016]
["2017-10-30",2017]
["2018-10-30",2018]