{"id":7942,"date":"2026-08-10T09:50:03","date_gmt":"2026-08-10T09:50:03","guid":{"rendered":"https:\/\/nokobox.com\/index.php\/item\/udemy-microsoft-excel-advanced-functions-with-index-and-match-2018-6\/"},"modified":"2026-08-10T09:50:03","modified_gmt":"2026-08-10T09:50:03","slug":"udemy-microsoft-excel-advanced-functions-with-index-and-match-2018-6","status":"publish","type":"digital_item","link":"https:\/\/nokobox.com\/index.php\/item\/udemy-microsoft-excel-advanced-functions-with-index-and-match-2018-6\/","title":{"rendered":"Udemy \u2013 Microsoft Excel Advanced Functions with INDEX and MATCH 2018-6"},"content":{"rendered":"<div class=\"w-post-elm post_content\">\n<h2><span style=\"vertical-align: inherit\">Description<\/span><\/h2>\n<p><span style=\"vertical-align: inherit\">Microsoft Excel Advanced Functions with INDEX and MATCH Course. This course will help you take your skills in using Excel software to the next level. By learning two powerful functions INDEX and MATCH, you will be able to perform complex and long calculations easily. This course will be very useful for people who want to use Excel to analyze data and perform advanced calculations. In this course, you will be introduced to the basic and advanced concepts of the INDEX and MATCH functions. Also, using practical examples, you will learn how to combine these functions in different scenarios to achieve the desired results.<\/span><\/p>\n<div data-purpose=\"safely-set-inner-html:description:description\">\n<h3 data-sourcepos=\"7:1-7:91\"><span style=\"vertical-align: inherit\">What you will learn in the Microsoft Excel Advanced Functions with INDEX and MATCH course<\/span><\/h3>\n<ul data-sourcepos=\"9:1-14:0\">\n<li data-sourcepos=\"9:1-9:101\"><span style=\"vertical-align: inherit\">Building and Understanding Complex Excel Functions: You will learn how to build and understand complex Excel functions.<\/span><\/li>\n<li data-sourcepos=\"10:1-10:169\"><span style=\"vertical-align: inherit\">Automate Complex Excel Functions with Nested Functions: By using nesting function techniques, you can automate many repetitive tasks in Excel.<\/span><\/li>\n<li data-sourcepos=\"11:1-11:157\"><span style=\"vertical-align: inherit\">Create dynamic calculations in Excel using advanced techniques: You will learn how to create calculations that automatically change as data changes.<\/span><\/li>\n<li data-sourcepos=\"27:1-27:33\"><span style=\"vertical-align: inherit\">Difference between relative and absolute references<\/span><\/li>\n<li data-sourcepos=\"28:1-28:64\"><span style=\"vertical-align: inherit\">Using range names to create dynamic references to data<\/span><\/li>\n<li data-sourcepos=\"29:1-29:17\"><span style=\"vertical-align: inherit\">Function shortcuts<\/span><\/li>\n<li data-sourcepos=\"30:1-30:55\"><span style=\"vertical-align: inherit\">Analyze calculations using Excel formula inspection tools<\/span><\/li>\n<li data-sourcepos=\"31:1-31:36\"><span style=\"vertical-align: inherit\">Create dynamic searches by combining functions<\/span><\/li>\n<li data-sourcepos=\"32:1-32:42\"><span style=\"vertical-align: inherit\">Creating Array Functions with INDEX and IF Functions<\/span><\/li>\n<li data-sourcepos=\"33:1-33:52\"><span style=\"vertical-align: inherit\">Adding multiple criteria to the INDEX and MATCH functions<\/span><\/li>\n<li data-sourcepos=\"34:1-34:61\"><span style=\"vertical-align: inherit\">Combining INDEX\/MATCH and MIN functions to return related data<\/span><\/li>\n<li data-sourcepos=\"35:1-36:0\"><span style=\"vertical-align: inherit\">Build complex conditional formatting using calculations<\/span><\/li>\n<li data-sourcepos=\"12:1-12:183\"><span style=\"vertical-align: inherit\">Evaluate formulas to increase efficiency and find errors: By learning how to evaluate formulas, you can improve the performance of your worksheets and quickly find potential errors.<\/span><\/li>\n<li data-sourcepos=\"13:1-14:0\"><span style=\"vertical-align: inherit\">Simplify Excel formulas using arrays: Using arrays helps you make complex formulas simpler and more readable.<\/span><\/li>\n<\/ul>\n<h3 data-sourcepos=\"15:1-15:30\"><span style=\"vertical-align: inherit\">This course is suitable for people who:<\/span><\/h3>\n<ul data-sourcepos=\"17:1-20:0\">\n<li data-sourcepos=\"17:1-17:52\"><span style=\"vertical-align: inherit\">Seek to understand and create complex calculations in Excel.<\/span><\/li>\n<li data-sourcepos=\"18:1-18:77\"><span style=\"vertical-align: inherit\">Looking to automate repetitive tasks in Excel using advanced functions.<\/span><\/li>\n<li data-sourcepos=\"19:1-20:0\"><span style=\"vertical-align: inherit\">They want to become a master of Excel formulas.<\/span><\/li>\n<\/ul>\n<\/div>\n<h3><span style=\"vertical-align: inherit\">Microsoft Excel Advanced Functions with INDEX and MATCH Course Details<\/span><\/h3>\n<ul>\n<li><span style=\"vertical-align: inherit\">Publisher:&nbsp; <\/span><a href=\"https:\/\/href.li\/?https:\/\/www.udemy.com\/course\/microsoft-excel-advanced-functions-with-index-and-match\/?couponCode=NEWYEARCAREER\" target=\"_blank\" rel=\"noopener\"><span style=\"vertical-align: inherit\">Udemy<\/span><\/a><\/li>\n<li><span style=\"vertical-align: inherit\">Instructor:&nbsp; <\/span><a class=\"ud-btn ud-btn-large ud-btn-link ud-heading-md ud-text-sm ud-instructor-links\" href=\"https:\/\/downloadlynet.ir\/tag\/kyle-pew\/\" data-position=\"1\"><span class=\"ud-btn-label\"><span style=\"vertical-align: inherit\">Kyle Pew<\/span><\/span><\/a><\/li>\n<li><span style=\"vertical-align: inherit\">Training level: Beginner to advanced<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Training duration: 3 hours and 39 minutes<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Number of lessons: 42<\/span><\/li>\n<\/ul>\n<h3><span style=\"vertical-align: inherit\">Course headings<\/span><\/h3>\n<h2>&nbsp;<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-955097 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2025\/01\/Microsoft-Excel-Advanced-Functions-with-INDEX-and-MATCH3.png\" alt=\"Microsoft Excel Advanced Functions with INDEX and MATCH\" width=\"817\" height=\"466\"><\/h2>\n<h3><span style=\"vertical-align: inherit\">Prerequisites for the Microsoft Excel Advanced Functions with INDEX and MATCH course<\/span><\/h3>\n<div class=\"ud-block-list-item ud-block-list-item-small ud-block-list-item-tight ud-block-list-item-neutral ud-text-sm\">\n<ul>\n<li class=\"ud-block-list-item-content\" dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Microsoft Excel 2007, 2010, 2013, 2016<\/span><\/li>\n<li class=\"ud-block-list-item-content\" dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Experience working with Excel Functions ie. SUM, AVERAGE, MIN, MAX<\/span><\/li>\n<\/ul>\n<\/div>\n<h3><span style=\"vertical-align: inherit\">Course images<\/span><\/h3>\n<h2><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-955096 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2025\/01\/Microsoft-Excel-Advanced-Functions-with-INDEX-and-MATCH2.png\" alt=\"Microsoft Excel Advanced Functions with INDEX and MATCH\" width=\"804\" height=\"389\"><\/h2>\n<h3><span style=\"vertical-align: inherit\">Sample course video<\/span><\/h3>\n<div style=\"width: 640px;\" class=\"wp-video\"><span class=\"mejs-offscreen\">Video Player<\/span><\/p>\n<div id=\"mep_0\" class=\"mejs-container mejs-container-keyboard-inactive wp-video-shortcode mejs-video\" tabindex=\"0\" role=\"application\" aria-label=\"Video Player\" style=\"width: 640px; height: 360px; min-width: 217px;\">\n<div class=\"mejs-inner\">\n<div class=\"mejs-mediaelement\"><mediaelementwrapper id=\"video-150903-1\"><video class=\"wp-video-shortcode\" id=\"video-150903-1_html5\" width=\"640\" height=\"360\" preload=\"metadata\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Microsoft_Excel_Advanced_Functions_with_INDEX_and_MATCH_Downloadly.ir.mp4?_=1\" style=\"width: 640px; height: 360px;\"><source type=\"video\/mp4\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Microsoft_Excel_Advanced_Functions_with_INDEX_and_MATCH_Downloadly.ir.mp4?_=1\"><a href=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Microsoft_Excel_Advanced_Functions_with_INDEX_and_MATCH_Downloadly.ir.mp4?nocache=1786110973788\">https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Microsoft_Excel_Advanced_Functions_with_INDEX_and_MATCH_Downloadly.ir.mp4<\/a><\/video><\/mediaelementwrapper><\/div>\n<div class=\"mejs-layers\">\n<div class=\"mejs-poster mejs-layer\" style=\"display: none; width: 100%; height: 100%;\"><\/div>\n<div class=\"mejs-overlay mejs-layer\" style=\"display: none; width: 100%; height: 100%;\">\n<div class=\"mejs-overlay-loading\"><span class=\"mejs-overlay-loading-bg-img\"><\/span><\/div>\n<\/div>\n<div class=\"mejs-overlay mejs-layer\" style=\"display: none; width: 100%; height: 100%;\">\n<div class=\"mejs-overlay-error\"><\/div>\n<\/div>\n<div class=\"mejs-overlay mejs-layer mejs-overlay-play\" style=\"width: 100%; height: 100%;\">\n<div class=\"mejs-overlay-button\" role=\"button\" tabindex=\"0\" aria-label=\"Play\" aria-pressed=\"false\"><\/div>\n<\/div>\n<\/div>\n<div class=\"mejs-controls\">\n<div class=\"mejs-button mejs-playpause-button mejs-play\"><button type=\"button\" aria-controls=\"mep_0\" title=\"Play\" aria-label=\"Play\" tabindex=\"0\"><\/button><\/div>\n<div class=\"mejs-time mejs-currenttime-container\" role=\"timer\" aria-live=\"off\"><span class=\"mejs-currenttime\">00:00<\/span><\/div>\n<div class=\"mejs-time-rail\"><span class=\"mejs-time-total mejs-time-slider\" role=\"slider\" tabindex=\"0\" aria-label=\"Time Slider\" aria-valuemin=\"0\" aria-valuemax=\"0\" aria-valuenow=\"0\" aria-valuetext=\"00:00\"><span class=\"mejs-time-buffering\" style=\"display: none;\"><\/span><span class=\"mejs-time-loaded\"><\/span><span class=\"mejs-time-current\"><\/span><span class=\"mejs-time-hovered no-hover\"><\/span><span class=\"mejs-time-handle\"><span class=\"mejs-time-handle-content\"><\/span><\/span><span class=\"mejs-time-float\"><span class=\"mejs-time-float-current\">00:00<\/span><span class=\"mejs-time-float-corner\"><\/span><\/span><\/span><\/div>\n<div class=\"mejs-time mejs-duration-container\"><span class=\"mejs-duration\">00:00<\/span><\/div>\n<div class=\"mejs-button mejs-volume-button mejs-mute\"><button type=\"button\" aria-controls=\"mep_0\" title=\"Mute\" aria-label=\"Mute\" tabindex=\"0\"><\/button><a href=\"javascript:void(0);\" class=\"mejs-volume-slider\" aria-label=\"Volume Slider\" aria-valuemin=\"0\" aria-valuemax=\"100\" role=\"slider\" aria-orientation=\"vertical\"><span class=\"mejs-offscreen\">Use Up\/Down Arrow keys to increase or decrease volume.<\/span><\/p>\n<div class=\"mejs-volume-total\">\n<div class=\"mejs-volume-current\" style=\"bottom: 0px; height: 100%;\"><\/div>\n<div class=\"mejs-volume-handle\" style=\"bottom: 100%; margin-bottom: -3px;\"><\/div>\n<\/div>\n<p><\/a><\/div>\n<div class=\"mejs-button mejs-fullscreen-button\"><button type=\"button\" aria-controls=\"mep_0\" title=\"Fullscreen\" aria-label=\"Fullscreen\" tabindex=\"0\"><\/button><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div>\n<h3><span style=\"vertical-align: inherit\">Installation Guide<\/span><\/h3>\n<p><span style=\"vertical-align: inherit\">After Extract, view with your favorite player.<\/span><\/p>\n<p><span style=\"vertical-align: inherit\">Subtitles: None<\/span><\/p>\n<p><span style=\"vertical-align: inherit\">Quality: 1080p<\/span><\/p>\n<\/div>\n<h3><span style=\"vertical-align: inherit\">Download link<\/span><\/h3>\n<p><a href=\"https:\/\/dl1.downloadly.ir\/Files\/Elearning\/Udemy_Microsoft_Excel_Advanced_Functions_with_INDEX_and_MATCH_2018-6.part1_Downloadly.ir.rar?nocache=1786110973\"><span style=\"vertical-align: inherit\">Download Part 1 \u2013 1 GB<\/span><\/a><\/p>\n<p><a href=\"https:\/\/dl1.downloadly.ir\/Files\/Elearning\/Udemy_Microsoft_Excel_Advanced_Functions_with_INDEX_and_MATCH_2018-6.part2_Downloadly.ir.rar?nocache=1786110973\"><span style=\"vertical-align: inherit\">Download Part 2 \u2013 720 MB<\/span><\/a><\/p>\n<p><span style=\"vertical-align: inherit\">File(s) password: www.downloadly.ir<\/span><\/p>\n<h3><span style=\"vertical-align: inherit\">File size<\/span><\/h3>\n<p><span style=\"vertical-align: inherit\">1.7 GB<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Description Microsoft Excel Advanced Functions with INDEX and MATCH Course. This course will help you take your skills in using Excel software to the next level<\/p>\n","protected":false},"author":1,"template":"","dgi_category":[10458],"dgi_tag":[71425,71426,71427,71428,71429,71375],"class_list":["post-7942","digital_item","type-digital_item","status-publish","has-post-thumbnail","hentry","dgi_category-video-tutorials","dgi_tag-course-microsoft-excel-advanced-functions-with-index-and-match","dgi_tag-download-course-microsoft-excel-advanced-functions-with-index-and-match","dgi_tag-download-microsoft-excel-advanced-functions-with-index-and-match","dgi_tag-free-download-microsoft-excel-advanced-functions-with-index-and-match","dgi_tag-free-microsoft-excel-advanced-functions-with-index-and-match","dgi_tag-kyle-pew"],"_links":{"self":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item\/7942","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item"}],"about":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/types\/digital_item"}],"author":[{"embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":0,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item\/7942\/revisions"}],"wp:attachment":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/media?parent=7942"}],"wp:term":[{"taxonomy":"dgi_category","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_category?post=7942"},{"taxonomy":"dgi_tag","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_tag?post=7942"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}