Visual Basic for Applications (VBA) for Microsoft Excel (Beyond the Basics) Video

Visual Basic for Applications (VBA) for Microsoft Excel (Beyond the Basics) Video

Objectives:

1. Record a macro using the relative reference option in VBA.
2. Explore the Input Box, Message Box, and Active Cell in VBA.
3. Reference active cells and assign values to cells.
4. Master the immediate window and write complex decision logic in VBA.
5. Apply font changes with the help of a VBA macro.
6. Apply border and alignment formatting using VBA.
7. Copy and paste data using VBA.
8. Merge, color, wrap text, and change the orientation of the cells using VBA.
9. Clear and delete cells using VBA.
10. Insert and delete rows and columns using VBA.

Instructor: Hassan Khan

Length: 3 hours

Access period: For one year starting from purchase date