Excel Macros & Excel VBA Programming for Absolute Beginners

In this class my goal is to help you learn ways to create Excel Macros that won’t burst your brain. Also to convey the main principles of VBA language and allow beginners, taking their first steps, to learn without requiring individual training.

A macro is a sequence of instructions that automates some aspect of Excel so that you can work more efficiently and with fewer Errors. Macros are written in VBA, which stands for Visual Basic for Applications, is a programming language developed by Microsoft.

In this Class you will find several short, to the point lessons covering Excel Macros and VBA entertaining and accessible to non-techies. The goal is not to make you a star Excel programmer. If you want to be that, go for it! But I’ll give you some best practices and make this course extremely practical. After all, you are not a programmer, you just need to write an Excel Macro to help you get your work done.

Are you looking to learn practical Macro and VBA techniques you can put to use instantly? If so, then this is the class for you. It’s entirely project based and it’s full of examples which are fully explained and easy to understand. It has been recorder with the brand new Excel 2019 in full HD 1080p.

So let's get started!

• Introduction
• Compatibility and Macros Security
• What are macros and how we can use them
• Ways of Recording a Macro
• Ways of Running a Macro
• Assign a Macro to Ribbon Icons and Create your Ribbon
• Relative or Absolute Method ?
• The Anatomy of Macros
• Make a macro available all the time
• Organizing your Personal Macro Workbook
• Watch A Macro Write Your Code
• Project #1: Use navigation buttons to change Chart Type
• Macro Recorder vs VBA
• Enter the world of Excel VBA
• The VBA Environment
• VBA Editor Tips
• VBA Modules and Editor tab Tips
• Using VBAs Help System
• VBA Object Model
• Diving into Object Properties and Methods
• How to Create your First Piece of Code
• How VBA "speaks"
• Workbook, Worksheet and Range
• Sub procedures
• Sub Procedure Examples
• Function Procedures
• Function Procedure Examples
• Variables
• Constants
• Strings and Dates
• Range and Cells properties
• Assignment Statements
• Arrays
• Range Property
• Cells Property
• Offset property
• Useful Range Object Properties
• Useful Range Object Methods
• Using VBA and Worksheet Functions-Introduction
• Using Built In VBA Functions
• Using Worksheet Functions in VBA
• Using Custom Functions
• Make Decisions with VBA - Introduction
• The If Then structure
• The GoTo Statement
• For Next loops
• With End With Constructs
• EXAMPLE: How to read from a cell
• Dim and Set statements
• Using IF..ELSE Statements with Macros
• Using Relative or Absolute Reference
• Using FOR…NEXT Statements with Macros
• Using DO…UNTIL Statements with Macros
• Project #2: Add a confirmation dialog box with VBA IF statements
• Project #3: Prompting a user to select a worksheet and run a macro
• Combining Macro Recording and VBA Statements
• How to join 2 different Macros
• Tips for running your Macros fast
• Project #4: Transfer Data From one Excel Worksheet to another
• Project #5: How to Create Notifications-Reminders using VBA Code
• How to create an Excel Animated Chart using VBA Code
• Saving a Workbook before Closing
• Closing All Workbooks at Once
• Excel 2019 Tutorial for Beginners