Become a Professional Excel VBA developer. Go beyond Macros

Learn Excel VBA for career prospect. From intermediate, raw Excel to a VBA developer. Break the limitation of macros.

Created by: Samuel Osei-Tutu
Microsoft Certified Professional, Consultant and Author

What Will I Learn?

• You will be able to harness the power of VBA language to automate data processing and develop full featured Excel programs. Everything you need.
• Go beyond recording simple macros. Work with Event Procedures
• Dynamically manipulate workbooks, worksheets and arrays
• Transfer data to and from spreadsheet for manipulation
• Master the most important ActiveX controls such as Frame, MultiPage, List Box using VBA
• Develop fully functional VBA application to sort and re-arrange worksheets in any workbook

Requirements

• Familiarity with the Excel interface (Ribbon). Basic understanding of array and looping construct
• Willingness to experiment and explore
• You should be able to create Workbooks and Worksheets using Excel
• Be able to name cells and ranges
• Understanding of Excel's Worksheet Functions

Target audience

• For Excel users wanting to make the transition from data by day Excel data manipulation to automated data processing with VBA for increased productivity
• Acquire the VBA programming skills to guarantee career prospects in VBA programming
• Harness your VBA skills to make light of your daily Excel tasks and to assist co-workers