{"id":10603,"date":"2026-08-10T10:21:11","date_gmt":"2026-08-10T10:21:11","guid":{"rendered":"https:\/\/nokobox.com\/index.php\/item\/udemy-excel-vba-basic-to-advance-part1-20-hours-2024-8\/"},"modified":"2026-08-10T10:21:11","modified_gmt":"2026-08-10T10:21:11","slug":"udemy-excel-vba-basic-to-advance-part1-20-hours-2024-8","status":"publish","type":"digital_item","link":"https:\/\/nokobox.com\/index.php\/item\/udemy-excel-vba-basic-to-advance-part1-20-hours-2024-8\/","title":{"rendered":"Udemy \u2013 Excel VBA Basic to Advance Part1 (20 hours) 2024-8"},"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\">Excel VBA Basic to Advance Part 1 (20 hours). In this 20-hour course, participants will learn the basics and advanced concepts of VBA programming in Excel. The goal of this course is to empower individuals to automate everyday tasks in Excel and increase productivity. The course consists of different parts, each of which addresses a specific aspect of VBA and teaches the topics step-by-step from basic to advanced. It also teaches how to record, edit, run, and debug macros, run VBA programs and assign shortcut keys, and the concept of finding the last row of data (empty or non-empty). Methods for selecting data from top to bottom or vice versa, with static and dynamic approaches, and the advantages and disadvantages of each are examined. How to convert incorrect steps into correct steps when recording and running a program step by step for debugging is also explained. Moving between sheets and possible errors such as \u201cSubscript out of range\u201d when renaming a sheet will also be covered. Finally, how to collect data from different sheets and put it into one sheet using macro recording and a basic understanding of sheets and ranges will be explored.<\/span><\/p>\n<div data-purpose=\"safely-set-inner-html:description:description\">\n<p data-sourcepos=\"20:1-20:990\"><span style=\"vertical-align: inherit\">All lectures start from the basic level and gradually move to more advanced levels. The use of built-in functions like Left, StrReverse, Mid, Find, Trim, Lcase, Ucase, Date and Time etc. will be discussed. UDFs (User Defined Functions) in VBA will be shared with basic and advanced examples, advantages of UDFs over built-in functions, and amazing projects. How to pass parameters to subroutines and call functions, and how to execute functions from Excel sheets will be taught. The process of testing functions like UDFs and VBA built-in functions, and how to pass parameters from a subroutine to a function and its usage, and common VBA interview questions will also be covered. Finally, how to use VLOOKUP in VBA in an advanced project and how to use the Match function with loops and VLOOKUP to create powerful and amazing practical automations will be discussed. Online support will also be available to the participants at all times.<\/span><\/p>\n<h3 data-sourcepos=\"22:1-22:25\"><strong><span style=\"vertical-align: inherit\">What you will learn:<\/span><\/strong><\/h3>\n<ul data-sourcepos=\"24:1-38:0\">\n<li data-sourcepos=\"24:1-24:70\"><span style=\"vertical-align: inherit\">Complete introduction to automating Excel tasks using VBA from zero to one hundred.<\/span><\/li>\n<li data-sourcepos=\"25:1-25:83\"><span style=\"vertical-align: inherit\">Understand the basics of VBA and how to customize syntax without relying on the internet to solve problems.<\/span><\/li>\n<li data-sourcepos=\"26:1-26:81\"><span style=\"vertical-align: inherit\">Learn how to record, edit, run, and save macros and understand their benefits and limitations.<\/span><\/li>\n<li data-sourcepos=\"27:1-27:120\"><span style=\"vertical-align: inherit\">Familiarity with the types of loops in VBA, including For Next, Do While, and Do Until, and understanding the necessity of learning them, along with practical examples.<\/span><\/li>\n<li data-sourcepos=\"28:1-28:111\"><span style=\"vertical-align: inherit\">Understanding variables and data types and why they are needed, along with preparing for interview questions related to variables.<\/span><\/li>\n<li data-sourcepos=\"29:1-29:111\"><span style=\"vertical-align: inherit\">Learn conditional IF statements such as Single IF, IFAND, IFOR, IF with Else If, \u200b\u200band IF without Else If, \u200b\u200band the differences between types of IFs.<\/span><\/li>\n<li data-sourcepos=\"30:1-30:56\"><span style=\"vertical-align: inherit\">Combining IF with loops through a case study of a live example.<\/span><\/li>\n<li data-sourcepos=\"31:1-31:133\"><span style=\"vertical-align: inherit\">Identify and resolve errors such as OverFlow, Data Type Mismatch, Argument Not Optional, Property Method Not Defined, and Subscript Out Of Range.<\/span><\/li>\n<li data-sourcepos=\"32:1-32:123\"><span style=\"vertical-align: inherit\">Learn about set loops and improve your data management skills; learn how to work with multiple workbooks and easily copy and paste data.<\/span><\/li>\n<li data-sourcepos=\"33:1-33:96\"><span style=\"vertical-align: inherit\">Familiarity with the Set keyword and how to define objects using VBA classes, their methods, and properties.<\/span><\/li>\n<li data-sourcepos=\"34:1-34:128\"><span style=\"vertical-align: inherit\">Working with classes such as Worksheet, Workbook, Range, Worksheet Function, Strings, and Info, and how to use the Object Browser in VBA.<\/span><\/li>\n<li data-sourcepos=\"35:1-35:84\"><span style=\"vertical-align: inherit\">Learn how to use VBA built-in functions and create user-defined functions (UDFs).<\/span><\/li>\n<li data-sourcepos=\"36:1-36:79\"><span style=\"vertical-align: inherit\">Familiarity with the use of arrays in VBA, which is one of the most important and practical concepts.<\/span><\/li>\n<li data-sourcepos=\"37:1-38:0\"><span style=\"vertical-align: inherit\">Each topic will be discussed with practical examples and full details.<\/span><\/li>\n<\/ul>\n<h3 data-sourcepos=\"39:1-39:31\"><strong><span style=\"vertical-align: inherit\">This course is suitable for people who:<\/span><\/strong><\/h3>\n<ul data-sourcepos=\"41:1-43:120\">\n<li data-sourcepos=\"41:1-41:105\"><span style=\"vertical-align: inherit\">Students who want to become business analysts, data analysts, VBA developers, or market research analysts.<\/span><\/li>\n<li data-sourcepos=\"42:1-42:262\"><span style=\"vertical-align: inherit\">Any accountant, business salesperson, or marketing executive interested in automating Excel tasks like copying and pasting data from different workbooks into one file, creating custom functions if they don\u2019t exist in Excel, and automatically creating Excel templates.<\/span><\/li>\n<li data-sourcepos=\"43:1-43:120\"><span style=\"vertical-align: inherit\">Any data enthusiast who wants to save time and avoid manual tasks by automating tasks in Excel.<\/span><\/li>\n<\/ul>\n<\/div>\n<h3><span style=\"vertical-align: inherit\">Excel VBA Basic to Advance Part1 Course Details (20 hours)<\/span><\/h3>\n<ul>\n<li><span style=\"vertical-align: inherit\">Publisher:&nbsp; <\/span><a href=\"https:\/\/href.li\/?https:\/\/www.udemy.com\/course\/excel-vba-basic-to-super-advance-level-20-plus-hrs-course\/?couponCode=ST19MT280525G1\" 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-medium ud-btn-link ud-heading-sm ud-text-sm ud-instructor-links\" href=\"https:\/\/downloadlynet.ir\/tag\/ajay-parmar\/\" data-position=\"1\"><span class=\"ud-btn-label\"><span style=\"vertical-align: inherit\">ajay parmar<\/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: 21 hours and 45 minutes<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Number of lessons: 51<\/span><\/li>\n<\/ul>\n<h3><span style=\"vertical-align: inherit\">Course headings<\/span><\/h3>\n<h2><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-987195 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2025\/05\/Excel-VBA-Basic-to-Advance-Part1-20-hours13.png\" alt=\"Excel VBA Basic to Advance Part 1 (20 hours)\" width=\"795\" height=\"452\"><\/h2>\n<h3><span style=\"vertical-align: inherit\">Prerequisites for the Excel VBA Basic to Advance Part 1 course (20 hours)<\/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\">You should know basic formulas like Text functions, Lookup functions of excel and basic knowledge of excel is required.<\/span><\/li>\n<li class=\"ud-block-list-item-content\" dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">No prior programming knowledge is required. This course is for beginners and gradually turning into advanced<\/span><\/li>\n<li class=\"ud-block-list-item-content\" dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Excel shortcut keys is an additional advantage like Copy, Cut &amp; Paste and How to move from first cell to another and how to select the data using shortcut keys like ctrl+shift+down arrow keys etc<\/span><\/li>\n<li class=\"ud-block-list-item-content\" dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Excel 2007 or any higher version should be fine. VBA is compatible with all versions.<\/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-987196 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2025\/05\/Excel-VBA-Basic-to-Advance-Part1-20-hours131.png\" alt=\"Excel VBA Basic to Advance Part 1 (20 hours)\" width=\"824\" height=\"349\"><\/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-166251-1\"><video class=\"wp-video-shortcode\" id=\"video-166251-1_html5\" width=\"640\" height=\"360\" preload=\"metadata\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Excel_VBA_Basic_to_Advance_Part1_20_hours_Downloadly.ir.mp4?_=1\" style=\"width: 640px; height: 360px;\"><source type=\"video\/mp4\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Excel_VBA_Basic_to_Advance_Part1_20_hours_Downloadly.ir.mp4?_=1\"><a href=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Excel_VBA_Basic_to_Advance_Part1_20_hours_Downloadly.ir.mp4?nocache=1786138501183\">https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Excel_VBA_Basic_to_Advance_Part1_20_hours_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: English<\/span><\/p>\n<p><span style=\"vertical-align: inherit\">Quality: 720p<\/span><\/p>\n<\/div>\n<h3><span style=\"vertical-align: inherit\">Download link<\/span><\/h3>\n<p><a href=\"https:\/\/dl2.downloadly.ir\/Files\/Elearning\/Udemy_Excel_VBA_Basic_to_Advance_Part1_20_hours_2024-8.part1_Downloadly.ir.rar?nocache=1786138498\"><span style=\"vertical-align: inherit\">Download Part 1 \u2013 2 GB<\/span><\/a><\/p>\n<p><a href=\"https:\/\/dl2.downloadly.ir\/Files\/Elearning\/Udemy_Excel_VBA_Basic_to_Advance_Part1_20_hours_2024-8.part2_Downloadly.ir.rar?nocache=1786138498\"><span style=\"vertical-align: inherit\">Download Part 2 \u2013 2 GB<\/span><\/a><\/p>\n<p><a href=\"https:\/\/dl2.downloadly.ir\/Files\/Elearning\/Udemy_Excel_VBA_Basic_to_Advance_Part1_20_hours_2024-8.part3_Downloadly.ir.rar?nocache=1786138498\"><span style=\"vertical-align: inherit\">Download Part 3 \u2013 2 GB<\/span><\/a><\/p>\n<p><a href=\"https:\/\/dl2.downloadly.ir\/Files\/Elearning\/Udemy_Excel_VBA_Basic_to_Advance_Part1_20_hours_2024-8.part4_Downloadly.ir.rar?nocache=1786138498\"><span style=\"vertical-align: inherit\">Download Part 4 \u2013 2 GB<\/span><\/a><\/p>\n<p><a href=\"https:\/\/dl2.downloadly.ir\/Files\/Elearning\/Udemy_Excel_VBA_Basic_to_Advance_Part1_20_hours_2024-8.part5_Downloadly.ir.rar?nocache=1786138498\"><span style=\"vertical-align: inherit\">Download Part 5 \u2013 1.54 GB<\/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\">9.54 GB<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Description Excel VBA Basic to Advance Part 1 (20 hours). In this 20-hour course, participants will learn the basics and advanced concepts of VBA programming in<\/p>\n","protected":false},"author":1,"template":"","dgi_category":[10458],"dgi_tag":[71242,89410,89411,89412,89413,89414],"class_list":["post-10603","digital_item","type-digital_item","status-publish","has-post-thumbnail","hentry","dgi_category-video-tutorials","dgi_tag-ajay-parmar","dgi_tag-course-excel-vba-basic-to-advance-part1-20-hours","dgi_tag-download-course-excel-vba-basic-to-advance-part1-20-hours","dgi_tag-download-excel-vba-basic-to-advance-part1-20-hours","dgi_tag-free-download-excel-vba-basic-to-advance-part1-20-hours","dgi_tag-free-excel-vba-basic-to-advance-part1-20-hours"],"_links":{"self":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item\/10603","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\/10603\/revisions"}],"wp:attachment":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/media?parent=10603"}],"wp:term":[{"taxonomy":"dgi_category","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_category?post=10603"},{"taxonomy":"dgi_tag","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_tag?post=10603"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}