{"version":1,"pages":[{"id":"-LR_tHSShmsxcTByxgNe","title":"Introduction to Excel","pathname":"/advanced-excel","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRab29B4-9AMSVnGxTN","title":"Security","pathname":"/advanced-excel/security","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRab85higxxZ-L1jlh-","title":"Short Keys","pathname":"/advanced-excel/short-keys","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRfVUC8307qyVAl3f_S","title":"Practice Data Sheets","pathname":"/advanced-excel/practice-data-sheets1","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRabhApQx3uIdqumvct","title":"Data Formats","pathname":"/advanced-excel/data-formats","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRabjYV5Pvxa1Sgvd4G","title":"Conditional Formatting","pathname":"/advanced-excel/conditional-formatting","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRabqNRdHDXqRkPhDJ8","title":"Format as Table","pathname":"/advanced-excel/format-as-table","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRabspsyUi2nof8HPL5","title":"Data Sorting","pathname":"/advanced-excel/sorting-filtering","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRauiDzsS3yTU39zxLp","title":"Data Filtering","pathname":"/advanced-excel/filtering","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRabymZnDmly9DSqvz5","title":"Remove Duplicates","pathname":"/advanced-excel/remove-duplicates","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRb21os8i1_aDgDl2kD","title":"Data Validation","pathname":"/advanced-excel/data-validation","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRb55paP_UkEWIBDJXj","title":"Text-To-Columns","pathname":"/advanced-excel/text-to-columns","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRabvUsVmEyXMCU_ozL","title":"Data Consolidation","pathname":"/advanced-excel/data-consolidation","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRac90kekNtu6lgqiOC","title":"What-if-Analysis","pathname":"/advanced-excel/what-if-analysis","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRacCc7S5bFvRF90RUG","title":"Grouping","pathname":"/advanced-excel/grouping","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRacHxYl9_y7EqXjBFo","title":"Absolute & Relative Referencing","pathname":"/advanced-excel/absolute-and-relative-referencing","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRac-rofn5pos5Ic8An","title":"Mathematical Functions - Sum, Sumif, Sumifs, Count, Counta, Countif, Max, Min, Average","pathname":"/advanced-excel/mathematical-functions-sum-sumif-sumifs-count-counta-countif","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRfV2r853K7FyTbHHUO","title":"Task1 - Mathematical Formulas","pathname":"/advanced-excel/practice-sheet-mathematical-formulas","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRfa0IJNpAbnLb9k5__","title":"Logical Functions - IF, IFERROR, AND, OR","pathname":"/advanced-excel/logical-functions-and-if-iferror-or","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRacmrtA9knCprpedy3","title":"Date Time Functions - Date, Year, Month, Day, Time, Hour, Minute, Second, Today, Now, Datedif","pathname":"/advanced-excel/functions-if-and-or-concatenate-date-time-dated-if","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRadLZ2IAxteLc3S3IH","title":"Text Functions - Proper, Left, Right, Concatenate, Exact, Find, Search, Mid, Replace, Text, Replace","pathname":"/advanced-excel/text-functions","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRadRNgX-m7wA84RhrG","title":"Vlookup Formula","pathname":"/advanced-excel/advanced-vlookup","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRw9fg5132C9dMJIpK-","title":"Task2 - Vlookup Problems","pathname":"/advanced-excel/task2-vlookup-problems","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRvzyOHnBftUhihWbBS","title":"Vlookup with Match Formula - Dynamic Duo","pathname":"/advanced-excel/vlookup-with-match-formula-dynamic-duo","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRaf4_48FfqMtWxFqLv","title":"Vlookup using (*) example","pathname":"/advanced-excel/advanced-excel-logical-problems","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRw5-marPndgyTZWJfp","title":"Vlookup with Running Countif","pathname":"/advanced-excel/vlookup-with-running-countif","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRw8zAVBHuiPCf9CYHl","title":"Task3 - Vlookup, Running Countif Problem","pathname":"/advanced-excel/task2-vlookup-running-countif-problem","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRae6mmoWsLnGrstWQt","title":"Lookup Functions - Hlookup, Index Match","pathname":"/advanced-excel/lookup-functions-hlookup-index-match","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRaeGe_mvSlTNL5OVVB","title":"Lookup Functions - Indirect, Offset","pathname":"/advanced-excel/functions-indirect-offset-iferror","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRwWABA0SbpE9VfblsQ","title":"Vlookup-Indirect Example","pathname":"/advanced-excel/vlookup-indirect-example","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRwYXLtlVh4FOzjvI7P","title":"Sumif, Indirect, Offset, Match Example","pathname":"/advanced-excel/sumif-indirect-offset-match-example","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRae_hjm2TnyWqg5-RS","title":"Array Functions","pathname":"/advanced-excel/array-functions","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRwbih0yM1M7E80bR6n","title":"Task4 - Array Problem","pathname":"/advanced-excel/task4-array-problem","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRwmiWbkOlXrfm9Magv","title":"Advanced Conditional Formatting using Formula","pathname":"/advanced-excel/advanced-conditional-formatting-using-formula","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRwnVY-RAB5nASebE1z","title":"Data Validation using Indirect Function","pathname":"/advanced-excel/data-validation-using-indirect-function","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRaerJorWIL9TXP_M8K","title":"Charts, Waterfall Graph","pathname":"/advanced-excel/charts-waterfall-graph","siteSpaceId":"sitesp_zwBV3","description":""},{"id":"-LRaewl3Y6STv4QNfMBq","title":"Pivot Table, Dashboards","pathname":"/advanced-excel/pivot-table-dashboards","siteSpaceId":"sitesp_zwBV3","description":""}]}