Udemy – Excel VBA Basic to Advance Part1 (20 hours) 2024-8

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.

What you will learn:

• Complete introduction to automating Excel tasks using VBA from zero to one hundred.
• Understand the basics of VBA and how to customize syntax without relying on the internet to solve problems.
• Learn how to record, edit, run, and save macros and understand their benefits and limitations.
• 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.
• Understanding variables and data types and why they are needed, along with preparing for interview questions related to variables.
• Learn conditional IF statements such as Single IF, IFAND, IFOR, IF with Else If, ​​and IF without Else If, ​​and the differences between types of IFs.
• Combining IF with loops through a case study of a live example.
• Identify and resolve errors such as OverFlow, Data Type Mismatch, Argument Not Optional, Property Method Not Defined, and Subscript Out Of Range.
• Learn about set loops and improve your data management skills; learn how to work with multiple workbooks and easily copy and paste data.
• Familiarity with the Set keyword and how to define objects using VBA classes, their methods, and properties.
• Working with classes such as Worksheet, Workbook, Range, Worksheet Function, Strings, and Info, and how to use the Object Browser in VBA.
• Learn how to use VBA built-in functions and create user-defined functions (UDFs).
• Familiarity with the use of arrays in VBA, which is one of the most important and practical concepts.
• Each topic will be discussed with practical examples and full details.

This course is suitable for people who:

• Students who want to become business analysts, data analysts, VBA developers, or market research analysts.
• 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’t exist in Excel, and automatically creating Excel templates.
• Any data enthusiast who wants to save time and avoid manual tasks by automating tasks in Excel.

Installation Guide

After Extract, view with your favorite player.

Subtitles: English

Quality: 720p