{"id":11980,"date":"2019-05-17T00:09:46","date_gmt":"2019-05-16T22:09:46","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=11980"},"modified":"2024-02-06T16:15:03","modified_gmt":"2024-02-06T15:15:03","slug":"025-free-excel-formulas-webinar-training-vlookup-index-match-if-sumif","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/025-free-excel-formulas-webinar-training-vlookup-index-match-if-sumif\/","title":{"rendered":"025: Free Excel Formulas Webinar Training &#8211; VLOOKUP, INDEX, MATCH, IF, SUMIF"},"content":{"rendered":"<p><span style=\"color: #000000;\"><div class=\"smart-track-player-container stp-color-f77223-EEEEEE spp-stp-desktop\" data-uid=\"7c259628\"><\/div><div class=\"spp-shsp-form spp-shsp-form-7c259628\"><\/div><\/span><\/p>\n<p><strong><span style=\"color: #000000;\"><a style=\"color: #000000;\" href=\"http:\/\/traffic.libsyn.com\/myexcelonline\/025_Free_Excel_Formulas_Webinar_Training.mp3\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Listen on Web Browser &gt;&gt;<\/a><\/span><\/strong><\/p>\n<p>I am excited to announce that our in house MyExcelOnline and\u00a0<em>Microsoft Certified Trainer,<\/em>\u00a0<strong>Kyle Pew<\/strong>\u00a0and myself will be holding a free 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> webinar training over the coming few days on:<\/p>\n<h4 style=\"text-align: center;\"><span style=\"color: #000000;\"><span class=\"\"><br \/>\n<\/span><span class=\"\"><span style=\"text-decoration: underline; color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/115-43.html\" target=\"_blank\" rel=\"noopener noreferrer\"><strong class=\"\">The MUST KNOW Excel Formulas to ADVANCE your Excel skills!<\/strong><\/a><\/span><br \/>\n<br class=\"\" \/><\/span><\/span><\/h4>\n<p>Whether you are just getting started with Formulas, or have been using Formulas for a while, this webinar will cover everything you need to know to get going.<\/p>\n<p>During <strong><a style=\"color: #000000;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/115-43.html\" target=\"_blank\" rel=\"noopener noreferrer\">this free training<\/a><\/strong> you will learn:<\/p>\n<p>&#x1f449; The MUST KNOW <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/formulas\/lookup\/match\/\" target=\"_blank\" rel=\"noopener\">Excel Formulas<\/a> that your boss EXPECTS you to know!<br \/>\n&#x1f449; A proven step by step guide to creating <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/formulas\/lookup\/index\/\" target=\"_blank\" rel=\"noopener\">Excel Formulas<\/a> in SECONDS!<br \/>\n&#x1f449; The limitations of using a VLOOKUP and why INDEX &amp; MATCH is better!<br \/>\n&#x1f449; 3 TIPS that the Excel experts &amp; MVPS use that will enhance your <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> knowledge forever!<br \/>\n&#x1f449; You will also be able to download the Excel workbook used in the training so you can follow along &amp; practice!<\/p>\n<p>If you want to learn Excel Formulas to gain an advantage over your colleagues and become more productive, get a better job or promotion, then <strong><a style=\"color: #000000;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/115-43.html\" target=\"_blank\" rel=\"noopener noreferrer\">this training<\/a><\/strong> will significantly help to achieve your goals!<\/p>\n<p>Here\u2019s what a few people have said after they attended this Excel formulas webinar:<\/p>\n<blockquote>\n<div><span class=\"\" style=\"color: #000000;\"><em>&#8220;The best 1 hour training I have ever had&#8221;\u00a0 &#8211;<strong>\u00a0Michael<\/strong><\/em><\/span><\/div>\n<div><\/div>\n<div><span style=\"color: #000000;\"><em>&#8220;Easy to follow along and apply the formulas in the workbook supplied&#8221; &#8211;\u00a0<\/em><em><b>Dawn<\/b><\/em><\/span><\/div>\n<div><\/div>\n<div><span style=\"color: #000000;\"><em>&#8220;I can now say with confidence that I KNOW how to use formulas in Excel!&#8221; &#8211; <strong>Harry<\/strong><\/em><\/span><\/div>\n<\/blockquote>\n<div><\/div>\n<p>The webinar will be held over the next few days only and you can select a few times per day.\u00a0\u00a0The webinar start times\u00a0are shown on your local timezone.\u00a0\u00a0<strong class=\"\">A Free BONUS Formulas Cheat Sheet<\/strong>\u00a0will also be sent out to anyone who registers!<\/p>\n<p>Please click the link below to register for a day and time that works for you:<\/p>\n<h4><span style=\"color: #000000;\">&#x1f449; <span style=\"text-decoration: underline; color: #0000ff;\"><strong><a style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/115-43.html\" target=\"_blank\" rel=\"noopener noreferrer\">Free Excel Formulas Webinar Training on VLOOKUP, INDEX, MATCH, SUMIF, IF<\/a><\/strong><\/span><\/span><\/h4>\n<p>&nbsp;<\/p>\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\/podcast\/025-free-excel-formulas-webinar-training-vlookup-index-match-if-sumif\/#Listen_to_the_MyExcelOnline_Podcast_on_your_favorite_platform\" title=\"Listen to the MyExcelOnline Podcast on your favorite platform!\">Listen to the MyExcelOnline Podcast on your favorite platform!<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/025-free-excel-formulas-webinar-training-vlookup-index-match-if-sumif\/#Free_Resources\" title=\"Free Resources!\">Free Resources!<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/025-free-excel-formulas-webinar-training-vlookup-index-match-if-sumif\/#Excel_Tutorial_Blog\" title=\"Excel Tutorial\u00a0Blog:\">Excel Tutorial\u00a0Blog:<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/025-free-excel-formulas-webinar-training-vlookup-index-match-if-sumif\/#Free_Excel_Webinars\" title=\"Free Excel Webinars:\">Free Excel Webinars:<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/025-free-excel-formulas-webinar-training-vlookup-index-match-if-sumif\/#Thanks_for_Listening\" title=\"Thanks for Listening!\">Thanks for Listening!<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"text-center\"><span class=\"ez-toc-section\" id=\"Listen_to_the_MyExcelOnline_Podcast_on_your_favorite_platform\"><\/span><span style=\"color: #000000;\"><strong>Listen to the MyExcelOnline Podcast on your favorite platform!<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"color: #000000;\"><a style=\"color: #000000;\" href=\"https:\/\/itunes.apple.com\/us\/podcast\/my-excel-online-podcast\/id1019164720?l=en\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1057 size-medium aligncenter\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/available-on-itunes-logo-300x112.jpg\" alt=\"Free Excel Formulas Webinar Training - VLOOKUP, INDEX, MATCH, IF, SUMIF\" width=\"300\" height=\"112\" title=\"\"><\/a><\/span><\/p>\n<p><span style=\"color: #000000;\"><a style=\"color: #000000;\" href=\"http:\/\/www.stitcher.com\/s?fid=69832&amp;refid=stpr\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1051 size-full aligncenter\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Stitcher-button.png\" alt=\"Free Excel Formulas Webinar Training - VLOOKUP, INDEX, MATCH, IF, SUMIF\" width=\"300\" height=\"150\" title=\"\"><\/a><\/span><\/p>\n<p><span style=\"color: #000000;\"><a style=\"color: #000000;\" href=\"https:\/\/play.google.com\/music\/m\/I5hjkav2s3dgtv72ovqol3qbgre?t=My_Excel_Online_Podcast&amp;pcampaignid=MKT-na-all-co-pr-mu-pod-16\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1052 size-medium aligncenter\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/google-300x116.png\" alt=\"Free Excel Formulas Webinar Training - VLOOKUP, INDEX, MATCH, IF, SUMIF\" width=\"300\" height=\"116\" title=\"\"><\/a><\/span><\/p>\n<p><span style=\"color: #000000;\"><a style=\"color: #000000;\" href=\"https:\/\/www.iheart.com\/show\/263-my-excel-online-podc\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1064 size-medium aligncenter\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/iheart-300x80.png\" alt=\"Free Excel Formulas Webinar Training - VLOOKUP, INDEX, MATCH, IF, SUMIF\" width=\"300\" height=\"80\" title=\"\"><\/a><\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Free_Resources\"><\/span><span style=\"color: #000000;\"><strong>Free Resources!<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"Excel_Tutorial_Blog\"><\/span><strong>Excel Tutorial\u00a0<\/strong><strong>Blog<\/strong><strong>:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Learn all the essential tips to get you up and running and using Excel to its full potential.\u00a0 Choose from Formulas, <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Tables\" data-wpil-keyword-link=\"linked\">Pivot Tables<\/a>, Charts, Analysis, Shortcuts, Macros plus more<\/p>\n<p><strong>&gt;&gt;<\/strong>\u00a0<a style=\"color: #000000;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>CLICK HERE TO VIEW<\/strong><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Free_Excel_Webinars\"><\/span><span style=\"color: #000000;\"><strong>Free Excel Webinars:<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Learn the power of Formulas, <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-macros-examples\/\" target=\"_blank\" rel=\"noopener\" title=\"Macros\" data-wpil-keyword-link=\"linked\">Macros<\/a> &amp; VBA and Pivot Tables with our free webinars!<\/p>\n<p><strong>&gt;&gt;<\/strong>\u00a0<strong><a style=\"color: #000000;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/115-57.html\" target=\"_blank\" rel=\"noopener noreferrer\">CLICK HERE TO VIEW NOW<\/a><\/strong><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Thanks_for_Listening\"><\/span><strong>Thanks for Listening!<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Thank you for joining me this week. If you have some feedback that you\u2019d like to share, then please leave a note in the comment section below!<\/p>\n<p>If you enjoyed this episode, please\u00a0<strong>share<\/strong>\u00a0it using the social media buttons you see at the bottom of the post.<\/p>\n<p>Also,\u00a0<strong><a style=\"color: #000000;\" href=\"\/\/www.myexcelonline.com\/meo-staging\/podcast\/itune\" target=\"_blank\" rel=\"noopener noreferrer\">please leave an honest review for The MyExcelOnline Podcast on iTunes<\/a>!<\/strong>\u00a0Ratings and reviews\u00a0are\u00a0<strong>extremely<\/strong>\u00a0<strong>helpful<\/strong>\u00a0and greatly appreciated! They do matter in the rankings of the show, and I read each and every one of them.<\/p>\n<p>If you have any questions you can send me an email to <strong><a style=\"color: #000000;\" href=\"mailto:podcast@myexcelonline.com\" target=\"_blank\" rel=\"noopener noreferrer\">podcast@myexcelonline.com<\/a><\/strong><\/p>\n<p>Don\u2019t forget to subscribe to the show on\u00a0<strong><a style=\"color: #000000;\" href=\"\/\/www.myexcelonline.com\/meo-staging\/podcast\/itune\" target=\"_blank\" rel=\"noopener noreferrer\">iTunes<\/a><\/strong>\u00a0to get automatic\u00a0updates so you don&#8217;t miss out on these awesome interviews and Excel insights!<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Listen on Web Browser &gt;&gt; I am excited to announce that our in house MyExcelOnline and\u00a0Microsoft Certified Trainer,\u00a0Kyle Pew\u00a0and myself will be holding a free Excel formulas webinar training over the coming few days on: The MUST KNOW Excel Formulas to ADVANCE your Excel skills! Whether you are just getting started with Formulas, or have [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":20440,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"025: Free Excel Formulas Webinar Training - VLOOKUP, INDEX, MATCH, IF, SUMIF","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[334],"tags":[],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/11980"}],"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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=11980"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/11980\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/20440"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=11980"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=11980"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=11980"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}