{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Example Data","Data","Sample Data","Contents","Autofill Ordinal","Custom AutoFill","Data Validation List","Fractions","Burndown Chart","Camera","Compare Tables","EOM","Format Million","Hide Cell Math Answer","Remove Blanks","Running Total","Emoji in Cell","XLOOKUP"],"not_rendered":{"charts":2,"images":34,"macros":0,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Example Data","index":0,"n_rows":101,"n_cols":17,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
["Rep Name","Division","Years of Service","Office","Product Line","Jan '23 Sales","Feb '23 Sales","Mar '23 Sales","Apr '23 Sales","May '23 Sales","Jun '23 Sales","Jul '23 Sales","Aug '23 Sales","Sep '23 Sales","Oct '23 Sales","Nov '23 Sales","Dec '23 Sales"]
["Aiden","Eastern","1-15","Regional Office","Red Line",43088,49622,55022,44773,37947,31151,44749,51187,44301,49373,30808,38174]
["Cam","Eastern","1-15","Satellite Office","Blue Line",49568,31677,37473,49823,48399,33053,55899,45613,53277,45205,54153,37180]
["Rodrigo","Western","16-30","Satellite Office","Blue Line",41107,54474,34968,45911,30109,52646,37564,47606,46534,46150,39191,45605]
["Liam","Western","16-30","Home Office","Orange Line",51734,32650,38035,45420,39822,41141,44823,38626,32508,46834,34396,48335]
["Peiola","International","1-15","Home Office","Orange Line",46837,47459,43975,54172,50582,54523,46937,44649,45693,52609,35361,50404]
["Jack","Western","16-30","Satellite Office","Blue Line",55544,46828,36822,34858,52576,30158,47500,55537,50931,36122,53614,34353]
["Nora","Southern","16-30","Satellite Office","Blue Line",32211,46725,53770,39571,50084,44620,46818,52995,53548,48707,37049,45819]
["Ananya","International","31+","Satellite Office","Blue Line",45375,35171,36170,47549,38226,32022,34380,30058,42763,37764,51279,49283]
["Nalu","International","31+","Satellite Office","Blue Line",43629,47125,33849,41416,41936,45524,39793,37651,42346,38653,35115,55862]
["Kaelity","Southern","31+","Regional Office","Red Line",42628,41552,40988,52514,48512,53325,33644,34720,33281,37667,33293,48827]
["Zara","Northern","31+","Corporate Headquarters","Yellow Line",53769,45488,47652,54682,44829,55006,52822,49446,47369,45191,47414,52892]
["Wyatt","Southern","1-15","Corporate Headquarters","Yellow Line",34548,38104,45289,43639,32589,33003,40844,52284,46363,52992,45800,53944]
["Liko","International","16-30","Home Office","Orange Line",31017,37608,43032,47695,35846,55239,50475,36841,36565,41243,39565,46804]
["Leo","International","16-30","Regional Office","Red Line",46719,37665,44002,48971,51225,33200,45633,49787,55297,53841,38019,32131]
["Penelope","Western","31+","Corporate Headquarters","Yellow Line",43814,35827,44299,42169,43974,55341,35227,51487,31767,45128,41060,34503]
["Brayden","Eastern","1-15","Regional Office","Red Line",35171,51218,36847,36450,40937,36342,34345,48476,30762,49679,51289,54222]
["Caleb","Western","1-15","Corporate Headquarters","Yellow Line",51879,48697,35533,46268,31895,47439,42020,31460,49702,33472,51958,50578]
["Emma","International","16-30","Home Office","Orange Line",45094,32292,54616,38895,39955,43837,42549,42904,41083,42506,41443,41875]
["Philipe","Northern","31+","Corporate Headquarters","Yellow Line",40107,33182,47839,54946,52232,31681,51816,53952,55056,32338,34383,45834]
["Raj","Eastern","31+","Satellite Office","Blue Line",35794,41955,49055,41841,55110,30031,44259,33795,41163,35502,45145,45245]
["Quin","Northern","1-15","Satellite Office","Blue Line",54538,43420,37957,44561,33680,50889,54703,53955,38775,49643,36509,30979]
["Grace","Eastern","31+","Corporate Headquarters","Yellow Line",33028,38868,53149,35727,45722,33253,52924,49456,55218,48970,41482,49009]
["Winona","Eastern","31+","Home Office","Orange Line",52029,35889,40870,38185,53415,50488,31481,30297,53307,50253,35844,33868]
["Zoe","Midwest","31+","Corporate Headquarters","Yellow Line",44294,38190,31053,34839,37302,40423,45238,54520,48725,52393,48966,55971]
["Victoria","Eastern","31+","Home Office","Orange Line",51583,44533,47792,53107,55593,53515,34358,31748,43358,38392,42902,30079]
["Ethan","Eastern","31+","Satellite Office","Blue Line",54745,39533,54708,54974,44967,48502,37528,50508,33554,49013,30290,54556]
["Luke","Eastern","16-30","Regional Office","Red Line",34199,33714,41840,31202,50271,49826,33061,34503,48757,53930,39704,42610]
["Antonio","International","31+","Home Office","Orange Line",47181,54672,50751,30175,36311,33029,47554,35641,51290,39226,33248,45063]
["Lolani","Southern","16-30","Home Office","Orange Line",54825,40077,35599,35857,42863,45712,39466,42830,33107,31053,55664,46906]
["Noah","Midwest","16-30","Regional Office","Red Line",33951,48396,46221,36786,33014,33311,31173,54526,49930,35379,38652,30556]
["Logan","International","31+","Home Office","Orange Line",55775,42572,41339,41327,53331,37226,38553,42436,34535,52653,35589,38890]
["Mason","International","31+","Satellite Office","Blue Line",35421,48283,50071,33927,52590,45238,39433,33168,38171,54115,42016,50578]
["Tahoma","Eastern","1-15","Home Office","Orange Line",38016,37352,47085,48775,33979,37621,38892,38209,47748,41055,35161,32343]
["Levi","Eastern","16-30","Satellite Office","Blue Line",36024,47824,53874,33182,37676,40139,50274,36660,45749,44819,35052,51694]
["Manitou","International","16-30","Corporate Headquarters","Yellow Line",41238,33525,50079,41362,43785,35935,45996,50660,49573,55318,53116,55731]
["Sofia","Midwest","16-30","Corporate Headquarters","Yellow Line",36935,31591,54491,44361,42833,33782,36440,37487,41261,32201,47882,32854]
["Jackson","Northern","16-30","Home Office","Orange Line",55903,46920,41313,32645,41734,49370,48220,51581,47606,37638,46474,53260]
["Abigail","Eastern","31+","Corporate Headquarters","Yellow Line",51685,37259,44541,39092,31667,30452,49525,33440,46454,37510,47165,51225]
["Mia","Southern","16-30","Corporate Headquarters","Yellow Line",37795,54875,40092,54926,33286,49177,36682,54493,31417,50658,46471,51724]
["Savannah","Southern","1-15","Home Office","Orange Line",53326,36588,41961,45054,37377,46971,39038,41294,53536,40709,55949,53592]
["Owen","Northern","16-30","Corporate Headquarters","Yellow Line",31026,45558,55806,45099,45572,46492,34084,37706,46019,53001,42998,38269]
["Santiago","Southern","1-15","Home Office","Orange Line",54234,54696,35833,34366,33327,36203,52399,33587,41263,50281,52851,37278]
["Chloe","Midwest","16-30","Satellite Office","Blue Line",33725,55114,39088,55322,46900,49078,37101,49513,43118,31062,55269,42140]
["Leilani","Western","16-30","Regional Office","Red Line",32536,46837,41582,35370,42015,43335,37030,41918,37319,47282,52516,45644]
["Ayita","Northern","16-30","Regional Office","Red Line",41682,54044,37439,34018,51298,47024,32303,35621,32812,38229,32303,49346]
["Samuel","Southern","31+","Home Office","Orange Line",47120,54911,43065,39693,42424,38553,52106,30539,53943,39893,47098,48233]
["Maya","Eastern","16-30","Home Office","Orange Line",40498,32687,54346,31140,34903,31062,45862,30273,51124,48123,36107,46755]
["Odina","Western","16-30","Satellite Office","Blue Line",48766,41143,43387,52656,50832,41432,33378,45518,35487,37143,32803,45807]
["Azurino","Western","1-15","Home Office","Orange Line",33311,35078,44477,52510,32710,46268,50592,37001,51988,50908,30350,33229]
["Layla","Eastern","16-30","Corporate Headquarters","Yellow Line",43924,49067,30829,55736,45935,48571,35195,43693,48637,33402,37237,42317]
["Ava","International","1-15","Home Office","Orange Line",44224,31296,34739,36299,44597,44796,44486,43141,32284,51374,38641,33310]
["Jayden","International","1-15","Satellite Office","Blue Line",38720,48773,39915,53319,38197,34558,55659,30645,53116,33259,54293,42813]
["Zoey","Southern","31+","Corporate Headquarters","Yellow Line",47174,45470,45409,52257,40345,41861,35647,52194,40785,48082,30286,40107]
["Koa","International","31+","Satellite Office","Blue Line",41722,53292,36149,31453,42291,52068,37597,53983,48070,32533,47325,53477]
["Isabella","Midwest","16-30","Regional Office","Red Line",53550,47452,34829,41006,52410,54542,36610,48820,36500,48576,41857,47859]
["Ed","International","16-30","Home Office","Orange Line",39537,36742,43016,31360,33008,37461,31924,33726,32304,47692,45173,41957]
["Diego","Southern","31+","Corporate Headquarters","Yellow Line",38469,43266,53140,38859,51454,44494,36222,30479,44471,52824,33575,40850]
["Meera","Western","16-30","Home Office","Orange Line",32327,39375,52224,50660,30572,46891,54587,38219,37980,45863,45785,40772]
["Aria","International","16-30","Corporate Headquarters","Yellow Line",43837,41590,36957,54189,30292,39177,53879,54604,43749,42027,40690,39954]
["Lolilta","International","31+","Corporate Headquarters","Yellow Line",41816,46731,54983,54719,53426,37956,32108,42144,53822,39218,40900,40610]
["Priya","Southern","16-30","Satellite Office","Blue Line",54888,44629,51116,45227,33167,42301,34088,51450,52569,52633,33890,43166]
["Kaya","Southern","31+","Regional Office","Red Line",41587,50798,42422,42545,42736,53187,53063,36700,35427,44387,32380,34038]
["Lucas","Western","31+","Satellite Office","Blue Line",45751,37633,47299,34100,33731,49857,42991,53034,53474,49585,34688,39406]
["Frial","Northern","1-15","Home Office","Orange Line",36570,49815,36365,33201,45433,38843,38563,45059,50306,54348,33368,40930]
["Madison","Southern","31+","Satellite Office","Blue Line",53206,39088,32289,41291,30248,46863,46991,36793,41514,44073,31703,55256]
["Luis","Southern","1-15","Home Office","Orange Line",55459,42922,45908,41311,34210,54565,44997,38284,33944,49675,41050,45654]
["Olivia","Midwest","16-30","Corporate Headquarters","Yellow Line",52671,41511,38938,40067,54291,53349,35048,43118,42220,33272,55106,37790]
["Mahina","International","16-30","Corporate Headquarters","Yellow Line",31934,37793,48236,42600,45221,49522,32901,51703,37761,36375,45255,37714]
["Marta","Midwest","31+","Corporate Headquarters","Yellow Line",43588,43662,45129,51021,51861,37676,55248,41873,39158,54584,55734,35206]
["Thaloina","Western","1-15","Satellite Office","Blue Line",37423,37193,32662,36502,53200,41096,37592,47707,54666,53194,47556,42462]
["Xanthe","Eastern","1-15","Home Office","Orange Line",54351,39328,53815,33504,41297,37445,39827,31493,43486,42604,37585,37241]
["Benjamin","Midwest","31+","Home Office","Orange Line",32508,37735,53772,30060,31282,49731,51225,32280,39348,54518,30366,39384]
["Mateo","Southern","1-15","Satellite Office","Blue Line",50779,39212,43176,30249,43709,30657,47864,43336,37308,55676,40327,39842]
["Sequoia","Western","31+","Regional Office","Red Line",34006,46292,34630,55963,31468,43082,35784,30073,48526,45750,32329,32485]
["Addison","Southern","31+","Corporate Headquarters","Yellow Line",45057,42789,37670,42617,41055,46606,34174,48749,49354,47426,49749,55870]
["Carter","Midwest","16-30","Home Office","Orange Line",48512,49089,50568,37173,42327,35548,31551,50188,33216,41648,48696,42958]
["Scarlett","Northern","1-15","Regional Office","Red Line",32593,38495,43559,37987,42453,36707,44986,36327,44889,40678,46302,33359]
["Henry","Eastern","16-30","Corporate Headquarters","Yellow Line",51797,49652,50695,30955,31001,47856,41729,38313,32998,42897,35128,37587]
["Gabriel","International","1-15","Corporate Headquarters","Yellow Line",39407,51399,50140,51040,49182,45963,45192,38476,41388,31783,48741,30810]
["Jezell","Northern","31+","Satellite Office","Blue Line",48141,51564,50809,48347,41077,30321,31095,36302,51393,55279,35552,54049]
["Elijah","Midwest","1-15","Regional Office","Red Line",50941,31475,47329,46178,46918,52445,53435,54568,37346,45621,54360,39610]
["Hiroshi","Southern","16-30","Satellite Office","Blue Line",38831,35255,38048,49891,47831,41920,33674,40850,48950,49883,55063,46356]
["Sophia","Eastern","16-30","Regional Office","Red Line",49989,36779,36511,48661,30046,44102,49638,33491,30812,32725,55861,41264]
["Zane","Midwest","16-30","Corporate Headquarters","Yellow Line",37782,46262,41008,37533,32753,34563,37483,40015,35931,31314,53019,53866]
["Amelia","Northern","16-30","Regional Office","Red Line",36799,50977,43134,42598,31066,49758,41016,51929,39202,50600,42047,37351]
["Kae","Southern","1-15","Home Office","Orange Line",46016,44914,43370,46861,55973,32165,48204,34639,47749,49540,32906,37871]
["Mai","Northern","1-15","Satellite Office","Blue Line",30564,38612,39379,45068,39944,44721,42145,54069,30087,33711,35991,46849]
["Lulu","Eastern","16-30","Satellite Office","Blue Line",33012,50699,41120,52114,35641,40281,44608,36720,39206,42286,46092,51920]
["Alejandro","Eastern","16-30","Regional Office","Red Line",35941,34640,50977,54276,37086,43227,49441,34147,50570,39513,44699,54789]
["Alexander","Eastern","31+","Corporate Headquarters","Yellow Line",36113,51533,40158,37167,39567,51914,47980,51122,55403,33495,46232,48660]
["Zeph","Midwest","31+","Satellite Office","Blue Line",51813,40445,38769,35155,37398,33015,51953,42060,51474,31358,53985,42551]
["Nakoda","Northern","31+","Home Office","Orange Line",50269,33474,52357,40264,52555,36613,49214,54361,33131,40204,34528,51145]
["Malia","Southern","1-15","Satellite Office","Blue Line",48378,53309,39399,41899,31575,47834,50733,40623,51686,46517,52272,41871]
["Lily","Southern","31+","Corporate Headquarters","Yellow Line",40244,32168,31595,50049,55286,36481,53037,33197,55378,41803,46247,32750]
["Malik","Midwest","1-15","Home Office","Orange Line",36174,41895,47793,43466,33059,55509,39457,52802,47204,52413,41887,54673]
["Harper","Southern","16-30","Regional Office","Red Line",53912,44408,41093,47264,50936,53413,53702,43838,45730,42054,35247,55738]
["Aiyana","Eastern","16-30","Home Office","Orange Line",35489,51243,41795,34806,38431,43262,55026,33796,49070,54885,38957,49154]
["Takoda","Southern","16-30","Corporate Headquarters","Yellow Line",39776,48630,33099,47118,51372,44218,34755,40397,41654,45374,43465,48866]
["Ella","Midwest","31+","Satellite Office","Blue Line",55979,53161,39222,47869,36371,51145,44965,38252,52324,43313,50836,51981]
["Riley","Midwest","16-30","Regional Office","Red Line",37134,39933,43982,51332,39861,39955,31459,41631,50358,50647,34290,33474]

{"sheet":"Data","index":1,"n_rows":28,"n_cols":19,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Data for Examples"]
[]
[null,"Division","JAN","FEB","MAR","1st\nQtr","APR","MAY","JUN","2nd Qtr","JUL","AUG","SEP","3rd\nQtr","OCT","NOV","DEC","4th\nQtr","Totals"]
[null,"North",87,91,95,{"$f":"SUM(C4:E4)","v":273},null,84,86,{"$f":"SUM(G4:I4)","v":170},59,81,66,{"$f":"SUM(K4:M4)","v":206},71,59,89,{"$f":"SUM(O4:Q4)","v":219},{"$f":"SUM(R4,N4,J4,F4)","v":868}]
[null,"South",67,99,92,258,80,99,79,258,71,74,74,219,75,68,93,236,971]
[null,"East",88,55,83,226,83,76,87,246,86,96,65,247,65,99,93,257,976]
[null,"West",65,47,86,198,74,61,87,222,84,91,89,264,76,83,92,251,935]
[null,"Northwest",57,94,99,250,83,98,80,261,77,60,87,224,60,62,92,214,949]
[null,"Southeast",92,91,59,242,68,94,91,253,64,72,57,193,61,56,56,173,861]
[null,"Northeast",57,89,70,216,68,69,76,213,87,70,92,249,64,73,66,203,881]
[null,"Southwest",98,72,61,231,60,57,96,213,77,60,57,194,74,77,70,221,859]
[null,"Midwest",81,76,72,229,59,85,75,219,77,72,60,209,92,68,85,245,902]
[null,"Territories",89,93,66,248,90,82,85,257,97,92,78,267,83,57,65,205,977]
[null,"Totals",{"$f":"SUM(C4:C13)","v":781},807,783,2371,665,805,842,2312,779,768,725,2272,721,702,801,2224,9179]
[]
[]
[null,"Division","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","Totals"]
[null,"North",87,91,95,null,84,86,59,81,66,71,59,89,{"$f":"SUM(C18:N18)","v":868}]
[null,"South",67,99,92,80,99,79,71,74,74,75,68,93,{"$f":"SUM(C19:N19)","v":971}]
[null,"East",88,55,83,83,76,87,86,96,65,65,99,93,976]
[null,"West",65,47,86,74,61,87,84,91,89,76,83,92,935]
[null,"Northwest",57,94,99,83,98,80,77,60,87,60,62,92,949]
[null,"Southeast",92,91,59,68,94,91,64,72,57,61,56,56,861]
[null,"Northeast",57,89,70,68,69,76,87,70,92,64,73,66,881]
[null,"Southwest",98,72,61,60,57,96,77,60,57,74,77,70,859]
[null,"Midwest",81,76,72,59,85,75,77,72,60,92,68,85,902]
[null,"Territories",89,93,66,90,82,85,97,92,78,83,57,65,977]
[null,"Totals",{"$f":"SUM(C18:C27)","v":781},807,783,665,805,842,779,768,725,721,702,801,9179]

{"sheet":"Sample Data","index":2,"n_rows":12,"n_cols":18,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Division","JAN","FEB","MAR","1st\nQtr","APR","MAY","JUN","2nd Qtr","JUL","AUG","SEP","3rd\nQtr","OCT","NOV","DEC","4th\nQtr","Totals"]
["North",87,91,95,{"$f":"SUM(B2:D2)","v":273},61,84,86,{"$f":"SUM(F2:H2)","v":231},59,81,66,{"$f":"SUM(J2:L2)","v":206},71,59,89,{"$f":"SUM(N2:P2)","v":219},{"$f":"SUM(Q2,M2,I2,E2)","v":929}]
["South",67,99,92,258,80,99,79,258,71,74,74,219,75,68,93,236,971]
["East",88,55,83,226,83,76,87,246,86,96,65,247,65,99,93,257,976]
["West",88,95,67,250,70,97,78,245,86,57,78,221,81,94,60,235,951]
["Northwest",57,94,99,250,59,98,80,237,77,60,87,224,60,62,92,214,925]
["Southeast",92,91,59,242,68,94,91,253,64,72,57,193,61,56,56,173,861]
["Northeast",57,89,70,216,68,69,76,213,87,70,92,249,64,73,66,203,881]
["Southwest",98,72,61,231,60,57,96,213,77,60,57,194,74,77,70,221,859]
["Midwest",81,76,72,229,59,85,75,219,77,72,60,209,92,68,85,245,902]
["Territories",84,93,66,243,90,82,85,257,97,92,78,267,97,57,65,219,986]
["Totals",{"$f":"SUM(B2:B11)","v":799},855,764,2418,698,841,833,2372,781,734,714,2229,740,713,769,2222,9241]

{"sheet":"Contents","index":3,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["CONTENTS"]
["Autofill Ordinal"]
["Custom AutoFill"]
["Data Validation List"]
["Fractions"]
["Burndown Chart"]
["Compare Tables"]
["EOM"]
["Format Million"]
["Hide Cell Math Answer"]
["Remove Blanks"]
["Running Total"]
["Emoji in Cell"]
["XLOOKUP"]

{"sheet":"Autofill Ordinal","index":4,"n_rows":13,"n_cols":23,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,null,"Use Superscript",null,"Last Day of Month","Create the pattern",null,"Numbers","Pattern","Ctrl + ;","Ctrl+ + Shift + ;","Day","Month","Quarter","Quarter","Word #","# Word","Formats"]
["1st","OR","1st",null,"2025-01-31","2025-01-31",null,500,0,null,null,"Wed","November","Qtr 1","Quarter 3","Person 1","50 - Item Number","ITEM 01",null,"JAN","FEB","MAR","1st Qtr"]
["2nd",null,"2nd",null,"2025-02-28","2025-02-28",null,null,5,null,null,null,null,null,null,null,null,"ITEM 02"]
[null,null,null,null,"2025-03-31",null,null,null,null,null,null,null,null,null,null,null,null,"ITEM 03"]
[null,null,null,null,"2025-04-30"]
[null,null,null,null,"2025-05-31"]
[null,null,null,null,"2025-06-30"]
[null,null,null,null,"2025-07-31"]
[null,null,null,null,"2025-08-31"]
[null,null,null,null,"2025-09-30"]
[null,null,null,null,"2025-10-31"]
[null,null,null,null,"2025-11-30"]
[null,null,null,null,"2025-12-31"]

{"sheet":"Custom AutoFill","index":5,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Let's see an example ➡️","Sheri Example:",null,null,"Stock Name","Ticker Symbol",null,"Let's make a list\n⬇️"]
[null,"Vicki",null,null,"Goldman Sachs Group Inc.","GS",null,"AMGN"]
[null,null,null,null,"Home Depot Inc.","HD"]
[null,null,null,null,"Caterpillar Inc.","CAT"]
[null,null,null,null,"Amgen Inc.","AMGN"]
[null,null,null,null,"JPMorgan Chase & Co.","JPM"]

{"sheet":"Data Validation List","index":6,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,0,1,3],[1,5,6,5],[1,7,6,7],[1,9,6,9]]}
["Data Validation Lists",null,null,null,null,null,"Click a cell to see an example of a list ⬇️",null,"Let's make a list\n⬇️",null,"Click a cell to see a ticker example ⬇️","This column has an example of using IFS to match the ticker to the stock."]
["The top 5 stocks from the Dow Jones Industrial Average (DJIA)\nas of the most recent closing March 26, 2024:",null,null,null,null,"Data Validation Example\nName of Stock","Name of Stock","Data Validation Example\nStock Ticker Symbol","Stock Ticker Symbol","Data Validation Example with IFS statement","Stock Ticker Symbol","Name of Stock"]
[1,"Goldman Sachs Group Inc. (GS):\nClosing price of $413.71 with a 4.35% gain.","Goldman Sachs Group Inc.","GS",null,null,"Home Depot Inc.",null,null,null,"HD",{"$f":"IFERROR(_xlfn.IFS(K3=$D$3,$C$3,K3=$D$4,$C$4,K3=$D$5,$C$5,K3=$D$6,$C$6,K3=$D$7,$C$7),\"Enter Ticker\")","v":"Home Depot Inc."}]
[2,"Home Depot Inc. (HD):\nClosing price of $395.20 with a 2.81% gain.","Home Depot Inc.","HD",null,null,"Caterpillar Inc.",null,null,null,"JPM",{"$f":"IFERROR(_xlfn.IFS(K4=$D$3,$C$3,K4=$D$4,$C$4,K4=$D$5,$C$5,K4=$D$6,$C$6,K4=$D$7,$C$7),\"Enter Ticker\")","v":"JPMorgan Chase & Co."}]
[3,"Caterpillar Inc. (CAT):\nClosing price of $364.56 with a 2.28% gain.","Caterpillar Inc.","CAT",null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.IFS(K5=$D$3,$C$3,K5=$D$4,$C$4,K5=$D$5,$C$5,K5=$D$6,$C$6,K5=$D$7,$C$7),\"Enter Ticker\")","v":"Enter Ticker"}]
[4,"Amgen Inc. (AMGN):\nClosing price of $276.95 with a 1.43% gain.","Amgen Inc.","AMGN",null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.IFS(K6=$D$3,$C$3,K6=$D$4,$C$4,K6=$D$5,$C$5,K6=$D$6,$C$6,K6=$D$7,$C$7),\"Enter Ticker\")","v":"Enter Ticker"}]
[5,"JPMorgan Chase & Co. (JPM):\nClosing price of $199.06 with a 1.39% gain1.","JPMorgan Chase & Co.","JPM",null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.IFS(K7=$D$3,$C$3,K7=$D$4,$C$4,K7=$D$5,$C$5,K7=$D$6,$C$6,K7=$D$7,$C$7),\"Enter Ticker\")","v":"Enter Ticker"}]
[null,"Note: Use Alt+Enter to use a Return within a cell.",null,null,null,"Note: This can be done with larger lists and the source data can be hidden or in another location."]

{"sheet":"Fractions","index":7,"n_rows":103,"n_cols":7,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Let's type fractions\n⬇️",null,"It should look like this  ⬇️"]
[null,null,null,null,null,"⬅️ Propertly enter 3/4",0.75]
[null,null,null,null,null,"⬅️ Propertly enter 7/5",1.4]
[null,null,null,null,null,"⬅️ Propertly enter 1/2",0.5]
[null,null,null,null,null,"⬅️ Propertly enter 1 7/8",1.875]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Select Cell ® Enter Number ® Fraction results","Example Result","Example Result"]
[null,"No change in format","Format updated"]
["Up to one digit (1/4)",0.25,0.25]
["Up to two digits (21/25) \u009f numbers move to accommodate 2 digits",0.84,0.84]
["Up to three digits (312/943) \u009f numbers move to accommodate 3 digits",0.33085896076352067,0.33085896076352067]
["As halves (1/2)",0.5,0.5]
["As quarters (2/4)",0.5,0.5]
["As eighths (4/8)",0.5,0.5]
["As sixteenths (8/16)",0.5,0.5]
["As tenths (3/10)",0.3,0.3]
["As hundredths (30/100)",0.3,0.3]
[]
["Some guidelines"]
["If Excel can’t display the exact fraction, Excel will round"]
["Excel converts fractions to the lowest denominator when entered"]
["For example, if you enter 0 5/10, Excel will display 1/2"]
["If you don’t want Excel to convert the lowest denominator, create a custom format"]
["??/10","No Format","Formatted ??/10","What was typed"]
[null,0.5,0.5,"0 5/10"]
[null,0.5,0.5,"0 2/20"]
[null,1.25,1.25,"0 5/4"]
[null,2.2000000000000002,2.2000000000000002,"0 22/10"]
[]
["Note: The custom format does not work with all fractions."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Be sure to match the section component to the entered denominator. For instance, if you entered 0 5/100, you’d use the format ???/100. You could enter ?/100, but ???/100 would accommodate a 3-digit numerator."]
["If you want to enter fractions as fractions by displaying the underlying value, format the entries using one of the Number formats. In this way, you can quickly enter fractions without converting them to whole and decimal values in your head."]
["It’s up to you whether you need to format fractions differently than Excel’s first display. The way you’re using those fractions will help you make that decision."]

{"sheet":"Burndown Chart","index":8,"n_rows":35,"n_cols":13,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[1,9,1,13],[4,0,4,5],[3,0,3,5],[31,0,31,5],[34,0,34,5],[33,0,33,5],[32,0,32,5],[2,0,2,5],[32,9,34,13],[5,0,5,5],[2,9,3,13],[4,9,4,13],[5,9,5,13]]}
["Burndown Chart"]
["A burndown chart is a line chart that visually represents the remaining tasks versus the amount of time left to complete. Burndown charts allow team members to view progress and adapt their efforts to meet goals.",null,null,null,null,null,null,null,null,"The example on the left is date dependant. The tracking is to identify if the project is running on schedule, therefore the date is important. To simply track the estimated and actual duration, the date is not needed."]
["A burndown chart requires three columns in Excel of which two must be durations. There is an estimated task duration and actual task duration.",null,null,null,null,null,null,null,null,"Example 2:\nTracking not based on dates,\ntracking to identify duration for next time"]
["Example 1:\nTracking real-time for being ahead or behind schedule"]
["In this example, the data represents the goal to begin on January 8 and complete all tasks by January 19.",null,null,null,null,null,null,null,null,"In this example, the data represents the goal to track the estimated time versus the actual time."]
["Task durations are in days.",null,null,null,null,null,null,null,null,"Task durations are in days."]
[null,"Date of task"," Estimated Task Duration","Actual Task Duration","Task",null,null,null,null,null,"Task"," Estimated Task Duration","Actual Task Duration"]
[null,"2024-01-08",5,5,"Task 01",null,null,null,null,null,"Event venues",8,6]
[null,"2024-01-09",5,5,"Task 02",null,null,null,null,null,"Food",4,5]
[null,"2024-01-10",1,2,"Task 03",null,null,null,null,null,"Marketing",15,10]
[null,"2024-01-11",4,3,"Task 04",null,null,null,null,null,"Speakers",15,20]
[null,"2024-01-12",6,5,"Task 05",null,null,null,null,null,"Sponsors",15,15]
[null,"2024-01-15",2,3,"Task 06",null,null,null,null,null,"Sessions",15,8]
[null,"2024-01-16",5,5,"Task 07",null,null,null,null,null,"Materials",15,12]
[null,"2024-01-17",4,4,"Task 08",null,null,null,null,null,"Catering",7,10]
[null,"2024-01-18",3,1,"Task 09",null,null,null,null,null,"Badges",5,3]
[null,"2024-01-19",1,1,"Task 10",null,null,null,null,null,"Materials",10,6]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The chart shows when you are ahead of schedule. Anytime the green line (Actual Task Duration) goes above the black line (Estimated Task Duration) you are behind schedule."]
["The chart shows when you are behind schedule. Anytime the green line (Actual Task Duration) goes below the black line (Estimated Task Duration) you are ahead of schedule.",null,null,null,null,null,null,null,null,"The chart is not about being on schedule because dates are not included, it shows how much longer or how much less time a task took than was scheduled.\nAnytime the green line (Actual Task Duration) goes below the black line (Estimated Task Duration) it simply shows the task took less time than anticipated."]
["When the green and black line meet, you are exactly on schedule at that point in time."]
["You finished on time as shown by the meeting of the green and black lines."]

{"sheet":"Camera","index":9,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,1,19,2],[5,1,5,2],[1,1,3,2],[18,1,18,2],[17,1,17,2]]}
[]
[null,"The Excel Camera Tool is a nifty feature that allows you to create dynamic\nscreenshots of specific ranges of cells in your Excel spreadsheet.\nThese snapshots update automatically when the source data changes.",null,null,null,"Division","Jan","Feb","Mar","Total",null,"Let's use the camera\n⬇️"]
[null,null,null,null,null,"North",95,67,98,{"$f":"SUM(G3:I3)","v":260}]
[null,null,null,null,null,"South",66,99,65,230]
[null,"Where is the snapshots stored using the Camera Tool",null,null,null,"East",92,71,70,233]
[null,"Screenshots will be stored in your clipboard.",null,null,null,"West",91,93,98,282]
[null,"Add the Camera to the Quick Access Toolbar (QAT):"]
[null,1,"Right-click on any of the tabs in the Excel ribbon or anywhere on the QAT."]
[null,2,"Select Customize Quick Access Toolbar…"]
[null,3,"In the Choose Commands From drop-down, select All Commands."]
[null,4,"Scroll down and choose the Camera Tool (it looks like a camera icon)."]
[null,5,"Click the Add>> button to add it to your QAT."]
[null,6,"Click OK to save the changes."]
[null,"Use the Camera"]
[null,1,"Select the cell or range of cells you want to capture as an image."]
[null,2,"Click on the Excel Camera Tool icon in the Quick Access Toolbar."]
[null,3,"Go to the worksheet where you want to place the snapshot and click anywhere."]
[null,"Voilà! You now have an image of the selected range."]
[null,"If you make changes in the original data set,\nthe image will automatically update itself."]
[null,"The Excel Camera Tool is like a live feed, and it works even\nif the data and image are in different worksheets\nwithin the same workbook. Give it a try!"]

{"sheet":"Compare Tables","index":10,"n_rows":61,"n_cols":6,"rows_kept":61,"cut":false,"hidden":false,"merged":[[0,1,0,5],[12,1,12,5],[51,1,51,5],[17,1,17,3]]}
[null,"This example is comparing quantity in stock from one month to the next.\nThe conditional formatting compares columns C and F, if they do not match,\nthe conditional format of an orange highlight appears."]
[null,"Quantity in stock in JANUARY",null,null,"Quantity in stock in FEBRUARY"]
[null,"Item","Number",null,"Item","Number"]
[null,"Financial Planner",25,null,"Financial Planner",15]
[null,"Financial Planning Software",36,null,"Financial Planning Software",36]
[null,"Investment Books",21,null,"Investment Books",21]
[null,"Ergonomic Keyboard",27,null,"Ergonomic Keyboard",27]
[null,"Stock Market Board Game",3,null,"Stock Market Board Game",1]
[null,"Finance Calculator",12,null,"Finance Calculator",12]
[null,"Laptop Bag",1,null,"Laptop Bag",0]
[]
[1,"Select what you want to compare (include all cells that you would like to have highlighted)"]
[null,"For this example, I will select B23:C29 and then hold the CTRL key down while selecting E23:F29, then release the CTRL key to continue."]
[2,"On the Home Ribbon, select Conditional Formatting"]
[3,"Selelct New Rule..."]
[4,"Select Use a formula to determine which cells to format"]
[5,"Click in the line Format values where this formula is true:"]
[null,"Type the formula to include the cells that should match\nIn this example it would be =$C23<>$F23",null,null,"Let's create a conditional format\n↙️ ⬇️"]
[]
[null,"Quantity in stock in FEBRUARY",null,null,"Quantity in stock in MARCH"]
[null,"Item","Number",null,"Item","Number"]
[null,"Financial Planner",15,null,"Financial Planner",17]
[null,"Financial Planning Software",36,null,"Financial Planning Software",36]
[null,"Investment Books",21,null,"Investment Books",15]
[null,"Ergonomic Keyboard",27,null,"Ergonomic Keyboard",25]
[null,"Stock Market Board Game",1,null,"Stock Market Board Game",1]
[null,"Finance Calculator",12,null,"Finance Calculator",12]
[null,"Laptop Bag",0,null,"Laptop Bag",10]
[]
[null,"To find the increased inventory use =$C34<$F34"]
[null,"Quantity in stock in FEBRUARY",null,null,"Quantity in stock in MARCH"]
[null,"Item","Number",null,"Item","Number"]
[null,"Financial Planner",15,null,"Financial Planner",17]
[null,"Financial Planning Software",36,null,"Financial Planning Software",36]
[null,"Investment Books",21,null,"Investment Books",15]
[null,"Ergonomic Keyboard",27,null,"Ergonomic Keyboard",25]
[null,"Stock Market Board Game",1,null,"Stock Market Board Game",1]
[null,"Finance Calculator",12,null,"Finance Calculator",12]
[null,"Laptop Bag",0,null,"Laptop Bag",10]
[]
[null,"To find the decreased inventory use =$C45>$F45"]
[null,"Quantity in stock in FEBRUARY",null,null,"Quantity in stock in MARCH"]
[null,"Item","Number",null,"Item","Number"]
[null,"Financial Planner",15,null,"Financial Planner",17]
[null,"Financial Planning Software",36,null,"Financial Planning Software",36]
[null,"Investment Books",21,null,"Investment Books",15]
[null,"Ergonomic Keyboard",27,null,"Ergonomic Keyboard",25]
[null,"Stock Market Board Game",1,null,"Stock Market Board Game",1]
[null,"Finance Calculator",12,null,"Finance Calculator",12]
[null,"Laptop Bag",0,null,"Laptop Bag",10]
[]
[null,"Or show both the larger and smaller numbers by using both conditional formats"]
[null,"Quantity in stock in FEBRUARY",null,null,"Quantity in stock in MARCH"]
[null,"Item","Number",null,"Item","Number"]
[null,"Financial Planner",15,null,"Financial Planner",17]
[null,"Financial Planning Software",36,null,"Financial Planning Software",36]
[null,"Investment Books",21,null,"Investment Books",15]
[null,"Ergonomic Keyboard",27,null,"Ergonomic Keyboard",25]
[null,"Stock Market Board Game",1,null,"Stock Market Board Game",1]
[null,"Finance Calculator",12,null,"Finance Calculator",12]
[null,"Laptop Bag",0,null,"Laptop Bag",10]

{"sheet":"EOM","index":11,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[[37,10,37,16],[26,7,26,12],[1,1,1,4],[6,1,6,4],[16,1,16,4],[0,1,0,8],[2,1,2,8],[5,1,5,8],[4,1,4,8],[3,1,3,8],[15,5,15,6],[8,1,8,4],[18,1,18,6],[19,1,19,6],[7,1,7,8],[47,1,47,8],[40,1,40,4],[44,1,44,4],[45,1,45,4],[49,1,49,4],[41,1,41,4],[42,1,42,4],[43,1,43,4],[50,1,50,4],[51,1,51,4],[52,1,52,4],[55,5,55,7],[48,1,48,2],[53,1,53,4]]}
[null,"EOMONTH()"]
[null,"=EOMONTH(startdate,months)"]
[null,"Excel’s EOMONTH() function returns the last day in a month, and it handles leap years. Most users will use it to determine maturity dates, due dates, and even forecasting. Its syntax is simple: =EOMONTH(startdate,months)"]
[null,"In the =EOMONTH(startdate,months) function, startdate = the initial or anchor date"]
[null,"In the =EOMONTH(startdate,months) function, months = how far into the future or the past the end date should display"]
[null,"If months is positive, the function returns a future date. When months is negative, the function returns a past date.\nUse 0 to return the last day of the specified month."]
[null,"How to specify the month"]
[null,"The Date of Investment is used to calculate the last day of the month in which the investment was made."]
[null,"We returned the last day of each month by referring to the dates and using 0 as the months argument in the function"]
[null,"Client","Date of Investment","EOM","Days to EOM"]
[null,"Client 01","2024-02-27","=EOMONTH(C11,0)",{"$f":"D11-C11","v":{"$error":"#VALUE!"}},"⬅️ The EOM function has an apostrophe to show it as the function, remove the ' to see the calculation result"]
[null,"Client 02","2021-02-04",{"$f":"EOMONTH(C12,0)","v":"2021-02-28"},{"$f":"D12-C12","v":24}]
[null,"Client 03","2023-09-16","2023-09-30",14]
[null,"Client 04","2022-03-18","2022-03-31",13]
[null,"Client 05","2023-11-29","2023-11-30",1]
[null,"Client 06","2023-07-26",null,-45133,"⬅️ Let's create the calculation for the end of the current month = EOMonth(C16,0)"]
[null,"This function returns a set of last-day-of-the-month dates for the month expressed in the EOM column. Notice that the two February dates correctly return Feb 29 and Feb 28, as 2024 was a leap year and 2021 is not."]
[null,"Into the future"]
[null,"The Date of Investment is used to calculate the last day of the month which is 6 months into the future."]
[null,"We returned the last day of each month by referring to the dates and using 6 as the months argument in the function"]
[null,"Client","Date of Investment","EOM","Days to EOM","6 Months EOM","Days to EOM\n6 Months"]
[null,"Client 01","2024-02-27",{"$f":"EOMONTH(C22,0)","v":"2024-02-29"},{"$f":"D22-C22","v":2},"=EOMONTH(C22,6)",{"$f":"F22-C22","v":{"$error":"#VALUE!"}},"⬅️ The EOM function has an apostrophe to show it as the function, remove the ' to see the calculation result"]
[null,"Client 02","2021-02-04",{"$f":"EOMONTH(C23,0)","v":"2021-02-28"},{"$f":"D23-C23","v":24},{"$f":"EOMONTH(C23,6)","v":"2021-08-31"},{"$f":"F23-C23","v":208}]
[null,"Client 03","2023-09-16","2023-09-30",14,"2024-03-31",197]
[null,"Client 04","2022-03-18","2022-03-31",13,"2022-09-30",196]
[null,"Client 05","2023-11-29","2023-11-30",1,"2024-05-31",184]
[null,"Client 06","2023-07-04","2023-07-31",27,null,-45111,"⬅️ Let's create the calculation for the last day of the month in\n6 months = EOMonth(C27,6)"]
[]
[null,"Into the past"]
[null,"The Date of Investment is used to calculate the last day of the month prior"]
[null,"We returned the last day of each month by referring to the dates and using -1 as the months argument in the function"]
[null,"Client","Date of Investment","EOM","Days to EOM","6 Months EOM","Days to EOM\n6 Months","EOM, Month Prior","Days to EOM, Month Prior"]
[null,"Client 01","2024-02-27",{"$f":"EOMONTH(C33,0)","v":"2024-02-29"},{"$f":"D33-C33","v":2},{"$f":"EOMONTH(C33,6)","v":"2024-08-31"},{"$f":"F33-C33","v":186},"=EOMONTH(C33,-1)",{"$f":"H33-C33","v":{"$error":"#VALUE!"}},null,"⬅️ The EOM function has an apostrophe to show it as the function, remove the ' to see the calculation result"]
[null,"Client 02","2021-02-04",{"$f":"EOMONTH(C34,0)","v":"2021-02-28"},{"$f":"D34-C34","v":24},{"$f":"EOMONTH(C34,6)","v":"2021-08-31"},{"$f":"F34-C34","v":208},{"$f":"EOMONTH(C34,-1)","v":"2021-01-31"},{"$f":"H34-C34","v":-4}]
[null,"Client 03","2023-09-16","2023-09-30",14,"2024-03-31",197,"2023-08-31",-16]
[null,"Client 04","2022-03-18","2022-03-31",13,"2022-09-30",196,"2022-02-28",-18]
[null,"Client 05","2023-11-29","2023-11-30",1,"2024-05-31",184,"2023-10-31",-29]
[null,"Client 06","2023-07-04","2023-07-31",27,"2024-01-31",211,null,-45111,null,"⬅️ Let's create the calculation for the last day of the month for the previous month = EOMonth(C38,-1)"]
[]
[null,"How about today?"]
[null,"The function =Today() will show the current date",null,null,null,{"$f":"TODAY()","v":"2024-03-29"},"=Today()"]
[null,"Using a reference cell to find the last day of the month for the current date",null,null,null,{"$f":"EOMONTH(F41,0)","v":"2024-03-31"},"=EOMONTH(F41,0)"]
[null,"Using a nested function to find the last day of the month for the current date",null,null,null,{"$f":"EOMONTH(TODAY(),0)","v":"2024-03-31"},"=EOMONTH(TODAY(),0)"]
[null,"Using a nested function to find the last day of the month 6 months in the future from the current date",null,null,null,{"$f":"EOMONTH(TODAY(),6)","v":"2024-09-30"},"=EOMONTH(TODAY(),6)"]
[null,"Using a nested function to find the last day of the month  9 months in the future from the current date",null,null,null,{"$f":"EOMONTH(TODAY(),9)","v":"2024-12-31"},"=EOMONTH(TODAY(),9)"]
[null,"Using a nested function to find the last day of the month that is the month prior to the current date",null,null,null,{"$f":"EOMONTH(TODAY(),-1)","v":"2024-02-29"},"=EOMONTH(TODAY(),-1)"]
[null,"CURRENT MONTH"]
[null,"Excel doesn’t offer a function that returns the total number of days in a specified month, and before EOMONTH() came around,\nan expression to do so was complex. Now, by combining EOMONTH() and DAY() we can get an integer value that you can\ninclude in other expressions when you need the number of days in a specific month:"]
[null,"Date to use for example:",null,"2024-07-04"]
[null,"=DAY(EOMONTH(TODAY(),0)) will show the number of days in the current month",null,null,null,{"$f":"DAY(EOMONTH(TODAY(),-2))","v":31},{"$f":"_xlfn.CONCAT(\"Today is: \",TEXT(TODAY(), \"mmmm d, yyyy\"))","v":"Today is: March 29, 2024"}]
[null,"Using a nested function, and today's date, find the number of days in the month that is 6 months from today",null,null,null,{"$f":"DAY(EOMONTH(TODAY(),6))","v":30},"=DAY(EOMONTH(TODAY(),6))"]
[null,"Using a nested function, and specific date, find the number of days in the month that is 9 months from that date",null,null,null,{"$f":"DAY(EOMONTH(D49,9))","v":30},"=DAY(EOMONTH(D49,9))"]
[null,"Using a nested function, and today's date, find the number of days in the previous month",null,null,null,{"$f":"DAY(EOMONTH(TODAY(),-1))","v":29},"=DAY(EOMONTH(TODAY(),-1))"]
[null,"Using a nested function, and specific date, find the number of days in the previous month",null,null,null,{"$f":"DAY(EOMONTH(D49,-1))","v":30},"=DAY(EOMONTH(D49,-1))"]

{"sheet":"Format Million","index":12,"n_rows":56,"n_cols":12,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,1,0,9],[1,1,1,9],[2,1,2,9],[3,1,3,9],[4,1,4,9],[5,1,5,9],[6,1,6,9],[7,1,7,9],[15,1,15,9],[14,1,14,9],[13,1,13,9],[12,1,12,9],[11,1,11,9],[10,1,10,9],[9,1,9,9],[42,1,42,9],[33,1,33,9],[27,1,27,9],[26,1,26,9],[8,1,8,9],[16,1,16,9],[17,1,17,7]]}
[null,"Excel’s custom millions format",null,null,null,null,null,null,null,null,null,"Try it lines begin on row 24"]
[null,"$#.##,, \"M\";   formats without all of the zeros",null,null,null,null,null,null,null,null,null,"⬇️"]
[null,"This format $#.##,, \"M\"; uses only 1 section of the potential formatting options. For clarity let's quickly look at the formatting syntax."]
[null,"Each formatting code has up to four sections, separated by semi-colons (;)"]
[null,"The first section identifies how to format to positive values"]
[null,"The second section identifies how to format negative values"]
[null,"The third section applies to formatting a 0 value"]
[null,"The fourth section applies to text formats"]
[null,"For example, the format for accounting (currency) is as follows:\n_($* #,##0.00_);_($* (#,##0.00);_($* \"-\"??_);_(@_) "]
[null,"The first section for positive numbers: Displayed with a dollar sign, thousands separator, and two decimal places. If you apply this format to the number 1234.56, it will appear as $1,234.56."]
[null,"The second section for negative numbers: Enclosed in parentheses and formatted the same as positive numbers. If you apply it to the number -987.65, it will appear as ($987.65)."]
[null,"The third section for zero values: Displayed as a hyphen. If you apply it to the number 0, it will appear as - (a hyphen)."]
[null,"The fourth section for text values: Displayed as is. If you apply it to the text Hello, it will remain as Hello."]
[null,"Custom format for million     $#.##,, \"M\";"]
[null,"Excel’s custom millions format uses only the first section, which specifies the formatting for positive values."]
[null,"Now let’s break down the custom format for values larger than or equal to one million. This format displays the dollar symbol, $ to the left. Next, the #.##,, formats the actual digits. First, the two commas represent the thousands separator, and ,, omits values in the thousand and hundred places. For example, 1781564 rather than showing as $1,781,564 displays as $1.78 M. The decimal is necessary for conversion; 1.78 M is not the same thing as 178 M."]
[null,"To add this custom format to your Excel workbook, do the following:"]
[1,"On the Home tab, click the dialog launcher for the Number group (the dialog launcher is the little arrow in the bottom right of the Number group)"]
[2,"Click the Number tab if necessary"]
[3,"In the Category list, select Custom"]
[4,"Click in the line below Type: and key in the custom format $#.##,, \"M\"; and then click OK"]
[]
[null,"1st Qtr","2nd Qtr","3rd Qtr","4th Qtr",null,"1st Qtr","2nd Qtr","3rd Qtr","4th Qtr"]
["➡️",3782065,8736150,6583907,3763415,null,3782065,8736150,6583907,3763415]
["Try it",8803566,2001272,8580929,5619530,null,8803566,2001272,8580929,5619530]
[null,5472239,3390865,5258481,2454613,null,5472239,3390865,5258481,2454613]
[null,"This format doesn’t change the underlying value—only the way Excel displays it. You might not like the way this format displays values less than one million. They’re not as readable as you might like; in fact, they might be misread. That’s why you need a custom thousands format.     $###,\"K\";  Repeat the steps and create the thousands format."]
[null,"Excel’s custom thousands format         $###, \"K\";"]
[null,"1st Qtr","2nd Qtr","3rd Qtr","4th Qtr",null,"1st Qtr","2nd Qtr","3rd Qtr","4th Qtr"]
["➡️",8500,7455,4069,49555,null,8500,7455,4069,49555]
["Try it",46767,47903,40258,58580,null,46767,47903,40258,58580]
[null,60785,27602,40242,54023,null,60785,27602,40242,54023]
[]
[null,"How to create conditional formatting rules in Excel"]
[null,"When there are mixed formats, use the conditional formatting option too get it all just right!."]
[null,"With conditional formatiing you will use the New Rule option and Format only cells that contain"]
[null,"Use the custom formats you created! Let's look at an example: ↘️ and then give is a shot in the data on the left."]
[null,"1st Qtr","2nd Qtr","3rd Qtr","4th Qtr",null,"1st Qtr","2nd Qtr","3rd Qtr","4th Qtr"]
["➡️",891130,30842977,966182,29766938,null,891130,30842977,966182,29766938]
["Try it",6921952,730625,15690170,9735981,null,6921952,730625,15690170,9735981]
[null,11431260,21753814,29989874,28863378,null,11431260,21753814,29989874,28863378]
[]
[null,"To create an Excel conditional format rule that handles values that are greater than or equal to one million:"]
[1,"Select the data to format - in this example it is B38:E40"]
[2,"On the Home tab, click Conditional Formatting in the Styles group"]
[3,"Choose New Rule from the dropdown list"]
[4,"A dialog box opens, in the top section choose Format Only Cells That Contain in the top pane"]
[5,"In the lower pane, the first dropdown is Cells, and that’s what we need, do not change it"]
[6,"Choose Greater Than or Equal to from the second dropdown"]
[7,"In the third control, enter 1000000"]
[8,"Click Format"]
[9,"Click the Number tab"]
[10,"From the Category list, choose Custom"]
[11,"To the right, select the custom format, $#.##,, \"M\" and click OK"]
[null,"Now, repeat the instructions to add a rule for the custom format"]
[null,"$###, \"K\";"]

{"sheet":"Hide Cell Math Answer","index":13,"n_rows":48,"n_cols":26,"rows_kept":48,"cut":false,"hidden":false,"merged":[[1,20,1,25],[9,20,9,25],[10,20,10,25],[1,11,5,17]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,"The direction on the left explain how to use the custom format of ;;; to hide cell contents,\nfollowed by directions on how\nto hide the formula bar.\n\nLet's practice using the ;;; custom format ➡️\nJAN and FEB are hidden, practice on MAR",null,null,null,null,null,null,null,null,"Percent Change in Interest Earned"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Client","JAN Interest","FEB Interest","% Change\nJan-Feb","MAR Interest","% Change\nFeb-Mar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Juan L",95,98,{"$f":"(W4-V4)/V4","v":3.1578947368421054E-2},93,{"$f":"(Y4-W4)/W4","v":-5.1020408163265307E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mia P",60,54,{"$f":"(W5-V5)/V5","v":-0.1},74,0.37037037037037035]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kali Y",71,99,0.39436619718309857,99,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Broj K",66,78,0.18181818181818182,89,0.14102564102564102]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ken Q",59,75,0.2711864406779661,74,-1.3333333333333334E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Joy A",82,72,-0.12195121951219512,75,4.1666666666666664E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please note the amount if interest is hidden, the focus is on the increase or decrease in interest earned."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To calculate the percent change\n=(current month - previous month)/previous month"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"s"]

{"sheet":"Remove Blanks","index":14,"n_rows":15,"n_cols":37,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,19,0,21]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Let's remove the blanks\n⬇️"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Division","JAN","FEB","MAR","1st\nQtr","APR","MAY","JUN","2nd Qtr","JUL","AUG","SEP","3rd\nQtr","OCT","NOV","DEC","4th\nQtr","Totals"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"North",87,91,95,{"$f":"SUM(U3:W3)","v":273},61,84,86,{"$f":"SUM(Y3:AA3)","v":231},59,81,66,{"$f":"SUM(AC3:AE3)","v":206},71,59,89,{"$f":"SUM(AG3:AI3)","v":219},{"$f":"SUM(AJ3,AF3,AB3,X3)","v":929}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"South",null,null,null,0,80,99,79,258,71,74,74,219,75,68,null,143,620]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"East",88,55,83,226,83,null,87,170,86,96,null,182,65,99,93,257,835]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"West",88,95,67,250,70,97,78,245,86,57,78,221,81,94,60,235,951]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Northwest",57,94,99,250,59,98,80,237,77,60,87,224,60,62,92,214,925]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Southeast",92,91,59,242,68,94,91,253,64,72,57,193,61,56,56,173,861]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Northeast",57,89,70,216,68,69,76,213,87,70,92,249,64,73,66,203,881]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Southwest",98,72,61,231,60,57,96,213,77,60,57,194,74,77,70,221,859]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Midwest",81,76,72,229,null,null,75,75,77,72,60,209,null,68,85,153,666]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Territories",84,93,66,243,90,82,85,257,97,92,78,267,97,57,65,219,986]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data Totals"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totals",{"$f":"SUM(U3:U13)","v":732},{"$f":"SUM(V3:V13)","v":756},{"$f":"SUM(W3:W13)","v":672},{"$f":"SUM(X3:X13)","v":2160},{"$f":"SUM(Y3:Y13)","v":639},{"$f":"SUM(Z3:Z13)","v":680},{"$f":"SUM(AA3:AA13)","v":833},{"$f":"SUM(AB3:AB13)","v":2152},{"$f":"SUM(AC3:AC13)","v":781},{"$f":"SUM(AD3:AD13)","v":734},{"$f":"SUM(AE3:AE13)","v":649},{"$f":"SUM(AF3:AF13)","v":2164},{"$f":"SUM(AG3:AG13)","v":648},{"$f":"SUM(AH3:AH13)","v":713},{"$f":"SUM(AI3:AI13)","v":676},{"$f":"SUM(AJ3:AJ13)","v":2037},{"$f":"SUM(AK3:AK13)","v":8513}]

{"sheet":"Running Total","index":15,"n_rows":50,"n_cols":20,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,8,1,10],[2,8,3,10]]}
[null,null,null,null,null,null,null,null,"Let's try the Quick Analysis Tool - select M7:S7 ➡️"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Division","JAN","FEB","MAR","APR","MAY","JUN","Totals"]
[null,null,null,null,null,null,null,null,"Let's try the PivotTable begins on row 39 ⬇️",null,null,null,"North",87,91,95,56,84,86,{"$f":"SUM(N3:S3)","v":499}]
[null,null,null,null,null,null,null,null,null,null,null,null,"South",67,99,92,80,99,79,{"$f":"SUM(N4:S4)","v":516}]
[null,null,null,null,null,null,null,null,null,null,null,null,"East",88,55,83,83,76,87,{"$f":"SUM(N5:S5)","v":472}]
[null,null,null,null,null,null,null,null,null,null,null,null,"West",65,47,86,74,61,87,{"$f":"SUM(N6:S6)","v":420}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Totals",{"$f":"SUM(N3:N6)","v":307},{"$f":"SUM(O3:O6)","v":292},{"$f":"SUM(P3:P6)","v":356},{"$f":"SUM(Q3:Q6)","v":293},{"$f":"SUM(R3:R6)","v":320},{"$f":"SUM(S3:S6)","v":339},{"$f":"SUM(T3:T6)","v":1907}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Let's try the PivotTable ⬇️"]
[null,"Month","Sales",null,null,"Row Labels","Sum of Sales","Sales Running Totals"]
[null,"January",46,null,null,"January",123,123]
[null,"January",28,null,null,"February",224,347]
[null,"January",49,null,null,"March",39,386]
[null,"February",50,null,null,"Grand Total",386]
[null,"February",20]
[null,"February",39]
[null,"February",26]
[null,"February",44]
[null,"February",45]
[null,"March",13]
[null,"March",26]

{"sheet":"Emoji in Cell","index":16,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,0,2,5],[3,0,3,5],[5,0,5,5],[6,0,6,5],[7,0,7,5],[0,12,1,14]]}
["Adding an Emoji in a cell",null,null,null,null,null,null,null,null,null,null,null,"Let's try an Emoji in a cell  ⬇️"]
["This is a super cool, fast trick!"]
["Using the keyboard Window Key\nand the Period Key emojis and\nother items may be inserted.",null,null,null,null,null,null,null,null,null,null,null,"💕"]
["Simply select the cell, or be inside of the cell typing, and hold the Window Key while clicking the Period Key (.)"]
["Then select the emoji"]
["There is an arrow to select from more options and a search bar to find specific items"]
["There are other items to insert as well, check it out!"]
["Excel does not support the 3d look of an emoji so they insert as an icon, but then they can be formatted as different colors."]

{"sheet":"XLOOKUP","index":17,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"Date","Sales","Rep","Commission"]
[null,null,null,null,"2023-01-01",50809,"Juan",{"$f":"F3*0.12","v":6097.08}]
[null,null,null,null,"2023-03-01",88473,"Marta",{"$f":"F4*0.12","v":10616.76}]
[null,null,null,null,"2023-04-01",65646,"Izeakel",7877.5199999999995]
[null,null,null,null,"2023-05-01",33990,"Marina",4078.7999999999997]
[null,null,null,null,"2023-06-01",89155,"Bob",10698.6]
[null,null,null,null,"2023-07-01",50453,"Cam",6054.36]
[null,null,null,null,"2023-08-01",97328,"Sloah",11679.359999999999]
[null,null,null,null,"2023-09-01",90874,"Jo",10904.88]
[null,null,null,null,"2023-10-01",115944,"April",13913.279999999999]
[null,null,null,null,"2023-11-01",82560,"Pete",9907.1999999999989]
[null,null,null,null,"2023-12-01",35080,"Rowan",4209.5999999999995]
[]
[null,null,null,null,"Date","Sales","Rep","Commission"]
[null,null,null,null,{"$f":"_xlfn.XLOOKUP(G16,G3:G13,E3:E13,\"Not in list\")","v":"2023-07-01"},{"$f":"_xlfn.XLOOKUP(G16,G3:G13,F3:F13,\"Not in list\")","v":50453},"Cam",null,"⬅️ Let's create the XLOOKUP for Commission, using the Rep as the Lookup Value"]