{"id":28162,"date":"2023-02-21T12:06:56","date_gmt":"2023-02-21T11:06:56","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=28162"},"modified":"2024-03-28T23:56:54","modified_gmt":"2024-03-28T22:56:54","slug":"how-to-master-excel-formulas","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/","title":{"rendered":"How to Master Excel Formulas &#8211; The Ultimate Guide"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" title=\"How to Master Excel Formulas - The Ultimate Guide\" class=\"size-full wp-image-28164 aligncenter\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/02\/Ultimate-Formula.png\" alt=\"How to Master Excel Formulas - The Ultimate Guide\" width=\"800\" height=\"450\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/02\/Ultimate-Formula.png 800w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/02\/Ultimate-Formula-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/02\/Ultimate-Formula-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<div class=\"elementor-element elementor-element-cab42e6 elementor-widget elementor-widget-text-editor\" data-id=\"cab42e6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#120_Lessons_of_Free_Microsoft_Excel_Formula_Training_Videos_Articles\" title=\"120+ Lessons of Free Microsoft Excel Formula Training Videos &amp; Articles\">120+ Lessons of Free Microsoft Excel Formula Training Videos &amp; Articles<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Absolutely_FREE_No_Sign-up_Needed_Scroll_Down_Start_Learning\" title=\"Absolutely FREE! | No Sign-up Needed | Scroll Down &amp; Start Learning!\">Absolutely FREE! | No Sign-up Needed | Scroll Down &amp; Start Learning!<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#3D\" title=\"3D\u00a0\">3D\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#And\" title=\"And \">And <\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Array\" title=\"Array\u00a0\">Array\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Array_Lookup\" title=\"Array, Lookup\u00a0\">Array, Lookup\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Average\" title=\"Average\u00a0\">Average\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Between\" title=\"Between\u00a0\">Between\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Chart\" title=\"Chart\u00a0\">Chart\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Clean\" title=\"Clean\u00a0\">Clean\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Concatenate\" title=\"Concatenate\u00a0\">Concatenate\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Convert_Values\" title=\"Convert, Values\u00a0\">Convert, Values\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Count\" title=\"Count\u00a0\">Count\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#CountA\" title=\"CountA\u00a0\">CountA\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#CountBlank\" title=\"CountBlank\u00a0\">CountBlank\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#CountIf\" title=\"CountIf\u00a0\">CountIf\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#CountIfs\" title=\"CountIfs\u00a0\">CountIfs\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Data_Cleansing_Trim\" title=\"Data Cleansing, Trim\u00a0\">Data Cleansing, Trim\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#DateDif\" title=\"DateDif\u00a0\">DateDif\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#EndOfMonth\" title=\"EndOfMonth\u00a0\">EndOfMonth\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Evaluate\" title=\"Evaluate\u00a0\">Evaluate\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Extract_Find_Left\" title=\"Extract, Find, Left\u00a0\">Extract, Find, Left\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Filter\" title=\"Filter \">Filter <\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#FV\" title=\"FV\u00a0\">FV\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Find_Select\" title=\"Find &amp; Select\u00a0\">Find &amp; Select\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-26\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Hlookup\" title=\"Hlookup\u00a0\">Hlookup\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-27\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#If\" title=\"If\u00a0\">If\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-28\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#If_And\" title=\"If, And\u00a0\">If, And\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-29\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Iferror\" title=\"Iferror\u00a0\">Iferror\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-30\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Iferror_Vlookup\" title=\"Iferror, Vlookup\u00a0\">Iferror, Vlookup\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-31\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Index\" title=\"Index\u00a0\">Index\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-32\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Index_Match\" title=\"Index, Match\u00a0\">Index, Match\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-33\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Indirect\" title=\"Indirect\u00a0\">Indirect\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-34\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Left\" title=\"Left\u00a0\">Left\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-35\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Len_Length\" title=\"Len, Length\u00a0\">Len, Length\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-36\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Match\" title=\"Match\u00a0\">Match\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-37\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Mathematical_Formulas\" title=\"Mathematical Formulas\u00a0\">Mathematical Formulas\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-38\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Mod\" title=\"Mod\u00a0\">Mod\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-39\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Multiple_Criteria_Vlookup\" title=\"Multiple Criteria, Vlookup\u00a0\">Multiple Criteria, Vlookup\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-40\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Offset\" title=\"Offset\u00a0\">Offset\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-41\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Percentage\" title=\"Percentage\u00a0\">Percentage\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-42\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Pivot_Table_GetPivotData\" title=\"Pivot Table, GetPivotData\u00a0\">Pivot Table, GetPivotData\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-43\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Proper\" title=\"Proper\u00a0\">Proper\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-44\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Rand\" title=\"Rand\u00a0\">Rand\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-45\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Randbetween\" title=\"Randbetween\u00a0\">Randbetween\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-46\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Reference\" title=\"Reference\u00a0\">Reference\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-47\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Remove\" title=\"Remove\u00a0\">Remove\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-48\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Remove_Substitute\" title=\"Remove, Substitute\u00a0\">Remove, Substitute\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-49\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Replace\" title=\"Replace\u00a0\">Replace\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-50\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Replace_Cleanup\" title=\"Replace, Cleanup\u00a0\">Replace, Cleanup\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-51\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Right\" title=\"Right\u00a0\">Right\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-52\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Round\" title=\"Round\u00a0\">Round\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-53\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Show_Hide\" title=\"Show, Hide\u00a0\">Show, Hide\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-54\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Sort\" title=\"Sort\u00a0\">Sort\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-55\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Sortby\" title=\"Sortby\u00a0\">Sortby\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-56\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Substitute\" title=\"Substitute\u00a0\">Substitute\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-57\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Substitute_Trim\" title=\"Substitute, Trim\u00a0\">Substitute, Trim\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-58\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Subtotal\" title=\"Subtotal\u00a0\">Subtotal\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-59\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Sum_Lookup\" title=\"Sum, Lookup\u00a0\">Sum, Lookup\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-60\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Sumifs\" title=\"Sumifs\u00a0\">Sumifs\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-61\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Sumproduct\" title=\"Sumproduct\u00a0\">Sumproduct\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-62\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Text\" title=\"Text\u00a0\">Text\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-63\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Time\" title=\"Time\u00a0\">Time\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-64\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Transpose\" title=\"Transpose \">Transpose <\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-65\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Type\" title=\"Type \">Type <\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-66\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Upper\" title=\"Upper \">Upper <\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-67\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Unique\" title=\"Unique \">Unique <\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-68\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Value\" title=\"Value \">Value <\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-69\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Vlookup\" title=\"Vlookup\u00a0\">Vlookup\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-70\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Xlookup\" title=\"Xlookup \">Xlookup <\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-71\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Weekday\" title=\"Weekday\u00a0\">Weekday\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-72\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Weeknum\" title=\"Weeknum \">Weeknum <\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-73\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Workday\" title=\"Workday\u00a0\">Workday\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-74\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/#Year\" title=\"Year \">Year <\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"120_Lessons_of_Free_Microsoft_Excel_Formula_Training_Videos_Articles\"><\/span>120+ Lessons of Free Microsoft Excel Formula Training Videos &amp; Articles<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-6725bab elementor-widget elementor-widget-text-editor\" data-id=\"6725bab\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-text-editor elementor-clearfix\">\n<h2><span class=\"ez-toc-section\" id=\"Absolutely_FREE_No_Sign-up_Needed_Scroll_Down_Start_Learning\"><\/span><b>Absolutely FREE! | No Sign-up Needed | Scroll Down &amp; Start Learning!<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<p>Excel <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"Formulas\" data-wpil-keyword-link=\"linked\">Formulas<\/a> &amp; Functions are a <strong>must know feature in Microsoft Excel<\/strong> that allows you to quickly analyze your data in many forms.\u00a0 It is an indispensable skill that will make you stand out from the crowd in the Excel world.<\/p>\n<p>Below you will find <strong>120+ Excel formulas &amp; functions examples<\/strong> for key formulas &amp; functions like XLOOKUP, VLOOKUP, INDEX, MATCH, IF, SUMPRODUCT, AVERAGE, SUBTOTAL, OFFSET, LOOKUP, ROUND, COUNT, SUMIFS, ARRAY, FIND, TEXT, and many more.\u00a0 Let us start learning for free!<\/p>\n<h3 style=\"text-align: left\">Free Excel Formulas &amp; Functions Video Lessons<\/h3>\n<div style=\"background: #e8e8e8\"><a href=\"#lesson03\">Lesson 1: MOST POPULAR Excel Formulas and Functions<\/a><\/div>\n<div style=\"background: #f4f4f4\"><a href=\"#lesson04\">Lesson 2: Learn the VLOOKUP formula in 4 easy steps<\/a><\/div>\n<div style=\"background: #e8e8e8\"><a href=\"#lesson05\">Lesson 3: 6 brand new functions in Office 365<\/a><\/div>\n<div style=\"background: #f4f4f4\"><a href=\"#lesson06\">Lesson 4: Len Function<\/a><\/div>\n<div style=\"background: #e8e8e8\"><a href=\"#lesson07\">Lesson 5: Filter Function<\/a><\/div>\n<div style=\"background: #f4f4f4\"><a href=\"#lesson08\">Lesson 6: Substitute Function<\/a><\/div>\n<div style=\"background: #e8e8e8\"><a href=\"#lesson09\">Lesson 7: Concatenate Function<\/a><\/div>\n<div style=\"background: #f4f4f4\"><a href=\"#lesson06\">Lesson 8: Match Function<\/a><\/div>\n<div style=\"background: #f4f4f4\"><a href=\"#lesson11\">Lesson 9: Absolute and Relative Function<\/a><\/div>\n<div style=\"background: #e8e8e8\"><a href=\"#lesson12\">Lesson 10: Left, Mid and Right Function<\/a><\/div>\n<div style=\"background: #f4f4f4\"><a href=\"#lesson13\">Lesson 11: XLOOKUP &#8211; Outstanding Replacement of VLOOKUP<\/a><\/div>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson03\"><\/a>Lesson 1: MOST POPULAR Excel Formulas and Functions<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/cos-90-degrees-in-excel\/\" target=\"_blank\" rel=\"noopener\">Excel Formulas &amp; Functions<\/a> will allow you to quickly analyze your data in many forms and will increase your Excel skill exponentially.<\/p>\n<p>After completing this tutorial, you will Master <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/offset-function\/\" target=\"_blank\" rel=\"noopener\">the Most POPULAR Excel Formulas<\/a> and Functions: <strong>VLOOKUP, INDEX, MATCH, SUMIF, &amp; IF<\/strong> in only<strong> 1 HOUR<\/strong>! You will also learn:<\/p>\n<ul>\n<li>A proven step-by-step guide to creating Excel Formulas in SECONDS!<\/li>\n<li>The limitations of using a VLOOKUP and why INDEX &amp; MATCH is better!<\/li>\n<li>3 TIPS that the Excel experts &amp; MVPS use that will enhance your Formula knowledge!<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/eBkMQxIIkx4?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson04\"><\/a>Lesson 2: Learn VLOOKUP formula in 4 easy steps<\/strong><\/p>\n<p>Excel`s\u00a0<strong>VLOOKUP<\/strong>\u00a0function is arguably <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/xmatch-function-2\/\" target=\"_blank\" rel=\"noopener\">the<\/a> <strong>most used function<\/strong> and the <strong>most talked-about function <\/strong>in Excel. It can be used to <strong>extract values from a table<\/strong> and use them in your custom reports and analysis.<\/p>\n<p>In this tutorial, we will cover how <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/use-vlookup-in-excel\/\" target=\"_blank\" rel=\"noopener\">to use VLOOKUP in Excel<\/a> using<strong> 4 easy steps<\/strong>!<\/p>\n<ul>\n<li>Enter VLOOKUP formula<\/li>\n<li>Enter the value you are looking for<\/li>\n<li>Enter the table where you going<\/li>\n<li>Enter the column number containing the result<\/li>\n<\/ul>\n<p>Watch this Tutorial to Master the VLOOKUP function and use it with confidence!<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/wlyr10UTgEQ?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson05\"><\/a>Lesson 3: 6 brand new functions in Office 365 <\/strong><\/p>\n<p>This is your o<strong>ne-stop-shop for learning<\/strong> all the <strong>new Excel formulas in Office 365:<\/strong><\/p>\n<ul>\n<li><strong>Filter Formula<\/strong> &#8211; \u00a0Filter your table data with an Excel Formula<\/li>\n<li><strong>Randarray Formula<\/strong> &#8211; Generate random numbers in an array<\/li>\n<li><strong>Sequence Formula<\/strong> &#8211; Generate a series of numbers with an Excel Formula<\/li>\n<li><strong>Sort Formula<\/strong> &#8211; Sorts a table based on a column and order specified<\/li>\n<li><strong>Sortby Formula<\/strong> &#8211; Sorts a table based on the column(s) specified<\/li>\n<li><strong>Unique Formula<\/strong> &#8211; Gets the unique values of a list<\/li>\n<\/ul>\n<p>Watch this video lesson to learn the following formulas in detail!<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/D69Sy_fpGc8?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson06\"><\/a>Lesson 4: LEN Function<\/strong><\/p>\n<p>There are times when you need to<strong> get the number of characters within a cell<\/strong> in Excel. Thankfully this is very easy to do with Excel\u2019s LEN (Length) <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formula\" data-wpil-keyword-link=\"linked\">formula<\/a>!<\/p>\n<p>You can use the LEN formula in Excel:<\/p>\n<ul>\n<li>To <strong>count all characters in a cell<\/strong>, including letters, numbers, special characters, and all spaces.<\/li>\n<li>As a <strong>data cleansing technique<\/strong> to find leading or trailing spaces or can be nested with other TEXT functions.<\/li>\n<li>To<strong> find out errors<\/strong> like additional spaces in data entry.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/8_AFpelhieA?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong><a id=\"lesson07\"><\/a>Lesson 5: FILTER Function<\/strong><\/p>\n<p>Did you know that you can now<strong> filter your table <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/choose-function\/\" target=\"_blank\" rel=\"noopener\">data with an Excel Formula<\/a><\/strong>? Watch this free Excel training to learn how.<\/p>\n<ul>\n<li>Filter is a <strong>new formula<\/strong> introduced in <strong>Office 365<\/strong> released in 2018!<\/li>\n<li>It can be used to filter a table array based on conditions you specify and extract matching records.<\/li>\n<li>It is a<strong> dynamic function<\/strong>\u00a0i.e. when the values in the data sources change the result from this formula will update automatically.<\/li>\n<li>It&#8217;s an ideal function for <strong>sorting and picking out data<\/strong> and can even be used to <strong>improve the presentation<\/strong> of your reports.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/TKI1Q4Wm0Mk?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson08\"><\/a>Lesson 6: SUBSTITUTE Function<\/strong><\/p>\n<p>When you needed to <strong>replace a specific text\u00a0in each word<\/strong>, and there is a pattern, Excel has just the formula for you.<\/p>\n<p>Substitute Function can be used to :<\/p>\n<ul>\n<li>Clean Data by <strong>substituting any leading, trailing, or unwanted text.<\/strong><\/li>\n<li><strong>Replace every instance of old text<\/strong> with new text.<\/li>\n<li><strong>Replace multiple texts<\/strong> at one time using the nested Substitute function.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/nWOJzkRbvXg?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson09\"><\/a>Lesson 7: CONCATENATE Function<\/strong><\/p>\n<p>Excel\u2019s CONCATENATE functions <strong>join two or more text strings<\/strong> into one string. The<strong> item can be a text value, number, or cell reference<\/strong>.<\/p>\n<ul>\n<li>A helpful formula for extracting text from data<span style=\"color: #ff0000\">.<\/span><\/li>\n<li><strong>Join several cells to give a consolidated result<\/strong>, especially useful for combining names and other details.<\/li>\n<li>You can even <strong>combine concatenate with other functions for advanced results.<\/strong><\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/0ec59hlQkvw?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson10\"><\/a>Lesson 8: MATCH Function<\/strong><\/p>\n<p>The\u00a0<strong>MATCH<\/strong> function in Excel returns the position of an item within a list or a range of cells.<\/p>\n<ul>\n<li>It can <strong>find irregularities<\/strong> just as easily as it can extract data.<\/li>\n<li>The match function is a dynamic tool to <strong>help make your Excel work at optimum levels.<\/strong><\/li>\n<li>Primarily<strong> combined with INDEX function<\/strong> to help user result value from a table based on horizontal and vertical criteria.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/8ldK8L2ioEU?list=PLWSweFpA2PEiHZ03UzIsGZ2VQsY-Gy4YL\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson11\"><\/a>Lesson 9: ABSOLUTE and RELATIVE Function<\/strong><\/p>\n<p>Learn the differences between these two and how you can properly use them in Excel Formulas! You can easily <strong>compare the differences between Relative and Absolute References<\/strong> in Excel with this Online Excel Training.<\/p>\n<ul>\n<li>Use <strong>Absolute Reference<\/strong> &#8211; When you <strong>do not want cell reference<\/strong> to change when filling cells.<\/li>\n<li>Use <strong>Relative Reference<\/strong> &#8211; When you <strong>want cell reference<\/strong> to automatically adjust when filling cells.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/wAGr82yKgz0?list=PLWSweFpA2PEiHZ03UzIsGZ2VQsY-Gy4YL\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson12\"><\/a>Lesson 10: Left, Right &amp; Mid Function<\/strong><\/p>\n<p>Ever wanted to <strong>get something on the left, middle, or right side of your text<\/strong>? You can with the LEFT, MID, and RIGHT text formulas in Excel.<\/p>\n<ul>\n<li>Three most <strong>useful and powerful text-based functions.<\/strong><\/li>\n<li><strong>Extracts a specific number<\/strong> of characters from the left, middle, or right of a text.<\/li>\n<li>Also, helpful in cases where <strong>different parts of text contain different information<\/strong> (like social security numbers).<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/WUz3A0GCAsk?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"lesson13\"><\/a>Lesson 11: XLOOKUP &#8211; Outstanding Replacement of VLOOKUP<\/strong><\/p>\n<p>XLOOKUP is a<strong>\u00a0versatile and outstanding replacement<\/strong>\u00a0for the above-mentioned Excel functions. It allows you to <strong>quickly lookup values in a data set<\/strong> (just like VLOOKUP Excel) with additional flexibility and advantages.<\/p>\n<ul>\n<li>It can search the value both\u00a0<strong>horizontally and vertically<\/strong>,<\/li>\n<li>Perform an\u00a0<strong>exact or approximate match<\/strong>,<\/li>\n<li>Use\u00a0<strong>wildcards<\/strong>,<\/li>\n<li>Return a\u00a0<strong>custom text when no result<\/strong>\u00a0is found,<\/li>\n<li><strong>Doesn\u2019t even have the restriction of the return array to be on the right<\/strong>\u00a0of the lookup array.<\/li>\n<\/ul>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/aRo-bzKzTqM?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<h3 style=\"text-align: left\">Free Excel Formulas &amp; Functions Tutorials and Exercise Workbooks<\/h3>\n<div>\n<div>\n<div class=\"table-of-contents\" id=\"table_of_contents\" ><br \/>\n<div class='content-column one_third'><p><span style=\"color: #0000ff\"><i class=\"fa fa-calendar \" ><\/i> <strong>DATE &amp; TIME<\/strong><\/span><br \/>\n<a href=\"#section1\">DateDif<\/a><br \/>\n<a href=\"#section2\">EndOfMonth<\/a><br \/>\n<a href=\"#section3\">Time<\/a><br \/>\n<a href=\"#section4\">Weekday<\/a><br \/>\n<a href=\"#section67\">Weeknum<\/a><br \/>\n<a href=\"#section5\">Workday<\/a><br \/>\n<a href=\"#section66\">Year<\/a><\/p>\n<p><span style=\"color: #0000ff\"><i class=\"fa fa-lightbulb-o \" ><\/i> <strong>LOGICAL<\/strong><\/span><br \/>\n<a href=\"#section65\">And<\/a><br \/>\n<a href=\"#section6\">If<\/a><br \/>\n<a href=\"#section7\">If, And<\/a><br \/>\n<a href=\"#section8\">Iferror<\/a><\/p>\n<p><span style=\"color: #0000ff\"><i class=\"fa fa-arrow-circle-up \" ><\/i>\u00a0<strong>LOOKUP<\/strong><\/span><br \/>\n<a href=\"#section9\">Array, Lookup<\/a><br \/>\n<a href=\"#section10\">Hlookup<\/a><br \/>\n<a href=\"#section11\">Iferror, Vlookup<\/a><br \/>\n<a href=\"#section12\">Index<\/a><br \/>\n<a href=\"#section13\">Index, Match<\/a><br \/>\n<a href=\"#section14\">Indirect<\/a><br \/>\n<a href=\"#section15\">Match<\/a><br \/>\n<a href=\"#section16\">Multiple Criteria, Vlookup<\/a><br \/>\n<a href=\"#section17\">Offset<\/a><br \/>\n<a href=\"#section18\">Pivot Table, GetPivotData<\/a><br \/>\n<a href=\"#section19\">Sum, Lookup<\/a><br \/>\n<a href=\"#section20\">Vlookup<\/a><br \/>\n<a href=\"#section72\">Xlookup<\/a><\/div><div class='content-column one_third'><p><span style=\"color: #0000ff\"><i class=\"fa fa-calculator \" ><\/i>\u00a0<strong>MATH<\/strong><\/span><br \/>\n<a href=\"#section21\">Average<\/a><br \/>\n<a href=\"#section22\">Count<\/a><br \/>\n<a href=\"#section23\">CountA<\/a><br \/>\n<a href=\"#section24\">CountBlank<\/a><br \/>\n<a href=\"#section25\">CountIf<\/a><br \/>\n<a href=\"#section26\">CountIfs<\/a><br \/>\n<a href=\"#section27\">Mathematical Formulas<\/a><br \/>\n<a href=\"#section28\">Mod<\/a><br \/>\n<a href=\"#section29\">Percentage<\/a><br \/>\n<a href=\"#section30\">Rand<\/a><br \/>\n<a href=\"#section31\">Randbetween<\/a><br \/>\n<a href=\"#section32\">Round<\/a><br \/>\n<a href=\"#section33\">Subtotal<\/a><br \/>\n<a href=\"#section34\">Sumifs<\/a><br \/>\n<a href=\"#section35\">Sumproduct<\/a><\/p>\n<p><span style=\"color: #0000ff\"><i class=\"fa fa-delicious \" ><\/i>\u00a0<strong>OTHER<\/strong><\/span><br \/>\n<a href=\"#section36\">3D<\/a><br \/>\n<a href=\"#section37\">Array<\/a><br \/>\n<a href=\"#section38\">Chart<\/a><br \/>\n<a href=\"#section39\">Convert, Values<\/a><br \/>\n<a href=\"#section40\">Evaluate<\/a><br \/>\n<a href=\"#section41\">Find &amp; Select<\/a><br \/>\n<a href=\"#section42\">FV<\/a><br \/>\n<a href=\"#section43\">Reference<\/a><br \/>\n<a href=\"#section44\">Show, Hide<\/a><br \/>\n<a href=\"#section71\">Transpose<\/a><br \/>\n<a href=\"#section70\">Type<\/a><br \/>\n<a href=\"#section68\">Value<\/a><\/div><div class='content-column one_third last_column'><p><span style=\"color: #0000ff\"><i class=\"fa fa-wpforms \" ><\/i>\u00a0<strong>TEXT<\/strong><\/span><br \/>\n<a href=\"#section45\">Between<\/a><br \/>\n<a href=\"#section46\">Clean<\/a><br \/>\n<a href=\"#section47\">Concatenate<\/a><br \/>\n<a href=\"#section48\">Data Cleansing, Trim<\/a><br \/>\n<a href=\"#section49\">Extract, Find, Left<\/a><br \/>\n<a href=\"#section50\">Left<\/a><br \/>\n<a href=\"#section51\">Len, Length<\/a><br \/>\n<a href=\"#section52\">Proper<\/a><br \/>\n<a href=\"#section53\">Remove<\/a><br \/>\n<a href=\"#section54\">Remove, Substitute<\/a><br \/>\n<a href=\"#section55\">Replace<\/a><br \/>\n<a href=\"#section56\">Replace, Cleanup<\/a><br \/>\n<a href=\"#section57\">Right<\/a><br \/>\n<a href=\"#section58\">Substitute<\/a><br \/>\n<a href=\"#section59\">Substitute, Trim<\/a><br \/>\n<a href=\"#section60\">Text<\/a><br \/>\n<a href=\"#section69\">Upper<\/a><\/p>\n<p><span style=\"color: #0000ff\"><i class=\"fa fa-wpforms \" ><\/i>\u00a0<strong>OFFICE 365<\/strong><\/span><br \/>\n<a href=\"#section61\">Filter<\/a><br \/>\n<a href=\"#section62\">Sort<\/a><br \/>\n<a href=\"#section63\">Sortby<\/a><br \/>\n<a href=\"#section64\">Unique<\/a><\/p><\/div><div class='clear_column'><\/div><br \/>\n<\/div>\n<div class=\"jumbotron2\">\n<div class=\"meo-subcount-2\">\n<p>&nbsp;<\/p>\n<\/div>\n<\/div>\n<p>Click on any <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-isna-function\/\" target=\"_blank\" rel=\"noopener\">Excel formula &amp; function<\/a> link below and it will take you to the advanced Excel formulas with examples in Excel sheet free download for you to practice!<\/p>\n<\/div>\n<div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"3D\"><\/span><span style=\"color: #ff0000\"><a id=\"section36\"><\/a>3D\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/consolidate-with-3d-formulas-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Consolidate with 3D Formulas in Excel<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"And\"><\/span><span style=\"color: #ff0000\"><a id=\"section65\"><\/a>And <\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/and-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">AND Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Array\"><\/span><span style=\"color: #ff0000\"><a id=\"section37\"><\/a>Array\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/calculate-total-sales-with-an-array-formula-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Calculate Total Sales With An Array Formula<\/a><\/div>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-array-formulas-explained\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel Array Formulas Explained<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Array_Lookup\"><\/span><span style=\"color: #ff0000\"><a id=\"section9\"><\/a>Array, Lookup\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/total-bonus-due-with-an-array-lookup-formula-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Total Bonus Due With An Array Lookup Formula<\/a><\/div>\n<div>\n<div>\n<div>\n<div>\n<div>\n<div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Average\"><\/span><span style=\"color: #ff0000\"><a id=\"section21\"><\/a>Average\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/get-average-values-excels-average-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Get the Average of Values with Excel\u2019s AVERAGE Formula<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Between\"><\/span><span style=\"color: #ff0000\"><a id=\"section45\"><\/a>Between\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/between-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">BETWEEN Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Chart\"><\/span><span style=\"color: #ff0000\"><a id=\"section38\"><\/a>Chart\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/in-cell-bar-charts-with-the-excel-rept-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">In-Cell Bar Charts with the REPT Function<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Clean\"><\/span><span style=\"color: #ff0000\"><a id=\"section46\"><\/a>Clean\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/cleaning-data-excels-clean-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cleaning Data with Excel\u2019s CLEAN Formula<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Concatenate\"><\/span><span style=\"color: #ff0000\"><a id=\"section47\"><\/a>Concatenate\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/concatenate-with-a-line-break-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Concatenate With A Line Break<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Convert_Values\"><\/span><span style=\"color: #ff0000\"><a id=\"section39\"><\/a>Convert, Values\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/convert-formulas-values\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Convert Formulas to Values<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Count\"><\/span><span style=\"color: #ff0000\"><a id=\"section22\"><\/a>Count\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/count-formula-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Count Formula in Excel<\/a><\/div>\n<div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"CountA\"><\/span><span style=\"color: #ff0000\"><a id=\"section23\"><\/a>CountA\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/counta-formula-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">CountA Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"CountBlank\"><\/span><span style=\"color: #ff0000\"><a id=\"section24\"><\/a>CountBlank\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/countblank-formula-excel-2\/\" target=\"_blank\" rel=\"noopener noreferrer\">CountBlank Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"CountIf\"><\/span><span style=\"color: #ff0000\"><a id=\"section25\"><\/a>CountIf\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/countif-formula-excel-2\/\" target=\"_blank\" rel=\"noopener noreferrer\">CountIf Formula in Excel<\/a><\/div>\n<div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"CountIfs\"><\/span><span style=\"color: #ff0000\"><a id=\"section26\"><\/a>CountIfs\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/countifs-formula-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">CountIfs Formula in Excel<\/a><\/div>\n<\/div>\n<\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Data_Cleansing_Trim\"><\/span><span style=\"color: #ff0000\"><a id=\"section48\"><\/a>Data Cleansing, Trim\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/cleaning-data-with-the-trim-formula-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cleaning Data with Excel\u2019s TRIM Formula<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"DateDif\"><\/span><span style=\"color: #ff0000\"><a id=\"section1\"><\/a>DateDif\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/datedif-function-introduction\/\" target=\"_blank\" rel=\"noopener noreferrer\">DATEDIF function: Introduction<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"EndOfMonth\"><\/span><span style=\"color: #ff0000\"><a id=\"section2\"><\/a>EndOfMonth\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excels-endofmonth-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel\u00b4s EndOfMonth function<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Evaluate\"><\/span><span style=\"color: #ff0000\"><a id=\"section40\"><\/a>Evaluate\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/evaluate-formulas-step-by-step-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Evaluate Formulas Step By Step in Excel<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Extract_Find_Left\"><\/span><span style=\"color: #ff0000\"><a id=\"section49\"><\/a>Extract, Find, Left\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/extract-first-name-from-full-name-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Extract First Name From Full Name in Excel<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Filter\"><\/span><span style=\"color: #ff0000\"><a id=\"section61\"><\/a>Filter <\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/filter-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">FILTER Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"FV\"><\/span><span style=\"color: #ff0000\"><a id=\"section42\"><\/a>FV\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/calculate-compound-interest-excels-fv-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Calculate the Compound Interest with Excel\u2019s FV Formula<\/a><\/div>\n<div>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/calculate-monthly-investment-excels-fv-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Calculate your Monthly Investment with Excel\u2019s FV Formula<\/a><\/div>\n<\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Find_Select\"><\/span><span style=\"color: #ff0000\"><a id=\"section41\"><\/a>Find &amp; Select\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/highlight-all-excel-formula-cells\/\" target=\"_blank\" rel=\"noopener noreferrer\">Highlight All Excel Formula Cells<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Hlookup\"><\/span><span style=\"color: #ff0000\"><a id=\"section10\"><\/a>Hlookup\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/formula\/hlookup-function-excel-introduction\/\" target=\"_blank\" rel=\"noopener noreferrer\">HLOOKUP Function in Excel: Introduction<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"If\"><\/span><span style=\"color: #ff0000\"><a id=\"section6\"><\/a>If\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/if-function-introduction\/\" target=\"_blank\" rel=\"noopener noreferrer\">IF Function: Introduction<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"If_And\"><\/span><span style=\"color: #ff0000\"><a id=\"section7\"><\/a>If, And\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/if-function-combined-with-the-and-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">IF Function Combined With The AND Function<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Iferror\"><\/span><span style=\"color: #ff0000\"><a id=\"section8\"><\/a>Iferror\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/iferror-introduction\/\" target=\"_blank\" rel=\"noopener noreferrer\">IFERROR Function: Introduction<\/a><\/div>\n<div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Iferror_Vlookup\"><\/span><span style=\"color: #ff0000\"><a id=\"section11\"><\/a>Iferror, Vlookup\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-combine-vlookup-and-iferror-to-replace-the-n-a-error-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Combine VLOOKUP and IFERROR to Replace the #N\/A Error in Excel<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Index\"><\/span><span style=\"color: #ff0000\"><a id=\"section12\"><\/a>Index\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/index-function-introduction\/\" target=\"_blank\" rel=\"noopener noreferrer\">INDEX Function Introduction<\/a><\/div>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/index-function-with-data-validation\/\" target=\"_blank\" rel=\"noopener noreferrer\">INDEX Function with Data Validation<\/a><\/div>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sum-a-range-using-the-index-function-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Sum a Range Using the INDEX Function<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Index_Match\"><\/span><span style=\"color: #ff0000\"><a id=\"section13\"><\/a>Index, Match\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-use-index-match-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Use INDEX-MATCH Formula<\/a><\/div>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/index-match-2-criteria-with-data-validation-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Index Match 2 Criteria with Data Validation<\/a><\/div>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/index-match-maximum-sales-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">INDEX-MATCH Maximum Sales<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Indirect\"><\/span><span style=\"color: #ff0000\"><a id=\"section14\"><\/a>Indirect\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-indirect-function-using-sheet-references\/\" target=\"_blank\" rel=\"noopener noreferrer\">INDIRECT Function Using Sheet References<\/a><\/div>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/indirect-function-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">INDIRECT Function in Excel<\/a><\/div>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/indirect-function-for-dependent-dropdown-lists-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">INDIRECT Function for Dependent Dropdown Lists in Excel<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Left\"><\/span><span style=\"color: #ff0000\"><a id=\"section50\"><\/a>Left\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/extracting-data-with-excels-left-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Extracting Data with Excel\u2019s LEFT Formula<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Len_Length\"><\/span><span style=\"color: #ff0000\"><a id=\"section51\"><\/a>Len, Length\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/getting-the-length-of-text-with-excels-len-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Getting the length of text with Excel\u2019s LEN Formula<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Match\"><\/span><span style=\"color: #ff0000\"><a id=\"section15\"><\/a>Match\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-match-function-intro\/\" target=\"_blank\" rel=\"noopener noreferrer\">MATCH Function Intro<\/a><\/div>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/match-two-lists-with-the-match-function-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Match Two Lists With The MATCH Function<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Mathematical_Formulas\"><\/span><span style=\"color: #ff0000\"><a id=\"section27\"><\/a>Mathematical Formulas\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/subtraction-formula-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Subtraction Formula in Excel<\/a><\/div>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/division-formula-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Division Formula in Excel<\/a><\/div>\n<div><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/addition-formula-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Addition Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Mod\"><\/span><span style=\"color: #ff0000\"><a id=\"section28\"><\/a>Mod\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/getting-the-remainder-with-excels-mod-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Getting the remainder with Excel\u2019s MOD Formula<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Multiple_Criteria_Vlookup\"><\/span><span style=\"color: #ff0000\"><a id=\"section16\"><\/a>Multiple Criteria, Vlookup\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-multiple-criteria-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">VLOOKUP with Multiple Criteria in Excel<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Offset\"><\/span><span style=\"color: #ff0000\"><a id=\"section17\"><\/a>Offset\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-dynamic-data-range-offset-function-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Create a Dynamic Data Range with the OFFSET function<\/a><\/div>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-offset-function-introduced\/\" target=\"_blank\" rel=\"noopener noreferrer\">OFFSET Function Introduced<\/a><\/div>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/return-the-last-value-column-offset-function-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Return the Last Value in a Column with the Offset Function<\/a><\/div>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sum-last-7-transactions-offset-function-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Sum the Last 7 Transactions with the Offset Function<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Percentage\"><\/span><span style=\"color: #ff0000\"><a id=\"section29\"><\/a>Percentage\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/calculate-percentage-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Calculate Percentage in Excel<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Pivot_Table_GetPivotData\"><\/span><span style=\"color: #ff0000\"><a id=\"section18\"><\/a>Pivot Table, GetPivotData\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/getpivotdata-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">GETPIVOTDATA Function<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Proper\"><\/span><span style=\"color: #ff0000\"><a id=\"section52\"><\/a>Proper\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/cleaning-data-with-excels-proper-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cleaning Data with Excel\u2019s PROPER Formula<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Rand\"><\/span><span style=\"color: #ff0000\"><a id=\"section30\"><\/a>Rand\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-a-random-list-ordering-with-excels-rand-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Create a Random List with Excel\u2019s RAND Formula<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Randbetween\"><\/span><span style=\"color: #ff0000\"><a id=\"section31\"><\/a>Randbetween\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/randbetween-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">RANDBETWEEN Function<\/a><\/div>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/randbetween-function-for-dates\/\" target=\"_blank\" rel=\"noopener noreferrer\">RANDBETWEEN Function for Excel Dates<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Reference\"><\/span><span style=\"color: #ff0000\"><a id=\"section43\"><\/a>Reference\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/jump-to-a-cell-reference-within-an-excel-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Jump To A Cell Reference Within An Excel Formula<\/a><\/div>\n<div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Remove\"><\/span><span style=\"color: #ff0000\"><a id=\"section53\"><\/a>Remove\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-remove-formulas-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Remove Formulas in Excel<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Remove_Substitute\"><\/span><span style=\"color: #ff0000\"><a id=\"section54\"><\/a>Remove, Substitute\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/remove-second-hyphen-with-excels-substitute-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Remove Second Hyphen with Excel\u2019s SUBSTITUTE Formula<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Replace\"><\/span><span style=\"color: #ff0000\"><a id=\"section55\"><\/a>Replace\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/change-phone-area-codes-with-excels-replace-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Change Phone Area Codes with Excel\u2019s REPLACE Formula<\/a><\/div>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/cleaning-data-with-excels-replace-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cleaning Data with Excel\u2019s REPLACE Formula<\/a><\/div>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/extract-last-name-with-excels-replace-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Extract Last Name with Excel\u2019s REPLACE Formula<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Replace_Cleanup\"><\/span><span style=\"color: #ff0000\"><a id=\"section56\"><\/a>Replace, Cleanup\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/clear-everything-hyphen-excels-replace-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Clear Everything Before the Hyphen with Excel\u2019s REPLACE Formula<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Right\"><\/span><span style=\"color: #ff0000\"><a id=\"section57\"><\/a>Right\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/extracting-data-with-excels-right-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Extracting Data with Excel\u2019s RIGHT Formula<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Round\"><\/span><span style=\"color: #ff0000\"><a id=\"section32\"><\/a>Round\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/round-off-numbers-with-excels-round-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Round Off Numbers with Excel\u2019s ROUND Formula<\/a><\/div>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/10-1-ways-to-round-numbers-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">10 + 1 Ways to Round Numbers in Excel<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Show_Hide\"><\/span><span style=\"color: #ff0000\"><a id=\"section44\"><\/a>Show, Hide\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-show-hide-formulas-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Show &amp; Hide Formulas in Excel<\/a><\/div>\n<\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Sort\"><\/span><span style=\"color: #ff0000\"><a id=\"section62\"><\/a>Sort\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sort-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">SORT Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Sortby\"><\/span><span style=\"color: #ff0000\"><a id=\"section63\"><\/a>Sortby\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sortby-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">SORTBY Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Substitute\"><\/span><span style=\"color: #ff0000\"><a id=\"section58\"><\/a>Substitute\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-comma-after-the-surname-with-excels-substitute-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Add Comma After the Surname with Excel\u2019s SUBSTITUTE Formula<\/a><\/div>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/cleaning-data-excels-substitute-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cleaning Data with Excel\u2019s SUBSTITUTE Formula<\/a><\/div>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/count-text-occurrences-excels-substitute-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Count Text Occurrences with Excel\u2019s SUBSTITUTE Formula<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Substitute_Trim\"><\/span><span style=\"color: #ff0000\"><a id=\"section59\"><\/a>Substitute, Trim\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-remove-leading-and-trailing-spaces-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Remove Leading and Trailing Spaces in Excel<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Subtotal\"><\/span><span style=\"color: #ff0000\"><a id=\"section33\"><\/a>Subtotal\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/autosum-an-array-of-data-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Autosum an Array of Data in Excel<\/a><\/div>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-subtotal-function-avoid-double-counting\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel Subtotal Function \u2013 Avoid Double Counting<\/a><\/div>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-subtotal-function-filtered-or-visible-values\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel Subtotal Function \u2013 Filtered or Visible Values<\/a><\/div>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-subtotal-function-include-hidden-values\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel Subtotal Function \u2013 Include Hidden Values<\/a><\/div>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/summarize-data-with-dynamic-subtotals-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Summarize Data With Dynamic Subtotals<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Sum_Lookup\"><\/span><span style=\"color: #ff0000\"><a id=\"section19\"><\/a>Sum, Lookup\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/two-way-lookup-using-intersect-function-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Two Way Lookup Using The SUM Intersect Function<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Sumifs\"><\/span><span style=\"color: #ff0000\"><a id=\"section34\"><\/a>Sumifs\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sumif-function-introduction\/\" target=\"_blank\" rel=\"noopener noreferrer\">SUMIF Function: Introduction<\/a><\/div>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sumif-function-one-criteria-sum-range\/\" target=\"_blank\" rel=\"noopener noreferrer\">SUMIF Function: One Criteria &amp; Sum Range<\/a><\/div>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sumifs-function-introduction\/\" target=\"_blank\" rel=\"noopener noreferrer\">SUMIFS Function: Introduction<\/a><\/div>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sumifs-function-wildcards\/\" target=\"_blank\" rel=\"noopener noreferrer\">SUMIFS function: Wildcards *<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Sumproduct\"><\/span><span style=\"color: #ff0000\"><a id=\"section35\"><\/a>Sumproduct\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/advanced-sumproduct-function-conditional-date\/\" target=\"_blank\" rel=\"noopener noreferrer\">Advanced SUMPRODUCT Function: Conditional Date<\/a><\/div>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/advanced-sumproduct-function-conditional-sum\/\" target=\"_blank\" rel=\"noopener noreferrer\">Advanced SUMPRODUCT Function: Conditional Sum<\/a><\/div>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/advanced-sumproduct-function-count\/\" target=\"_blank\" rel=\"noopener noreferrer\">Advanced SUMPRODUCT Function: Count<\/a><\/div>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/advanced-sumproduct-function-maximum-sales\/\" target=\"_blank\" rel=\"noopener noreferrer\">Advanced SUMPRODUCT Function: Maximum Sales<\/a><\/div>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/advanced-sumproduct-function-sum-multiple-criteria\/\" target=\"_blank\" rel=\"noopener noreferrer\">Advanced SUMPRODUCT Function: Sum Multiple Criteria<\/a><\/div>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/advanced-sumproduct-function-sum-of-the-top-3-sales-with-an-array-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Advanced Sumproduct Function: Sum the Top 3 Sales with an Array Formula<\/a><\/div>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sumproduct-weighted-averages\/\" target=\"_blank\" rel=\"noopener noreferrer\">Sumproduct &amp; Weighted Averages<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Text\"><\/span><span style=\"color: #ff0000\"><a id=\"section60\"><\/a>Text\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excels-text-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel\u00b4s TEXT Function<\/a><\/div>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-leading-zeros-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Add Leading Zeros in Excel<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Time\"><\/span><span style=\"color: #ff0000\"><a id=\"section3\"><\/a>Time\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/calculate-elapsed-time-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Calculate Elapsed Time in Excel<\/a><\/div>\n<div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Transpose\"><\/span><span style=\"color: #ff0000\"><a id=\"section71\"><\/a>Transpose <\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/transpose-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">TRANSPOSE Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Type\"><\/span><span style=\"color: #ff0000\"><a id=\"section70\"><\/a>Type <\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/type-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">TYPE Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Upper\"><\/span><span style=\"color: #ff0000\"><a id=\"section69\"><\/a>Upper <\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/upper-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">UPPER Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Unique\"><\/span><span style=\"color: #ff0000\"><a id=\"section64\"><\/a>Unique <\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/unique-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">UNIQUE Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Value\"><\/span><span style=\"color: #ff0000\"><a id=\"section68\"><\/a>Value <\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/value-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">VALUE Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Vlookup\"><\/span><span style=\"color: #ff0000\"><a id=\"section20\"><\/a>Vlookup\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-named-ranges-with-vlookup-formula-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Named Ranges with Vlookup Formula<\/a><\/div>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-approximate-match-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Vlookup Approximate Match in Excel<\/a><\/div>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-example-with-drop-down-list\/\" target=\"_blank\" rel=\"noopener noreferrer\">VLOOKUP Example: Vlookup with a Drop Down List<\/a><\/div>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-function-introduction-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">VLOOKUP Function: Introduction<\/a><\/div>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-in-an-excel-table\/\" target=\"_blank\" rel=\"noopener noreferrer\">Vlookup in an Excel Table<\/a><\/div>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-in-multiple-excel-sheets\/\" target=\"_blank\" rel=\"noopener noreferrer\">Vlookup in Multiple Excel Sheets<\/a><\/div>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-multiple-columns\/\" target=\"_blank\" rel=\"noopener noreferrer\">VLOOKUP Multiple Columns<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Xlookup\"><\/span><span style=\"color: #ff0000\"><a id=\"section72\"><\/a>Xlookup <\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/xlookup-function-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to use the XLOOKUP function in Excel with 7 Examples!<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Weekday\"><\/span><span style=\"color: #ff0000\"><a id=\"section4\"><\/a>Weekday\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/weekday-function-introduction\/\" target=\"_blank\" rel=\"noopener noreferrer\">WEEKDAY function: Introduction<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Weeknum\"><\/span><span style=\"color: #ff0000\"><a id=\"section67\"><\/a>Weeknum <\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/weeknum-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">WEEKNUM Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Workday\"><\/span><span style=\"color: #ff0000\"><a id=\"section5\"><\/a>Workday\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/workday-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Workday Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Year\"><\/span><span style=\"color: #ff0000\"><a id=\"section66\"><\/a>Year <\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/year-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">YEAR Formula in Excel<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>120+ Lessons of Free Microsoft Excel Formula Training Videos &amp; Articles Absolutely FREE! | No Sign-up Needed | Scroll Down &amp; Start Learning! Excel Formulas &amp; Functions are a must know feature in Microsoft Excel that allows you to quickly analyze your data in many forms.\u00a0 It is an indispensable skill that will make you [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":28164,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"How to Master Excel Formulas - The Ultimate Guide","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[13,3,15,12,11,14],"tags":[43,257],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/28162"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=28162"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/28162\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/28164"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=28162"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=28162"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=28162"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}