Summary
Keywords
Full Transcript
Excel VBA Expert Tutorial Get Ad-Free Training by becoming a member today! https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content: https://www.learnitanytime.com Exercise Files: https://tinyurl.com/m6bvnx4w Who it's for: Business Analysts, Data Scientists, and everyone in between looking to write their own rulebook on what’s possible in Excel. What it is: Visual Basic for Applications (VBA) is the programming language for Excel and other Microsoft Office programs. VBA is used to automate repetitive processes and frequent actions. Even more, it can be used to build tools that otherwise don’t exist in Excel. What you'll learn: In this series, users will be guided through the foundational concepts of VBA in Excel. Users will learn to build macros from the ground up, starting with recording macros that require little to no code, and working towards building their own macros using crucial VBA concepts such as Loop, If Then, and other complex functions. Start 0:00 Worksheets Methods 0:03 DateSerial and Format 3:28 Sheet Template Generator 13:32 Move 20:21 PrintOut and PrintPreview 23:40 Practice (Part 1) 25:51 Practice (Part 2) 34:20 Practice (Part 3) 35:54 Practice (Part 4) 37:38 Practice (Part 5) 41:11 Practice (Part 6) 51:48 Custom Functions (Part 1) 54:18 Custom Functions (Part 2) 1:01:01 Custom Functions (Part 3) 1:04:32 Wrapping Up 1:14:07 #ExcelVBA Learnit is no longer associated with this channel/video. (C) 2025 Bomberry Productions Any illegal reproduction of this content will result in immediate legal action.
