{"text_format":"1","workbook":"xlsx","n_sheets":24,"sheets":["Home Page","Dataset","1. Manual (Copy-Paste)","1. Copied Data","2.1 Filter","2.2 FILTER","2.3 Advanced Filter","3. From Column","4. From Cell","5. Partial","6.1 VLOOKUP","6.2 INDEX-MATCH","6.3 OFFSET","Dataset 1","7. Data Consolidation","8. Dynamic","9. Pivot Table","10. VBA Macro","11. Power Query","Specific Number of characters","Month & Day from Date","Dataset 2","Dataset 3","Same Cell from Mul. sheet"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":6,"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":"Home Page","index":0,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Extract Data in Excel"]
[]
[null,"Learn to extract data from Excel cells, columns, rows and worksheets with this free workbook. Read the article and practice yourself."]
[]
[null,"Prepared By","MD Tanvir Rahman"]
[null,"Last Update","2023-11-29"]
[null,"Reviewed By","Nehad Ulfat"]
[null,"Article Link","https://www.exceldemy.com/learn-excel/extract-data/"]
[]
[null,"Methods"]
[null,"1. Extracting Particular Data from Excel Manually"]
[null,"2. Extracting Filtered Data from Excel Sheet"]
[null,null,"2.1. Using Basic Filter Tool in Excel to Extract Filtered Data"]
[null,null,"2.2. Using Excel FILTER Function to Extract Data Based on Criterion"]
[null,null,"2.3  Using Advanced Filter to Extract Data Based on Multiple Criteria"]
[null,"3. Extracting Specific Data from a Column in Excel"]
[null,"4. Extracting Data from an Excel Cell"]
[null,"5. Extracting Data Based on Partial Input from Excel Cell"]
[null,"6.  Using Excel Formula to Extract Data Based on Lookup Value"]
[null,null,"6.1 Using VLOOKUP Function"]
[null,null,"6.2 Inserting INDEX-MATCH Formula"]
[null,null,"6.3 Using OFFSET and MATCH Function"]
[null,"7. Pulling Data from Worksheet Using Data Consolidate Tool"]
[null,"8. Extracting Information from Dynamic Dataset in Excel"]
[null,"9. Using Pivot Table to Extract Data in Excel"]
[null,"10. Applying VBA Macro to Extract Excel Data"]
[null,"11. Applying Excel Power Query to Extract Data"]
[null,"How to Extract Specific Number of Characters from an Excel Cell?"]
[null,"How to Extract Month and Day from Date in Excel?"]
[null,"How to Extract Same Cell from Multiple Sheets into a Master Column in Excel?"]

{"sheet":"Dataset","index":1,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,"Extract Data in Excel"]
[]
[null,"Sample Dataset"]
[]
[null,"Order ID","Order Date","Region","Sales Person","Sales Amount ($)"]
[null,11001,"2023-02-01","East","Nathan",400]
[null,11002,"2023-02-01","West","Simon",900]
[null,11003,"2023-02-02","West","Lily",500]
[null,11004,"2023-02-02","East","Cameron",300]
[null,11005,"2023-02-02","East","Kimberly",800]
[null,11006,"2023-02-02","East","Lily",850]
[null,11007,"2023-02-03","West","Cameron",750]
[null,11008,"2023-02-03","East","Simon",700]
[null,11009,"2023-02-03","East","Kimberly",800]
[null,11010,"2023-02-04","West","Simon",700]
[null,11011,"2023-02-04","West","Lily",550]
[null,11012,"2023-02-06","West","Lily",950]
[null,11013,"2023-02-07","West","Nathan",600]
[null,11014,"2023-02-07","East","Simon",950]
[null,11015,"2023-02-08","East","Kimberly",1000]
[null,11016,"2023-02-08","West","Kimberly",550]
[null,11017,"2023-02-08","East","Cameron",400]
[null,11018,"2023-02-08","West","Cameron",700]
[null,11019,"2023-02-09","West","Lily",500]
[null,11020,"2023-02-09","West","Simon",700]
[]
[]
[]
[]
[]
[]
["Home Page"]

{"sheet":"1. Manual (Copy-Paste)","index":2,"n_rows":30,"n_cols":16,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,"Extract Data Manually in Excel"]
[]
[null,"Extract First 10 Orders into a New Worksheet",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Order ID","Order Date","Region","Sales Person","Sales Amount ($)",null,"Pro Tips:",null,null,null,"Order ID","Order Date","Region","Sales Person","Sales Amount ($)"]
[null,11001,"2023-02-01","East","Nathan",400,null,"1. Select and copy data first",null,null,null,11001,"2023-02-01","East","Nathan",400]
[null,11002,"2023-02-01","West","Simon",900,null,"2. Then paste it to another worksheet.",null,null,null,11002,"2023-02-01","West","Simon",900]
[null,11003,"2023-02-02","West","Lily",500,null,null,null,null,null,11003,"2023-02-02","West","Lily",500]
[null,11004,"2023-02-02","East","Cameron",300,null,null,null,null,null,11004,"2023-02-02","East","Cameron",300]
[null,11005,"2023-02-02","East","Kimberly",800,null,null,null,null,null,11005,"2023-02-02","East","Kimberly",800]
[null,11006,"2023-02-02","East","Lily",850,null,null,null,null,null,11006,"2023-02-02","East","Lily",850]
[null,11007,"2023-02-03","West","Cameron",750,null,null,null,null,null,11007,"2023-02-03","West","Cameron",750]
[null,11008,"2023-02-03","East","Simon",700,null,null,null,null,null,11008,"2023-02-03","East","Simon",700]
[null,11009,"2023-02-03","East","Kimberly",800,null,null,null,null,null,11009,"2023-02-03","East","Kimberly",800]
[null,11010,"2023-02-04","West","Simon",700,null,null,null,null,null,11010,"2023-02-04","West","Simon",700]
[null,11011,"2023-02-04","West","Lily",550,null,null,null,null,null,11011,"2023-02-04","West","Lily",550]
[null,11012,"2023-02-06","West","Lily",950,null,null,null,null,null,11012,"2023-02-06","West","Lily",950]
[null,11013,"2023-02-07","West","Nathan",600,null,null,null,null,null,11013,"2023-02-07","West","Nathan",600]
[null,11014,"2023-02-07","East","Simon",950,null,null,null,null,null,11014,"2023-02-07","East","Simon",950]
[null,11015,"2023-02-08","East","Kimberly",1000,null,null,null,null,null,11015,"2023-02-08","East","Kimberly",1000]
[null,11016,"2023-02-08","West","Kimberly",550,null,null,null,null,null,11016,"2023-02-08","West","Kimberly",550]
[null,11017,"2023-02-08","East","Cameron",400,null,null,null,null,null,11017,"2023-02-08","East","Cameron",400]
[null,11018,"2023-02-08","West","Cameron",700,null,null,null,null,null,11018,"2023-02-08","West","Cameron",700]
[null,11019,"2023-02-09","West","Lily",500,null,null,null,null,null,11019,"2023-02-09","West","Lily",500]
[null,11020,"2023-02-09","West","Simon",700,null,null,null,null,null,11020,"2023-02-09","West","Simon",700]
[]
[]
[]
[]
["Home Page"]

{"sheet":"1. Copied Data","index":3,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Order ID","Order Date","Region","Sales Person","Sales Amount ($)"]
[11001,"2023-02-01","East","Nathan",400]
[11002,"2023-02-01","West","Simon",900]
[11003,"2023-02-02","West","Lily",500]
[11004,"2023-02-02","East","Cameron",300]
[11005,"2023-02-02","East","Kimberly",800]
[11006,"2023-02-02","East","Lily",850]
[11007,"2023-02-03","West","Cameron",750]
[11008,"2023-02-03","East","Simon",700]
[11009,"2023-02-03","East","Kimberly",800]
[11010,"2023-02-04","West","Simon",700]
[]
[]
[]
[]
["Home Page"]

{"sheet":"2.1 Filter","index":4,"n_rows":52,"n_cols":8,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[null,"Extract Filtered Data from Excel Worksheet"]
[]
[null,"Using Filter Tool"]
[]
[null,"Order ID","Order Date","Region","Sales Person","Sales Amount ($)"]
[null,11001,"2023-02-01","East","Nathan",400]
[null,11002,"2023-02-01","West","Simon",900]
[null,11003,"2023-02-02","West","Lily",500]
[null,11004,"2023-02-02","East","Cameron",300,null,"Pro Tips:"]
[null,11005,"2023-02-02","East","Kimberly",800,null,"1. Select B5:F5 range first"]
[null,11006,"2023-02-02","East","Lily",850,null,"2. Then click: Home => Sort & Find => Filter."]
[null,11007,"2023-02-03","West","Cameron",750,null,"3. Check East only from Region Filter Drop-down"]
[null,11008,"2023-02-03","East","Simon",700]
[null,11009,"2023-02-03","East","Kimberly",800]
[null,11010,"2023-02-04","West","Simon",700]
[null,11011,"2023-02-04","West","Lily",550]
[null,11012,"2023-02-06","West","Lily",950]
[null,11013,"2023-02-07","West","Nathan",600]
[null,11014,"2023-02-07","East","Simon",950]
[null,11015,"2023-02-08","East","Kimberly",1000]
[null,11016,"2023-02-08","West","Kimberly",550]
[null,11017,"2023-02-08","East","Cameron",400]
[null,11018,"2023-02-08","West","Cameron",700]
[null,11019,"2023-02-09","West","Lily",500]
[null,11020,"2023-02-09","West","Simon",700]
[]
[]
[null,"Practice Section"]
[]
[null,"Order ID","Order Date","Region","Sales Person","Sales Amount ($)"]
[null,11001,"2023-02-01","East","Nathan",400]
[null,11002,"2023-02-01","West","Simon",900]
[null,11003,"2023-02-02","West","Lily",500]
[null,11004,"2023-02-02","East","Cameron",300]
[null,11005,"2023-02-02","East","Kimberly",800]
[null,11006,"2023-02-02","East","Lily",850]
[null,11007,"2023-02-03","West","Cameron",750]
[null,11008,"2023-02-03","East","Simon",700]
[null,11009,"2023-02-03","East","Kimberly",800]
[null,11010,"2023-02-04","West","Simon",700]
[null,11011,"2023-02-04","West","Lily",550]
[null,11012,"2023-02-06","West","Lily",950]
[null,11013,"2023-02-07","West","Nathan",600]
[null,11014,"2023-02-07","East","Simon",950]
[null,11015,"2023-02-08","East","Kimberly",1000]
[null,11016,"2023-02-08","West","Kimberly",550]
[null,11017,"2023-02-08","East","Cameron",400]
[null,11018,"2023-02-08","West","Cameron",700]
[null,11019,"2023-02-09","West","Lily",500]
[null,11020,"2023-02-09","West","Simon",700]
[]
["Home Page"]

{"sheet":"2.2 FILTER","index":5,"n_rows":41,"n_cols":16,"rows_kept":41,"cut":false,"hidden":false,"merged":[[7,7,8,9]]}
[null,"Extract Filtered Data from Excel Worksheet"]
[]
[null,"Using FILTER Function",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Order ID","Order Date","Region","Sales Person","Sales Amount ($)",null,null,null,null,null,"Order ID","Order Date","Region","Sales Person","Sales Amount ($)"]
[null,11001,"2023-02-01","East","Nathan",400,null,null,null,null,null,11001,"2023-02-01","East","Nathan",400]
[null,11002,"2023-02-01","West","Simon",900,null,"Pro Tips:",null,null,null,11002,"2023-02-01","West","Simon",900]
[null,11003,"2023-02-02","West","Lily",500,null,"We will extract data for West region with FILTER Function",null,null,null,11003,"2023-02-02","West","Lily",500]
[null,11004,"2023-02-02","East","Cameron",300,null,null,null,null,null,11004,"2023-02-02","East","Cameron",300]
[null,11005,"2023-02-02","East","Kimberly",800,null,null,null,null,null,11005,"2023-02-02","East","Kimberly",800]
[null,11006,"2023-02-02","East","Lily",850,null,null,null,null,null,11006,"2023-02-02","East","Lily",850]
[null,11007,"2023-02-03","West","Cameron",750,null,null,null,null,null,11007,"2023-02-03","West","Cameron",750]
[null,11008,"2023-02-03","East","Simon",700,null,null,null,null,null,11008,"2023-02-03","East","Simon",700]
[null,11009,"2023-02-03","East","Kimberly",800,null,null,null,null,null,11009,"2023-02-03","East","Kimberly",800]
[null,11010,"2023-02-04","West","Simon",700,null,null,null,null,null,11010,"2023-02-04","West","Simon",700]
[null,11011,"2023-02-04","West","Lily",550,null,null,null,null,null,11011,"2023-02-04","West","Lily",550]
[null,11012,"2023-02-06","West","Lily",950,null,null,null,null,null,11012,"2023-02-06","West","Lily",950]
[null,11013,"2023-02-07","West","Nathan",600,null,null,null,null,null,11013,"2023-02-07","West","Nathan",600]
[null,11014,"2023-02-07","East","Simon",950,null,null,null,null,null,11014,"2023-02-07","East","Simon",950]
[null,11015,"2023-02-08","East","Kimberly",1000,null,null,null,null,null,11015,"2023-02-08","East","Kimberly",1000]
[null,11016,"2023-02-08","West","Kimberly",550,null,null,null,null,null,11016,"2023-02-08","West","Kimberly",550]
[null,11017,"2023-02-08","East","Cameron",400,null,null,null,null,null,11017,"2023-02-08","East","Cameron",400]
[null,11018,"2023-02-08","West","Cameron",700,null,null,null,null,null,11018,"2023-02-08","West","Cameron",700]
[null,11019,"2023-02-09","West","Lily",500,null,null,null,null,null,11019,"2023-02-09","West","Lily",500]
[null,11020,"2023-02-09","West","Simon",700,null,null,null,null,null,11020,"2023-02-09","West","Simon",700]
[]
[null,"Order ID","Order Date","Region","Sales Person","Sales Amount ($)",null,null,null,null,null,"Order ID","Order Date","Region","Sales Person","Sales Amount ($)"]
[null,{"$f":"_xlfn._xlws.FILTER(B6:F25,D6:D25=\"west\")","v":11002},"2023-02-01","West","Simon",900]
[null,11003,"2023-02-02","West","Lily",500]
[null,11007,"2023-02-03","West","Cameron",750]
[null,11010,"2023-02-04","West","Simon",700]
[null,11011,"2023-02-04","West","Lily",550]
[null,11012,"2023-02-06","West","Lily",950]
[null,11013,"2023-02-07","West","Nathan",600]
[null,11016,"2023-02-08","West","Kimberly",550]
[null,11018,"2023-02-08","West","Cameron",700]
[null,11019,"2023-02-09","West","Lily",500]
[null,11020,"2023-02-09","West","Simon",700]
[]
[]
["Home Page"]

{"sheet":"2.3 Advanced Filter","index":6,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[9,7,11,8]]}
[null,"Extract Filtered Data from Excel Worksheet"]
[]
[null,"Using Advanced Filter Tool",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Order ID","Order Date","Region","Sales Person","Sales Amount ($)",null,null,null,null,"Order ID","Order Date","Region","Sales Person","Sales Amount ($)"]
[null,11001,"2023-02-01","East","Nathan",400,null,"Pro Tips:",null,null,11001,"2023-02-01","East","Nathan",400]
[null,11002,"2023-02-01","West","Simon",900,null,"1. Select B5:F25 range first",null,null,11002,"2023-02-01","West","Simon",900]
[null,11003,"2023-02-02","West","Lily",500,null,"2. Then click: Data => Advanced",null,null,11003,"2023-02-02","West","Lily",500]
[null,11004,"2023-02-02","East","Cameron",300,null,"3. Select List range, Criteria range and Copy location.",null,null,11004,"2023-02-02","East","Cameron",300]
[null,11005,"2023-02-02","East","Kimberly",800,null,"4. We will extract data for order after 2/6/2023 and west region.",null,null,11005,"2023-02-02","East","Kimberly",800]
[null,11006,"2023-02-02","East","Lily",850,null,null,null,null,11006,"2023-02-02","East","Lily",850]
[null,11007,"2023-02-03","West","Cameron",750,null,null,null,null,11007,"2023-02-03","West","Cameron",750]
[null,11008,"2023-02-03","East","Simon",700,null,null,null,null,11008,"2023-02-03","East","Simon",700]
[null,11009,"2023-02-03","East","Kimberly",800,null,null,null,null,11009,"2023-02-03","East","Kimberly",800]
[null,11010,"2023-02-04","West","Simon",700,null,null,null,null,11010,"2023-02-04","West","Simon",700]
[null,11011,"2023-02-04","West","Lily",550,null,null,null,null,11011,"2023-02-04","West","Lily",550]
[null,11012,"2023-02-06","West","Lily",950,null,null,null,null,11012,"2023-02-06","West","Lily",950]
[null,11013,"2023-02-07","West","Nathan",600,null,null,null,null,11013,"2023-02-07","West","Nathan",600]
[null,11014,"2023-02-07","East","Simon",950,null,null,null,null,11014,"2023-02-07","East","Simon",950]
[null,11015,"2023-02-08","East","Kimberly",1000,null,null,null,null,11015,"2023-02-08","East","Kimberly",1000]
[null,11016,"2023-02-08","West","Kimberly",550,null,null,null,null,11016,"2023-02-08","West","Kimberly",550]
[null,11017,"2023-02-08","East","Cameron",400,null,null,null,null,11017,"2023-02-08","East","Cameron",400]
[null,11018,"2023-02-08","West","Cameron",700,null,null,null,null,11018,"2023-02-08","West","Cameron",700]
[null,11019,"2023-02-09","West","Lily",500,null,null,null,null,11019,"2023-02-09","West","Lily",500]
[null,11020,"2023-02-09","West","Simon",700,null,null,null,null,11020,"2023-02-09","West","Simon",700]
[]
[null,null,"Order Date","Region",null,null,null,null,null,null,null,"Order Date","Region"]
[null,null,">2/6/2023","West",null,null,null,null,null,null,null,">2/5/2023","East"]
[]
[null,"Order ID","Order Date","Region","Sales Person","Sales Amount ($)"]
[null,11013,"2023-02-07","West","Nathan",600]
[null,11016,"2023-02-08","West","Kimberly",550]
[null,11018,"2023-02-08","West","Cameron",700]
[null,11019,"2023-02-09","West","Lily",500]
[null,11020,"2023-02-09","West","Simon",700]
[]
[]
["Home Page"]

{"sheet":"3. From Column","index":7,"n_rows":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[[6,9,7,11]]}
[null,"Extract Specific Data from a Column in Excel"]
[]
[null,"Combining INDEX, IF, SMALL, ROWS and ROW Functions",null,null,null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Order ID","Order Date","Region","Sales Person","Sales Amount ($)",null,"Region",null,null,null,null,null,"Order ID","Order Date","Region","Sales Person","Sales Amount ($)",null,"Region"]
[null,11001,"2023-02-01","East","Nathan",400,null,"East",null,"Pro Tips:",null,null,null,11001,"2023-02-01","East","Nathan",400]
[null,11002,"2023-02-01","West","Simon",900,null,null,null,"We will extract Order Id of East region.",null,null,null,11002,"2023-02-01","West","Simon",900]
[null,11003,"2023-02-02","West","Lily",500,null,"Order ID",null,null,null,null,null,11003,"2023-02-02","West","Lily",500,null,"Order ID"]
[null,11004,"2023-02-02","East","Cameron",300,null,{"$f":"IFERROR(INDEX($B$6:$B$25, SMALL(IF($D$6:$D$25=$H$6, ROW($D$6:$D$25)-ROW($D$6)+1), ROWS($E$6:E6))), \"\")","v":11001},null,null,null,null,null,11004,"2023-02-02","East","Cameron",300]
[null,11005,"2023-02-02","East","Kimberly",800,null,{"$f":"IFERROR(INDEX($B$6:$B$25, SMALL(IF($D$6:$D$25=$H$6, ROW($D$6:$D$25)-ROW($D$6)+1), ROWS($E$6:E7))), \"\")","v":11004},null,null,null,null,null,11005,"2023-02-02","East","Kimberly",800]
[null,11006,"2023-02-02","East","Lily",850,null,{"$f":"IFERROR(INDEX($B$6:$B$25, SMALL(IF($D$6:$D$25=$H$6, ROW($D$6:$D$25)-ROW($D$6)+1), ROWS($E$6:E8))), \"\")","v":11005},null,null,null,null,null,11006,"2023-02-02","East","Lily",850]
[null,11007,"2023-02-03","West","Cameron",750,null,{"$f":"IFERROR(INDEX($B$6:$B$25, SMALL(IF($D$6:$D$25=$H$6, ROW($D$6:$D$25)-ROW($D$6)+1), ROWS($E$6:E9))), \"\")","v":11006},null,null,null,null,null,11007,"2023-02-03","West","Cameron",750]
[null,11008,"2023-02-03","East","Simon",700,null,{"$f":"IFERROR(INDEX($B$6:$B$25, SMALL(IF($D$6:$D$25=$H$6, ROW($D$6:$D$25)-ROW($D$6)+1), ROWS($E$6:E10))), \"\")","v":11008},null,null,null,null,null,11008,"2023-02-03","East","Simon",700]
[null,11009,"2023-02-03","East","Kimberly",800,null,{"$f":"IFERROR(INDEX($B$6:$B$25, SMALL(IF($D$6:$D$25=$H$6, ROW($D$6:$D$25)-ROW($D$6)+1), ROWS($E$6:E11))), \"\")","v":11009},null,null,null,null,null,11009,"2023-02-03","East","Kimberly",800]
[null,11010,"2023-02-04","West","Simon",700,null,{"$f":"IFERROR(INDEX($B$6:$B$25, SMALL(IF($D$6:$D$25=$H$6, ROW($D$6:$D$25)-ROW($D$6)+1), ROWS($E$6:E12))), \"\")","v":11014},null,null,null,null,null,11010,"2023-02-04","West","Simon",700]
[null,11011,"2023-02-04","West","Lily",550,null,{"$f":"IFERROR(INDEX($B$6:$B$25, SMALL(IF($D$6:$D$25=$H$6, ROW($D$6:$D$25)-ROW($D$6)+1), ROWS($E$6:E13))), \"\")","v":11015},null,null,null,null,null,11011,"2023-02-04","West","Lily",550]
[null,11012,"2023-02-06","West","Lily",950,null,{"$f":"IFERROR(INDEX($B$6:$B$25, SMALL(IF($D$6:$D$25=$H$6, ROW($D$6:$D$25)-ROW($D$6)+1), ROWS($E$6:E14))), \"\")","v":11017},null,null,null,null,null,11012,"2023-02-06","West","Lily",950]
[null,11013,"2023-02-07","West","Nathan",600,null,{"$f":"IFERROR(INDEX($B$6:$B$25, SMALL(IF($D$6:$D$25=$H$6, ROW($D$6:$D$25)-ROW($D$6)+1), ROWS($E$6:E15))), \"\")","v":""},null,null,null,null,null,11013,"2023-02-07","West","Nathan",600]
[null,11014,"2023-02-07","East","Simon",950,null,{"$f":"IFERROR(INDEX($B$6:$B$25, SMALL(IF($D$6:$D$25=$H$6, ROW($D$6:$D$25)-ROW($D$6)+1), ROWS($E$6:E16))), \"\")","v":""},null,null,null,null,null,11014,"2023-02-07","East","Simon",950,null,{"$f":"IFERROR(INDEX($B$6:$B$25, SMALL(IF($D$6:$D$25=$H$6, ROW($D$6:$D$25)-ROW($D$6)+1), ROWS($E$6:Q16))), \"\")","v":""}]
[null,11015,"2023-02-08","East","Kimberly",1000,null,{"$f":"IFERROR(INDEX($B$6:$B$25, SMALL(IF($D$6:$D$25=$H$6, ROW($D$6:$D$25)-ROW($D$6)+1), ROWS($E$6:E17))), \"\")","v":""},null,null,null,null,null,11015,"2023-02-08","East","Kimberly",1000,null,{"$f":"IFERROR(INDEX($B$6:$B$25, SMALL(IF($D$6:$D$25=$H$6, ROW($D$6:$D$25)-ROW($D$6)+1), ROWS($E$6:Q17))), \"\")","v":""}]
[null,11016,"2023-02-08","West","Kimberly",550,null,null,null,null,null,null,null,11016,"2023-02-08","West","Kimberly",550]
[null,11017,"2023-02-08","East","Cameron",400,null,null,null,null,null,null,null,11017,"2023-02-08","East","Cameron",400]
[null,11018,"2023-02-08","West","Cameron",700,null,null,null,null,null,null,null,11018,"2023-02-08","West","Cameron",700]
[null,11019,"2023-02-09","West","Lily",500,null,null,null,null,null,null,null,11019,"2023-02-09","West","Lily",500]
[null,11020,"2023-02-09","West","Simon",700,null,null,null,null,null,null,null,11020,"2023-02-09","West","Simon",700]
[]
[]
["Home Page"]

{"sheet":"4. From Cell","index":8,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[[6,6,7,8]]}
[null,"Extract Data from an Excel Cell"]
[]
[null,"Combining LEFT and FIND Functions",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Service","Package Price ($)",null,"Keyword",null,null,null,null,null,"Service","Package Price ($)",null,"Keyword"]
[null,"AIR SERVICE",400,null,{"$f":"LEFT(B6,FIND(\" \",B6)-1)","v":"AIR"},null,"Pro Tips:",null,null,null,"AIR SERVICE",400]
[null,"TRAIN SERVICE",900,null,{"$f":"LEFT(B7,FIND(\" \",B7)-1)","v":"TRAIN"},null,"We will extract first word of each cell.",null,null,null,"TRAIN SERVICE",900]
[null,"BUS SERVICE",500,null,{"$f":"LEFT(B8,FIND(\" \",B8)-1)","v":"BUS"},null,null,null,null,null,"BUS SERVICE",500]
[null,"VISA SERVICE",300,null,"VISA",null,null,null,null,null,"VISA SERVICE",300]
[null,"PASSPORT SERVICE",800,null,"PASSPORT",null,null,null,null,null,"PASSPORT SERVICE",800]
[null,"EMIGRATION SERVICE",850,null,"EMIGRATION",null,null,null,null,null,"EMIGRATION SERVICE",850]
[null,"TOUR SERVICE",750,null,"TOUR",null,null,null,null,null,"TOUR SERVICE",750]
[null,"HOTEL SERVICE",700,null,"HOTEL",null,null,null,null,null,"HOTEL SERVICE",700]
[null,"CRUISE SERVICE",800,null,"CRUISE",null,null,null,null,null,"CRUISE SERVICE",800]
[null,"ATTESTATION SERVICE",700,null,"ATTESTATION",null,null,null,null,null,"ATTESTATION SERVICE",700]
[null,"TAXI SERVICE",550,null,"TAXI",null,null,null,null,null,"TAXI SERVICE",550]
[null,"OTHER ONLINE SERVICES",950,null,"OTHER",null,null,null,null,null,"OTHER ONLINE SERVICES",950]
[]
[]
[]
["Home Page"]

{"sheet":"5. Partial","index":9,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,"Extract Data Based on Partial Input from Excel Cell"]
[]
[null,"Combining FILTER, ISNUMBER and SEARCH Functions",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Service","Package Price ($)",null,"Partial Text","Air",null,null,null,"Service","Package Price ($)",null,"Partial Text","emi"]
[null,"AIR SERVICE",400,null,null,null,null,null,null,"AIR SERVICE",400]
[null,"TRAIN SERVICE",900,null,"Service","Package Price ($)",null,null,null,"TRAIN SERVICE",900,null,"Service","Package Price ($)"]
[null,"BUS SERVICE",500,null,{"$f":"_xlfn._xlws.FILTER(B6:C18, ISNUMBER(SEARCH(F5, B6:B18)), \"None\")","v":"AIR SERVICE"},400,null,null,null,"BUS SERVICE",500]
[null,"VISA SERVICE",300,null,"Airport Service",250,null,null,null,"VISA SERVICE",300]
[null,"PASSPORT SERVICE",800,null,null,null,null,null,null,"PASSPORT SERVICE",800]
[null,"EMIGRATION SERVICE",850,null,null,null,null,null,null,"EMIGRATION SERVICE",850]
[null,"TOUR SERVICE",750,null,null,null,null,null,null,"TOUR SERVICE",750]
[null,"HOTEL SERVICE",700,null,null,null,null,null,null,"HOTEL SERVICE",700]
[null,"CRUISE SERVICE",800,null,null,null,null,null,null,"CRUISE SERVICE",800]
[null,"ATTESTATION SERVICE",700,null,null,null,null,null,null,"ATTESTATION SERVICE",700]
[null,"TAXI SERVICE",550,null,null,null,null,null,null,"TAXI SERVICE",550]
[null,"Airport Service",250,null,null,null,null,null,null,"Airport Service",250]
[null,"OTHER ONLINE SERVICES",950,null,null,null,null,null,null,"OTHER ONLINE SERVICES",950]
[]
[]
[]
["Home Page"]

{"sheet":"6.1 VLOOKUP","index":10,"n_rows":29,"n_cols":18,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,"Extract Data Based on Lookup Value Using Excel Formula"]
[]
[null,"Using VLOOKUP Function",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Order ID","Order Date","Region","Sales Person","Sales Amount ($)",null,"Order ID","Order Date",null,"Order ID","Order Date","Region","Sales Person","Sales Amount ($)",null,"Order ID","Order Date"]
[null,11001,"2023-02-01","East","Nathan",400,null,11008,{"$f":"VLOOKUP(H6,B6:F25,2)","v":"2023-02-03"},null,11001,"2023-02-01","East","Nathan",400]
[null,11002,"2023-02-01","West","Simon",900,null,11013,{"$f":"VLOOKUP(H7,B7:F26,2)","v":"2023-02-07"},null,11002,"2023-02-01","West","Simon",900]
[null,11003,"2023-02-02","West","Lily",500,null,11015,"2023-02-08",null,11003,"2023-02-02","West","Lily",500]
[null,11004,"2023-02-02","East","Cameron",300,null,11020,"2023-02-09",null,11004,"2023-02-02","East","Cameron",300]
[null,11005,"2023-02-02","East","Kimberly",800,null,null,null,null,11005,"2023-02-02","East","Kimberly",800]
[null,11006,"2023-02-02","East","Lily",850,null,null,null,null,11006,"2023-02-02","East","Lily",850]
[null,11007,"2023-02-03","West","Cameron",750,null,null,null,null,11007,"2023-02-03","West","Cameron",750]
[null,11008,"2023-02-03","East","Simon",700,null,null,null,null,11008,"2023-02-03","East","Simon",700]
[null,11009,"2023-02-03","East","Kimberly",800,null,null,null,null,11009,"2023-02-03","East","Kimberly",800]
[null,11010,"2023-02-04","West","Simon",700,null,null,null,null,11010,"2023-02-04","West","Simon",700]
[null,11011,"2023-02-04","West","Lily",550,null,null,null,null,11011,"2023-02-04","West","Lily",550]
[null,11012,"2023-02-06","West","Lily",950,null,null,null,null,11012,"2023-02-06","West","Lily",950]
[null,11013,"2023-02-07","West","Nathan",600,null,null,null,null,11013,"2023-02-07","West","Nathan",600]
[null,11014,"2023-02-07","East","Simon",950,null,null,null,null,11014,"2023-02-07","East","Simon",950]
[null,11015,"2023-02-08","East","Kimberly",1000,null,null,null,null,11015,"2023-02-08","East","Kimberly",1000]
[null,11016,"2023-02-08","West","Kimberly",550,null,null,null,null,11016,"2023-02-08","West","Kimberly",550]
[null,11017,"2023-02-08","East","Cameron",400,null,null,null,null,11017,"2023-02-08","East","Cameron",400]
[null,11018,"2023-02-08","West","Cameron",700,null,null,null,null,11018,"2023-02-08","West","Cameron",700]
[null,11019,"2023-02-09","West","Lily",500,null,null,null,null,11019,"2023-02-09","West","Lily",500]
[null,11020,"2023-02-09","West","Simon",700,null,null,null,null,11020,"2023-02-09","West","Simon",700]
[]
[]
[]
["Home Page"]

{"sheet":"6.2 INDEX-MATCH","index":11,"n_rows":28,"n_cols":18,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[null,"Extract Data from Worksheet Using Excel Formula"]
[]
[null,"Combining INDEX and MATCH Functions",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Order ID","Order Date","Region","Sales Person","Sales Amount ($)",null,"Order ID","Sales Person",null,"Order ID","Order Date","Region","Sales Person","Sales Amount ($)",null,"Order ID","Sales Person"]
[null,11001,"2023-02-01","East","Nathan",400,null,11008,{"$f":"INDEX($B$6:$F$25,MATCH(H6,$B$6:$B$25,0),4)","v":"Simon"},null,11001,"2023-02-01","East","Nathan",400]
[null,11002,"2023-02-01","West","Simon",900,null,11013,{"$f":"INDEX($B$6:$F$25,MATCH(H7,$B$6:$B$25,0),4)","v":"Nathan"},null,11002,"2023-02-01","West","Simon",900]
[null,11003,"2023-02-02","West","Lily",500,null,11015,"Kimberly",null,11003,"2023-02-02","West","Lily",500]
[null,11004,"2023-02-02","East","Cameron",300,null,11020,"Simon",null,11004,"2023-02-02","East","Cameron",300]
[null,11005,"2023-02-02","East","Kimberly",800,null,null,null,null,11005,"2023-02-02","East","Kimberly",800]
[null,11006,"2023-02-02","East","Lily",850,null,null,null,null,11006,"2023-02-02","East","Lily",850]
[null,11007,"2023-02-03","West","Cameron",750,null,null,null,null,11007,"2023-02-03","West","Cameron",750]
[null,11008,"2023-02-03","East","Simon",700,null,null,null,null,11008,"2023-02-03","East","Simon",700]
[null,11009,"2023-02-03","East","Kimberly",800,null,null,null,null,11009,"2023-02-03","East","Kimberly",800]
[null,11010,"2023-02-04","West","Simon",700,null,null,null,null,11010,"2023-02-04","West","Simon",700]
[null,11011,"2023-02-04","West","Lily",550,null,null,null,null,11011,"2023-02-04","West","Lily",550]
[null,11012,"2023-02-06","West","Lily",950,null,null,null,null,11012,"2023-02-06","West","Lily",950]
[null,11013,"2023-02-07","West","Nathan",600,null,null,null,null,11013,"2023-02-07","West","Nathan",600]
[null,11014,"2023-02-07","East","Simon",950,null,null,null,null,11014,"2023-02-07","East","Simon",950]
[null,11015,"2023-02-08","East","Kimberly",1000,null,null,null,null,11015,"2023-02-08","East","Kimberly",1000]
[null,11016,"2023-02-08","West","Kimberly",550,null,null,null,null,11016,"2023-02-08","West","Kimberly",550]
[null,11017,"2023-02-08","East","Cameron",400,null,null,null,null,11017,"2023-02-08","East","Cameron",400]
[null,11018,"2023-02-08","West","Cameron",700,null,null,null,null,11018,"2023-02-08","West","Cameron",700]
[null,11019,"2023-02-09","West","Lily",500,null,null,null,null,11019,"2023-02-09","West","Lily",500]
[null,11020,"2023-02-09","West","Simon",700,null,null,null,null,11020,"2023-02-09","West","Simon",700]
[]
[]
["Home Page"]

{"sheet":"6.3 OFFSET","index":12,"n_rows":29,"n_cols":18,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,"Extract Data from Worksheet Using Excel Formula"]
[]
[null,"Combining OFFSET and MATCH Functions",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Order ID","Order Date","Region","Sales Person","Sales Amount ($)",null,"Order ID","Sales Person",null,"Order ID","Order Date","Region","Sales Person","Sales Amount ($)",null,"Order ID","Sales Person"]
[null,11001,"2023-02-01","East","Nathan",400,null,11008,{"$f":"OFFSET($B$6, MATCH(H6, $B$6:$B$25, 0) - 1, 3)","v":"Simon"},null,11001,"2023-02-01","East","Nathan",400]
[null,11002,"2023-02-01","West","Simon",900,null,11013,{"$f":"OFFSET($B$6, MATCH(H7, $B$6:$B$25, 0) - 1, 3)","v":"Nathan"},null,11002,"2023-02-01","West","Simon",900]
[null,11003,"2023-02-02","West","Lily",500,null,11015,"Kimberly",null,11003,"2023-02-02","West","Lily",500]
[null,11004,"2023-02-02","East","Cameron",300,null,11020,"Simon",null,11004,"2023-02-02","East","Cameron",300]
[null,11005,"2023-02-02","East","Kimberly",800,null,null,null,null,11005,"2023-02-02","East","Kimberly",800]
[null,11006,"2023-02-02","East","Lily",850,null,null,null,null,11006,"2023-02-02","East","Lily",850]
[null,11007,"2023-02-03","West","Cameron",750,null,null,null,null,11007,"2023-02-03","West","Cameron",750]
[null,11008,"2023-02-03","East","Simon",700,null,null,null,null,11008,"2023-02-03","East","Simon",700]
[null,11009,"2023-02-03","East","Kimberly",800,null,null,null,null,11009,"2023-02-03","East","Kimberly",800]
[null,11010,"2023-02-04","West","Simon",700,null,null,null,null,11010,"2023-02-04","West","Simon",700]
[null,11011,"2023-02-04","West","Lily",550,null,null,null,null,11011,"2023-02-04","West","Lily",550]
[null,11012,"2023-02-06","West","Lily",950,null,null,null,null,11012,"2023-02-06","West","Lily",950]
[null,11013,"2023-02-07","West","Nathan",600,null,null,null,null,11013,"2023-02-07","West","Nathan",600]
[null,11014,"2023-02-07","East","Simon",950,null,null,null,null,11014,"2023-02-07","East","Simon",950]
[null,11015,"2023-02-08","East","Kimberly",1000,null,null,null,null,11015,"2023-02-08","East","Kimberly",1000]
[null,11016,"2023-02-08","West","Kimberly",550,null,null,null,null,11016,"2023-02-08","West","Kimberly",550]
[null,11017,"2023-02-08","East","Cameron",400,null,null,null,null,11017,"2023-02-08","East","Cameron",400]
[null,11018,"2023-02-08","West","Cameron",700,null,null,null,null,11018,"2023-02-08","West","Cameron",700]
[null,11019,"2023-02-09","West","Lily",500,null,null,null,null,11019,"2023-02-09","West","Lily",500]
[null,11020,"2023-02-09","West","Simon",700,null,null,null,null,11020,"2023-02-09","West","Simon",700]
[]
[]
[]
["Home Page"]

{"sheet":"Dataset 1","index":13,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Sample Dataset"]
[]
[null,"Sales Person","East - Sales ($)",null,"Sales Person","West - Sales ($)"]
[null,"Nathan",400,null,"Cameron",750]
[null,"Cameron",300,null,"Simon",700]
[null,"Kimberly",800,null,"Lily",550]
[null,"Lily",850,null,"Lily",950]
[null,"Simon",700,null,"Nathan",600]
[null,"Kimberly",800,null,"Kimberly",550]
[null,"Simon",950,null,"Cameron",700]
[null,"Kimberly",1000,null,"Lily",500]
[null,"Cameron",400,null,"Simon",700]
[]
[]
[]
[]
[]
["Home Page"]

{"sheet":"7. Data Consolidation","index":14,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"Extract Data from Worksheet Using Excel Tools"]
[]
[null,"Using Data Consolidation Tool",null,null,null,null,null,null,"Practice Section"]
[]
[null,null,"East - Sales ($)","West - Sales ($)",null,"Pro Tips:"]
[null,"Nathan",400,600,null,"1. Go to Data => Considate"]
[null,"Cameron",700,1450,null,"2. Select Function = Sum and Reference data."]
[null,"Kimberly",2600,550]
[null,"Lily",850,2000]
[null,"Simon",1650,1400]
[]
[]
[]
[]
["Home Page"]

{"sheet":"8. Dynamic","index":15,"n_rows":30,"n_cols":20,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,"Extract Data from Dynamic Dataset in Excel"]
[]
[null,"Combining INDEX, IF, SMALL, ROWS and ROW Functions",null,null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Order ID","Order Date","Region","Sales Person","Sales Amount ($)",null,"Sales Person","Simon",null,null,null,"Order ID","Order Date","Region","Sales Person","Sales Amount ($)",null,"Sales Person"]
[null,11001,"2023-02-01","East","Nathan",400,null,null,null,null,null,null,11001,"2023-02-01","East","Nathan",400]
[null,11002,"2023-02-01","West","Simon",900,null,"Order ID","Sales Amount ($)",null,null,null,11002,"2023-02-01","West","Simon",900,null,"Order ID","Sales Amount ($)"]
[null,11003,"2023-02-02","West","Lily",500,null,{"$f":"IFERROR(INDEX($B:$B, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H1))), \"\")","v":11002},{"$f":"IFERROR(INDEX($F:$F, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H1))), \"\")","v":900},null,null,null,11003,"2023-02-02","West","Lily",500]
[null,11004,"2023-02-02","East","Cameron",300,null,{"$f":"IFERROR(INDEX($B:$B, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H2))), \"\")","v":11008},{"$f":"IFERROR(INDEX($F:$F, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H2))), \"\")","v":700},null,null,null,11004,"2023-02-02","East","Cameron",300]
[null,11005,"2023-02-02","East","Kimberly",800,null,{"$f":"IFERROR(INDEX($B:$B, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H3))), \"\")","v":11010},{"$f":"IFERROR(INDEX($F:$F, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H3))), \"\")","v":700},null,null,null,11005,"2023-02-02","East","Kimberly",800]
[null,11006,"2023-02-02","East","Lily",850,null,{"$f":"IFERROR(INDEX($B:$B, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H4))), \"\")","v":11014},{"$f":"IFERROR(INDEX($F:$F, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H4))), \"\")","v":950},null,null,null,11006,"2023-02-02","East","Lily",850]
[null,11007,"2023-02-03","West","Cameron",750,null,{"$f":"IFERROR(INDEX($B:$B, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H5))), \"\")","v":11020},{"$f":"IFERROR(INDEX($F:$F, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H5))), \"\")","v":700},null,null,null,11007,"2023-02-03","West","Cameron",750]
[null,11008,"2023-02-03","East","Simon",700,null,{"$f":"IFERROR(INDEX($B:$B, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H6))), \"\")","v":""},{"$f":"IFERROR(INDEX($F:$F, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H6))), \"\")","v":""},null,null,null,11008,"2023-02-03","East","Simon",700]
[null,11009,"2023-02-03","East","Kimberly",800,null,{"$f":"IFERROR(INDEX($B:$B, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H7))), \"\")","v":""},{"$f":"IFERROR(INDEX($F:$F, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H7))), \"\")","v":""},null,null,null,11009,"2023-02-03","East","Kimberly",800]
[null,11010,"2023-02-04","West","Simon",700,null,{"$f":"IFERROR(INDEX($B:$B, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H8))), \"\")","v":""},{"$f":"IFERROR(INDEX($F:$F, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H8))), \"\")","v":""},null,null,null,11010,"2023-02-04","West","Simon",700]
[null,11011,"2023-02-04","West","Lily",550,null,{"$f":"IFERROR(INDEX($B:$B, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H9))), \"\")","v":""},{"$f":"IFERROR(INDEX($F:$F, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H9))), \"\")","v":""},null,null,null,11011,"2023-02-04","West","Lily",550]
[null,11012,"2023-02-06","West","Lily",950,null,{"$f":"IFERROR(INDEX($B:$B, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H10))), \"\")","v":""},{"$f":"IFERROR(INDEX($F:$F, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H10))), \"\")","v":""},null,null,null,11012,"2023-02-06","West","Lily",950]
[null,11013,"2023-02-07","West","Nathan",600,null,{"$f":"IFERROR(INDEX($B:$B, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H11))), \"\")","v":""},{"$f":"IFERROR(INDEX($F:$F, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H11))), \"\")","v":""},null,null,null,11013,"2023-02-07","West","Nathan",600]
[null,11014,"2023-02-07","East","Simon",950,null,{"$f":"IFERROR(INDEX($B:$B, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H12))), \"\")","v":""},{"$f":"IFERROR(INDEX($F:$F, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H12))), \"\")","v":""},null,null,null,11014,"2023-02-07","East","Simon",950]
[null,11015,"2023-02-08","East","Kimberly",1000,null,{"$f":"IFERROR(INDEX($B:$B, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H13))), \"\")","v":""},{"$f":"IFERROR(INDEX($F:$F, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H13))), \"\")","v":""},null,null,null,11015,"2023-02-08","East","Kimberly",1000]
[null,11016,"2023-02-08","West","Kimberly",550,null,{"$f":"IFERROR(INDEX($B:$B, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H14))), \"\")","v":""},{"$f":"IFERROR(INDEX($F:$F, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H14))), \"\")","v":""},null,null,null,11016,"2023-02-08","West","Kimberly",550]
[null,11017,"2023-02-08","East","Cameron",400,null,{"$f":"IFERROR(INDEX($B:$B, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H15))), \"\")","v":""},{"$f":"IFERROR(INDEX($F:$F, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H15))), \"\")","v":""},null,null,null,11017,"2023-02-08","East","Cameron",400]
[null,11018,"2023-02-08","West","Cameron",700,null,{"$f":"IFERROR(INDEX($B:$B, SMALL(IF($E:$E=$I$5, ROW($E:$E)-ROW($H$1)+1), ROWS($H$1:H16))), \"\")","v":""},null,null,null,null,11018,"2023-02-08","West","Cameron",700]
[null,11019,"2023-02-09","West","Lily",500,null,null,null,null,null,null,11019,"2023-02-09","West","Lily",500]
[null,11020,"2023-02-09","West","Simon",700,null,null,null,null,null,null,11020,"2023-02-09","West","Simon",700]
[null,11105,"2023-02-10","East","Mili",350]
[]
[]
[]
["Home Page"]

{"sheet":"9. Pivot Table","index":16,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,"Extract Data in Excel",null,null,null,null,null,"Extract Data in Excel"]
[]
[null," Using Pivot Table Tool",null,null,null,null,null," Using Pivot Table Tool",null,null,null,null,"Practice Section"]
[]
[null,"Order ID","Order Date","Region","Sales Person","Sales Amount ($)",null,"Row Labels","Sum of Sales Amount ($)",null,null,null,"Order ID","Order Date","Region","Sales Person","Sales Amount ($)"]
[null,11001,"2023-02-01","East","Nathan",400,null,"East",6200,null,null,null,11001,"2023-02-01","East","Nathan",400]
[null,11002,"2023-02-01","West","Simon",900,null,"Cameron",700,null,null,null,11002,"2023-02-01","West","Simon",900]
[null,11003,"2023-02-02","West","Lily",500,null,"Kimberly",2600,null,null,null,11003,"2023-02-02","West","Lily",500]
[null,11004,"2023-02-02","East","Cameron",300,null,"Lily",850,null,null,null,11004,"2023-02-02","East","Cameron",300]
[null,11005,"2023-02-02","East","Kimberly",800,null,"Nathan",400,null,null,null,11005,"2023-02-02","East","Kimberly",800]
[null,11006,"2023-02-02","East","Lily",850,null,"Simon",1650,null,null,null,11006,"2023-02-02","East","Lily",850]
[null,11007,"2023-02-03","West","Cameron",750,null,"West",7400,null,null,null,11007,"2023-02-03","West","Cameron",750]
[null,11008,"2023-02-03","East","Simon",700,null,"Cameron",1450,null,null,null,11008,"2023-02-03","East","Simon",700]
[null,11009,"2023-02-03","East","Kimberly",800,null,"Kimberly",550,null,null,null,11009,"2023-02-03","East","Kimberly",800]
[null,11010,"2023-02-04","West","Simon",700,null,"Lily",2500,null,null,null,11010,"2023-02-04","West","Simon",700]
[null,11011,"2023-02-04","West","Lily",550,null,"Nathan",600,null,null,null,11011,"2023-02-04","West","Lily",550]
[null,11012,"2023-02-06","West","Lily",950,null,"Simon",2300,null,null,null,11012,"2023-02-06","West","Lily",950]
[null,11013,"2023-02-07","West","Nathan",600,null,"Grand Total",13600,null,null,null,11013,"2023-02-07","West","Nathan",600]
[null,11014,"2023-02-07","East","Simon",950,null,null,null,null,null,null,11014,"2023-02-07","East","Simon",950]
[null,11015,"2023-02-08","East","Kimberly",1000,null,null,null,null,null,null,11015,"2023-02-08","East","Kimberly",1000]
[null,11016,"2023-02-08","West","Kimberly",550,null,"Pro Tips:",null,null,null,null,11016,"2023-02-08","West","Kimberly",550]
[null,11017,"2023-02-08","East","Cameron",400,null,"1. Go to Insert => Pivot Table => From Table/Range",null,null,null,null,11017,"2023-02-08","East","Cameron",400]
[null,11018,"2023-02-08","West","Cameron",700,null,"2. Select Existing worksheet and output location.",null,null,null,null,11018,"2023-02-08","West","Cameron",700]
[null,11019,"2023-02-09","West","Lily",500,null,null,null,null,null,null,11019,"2023-02-09","West","Lily",500]
[null,11020,"2023-02-09","West","Simon",700,null,null,null,null,null,null,11020,"2023-02-09","West","Simon",700]
[]
[]
[]
[]
[]
[]
["Home Page"]

{"sheet":"10. VBA Macro","index":17,"n_rows":32,"n_cols":18,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,"Extract Data in Excel"]
[]
[null,"Applying VBA Macro",null,null,null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Order ID","Order Date","Region","Sales Person","Sales Amount ($)",null,"Sales Person","Simon",null,null,null,null,"Order ID","Order Date","Region","Sales Person","Sales Amount ($)"]
[null,11001,"2023-02-01","East","Nathan",400,null,null,null,null,null,null,null,11001,"2023-02-01","East","Nathan",400]
[null,11002,"2023-02-01","West","Simon",900,null,"Order ID","Sales Amount ($)",null,null,null,null,11002,"2023-02-01","West","Simon",900]
[null,11003,"2023-02-02","West","Lily",500,null,11002,900,null,null,null,null,11003,"2023-02-02","West","Lily",500]
[null,11004,"2023-02-02","East","Cameron",300,null,11008,700,null,null,null,null,11004,"2023-02-02","East","Cameron",300]
[null,11005,"2023-02-02","East","Kimberly",800,null,11010,700,null,null,null,null,11005,"2023-02-02","East","Kimberly",800]
[null,11006,"2023-02-02","East","Lily",850,null,null,null,null,null,null,null,11006,"2023-02-02","East","Lily",850]
[null,11007,"2023-02-03","West","Cameron",750,null,null,null,"Pro Tips:",null,null,null,11007,"2023-02-03","West","Cameron",750]
[null,11008,"2023-02-03","East","Simon",700,null,null,null,"1. Go to Developer => Macro => Extract_Data_in_Excel",null,null,null,11008,"2023-02-03","East","Simon",700]
[null,11009,"2023-02-03","East","Kimberly",800,null,null,null,"2. Select input, criteria and output locations.",null,null,null,11009,"2023-02-03","East","Kimberly",800]
[null,11010,"2023-02-04","West","Simon",700,null,null,null,null,null,null,null,11010,"2023-02-04","West","Simon",700]
[null,11011,"2023-02-04","West","Lily",550,null,null,null,null,null,null,null,11011,"2023-02-04","West","Lily",550]
[null,11012,"2023-02-06","West","Lily",950,null,null,null,null,null,null,null,11012,"2023-02-06","West","Lily",950]
[null,11013,"2023-02-07","West","Nathan",600,null,null,null,null,null,null,null,11013,"2023-02-07","West","Nathan",600]
[null,11014,"2023-02-07","East","Simon",950,null,null,null,null,null,null,null,11014,"2023-02-07","East","Simon",950]
[null,11015,"2023-02-08","East","Kimberly",1000,null,null,null,null,null,null,null,11015,"2023-02-08","East","Kimberly",1000]
[null,11016,"2023-02-08","West","Kimberly",550,null,null,null,null,null,null,null,11016,"2023-02-08","West","Kimberly",550]
[null,11017,"2023-02-08","East","Cameron",400,null,null,null,null,null,null,null,11017,"2023-02-08","East","Cameron",400]
[null,11018,"2023-02-08","West","Cameron",700,null,null,null,null,null,null,null,11018,"2023-02-08","West","Cameron",700]
[null,11019,"2023-02-09","West","Lily",500,null,null,null,null,null,null,null,11019,"2023-02-09","West","Lily",500]
[null,11020,"2023-02-09","West","Simon",700,null,null,null,null,null,null,null,11020,"2023-02-09","West","Simon",700]
[]
[]
[]
[]
[]
[]
["Home Page"]

{"sheet":"11. Power Query","index":18,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,"Extract Data in Excel"]
[]
[null,"Using Power Query Tool",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Order ID","Order Date","Region","Sales Person","Sales Amount ($)",null,"Pro Tips:"]
[null,11002,44958,"West","Simon",900,null,"1. Go to Data => From Text/CSV"]
[null,11003,44959,"West","Lily",500,null,"2. Select Source Data text file."]
[null,11007,44960,"West","Cameron",750,null,"3. Select Transform Data => Filter and check West."]
[null,11010,44961,"West","Simon",700,null,"4. Click Load to command to import in Excel."]
[null,11011,44961,"West","Lily",550]
[null,11012,44963,"West","Lily",950]
[null,11013,44964,"West","Nathan",600]
[null,11016,44965,"West","Kimberly",550]
[null,11018,44965,"West","Cameron",700]
[null,11019,44966,"West","Lily",500]
[null,11020,44966,"West","Simon",700]
[]
[]
[]
[]
[]
[]
[]
["Home Page"]

{"sheet":"Specific Number of characters","index":19,"n_rows":23,"n_cols":20,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"Extract Specific Number of Characters from an Excel Cell"]
[]
[null,"Using LEFT Function",null,null,null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Customer ID","Order Date","Region","Sales Person","Sales Amount ($)",null,"Order Code",null,null,null,null,null,"Customer ID","Order Date","Region","Sales Person","Sales Amount ($)",null,"Order Code"]
[null,"11001_Andress","2023-02-01","East","Nathan",400,null,{"$f":"LEFT(B6,5)","v":"11001"},null,null,null,null,null,"11001_Andress","2023-02-01","East","Nathan",400]
[null,"11002_Luka","2023-02-01","West","Simon",900,null,{"$f":"LEFT(B7,5)","v":"11002"},null,null,null,null,null,"11002_Luka","2023-02-01","West","Simon",900]
[null,"11003_Henry","2023-02-02","West","Lily",500,null,"11003",null,null,null,null,null,"11003_Henry","2023-02-02","West","Lily",500]
[null,"11004_Roberto","2023-02-02","East","Cameron",300,null,"11004",null,null,null,null,null,"11004_Roberto","2023-02-02","East","Cameron",300]
[null,"11005_Gilly","2023-02-02","East","Kimberly",800,null,"11005",null,null,null,null,null,"11005_Gilly","2023-02-02","East","Kimberly",800]
[null,"11006_Haze","2023-02-02","East","Lily",850,null,"11006",null,null,null,null,null,"11006_Haze","2023-02-02","East","Lily",850]
[null,"11007_Wade","2023-02-03","West","Cameron",750,null,"11007",null,null,null,null,null,"11007_Wade","2023-02-03","West","Cameron",750]
[null,"11008_Matt","2023-02-03","East","Simon",700,null,"11008",null,null,null,null,null,"11008_Matt","2023-02-03","East","Simon",700]
[null,"11009_Jef","2023-02-03","East","Kimberly",800,null,"11009",null,null,null,null,null,"11009_Jef","2023-02-03","East","Kimberly",800]
[null,"11010_Mesut","2023-02-04","West","Simon",700,null,"11010",null,null,null,null,null,"11010_Mesut","2023-02-04","West","Simon",700]
[]
[]
[]
[]
[]
[]
[]
["Home Page"]

{"sheet":"Month & Day from Date","index":20,"n_rows":22,"n_cols":18,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,"Extract Month and Day from Date in Excel"]
[]
[null,"Using TEXT Function",null,null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Customer ID","Order Date","Region",null,"Order Month","Order Day",null,null,null,null,null,"Customer ID","Order Date","Region",null,"Order Month","Order Day"]
[null,"11001_Andress","2023-01-01","East",null,{"$f":"TEXT($C6,\"mmmm\")","v":"January"},{"$f":"TEXT($C6,\"dddd\")","v":"Sunday"},null,null,null,null,null,"11001_Andress","2023-01-01","East"]
[null,"11002_Luka","2023-02-04","West",null,{"$f":"TEXT($C7,\"mmmm\")","v":"February"},{"$f":"TEXT($C7,\"dddd\")","v":"Saturday"},null,null,null,null,null,"11002_Luka","2023-02-04","West"]
[null,"11003_Henry","2023-01-10","West",null,"January","Tuesday",null,null,null,null,null,"11003_Henry","2023-01-10","West"]
[null,"11004_Roberto","2023-03-09","East",null,"March","Thursday",null,null,null,null,null,"11004_Roberto","2023-03-09","East"]
[null,"11005_Gilly","2023-04-10","East",null,"April","Monday",null,null,null,null,null,"11005_Gilly","2023-04-10","East"]
[null,"11006_Haze","2023-05-11","East",null,"May","Thursday",null,null,null,null,null,"11006_Haze","2023-05-11","East"]
[null,"11007_Wade","2023-05-16","West",null,"May","Tuesday",null,null,null,null,null,"11007_Wade","2023-05-16","West"]
[null,"11008_Matt","2023-05-24","East",null,"May","Wednesday",null,null,null,null,null,"11008_Matt","2023-05-24","East"]
[null,"11009_Jef","2023-05-30","East",null,"May","Tuesday",null,null,null,null,null,"11009_Jef","2023-05-30","East"]
[null,"11010_Mesut","2023-06-02","West",null,"June","Friday",null,null,null,null,null,"11010_Mesut","2023-06-02","West"]
[]
[]
[]
[]
[]
[]
["Home Page"]

{"sheet":"Dataset 2","index":21,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,"Sample Dataset"]
[]
[null,"Sales Person","Salary of January ($)"]
[null,"Nathan",3400]
[null,"Cameron",5100]
[null,"Kimberly",3700]
[null,"Lily",4200]
[null,"Simon",4100]
[]
[]
[]
[]
[]
["Home Page"]

{"sheet":"Dataset 3","index":22,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"Sample dataset"]
[]
[null,"Sales Person","Salary of February ($)"]
[null,"Nathan",3900]
[null,"Cameron",4200]
[null,"Kimberly",4300]
[null,"Lily",3700]
[null,"Simon",4400]
[]
[]
[]
[]
[]
[]
["Home Page"]

{"sheet":"Same Cell from Mul. sheet","index":23,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"Combine Multiple Sheets into a Master Column"]
[]
[null,"Using Data Consolidation Tool",null,null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,null,"Salary of January ($)","Salary of February ($)",null,null,"Pro Tips:"]
[null,"Nathan",3400,3900,null,null,"1. Go to Data => Consolidate"]
[null,"Cameron",5100,4200,null,null,"2. We will sum up and get summary from Dataset 2 and Dataset 3 worksheets."]
[null,"Kimberly",3700,4300,null,null,"Dataset 2"]
[null,"Lily",4200,3700,null,null,"Dataset 3"]
[null,"Simon",4100,4400]
[]
[]
[]
[]
[]
[]
[]
[]
["Home Page"]