Excel VBA: The VBA Beginner’s Blueprint to Programming Excel

Unlock Excel's Power: Your Step-by-Step Guide to VBA Programming!

Created by: IsáBel .
Microsoft Certified IT Professional. Trainer of 25 Years

What Will I Learn?

• If you plan to use Excel in your job, than learning VBA has its advantages!
• Automate, and customize your Excel 2007, 2010, 2013, 2016, 2019, or 365 files with hours of Video Lectures, 40+ Articles, and 90+ Supplemental Resources.
• UNDERSTAND why you would want to use VBA in Excel
• KNOW the difference between Macros and VBA
• CREATE Macros in Excel
• MODIFY your Macros
• NAVIGATE comfortably in the Visual Basic Editor
• LEARN the essentials of writing Excel VBA code
• MODIFY your Workbooks using VBA
• CREATE Decision Structures in your VBA code
• LOOP your VBA code to have it run more than once
• CREATE user interaction dialog boxes, like Message Boxes, and Input Boxes
• CREATE User Forms from scratch
• DEBUG your VBA code
• LEARN how to handle errors
• CREATE New Worksheet Functions

Requirements

• To get the most out of this course, you should have working knowledge of Microsoft Excel.
• Excel 2010, 2013, 2016, 2019, 365

Target audience

• This course is for the everyday Excel user, who wants to extend the functionality of their spreadsheets using Visual Basic for Applications (VBA), but who is not yet familiar with VBA.
• This course is designed for beginners to VBA. Intermediate, and Advanced VBA users will find this course a great review, but this course is not designed for advanced users of VBA.