Online course · 60% off today ✦ Exclusive course

Excel VBA & Macros: Beginner to Advanced

Automate Excel from your first recorded macro to one-click reports, data-entry forms and numbered PDF invoices. Every macro tested, two complete live projects.

ECreated byEduBenchers English 58 Lessons 15:32:20 Hours Certificate
01

About course

Most Excel users repeat the same steps every day: copying branch files together, cleaning data, building summaries, saving PDFs and sending them on. VBA, the language built into desktop Excel, lets you turn those steps into one click. This course takes you from recording your very first macro to writing clean, tested automation that colleagues can rely on.

What you'll learn

  • Macros from zero: the Developer tab, recording, relative references, running macros safely and macro security
  • The VBA editor and basics: modules, variables and data types, ranges and cells, message and input boxes, debugging with F8 and the Immediate window
  • Logic and loops: If and Select Case, For, For Each and Do loops, finding the last row, copying, filtering and cleaning data
  • Sheets, workbooks and files: adding and naming sheets, combining and splitting files, folders, and saving PDFs
  • Functions, UserForms and events: your own worksheet functions, data-entry forms with validation, workbook and worksheet events, and error handling
  • Real automation: dates, arrays, collections, pivot tables and charts with code, a one-click monthly report, safe emails from Outlook, speed and protection
  • Advanced and modern: Excel tables, Power Query vs VBA, Office Scripts and Power Automate, using AI assistants safely, add-ins, clean code and interview preparation

Learn by doing. You follow Arjun, an MIS executive at Kapoor Auto Parts, a fictional auto-parts distributor with branches across Punjab, as he automates his daily, monthly and invoicing work. Every coding lecture types the macro line by line in a recreated VBA editor and shows the result of running it; the macros were run and checked during production, and the few that need features only desktop Excel has (such as UserForms, pivots, charts and Outlook) are clearly marked as reviewed line by line. Every lecture has three quiz questions, a hands-on task and practice workbooks with tested code. A self-assessment task with a 100-point rubric closes each module, and two live projects at the end, a one-click MIS report and a data-entry and invoicing tool, leave you with work you can show and explain.

Who this course is for. Excel users who repeat the same tasks every day; MIS, accounts, sales and operations staff; analysts who want to automate reports; students preparing for analyst roles; and anyone who has recorded a macro and wants to understand and improve it. No programming experience is needed. You'll need desktop Excel for Windows (some lessons also cover Excel for the web).

02

Overview

What you'll learn

  • Record, read and clean up macros, and run them safely
  • Write VBA with variables, ranges, decisions and loops
  • Combine, split, clean and export Excel files automatically
  • Build data-entry UserForms that check every entry
  • Handle errors cleanly and log what your macros do
  • Automate reports with arrays, pivots, charts and PDFs
  • Choose between VBA, Power Query and Office Scripts
  • Build and explain two complete automation projects
03

Curriculum

58 Lessons · 15:32:20 Hours

  • Why Learn VBA? From 3-Hour Reports to One Click 100:16:05
  • Macros and VBA Explained: What They Are and What They Can Do 300:15:49
  • Setting Up: Developer Tab, Trust Center and Saving as .xlsm 200:15:44
  • Recording Your First Macro: Formatting the Daily Report 200:15:33
  • Absolute vs Relative Recording: Macros That Work Anywhere 200:15:45
  • Running Macros: Buttons, Shapes, Shortcuts and the Quick Access Toolbar 200:15:20
  • Macro Security: Blocked Files, Trusted Locations and the Personal Macro Workbook 200:15:59
  • Notes Macros from ZeroNotes
  • Self Assessment Record a Report FormatterTask
  • Inside the VBA Editor: Project Explorer, Code Window and Properties 200:15:22
  • Reading a Recorded Macro and Cleaning It Up 200:15:32
  • Writing Your First Sub: Modules, Comments and Running with F5 200:15:26
  • The Excel Object Model: Application, Workbook, Worksheet and Range 200:15:12
  • Range vs Cells: Reading and Writing Values Without Select 200:15:44
  • Variables and Data Types: Dim, Option Explicit and Constants 200:16:47
  • Talking to the User: MsgBox and InputBox 200:16:53
  • Debugging Like a Pro: F8, Breakpoints, Watches and the Immediate Window 200:16:13
  • Notes The VBA Editor and BasicsNotes
  • Self Assessment Build a Branch Summary MacroTask
  • Making Decisions: If, ElseIf and Else 200:15:59
  • Select Case: Cleaner Choices for Many Conditions 200:15:52
  • For…Next Loops: Repeating Work Row by Row 200:15:37
  • For Each Loops: Cells, Ranges and Collections 300:15:30
  • Do While and Do Until Loops (and Avoiding Endless Loops) 200:15:15
  • Finding the Last Row and Working with Dynamic Ranges 200:15:59
  • Copying, Filtering and Formatting Data with VBA 200:16:51
  • Cleaning Messy Branch Data Automatically 200:16:31
  • Notes Logic and LoopsNotes
  • Self Assessment Auto Clean Branch DataTask
  • Looping Through Worksheets: Index Sheets and Quick Summaries 200:15:51
  • Creating, Renaming, Copying and Deleting Sheets Safely 200:16:07
  • Opening, Saving and Closing Workbooks with Code 200:16:32
  • Combining Many Workbooks into One Master File 300:15:48
  • Importing and Combining CSV Files from a Folder 200:16:28
  • Splitting Data into Separate Files by Branch 200:16:49
  • Saving Sheets and Reports as PDF 200:17:00
  • FileSystemObject Basics: Folders, Files and File Checks 300:17:23
  • Notes Sheets Workbooks and FilesNotes
  • Self Assessment Combine and Split FilesTask
  • Custom Functions (UDFs): Your Own Worksheet Formulas 200:16:43
  • Passing Arguments: ByVal, ByRef, Optional and Calling Procedures 200:16:57
  • Your First UserForm: Labels, Text Boxes and Buttons 400:16:04
  • UserForm Controls: Combo Boxes, Option Buttons, Check Boxes and List Boxes 400:16:01
  • Validating Entries and Saving Form Data to a Table 300:16:03
  • Workbook Events: Auto-Actions on Open, Before Save and Before Close 300:16:09
  • Worksheet Events: Change, SelectionChange and Double-Click 300:16:04
  • Error Handling: On Error, the Err Object and Clean Exits 200:15:44
  • Notes Functions UserForms and EventsNotes
  • Self Assessment Build a Dealer Entry FormTask
  • Working with Dates and Times in VBA 200:15:25
  • Arrays: Reading and Writing Whole Ranges in One Go 200:15:36
  • Dictionaries and Collections: Fast Lookups, Unique Lists and Totals 200:15:38
  • Automating Pivot Tables with VBA 200:16:47
  • Creating and Updating Charts with VBA 200:16:01
  • Building the Automatic Monthly Branch Report 200:16:13
  • Sending Emails from Excel with Outlook (Safely) 200:16:29
  • Speed and Protection: ScreenUpdating, Calculation and Locking Your Code 200:17:04
  • Notes Real AutomationNotes
  • Self Assessment Automate a Monthly ReportTask
  • Working with Excel Tables (ListObjects) in VBA 200:16:31
  • Power Query vs VBA: When to Use Which 400:16:12
  • Office Scripts and Power Automate: Automation for Excel on the Web 400:16:08
  • Using AI Assistants to Write and Explain VBA Safely 300:15:22
  • Your Personal Macro Library and Excel Add-in (.xlam) 200:16:09
  • Writing Clean, Maintainable VBA 200:16:14
  • VBA Interview Questions and Building Your Portfolio 300:16:15
  • Notes Advanced and ModernNotes
  • Self Assessment Build Your Macro LibraryTask
  • Project 1 · One-Click MIS Report (Part 1): Import, Clean and Combine Branch Files 400:15:57
  • Project 1 · One-Click MIS Report (Part 2): Summary, Pivot, Charts and PDF 300:15:51
  • Project 2 · Data-Entry and Invoicing Tool (Part 1): The Order Entry UserForm 500:15:38
  • Project 2 · Data-Entry and Invoicing Tool (Part 2): Numbered Invoices and PDF Export 300:16:09
Video LecturesWatch & rewatch anytime
Best Interactive ContentQuizzes and activities that stick
GuidanceAsk doubts, get expert answers
04

Why learn Excel VBA?

  • Excel is used in almost every office, and VBA is built into desktop Excel
  • Automating repeated tasks frees hours for real analysis
  • Macros make reports consistent: the same steps, every time
  • VBA skills help in MIS, finance, operations and analyst work
  • Understanding VBA helps you review, fix and improve existing macros
  • The logic you learn transfers to Office Scripts and other languages
05

Who this course is for:

  • Excel users who repeat the same steps every day
  • MIS, accounts, sales and operations professionals
  • Analysts who build daily, weekly or monthly reports
  • Students preparing for analyst and MIS roles
  • People who have recorded macros and want to understand them
  • Beginners with no programming experience