External Access

Visual Basics For Excel (VBA)

(0 Ratings)

$20.00$80

Master Visual Basic for Excel — Unlock the Power of Automation!

Tired of doing repetitive Excel tasks manually?

What if you could make Excel work for you — automatically?

Welcome to Visual Basics for Excel Video Tutorials, a step-by-step online course designed to transform you from a regular Excel user into a VBA-powered automation expert.

Whether you’re a student, accountant, data analyst, or business professional, this course will help you save time, eliminate errors, and supercharge your productivity using the magic of Visual Basic for Applications (VBA).

💡 Why Learn Visual Basic for Excel?

Excel alone is powerful — but VBA makes it unstoppable.

With Visual Basic for Excel, you can:

✅ Automate reports, dashboards, and data entry

✅ Create your own Excel functions & tools

✅ Build user forms and interactive applications

✅ Eliminate repetitive manual work forever

✅ Impress employers and clients with professional automation skills

🎓 What You’ll Learn Inside

Each lesson is explained in simple, clear videos that take you from step by step to master the contents.

Module 1: A Little about Macros – Recording Macros and Inspecting the Codes (4 Videos)

Module 2- Introduction to VBA – Understanding VBA & VBA Objects (3 Vides)

Module 3 – Exploring VBA Objects (1 Video)

Module 4 – Exploring VBA Menus (1 video)

Module 5 – Practicing with Various VBA Objects (6 videos)

Module 6 – Declaring Variables in VBA (2 Videos)

Module 7 – Using Conditional Logic In VBA – IF, AND, OR, Select Case Statements (5 Videos)

Module 8 – Referencing the Active Cell Object (3 Videos)

Module 9 – Working with Texts In VBA (10 Videos)

Module 10 – Using the For Next Loop (3 Videos)

Module 11 – Using the For Each Loop (5 Videos)

Module 12 – Using the Do While Loop (3 Videos)

Module 13 – Using The DO Until Loop ( 3 Videos)

Module 14 – Arrays In VBA (4 Videos)

Module 15 – Subroutines & Functions – Building Your Own Functions In Excel (7 Videos)

Module 16 – Calling Excel Functions In VBA (3 Videos)

Module 17 – Creating Forms In Excel (31 Videos)

Module 18 – Debugging VBA Codes ( 9 Videos)

Module 19 – Practical Case of automatic Bank Reconciliation Using VBA (11 Videos)

Module 20 – More Practical VBA Operations – Automate set column width, Manipulate colors, Conditional formatting, auto-switch sheet orientation, automatically delete blank rows in a range of cells, Formatting A Closed Workbook, (8 Videos)

Module 21 – Additional VBA Tasks (17 Videos)

About 139 Videos

🧑‍💻 Who This Course Is For

Accounting and finance students (ICAN, ACCA, CIMA, etc.)

Business professionals and data analysts

Anyone who uses Excel and wants to save hours every week

No programming background required — just basic Excel knowledge and a desire to learn.

🎥 What Makes This Course Different

✅ 100% Practical — Learn by doing, not by reading theory

✅ Step-by-step Video Lessons — Easy to follow, clear explanations

✅ Real-life Projects — Apply what you learn immediately

✅ Lifetime Access — Learn at your own pace - Videos are downloadable