{"text_format":"1","workbook":"xlsx","n_sheets":24,"sheets":["Dataset","SUM","INDEX & MATCH","VLOOKUP & Match","SUM & SUMIFS","MAX, INDEX & MATCH","Conditional Formatting","Pivot Table","Sort","Filter","What-If","Data Validation","Table","Analyze Data","Descriptive Statistics","Anova","Column Chart","Bar Chart","Line Chart","Pie Chart","Doughnut Chart ","Waterfall Chart","Animated Chart","Practice"],"not_rendered":{"charts":6,"images":0,"macros":1,"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":"Dataset","index":0,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sales Quantity of Products"]
[]
[null,"Month","Mobile","Laptop","Television"]
[null,"January",65,320,125]
[null,"February",106,342,120]
[null,"March",80,290,85]
[null,"April",73,239,150]
[null,"May",87,257,158]
[null,"June",125,272,147]
[null,"July",57,365,180]
[null,"August",60,368,161]
[null,"September",63,270,132]
[null,"October",82,325,123]
[null,"November",79,379,94]
[null,"December",81,230,89]

{"sheet":"SUM","index":1,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using SUM Function"]
[]
[null,"Month","Mobile","Laptop","Television"]
[null,"January",65,320,125]
[null,"February",106,342,120]
[null,"March",80,290,85]
[null,"April",73,239,150]
[null,"May",87,257,158]
[null,"June",125,272,147]
[null,"July",57,365,180]
[null,"August",60,368,161]
[null,"September",63,270,132]
[null,"October",82,325,123]
[null,"November",79,379,94]
[null,"December",81,230,89]
[null,"Total",{"$f":"SUM(C5:C16)","v":958},{"$f":"SUM(D5:D16)","v":3657},1564]

{"sheet":"INDEX & MATCH","index":2,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Using INDEX & MATCH Functions"]
[]
[null,"Month","Mobile","Laptop","Television",null,"Month","Mobile"]
[null,"January",65,320,125,null,"July",{"$f":"INDEX(B5:E16,MATCH(G5,B5:B16,0),2)","v":57}]
[null,"February",106,342,120]
[null,"March",80,290,85]
[null,"April",73,239,150]
[null,"May",87,257,158]
[null,"June",125,272,147]
[null,"July",57,365,180]
[null,"August",60,368,161]
[null,"September",63,270,132]
[null,"October",82,325,123]
[null,"November",79,379,94]
[null,"December",81,230,89]

{"sheet":"VLOOKUP & Match","index":3,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Using VLOOKUP & MATCH Functions"]
[]
[null,"Month","Mobile","Laptop","Television",null,"Month","June"]
[null,"January",65,320,125,null,"Product","Laptop"]
[null,"February",106,342,120,null,"Quantity",{"$f":"VLOOKUP(H4,B5:E16,MATCH(H5,B4:E4,0))","v":272}]
[null,"March",80,290,85]
[null,"April",73,239,150]
[null,"May",87,257,158]
[null,"June",125,272,147]
[null,"July",57,365,180]
[null,"August",60,368,161]
[null,"September",63,270,132]
[null,"October",82,325,123]
[null,"November",79,379,94]
[null,"December",81,230,89]

{"sheet":"SUM & SUMIFS","index":4,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Combining SUM & SUMIFS Functions"]
[]
[null,"Month","Mobile","Laptop","Television",null,"Month","Number of Products"]
[null,"January",65,320,125,null,"June",{"$f":"SUM(SUMIFS(C5:C16,B5:B16,G5), SUMIFS(D5:D16,B5:B16,G5), SUMIFS(E5:E16,B5:B16,G5))","v":544}]
[null,"February",106,342,120]
[null,"March",80,290,85]
[null,"April",73,239,150]
[null,"May",87,257,158]
[null,"June",125,272,147]
[null,"July",57,365,180]
[null,"August",60,368,161]
[null,"September",63,270,132]
[null,"October",82,325,123]
[null,"November",79,379,94]
[null,"December",81,230,89]

{"sheet":"MAX, INDEX & MATCH","index":5,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,6,3,7],[1,1,1,7]]}
[]
[null,"Applying MAX, INDEX & MATCH Functions"]
[]
[null,"Month","Mobile","Laptop","Television",null,"Laptop"]
[null,"January",65,320,125,null,"Maximum Amount Sold","Month"]
[null,"February",106,342,120,null,{"$f":"MAX(D5:D16)","v":379},{"$f":"INDEX(B5:E16,MATCH(G6,D5:D16,0),1)","v":"November"}]
[null,"March",80,290,85]
[null,"April",73,239,150]
[null,"May",87,257,158]
[null,"June",125,272,147]
[null,"July",57,365,180]
[null,"August",60,368,161]
[null,"September",63,270,132]
[null,"October",82,325,123]
[null,"November",79,379,94]
[null,"December",81,230,89]

{"sheet":"Conditional Formatting","index":6,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Applying Conditional Formatting"]
[]
[null,"Month","Mobile","Laptop","Television"]
[null,"January",65,320,125]
[null,"February",106,342,120]
[null,"March",80,290,85]
[null,"April",73,239,150]
[null,"May",87,257,158]
[null,"June",125,272,147]
[null,"July",57,365,180]
[null,"August",60,368,161]
[null,"September",63,270,132]
[null,"October",82,325,123]
[null,"November",79,379,94]
[null,"December",81,230,89]

{"sheet":"Pivot Table","index":7,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Pivot Table"]
[]
[null,"Month","Mobile","Laptop","Television",null,"Row Labels","Sum of Mobile","Sum of Laptop","Sum of Television"]
[null,"January",65,320,125,null,"January",65,320,125]
[null,"February",106,342,120,null,"February",106,342,120]
[null,"March",80,290,85,null,"March",80,290,85]
[null,"April",73,239,150,null,"April",73,239,150]
[null,"May",87,257,158,null,"May",87,257,158]
[null,"June",125,272,147,null,"June",125,272,147]
[null,"July",57,365,180,null,"July",57,365,180]
[null,"August",60,368,161,null,"August",60,368,161]
[null,"September",63,270,132,null,"September",63,270,132]
[null,"October",82,325,123,null,"October",82,325,123]
[null,"November",79,379,94,null,"November",79,379,94]
[null,"December",81,230,89,null,"December",81,230,89]
[null,null,null,null,null,null,"Grand Total",958,3657,1564]

{"sheet":"Sort","index":8,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sorting a Product"]
[]
[null,"Month","Mobile","Laptop","Television"]
[null,"June",125,272,147]
[null,"February",106,342,120]
[null,"May",87,257,158]
[null,"October",82,325,123]
[null,"December",81,230,89]
[null,"March",80,290,85]
[null,"November",79,379,94]
[null,"April",73,239,150]
[null,"January",65,320,125]
[null,"September",63,270,132]
[null,"August",60,368,161]
[null,"July",57,365,180]

{"sheet":"Filter","index":9,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Filtering Data"]
[]
[null,"Month","Mobile","Laptop","Television"]
[null,"January",65,320,125]
[null,"February",106,342,120]
[null,"March",80,290,85]
[null,"April",73,239,150]
[null,"May",87,257,158]
[null,"June",125,272,147]
[null,"July",57,365,180]
[null,"August",60,368,161]
[null,"September",63,270,132]
[null,"October",82,325,123]
[null,"November",79,379,94]
[null,"December",81,230,89]

{"sheet":"What-If","index":10,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,6,3,7],[1,1,1,7]]}
[]
[null,"Using What-If Analysis Feature"]
[]
[null,"Month","Mobile","Laptop","Television",null,"Television"]
[null,"January",65,320,125,null,"Total Units Sold",{"$f":"SUM(E5:E16)","v":1564}]
[null,"February",106,342,120,null,"Unit Price",1000]
[null,"March",80,290,85,null,"Revenue",{"$f":"H5*H6","v":1564000}]
[null,"April",73,239,150]
[null,"May",87,257,158]
[null,"June",125,272,147]
[null,"July",57,365,180]
[null,"August",60,368,161]
[null,"September",63,270,132]
[null,"October",82,325,123]
[null,"November",79,379,94]
[null,"December",81,230,89]

{"sheet":"Data Validation","index":11,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Applying Data Validation"]
[]
[null,"Month","Mobile","Laptop","Television",null,"Month","Laptop"]
[null,"January",65,320,125,null,"June",{"$f":"INDEX(B5:E16,MATCH(G5,B5:B16,0),3)","v":272}]
[null,"February",106,342,120]
[null,"March",80,290,85]
[null,"April",73,239,150]
[null,"May",87,257,158]
[null,"June",125,272,147]
[null,"July",57,365,180]
[null,"August",60,368,161]
[null,"September",63,270,132]
[null,"October",82,325,123]
[null,"November",79,379,94]
[null,"December",81,230,89]

{"sheet":"Table","index":12,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Excel Table"]
[]
[null,"Month","Television"]
[null,"January",125]
[null,"February",120]
[null,"March",85]
[null,"April",150]
[null,"May",158]
[null,"June",147]
[null,"July",180]
[null,"August",161]
[null,"September",132]
[null,"October",123]
[null,"November",94]
[null,"December",89]
[null,"Total",{"$f":"SUBTOTAL(109,Table1[Television])","v":1564}]

{"sheet":"Analyze Data","index":13,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Analyze Data Feature"]
[]
[null,"Month","Mobile","Laptop","Television"]
[null,"January",65,320,125]
[null,"February",106,342,120]
[null,"March",80,290,85]
[null,"April",73,239,150]
[null,"May",87,257,158]
[null,"June",125,272,147]
[null,"July",57,365,180]
[null,"August",60,368,161]
[null,"September",63,270,132]
[null,"October",82,325,123]
[null,"November",79,379,94]
[null,"December",81,230,89]

{"sheet":"Descriptive Statistics","index":14,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,6,3,7],[1,1,1,7]]}
[]
[null,"Analyzing Descriptive Statistics"]
[]
[null,"Month","Mobile","Laptop","Television",null,"Descriptive Statistics for Laptop"]
[null,"January",65,320,125,null,"Laptop"]
[null,"February",106,342,120]
[null,"March",80,290,85,null,"Mean",304.75]
[null,"April",73,239,150,null,"Standard Error",15.040916417115902]
[null,"May",87,257,158,null,"Median",305]
[null,"June",125,272,147,null,"Mode",{"$error":"#N/A"}]
[null,"July",57,365,180,null,"Standard Deviation",52.103262853683162]
[null,"August",60,368,161,null,"Sample Variance",2714.75]
[null,"September",63,270,132,null,"Kurtosis",-1.478558523077238]
[null,"October",82,325,123,null,"Skewness",4.1297124978345062E-2]
[null,"November",79,379,94,null,"Range",149]
[null,"December",81,230,89,null,"Minimum",230]
[null,null,null,null,null,null,"Maximum",379]
[null,null,null,null,null,null,"Sum",3657]
[null,null,null,null,null,null,"Count",12]

{"sheet":"Anova","index":15,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,6,3,12],[1,1,1,12]]}
[]
[null,"Analyzing Anova: Single Factor"]
[]
[null,"Month","Mobile","Laptop","Television",null,"Anova: Single Factor for All Products"]
[null,"January",65,320,125,null,"Anova: Single Factor"]
[null,"February",106,342,120]
[null,"March",80,290,85,null,"SUMMARY"]
[null,"April",73,239,150,null,"Groups","Count","Sum","Average","Variance"]
[null,"May",87,257,158,null,"Mobile",12,958,79.833333333333329,386.15151515151558]
[null,"June",125,272,147,null,"Laptop",12,3657,304.75,2714.75]
[null,"July",57,365,180,null,"Television",12,1564,130.33333333333334,919.33333333333246]
[null,"August",60,368,161]
[null,"September",63,270,132]
[null,"October",82,325,123,null,"ANOVA"]
[null,"November",79,379,94,null,"Source of Variation","SS","df","MS","F","P-value","F crit"]
[null,"December",81,230,89,null,"Between Groups",334235.72222222225,2,167117.86111111112,124.70753630780655,4.1288597269797483E-16,3.2849176510382869]
[null,null,null,null,null,null,"Within Groups",44222.583333333328,33,1340.0782828282827]
[]
[null,null,null,null,null,null,"Total",378458.30555555556,35]

{"sheet":"Column Chart","index":16,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Excel Column Chart"]
[]
[null,"Month","Mobile","Laptop","Television"]
[null,"January",65,320,125]
[null,"February",106,342,120]
[null,"March",80,290,85]
[null,"April",73,239,150]
[null,"May",87,257,158]
[null,"June",125,272,147]
[null,"July",57,365,180]
[null,"August",60,368,161]
[null,"September",63,270,132]
[null,"October",82,325,123]
[null,"November",79,379,94]
[null,"December",81,230,89]

{"sheet":"Bar Chart","index":17,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Excel Bar Chart"]
[]
[null,"Month","Mobile","Laptop","Television"]
[null,"January",65,320,125]
[null,"February",106,342,120]
[null,"March",80,290,85]
[null,"April",73,239,150]
[null,"May",87,257,158]
[null,"June",125,272,147]
[null,"July",57,365,180]
[null,"August",60,368,161]
[null,"September",63,270,132]
[null,"October",82,325,123]
[null,"November",79,379,94]
[null,"December",81,230,89]

{"sheet":"Line Chart","index":18,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Excel Line Chart"]
[]
[null,"Month","Mobile","Laptop","Television"]
[null,"January",65,320,125]
[null,"February",106,342,120]
[null,"March",80,290,85]
[null,"April",73,239,150]
[null,"May",87,257,158]
[null,"June",125,272,147]
[null,"July",57,365,180]
[null,"August",60,368,161]
[null,"September",63,270,132]
[null,"October",82,325,123]
[null,"November",79,379,94]
[null,"December",81,230,89]

{"sheet":"Pie Chart","index":19,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Excel Pie Chart"]
[]
[null,"Month","Mobile","Laptop","Television"]
[null,"January",65,320,125]
[null,"February",106,342,120]
[null,"March",80,290,85]
[null,"April",73,239,150]
[null,"May",87,257,158]
[null,"June",125,272,147]
[null,"July",57,365,180]
[null,"August",60,368,161]
[null,"September",63,270,132]
[null,"October",82,325,123]
[null,"November",79,379,94]
[null,"December",81,230,89]

{"sheet":"Doughnut Chart ","index":20,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Excel Doughnut Chart"]
[]
[null,"Month","Mobile","Laptop","Television"]
[null,"January",65,320,125]
[null,"February",106,342,120]
[null,"March",80,290,85]
[null,"April",73,239,150]
[null,"May",87,257,158]
[null,"June",125,272,147]
[null,"July",57,365,180]
[null,"August",60,368,161]
[null,"September",63,270,132]
[null,"October",82,325,123]
[null,"November",79,379,94]
[null,"December",81,230,89]

{"sheet":"Waterfall Chart","index":21,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Excel Waterfall Chart"]
[]
[null,"Month","Mobile","Laptop","Television"]
[null,"January",65,320,125]
[null,"February",106,342,120]
[null,"March",80,290,85]
[null,"April",73,239,150]
[null,"May",87,257,158]
[null,"June",125,272,147]
[null,"July",57,365,180]
[null,"August",60,368,161]
[null,"September",63,270,132]
[null,"October",82,325,123]
[null,"November",79,379,94]
[null,"December",81,230,89]

{"sheet":"Animated Chart","index":22,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Animated Column Chart"]
[]
[null,"Month","Mobile","Laptop","Television"]
[null,"January",65,320,125]
[null,"February",106,342,120]
[null,"March",80,290,85]
[null,"April",73,239,150]
[null,"May",87,257,158]
[null,"June",125,272,147]
[null,"July",57,365,180]
[null,"August",60,368,161]
[null,"September",63,270,132]
[null,"October",82,325,123]
[null,"November",79,379,94]
[null,"December",81,230,89]

{"sheet":"Practice","index":23,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Try Yourself"]
[]
[null,"Month","Mobile","Laptop","Television"]
[null,"January",65,320,125]
[null,"February",106,342,120]
[null,"March",80,290,85]
[null,"April",73,239,150]
[null,"May",87,257,158]
[null,"June",125,272,147]
[null,"July",57,365,180]
[null,"August",60,368,161]
[null,"September",63,270,132]
[null,"October",82,325,123]
[null,"November",79,379,94]
[null,"December",81,230,89]