Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Advance MS Excel VBA for Beginner to Advanced
Rating: 3.7 out of 5(635 ratings)
56,306 students

Advance MS Excel VBA for Beginner to Advanced

Automate Complex Tasks with Microsoft Excel VBA & Excel Macros (Real-World Projects included). Achieve More. Save time.
Created byMarcus Menti, Zechariah Tech
Last updated 5/2026
English
English [Auto],

What you'll learn

  • Learn how to automate daily routine tasks within Excel
  • Determine when it's best to use the Macro Recorder versus VBA
  • Learn VBA programming concepts to create dynamic, re-usable code
  • Learn best practices when creating macros and streamline your VBA code
  • Learn how to write custom VBA Macros to create more robust automation
  • Complete real world Macro/VBA projects from beginning to end

Course content

1 section • 28 lectures • 3h 0m total length

  • Introduction4:04

    Explore Visual Basic for Applications (VBA) in Excel and other Office apps, enabling automation, custom functions, and add-ins to streamline business tasks and reporting.

  • Basics of VBA6:37

    Explore the VBA interface, including the project panel, properties panel, and modules, and see how sheets and workbooks relate to the developer tab for enabling macros in Excel.

  • Object Oriented Programming 018:01

    Explore object oriented programming, a paradigm based on objects with data and code, and learn the four pillars—inheritance, polymorphism, encapsulation, and abstraction—using VBA in Excel.

  • Object Oriented Programming 024:22

    Enable the developer tab in Excel from the file tab, open the Visual Basic Editor with Alt+F11, and start VBA with macros and code in the customized ribbon environment.

  • The Macro Recorder9:45

    Record macros in Excel to automate formatting, data entry, and VBA code across sheets by using the macro recorder in the developer tab and replay with Alt+F8.

  • Basic of Cell Reference4:27

    Explore absolute and relative cell references, how dollar signs anchor cells, and how these references influence macro recording and formula replication across data fields.

  • Use relative reference6:44

    Learn how to use relative references in macro recording, compare them with absolute cell references, and paste data flexibly across sheets using recorded macros in Excel.

  • Recording simple macro part 017:24

    Record a macro using relative references to batch-update phone numbers and codes, then format cells as phone numbers to apply consistent brackets and spacing.

  • Recording simple macro part 028:11

    Record macros to customize date formats in Excel using relative references and the format cell option, including month, day, and year, and explore masking numbers such as social security numbers.

  • Multi step Macro Recording11:12

    Explore multi step macro recording in Excel, using formulas, functions, and cell references to format and mask data like social security numbers, zip codes, and phone numbers.

  • Sorting7:29

    Master sorting and filtering data with macros in Excel, recording steps to sort by injury location and age group, using absolute references and macro-driven buttons.

  • Sorting and filtering2:04

    Sort and filter data by recording a macro in Excel VBA, add a clear button to revert to default, and choose between absolute and relative references.

  • Protecting and formatting sheets with macro recorder7:32

    Record a macro in Excel to protect a sheet, unlocking only the selected category of data with absolute references and special selections, while others stay protected, optionally with a password.

  • VBA interface setup8:34

    Open the vba editor from excel's developer tab, and explore the interface, project explorer, properties, and modules, then use the immediate window to test code.

  • Recorder VS Manual code13:08

    Explore recorder vs manual code in Excel by turning on VB and the Developer tab, recording macros, editing modules, and running automated and manual scripts to format cells.

  • Introduction to editing macros 1st step.11:47

    Explore editing macros in Excel with vba, recording macros using absolute references, and debugging via the vba editor, developer mode, and macro playback to master fonts, formatting, and keyboard shortcuts.

  • Introduction to editing macros 2nd step.2:27

    Learn to edit macros in VBA by changing font size from 14 to 16 or 18, toggling true/false, adding shadows and strikethroughs, and applying the Cambria font.

  • Debugging Macros 1st part.5:44

    Learn to debug a macro in VBA by recording macros, inspecting modules, and using debugging tools to run code step by step, and keep backups since undo cannot revert changes.

  • Debugging Macros 2nd part2:27

    Edit macros in vba to modify formatting, adjusting font size and font type, toggling true/false for subscripts and shadows, applying strikethroughs, and running the macro to see changes.

  • Grammar in VBA7:38

    Explore VBA grammar by treating objects like ranges and cells as the subject, with adjectives and verbs guiding formatting, insertion, and macro actions while recording and reviewing a sample macro.

  • Macro Scripting Basics14:31

    Create a macro from scratch by adding a module, selecting sub, function, or property procedures, choosing public or private scope, and scripting ranges and headers with VBA.

  • Range8:18

    Learn how range defines data cells in Excel and master selecting cells with VBA using range, offset, and cells, including practical B2 and A1 examples via the immediate window.

  • Selection and Color9:37

    Master selection and range in VBA, explore absolute and relative references, and apply formatting, font changes, and color using hex and rgb codes in Excel.

  • Value and clear4:15

    Learn to use the range value property to read and set data in a cell and clear content and formatting with the clear method in Excel VBA.

  • Current Region4:37

    Explore the current region concept in Excel VBA by selecting a contiguous data block, using Ctrl+A to identify the range, and applying these steps to specific cells like B2.

  • MS Excel Frequently used shortcuts
  • Microsoft Excel VBA with AI
  • How to Take Help of AI for Advanced MS Excel VBA — Beginner to Advanced0:03

Requirements

  • In order to complete the projects detailed in this course, you will need Microsoft Excel loaded on you computer. Any version of Excel will work.
  • Understand English Language

Description

This Advanced MS Excel VBA course is designed to take you from zero knowledge to advanced-level Excel automation skills. Whether you are a beginner or an intermediate Excel user, this course will help you master Excel VBA (Visual Basic for Applications) to automate tasks, improve productivity, and build powerful Excel-based solutions.

You will learn step by step how to write VBA code, automate repetitive work, create dynamic tools, and develop professional Excel applications used in real-world office and business environments. The course focuses on practical examples, real-life projects, and hands-on learning to ensure you gain job-ready skills.

What You Will Learn

  • Basics of MS Excel VBA and macro recording

  • Understanding VBA editor, modules, procedures, and variables

  • Writing and editing VBA code from scratch

  • Automating repetitive Excel tasks using VBA

  • Working with loops, conditions, and error handling

  • Creating user forms and interactive Excel tools

  • Automating reports, dashboards, and data processing

  • Connecting VBA with worksheets, workbooks, and external data

  • Optimizing VBA code for better performance

  • Real-world VBA projects for office and business use

After Completing This Course, You Will Be Able To

  • Automate daily Excel tasks and save hours of manual work

  • Create custom Excel tools and applications using VBA

  • Build automated reports and data management systems

  • Write clean, efficient, and professional VBA code

  • Use Excel VBA confidently in office, corporate, and freelance work

  • Improve productivity and accuracy in data handling

  • Add advanced Excel automation skills to your resume

Course Level

  • Beginner to Advanced

  • Suitable for students, professionals, and business users

Requirements

  • Basic knowledge of MS Excel

  • A computer or laptop (Windows recommended)

  • MS Excel installed (2016 or later preferred)

  • No prior programming experience required

Who This Course Is For

  • Anyone who wants to become an Excel automation expert

This course is a complete guide to mastering Advanced MS Excel VBA from beginner to advanced level. By the end of the course, you will have the confidence and skills to automate complex Excel workflows, create professional tools, and solve real business problems efficiently. If you want to stand out in your career with high-demand Excel automation skills, this course is the perfect choice.

Who this course is for:

  • This Excel Macro/VBA course is meant for those that use Microsoft Excel and are looking to become more efficient by automating their daily Excel tasks. No prior programming experience is required.

Report abuse