{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Copyright","Examples","Sheet1","Sheet2","Sheet3","Sheet4","More Resources"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":2,"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":"Copyright","index":0,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"Copyright Notice"]
[]
[null," "]
[null,"The content in this file was created by Mynda Treacy from My Online Training Hub."]
[null,"Individual users are permitted to recreate the examples for personal practice only."]
[null,"Recreating the examples for training or demonstration to others is not permitted, unless written consent is granted by Mynda Treacy."]
[]
[null,"The workbook and any sheets within must be accompanied by the following copyright notice: My Online Training Hub ©."]
[]
[null,"This sheet must remain in any file that uses this data and or these techniques."]
[null,"Any uses of this workbook and/or data must include the above attribution."]

{"sheet":"Examples","index":1,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Automatically List Sheet Names"]
[]
[null,"All Versions of Excel",null,"Excel for Microsoft 365"]
[null,"Sheet Links",null,"Sheet Name","Hyperlink",null,"GET.WORKBOOK Function"]
[null,{"$f":"IFERROR(HYPERLINK(\"#'\"&INDEX(SheetNames,ROW(A1))&\"'!A1\",INDEX(SheetNames,ROW(A1))),\"\")","v":"Copyright"},null,{"$f":"TRANSPOSE(SheetNames)","v":"Copyright"},{"$f":"HYPERLINK(\"#'\"&_xlfn.ANCHORARRAY(D5)&\"'!A1\",\"Go to sheet\")","v":"Go to sheet"},null,{"$f":"TRANSPOSE(GetWorkbook)","v":"[excel_list_sheet_names.xlsm]Copyright"}]
[null,{"$f":"IFERROR(HYPERLINK(\"#'\"&INDEX(SheetNames,ROW(A2))&\"'!A1\",INDEX(SheetNames,ROW(A2))),\"\")","v":"Examples"},null,"Examples","Go to sheet",null,"[excel_list_sheet_names.xlsm]Examples"]
[null,{"$f":"IFERROR(HYPERLINK(\"#'\"&INDEX(SheetNames,ROW(A3))&\"'!A1\",INDEX(SheetNames,ROW(A3))),\"\")","v":"Sheet1"},null,"Sheet1","Go to sheet",null,"[excel_list_sheet_names.xlsm]Sheet1"]
[null,{"$f":"IFERROR(HYPERLINK(\"#'\"&INDEX(SheetNames,ROW(A4))&\"'!A1\",INDEX(SheetNames,ROW(A4))),\"\")","v":"Sheet2"},null,"Sheet2","Go to sheet",null,"[excel_list_sheet_names.xlsm]Sheet2"]
[null,{"$f":"IFERROR(HYPERLINK(\"#'\"&INDEX(SheetNames,ROW(A5))&\"'!A1\",INDEX(SheetNames,ROW(A5))),\"\")","v":"Sheet3"},null,"Sheet3","Go to sheet",null,"[excel_list_sheet_names.xlsm]Sheet3"]
[null,{"$f":"IFERROR(HYPERLINK(\"#'\"&INDEX(SheetNames,ROW(A6))&\"'!A1\",INDEX(SheetNames,ROW(A6))),\"\")","v":"Sheet4"},null,"Sheet4","Go to sheet",null,"[excel_list_sheet_names.xlsm]Sheet4"]
[null,{"$f":"IFERROR(HYPERLINK(\"#'\"&INDEX(SheetNames,ROW(A7))&\"'!A1\",INDEX(SheetNames,ROW(A7))),\"\")","v":"More Resources"},null,"More Resources","Go to sheet",null,"[excel_list_sheet_names.xlsm]More Resources"]
[null,{"$f":"IFERROR(HYPERLINK(\"#'\"&INDEX(SheetNames,ROW(A8))&\"'!A1\",INDEX(SheetNames,ROW(A8))),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(HYPERLINK(\"#'\"&INDEX(SheetNames,ROW(A9))&\"'!A1\",INDEX(SheetNames,ROW(A9))),\"\")","v":""}]
[null,{"$f":"IFERROR(HYPERLINK(\"#'\"&INDEX(SheetNames,ROW(A9))&\"'!A1\",INDEX(SheetNames,ROW(A9))),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(HYPERLINK(\"#'\"&INDEX(SheetNames,ROW(A10))&\"'!A1\",INDEX(SheetNames,ROW(A10))),\"\")","v":""}]
[null,{"$f":"IFERROR(HYPERLINK(\"#'\"&INDEX(SheetNames,ROW(A10))&\"'!A1\",INDEX(SheetNames,ROW(A10))),\"\")","v":""}]
[null,{"$f":"IFERROR(HYPERLINK(\"#'\"&INDEX(SheetNames,ROW(A11))&\"'!A1\",INDEX(SheetNames,ROW(A11))),\"\")","v":""}]
[null,{"$f":"IFERROR(HYPERLINK(\"#'\"&INDEX(SheetNames,ROW(A12))&\"'!A1\",INDEX(SheetNames,ROW(A12))),\"\")","v":""}]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet2","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet4","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"More Resources","index":6,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["More Resources"]
[]
[null,"Tutorials"]
[null,"Excel Functions","https://www.myonlinetraininghub.com/excel-functions"]
[null,"Charting Blog Posts","http://www.myonlinetraininghub.com/category/excel-charts"]
[null,"Excel Dashboard Blog Posts","http://www.myonlinetraininghub.com/category/excel-dashboard"]
[]
[null,"Webinars"]
[null,"Excel Dashboards & Power BI","http://www.myonlinetraininghub.com/excel-webinars"]
[]
[null,"Courses"]
[null,"Advanced Excel","https://www.myonlinetraininghub.com/excel-expert-upgrade"]
[null,"Advanced Excel Formulas","https://www.myonlinetraininghub.com/advanced-excel-formulas-course"]
[null,"Power Query","https://www.myonlinetraininghub.com/excel-power-query-course"]
[null,"PivotTable Quick Start","https://www.myonlinetraininghub.com/excel-pivottable-course-quick-start"]
[null,"Xtreme PivotTables","https://www.myonlinetraininghub.com/excel-pivottable-course"]
[null,"Power Pivot","https://www.myonlinetraininghub.com/power-pivot-course"]
[null,"Excel Dashboards","http://www.myonlinetraininghub.com/excel-dashboard-course"]
[null,"Power BI","http://www.myonlinetraininghub.com/power-bi-course"]
[null,"Excel for Decision Making Under Uncertainty","https://www.myonlinetraininghub.com/excel-for-decision-making-course"]
[null,"Excel for Finance Professionals","https://www.myonlinetraininghub.com/excel-for-finance-course"]
[null,"Excel Analysis ToolPak","https://www.myonlinetraininghub.com/excel-analysis-toolpak-course"]
[null,"Excel for Customer Service Professionals","https://www.myonlinetraininghub.com/excel-for-customer-service-professionals"]
[null,"Excel for Operations Management","https://www.myonlinetraininghub.com/excel-operations-management-course"]
[null,"Financial Modelling","https://www.myonlinetraininghub.com/financial-modelling-course"]
[]
[null,"Support"]
[null,"Excel Forum","https://www.myonlinetraininghub.com/excel-forum"]