{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Go To Special","Find","Power_Query","Table1","Nested_LOOKUP","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Dataset","index":0,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset"]
[]
[null,"Club Name","Player Name","Playing Position"]
[null,"Manchester United","Bruno Fernandes","Midfielder"]
[null,null,"Jadon Sancho"]
[null,null,"Marcus Rashford"]
[null,"Manchester City","Joan Cancelo","Defender"]
[null,null,"Ruben Dias"]
[null,"Chelsea","Kai Haverts","Forward"]
[null,null,"Timo Werner"]
[null,"Liverpool","Mohammed Salah"]
[null,null,"Sadio Mane"]

{"sheet":"Go To Special","index":1,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Use of 'Go To Special' Option",null,null,null,"Practice Yourself"]
[]
[null,"Club Name","Player Name","Playing Position",null,"Club Name","Player Name","Playing Position"]
[null,"Manchester United","Bruno Fernandes","Midfielder",null,"Manchester United","Bruno Fernandes","Midfielder"]
[null,{"$f":"B5","v":"Manchester United"},"Jadon Sancho",{"$f":"D5","v":"Midfielder"},null,null,"Jadon Sancho"]
[null,"Manchester United","Marcus Rashford","Midfielder",null,null,"Marcus Rashford"]
[null,"Manchester City","Joan Cancelo","Defender",null,"Manchester City","Joan Cancelo","Defender"]
[null,{"$f":"B8","v":"Manchester City"},"Ruben Dias",{"$f":"D8","v":"Defender"},null,null,"Ruben Dias"]
[null,"Chelsea","Kai Haverts","Forward",null,"Chelsea","Kai Haverts","Forward"]
[null,{"$f":"B10","v":"Chelsea"},"Timo Werner",{"$f":"D10","v":"Forward"},null,null,"Timo Werner"]
[null,"Liverpool","Mohammed Salah","Forward",null,"Liverpool","Mohammed Salah"]
[null,{"$f":"B12","v":"Liverpool"},"Sadio Mane","Forward",null,null,"Sadio Mane"]

{"sheet":"Find","index":2,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Use of Find Option",null,null,null,"Practice Yourself"]
[]
[null,"Club Name","Player Name","Playing Position",null,"Club Name","Player Name","Playing Position"]
[null,"Manchester United","Bruno Fernandes","Midfielder",null,"Manchester United","Bruno Fernandes","Midfielder"]
[null,{"$f":"B5","v":"Manchester United"},"Jadon Sancho",{"$f":"D5","v":"Midfielder"},null,null,"Jadon Sancho"]
[null,"Manchester United","Marcus Rashford","Midfielder",null,null,"Marcus Rashford"]
[null,"Manchester City","Joan Cancelo","Defender",null,"Manchester City","Joan Cancelo","Defender"]
[null,{"$f":"B8","v":"Manchester City"},"Ruben Dias",{"$f":"D8","v":"Defender"},null,null,"Ruben Dias"]
[null,"Chelsea","Kai Haverts","Forward",null,"Chelsea","Kai Haverts","Forward"]
[null,{"$f":"B10","v":"Chelsea"},"Timo Werner",{"$f":"D10","v":"Forward"},null,null,"Timo Werner"]
[null,"Liverpool","Mohammed Salah","Forward",null,"Liverpool","Mohammed Salah"]
[null,{"$f":"B12","v":"Liverpool"},"Sadio Mane","Forward",null,null,"Sadio Mane"]

{"sheet":"Power_Query","index":3,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Autofill Blanks with Power Query",null,null,null,"Practice Yourself"]
[]
[null,"Club Name","Player Name","Playing Position",null,"Club Name","Player Name","Playing Position"]
[null,"Manchester United","Bruno Fernandes","Midfielder",null,"Manchester United","Bruno Fernandes","Midfielder"]
[null,null,"Jadon Sancho",null,null,null,"Jadon Sancho"]
[null,null,"Marcus Rashford",null,null,null,"Marcus Rashford"]
[null,"Manchester City","Joan Cancelo","Defender",null,"Manchester City","Joan Cancelo","Defender"]
[null,null,"Ruben Dias",null,null,null,"Ruben Dias"]
[null,"Chelsea","Kai Haverts","Forward",null,"Chelsea","Kai Haverts","Forward"]
[null,null,"Timo Werner",null,null,null,"Timo Werner"]
[null,"Liverpool","Mohammed Salah",null,null,"Liverpool","Mohammed Salah"]
[null,null,"Sadio Mane",null,null,null,"Sadio Mane"]

{"sheet":"Table1","index":4,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Club Name","Player Name","Playing Position"]
["Manchester United","Bruno Fernandes","Midfielder"]
["Manchester United","Jadon Sancho","Midfielder"]
["Manchester United","Marcus Rashford","Midfielder"]
["Manchester City","Joan Cancelo","Defender"]
["Manchester City","Ruben Dias","Defender"]
["Chelsea","Kai Haverts","Forward"]
["Chelsea","Timo Werner","Forward"]
["Liverpool","Mohammed Salah","Forward"]
["Liverpool","Sadio Mane","Forward"]

{"sheet":"Nested_LOOKUP","index":5,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Use of Nested LOOKUP Formula",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Club Name","Player Name","Playing Position",null,{"$f":"LOOKUP(ROW(B4:B13),IF(LEN(B4:B13),ROW(B4:B13)),B4:B13)","v":"Club Name"},{"$f":"LOOKUP(ROW(C4:C13),IF(LEN(C4:C13),ROW(C4:C13)),C4:C13)","v":"Player Name"},{"$f":"LOOKUP(ROW(D4:D13),IF(LEN(D4:D13),ROW(D4:D13)),D4:D13)","v":"Playing Position"},null,"Club Name","Player Name","Playing Position"]
[null,"Manchester United","Bruno Fernandes","Midfielder",null,"Manchester United","Bruno Fernandes","Midfielder",null,"Manchester United","Bruno Fernandes","Midfielder"]
[null,null,"Jadon Sancho",null,null,"Manchester United","Jadon Sancho","Midfielder",null,null,"Jadon Sancho"]
[null,null,"Marcus Rashford",null,null,"Manchester United","Marcus Rashford","Midfielder",null,null,"Marcus Rashford"]
[null,"Manchester City","Joan Cancelo","Defender",null,"Manchester City","Joan Cancelo","Defender",null,"Manchester City","Joan Cancelo","Defender"]
[null,null,"Ruben Dias",null,null,"Manchester City","Ruben Dias","Defender",null,null,"Ruben Dias"]
[null,"Chelsea","Kai Haverts","Forward",null,"Chelsea","Kai Haverts","Forward",null,"Chelsea","Kai Haverts","Forward"]
[null,null,"Timo Werner",null,null,"Chelsea","Timo Werner","Forward",null,null,"Timo Werner"]
[null,"Liverpool","Mohammed Salah",null,null,"Liverpool","Mohammed Salah","Forward",null,"Liverpool","Mohammed Salah"]
[null,null,"Sadio Mane",null,null,"Liverpool","Sadio Mane","Forward",null,null,"Sadio Mane"]

{"sheet":"VBA","index":6,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Use of VBA Code",null,null,null,"Practice Yourself"]
[]
[null,"Club Name","Player Name","Playing Position",null,"Club Name","Player Name","Playing Position"]
[null,"Manchester United","Bruno Fernandes","Midfielder",null,"Manchester United","Bruno Fernandes","Midfielder"]
[null,"Manchester United","Jadon Sancho","Midfielder",null,null,"Jadon Sancho"]
[null,"Manchester United","Marcus Rashford","Midfielder",null,null,"Marcus Rashford"]
[null,"Manchester City","Joan Cancelo","Defender",null,"Manchester City","Joan Cancelo","Defender"]
[null,"Manchester City","Ruben Dias","Defender",null,null,"Ruben Dias"]
[null,"Chelsea","Kai Haverts","Forward",null,"Chelsea","Kai Haverts","Forward"]
[null,"Chelsea","Timo Werner","Forward",null,null,"Timo Werner"]
[null,"Liverpool","Mohammed Salah","Forward",null,"Liverpool","Mohammed Salah"]
[null,"Liverpool","Sadio Mane","Forward",null,null,"Sadio Mane"]