501: PRACTICAL MACRO & VBA

This course is for beginners of Macro who want to automate tasks in Excel. The course will cover how to automate entry, move or copy properties or objects, calculate data based on condition, or do a task if triggered by an action. VBA requires basic knowledge in font, cell ranges, workbook and worksheet. However, the course is not intended to cover the advanced features (eg. for/next loop), sophisticated writing of codes, userforms and its controls. The objective of the course is to create template and populate data or vice versa (example, data encoded in template, such as invoice, must be stored in or retrieved from database without manually copy-paste) The student must follow the flow of lecture with provided template. The lectures revolve in building up the template with automated task.