Excel VBA?  In 2025?  Yes, for so many reasons!  No tool available delivers click-of-a-button magic like Excel VBA.  And that’s not to mention the educational benefits of learning to write macros in Excel – it’s a great way to get started with computer coding.  So, let’s learn some Excel VBA today and enjoy a few punch-the-air moments!

EXCEL DOWNLOAD FILE LINK

WATCH THE VIDEO HERE

This video covers 25 quick, easy but powerful VBA constructs that I use daily in my work.  I find a lot of professionals out there have some VBA knowledge perhaps, for example, having recorded a few macros in the macro recorder.  But, the VBA syntax required to bind it all together - which has to be organically written or at least adapted from somewhere else - is missing.

In the session, I share the main non-recordable VBA constructs I use in my Excel client work.  These form the connective tissue of automated processes that save professionals like you hours of time, daily.   Yes, many of our customers are still asking for VBA-based applications, since no Excel-related tool delivers such clean and powerful solutions from the desktop.

The techniques we cover include loops in Excel VBA which allow you to repeat a VBA instruction any number of times, dynamic position control concepts to work with datasets that change in size, and VBA’s powerful application.worksheetfunction facility that calls worksheet formulae from the VBA editor.  And look out for a few non-categorisable gems too!

So, make sure you download the Excel file and work along with me – all the VBA code is included.  Let’s see if we can take your Excel VBA to the next level and get you automating those annoying manual processes at the click of a button.  Don’t forget to share those punch-the-air moments in the comments section below – I love reading about them!

WATCH NEXT

Excel VBA For Beginners (6-PART FOUNDATIONAL VIDEO SERIES)

Excel VBA For Beginners (2024 STAND-ALONE VIDEO)

Excel VBA For Beginners (TIGER CLASSIC – ONE MILLION VIEWS!)

Excel VBA Position Control Mastery In 13 One-Line Macros (HIDDEN GEM!)

Complete Excel VBA Training Programme (FREE ON YOUTUBE)

Real-World Excel VBA Training Programme (30 VBA CONSTRUCTS BROKEN DOWN IN DETAIL)

Real-World VBA Task (USE EXCEL VBA TO ANALYSE FOOTBALL DATA)

Get The Tiger Formatting Look In Your Spreadsheets