Comprehensive Excel Macro & VBA Workshop

Thursday-Saturday November 24-26, 2022

8:30 AM – 4:30 PM

Unit 3C Marsk Bldg., Aurora Boulevard corner Balete Drive, Barangay Kaunlaran, Quezon City 1111 (near UnionBank and Robinsons Magnolia)

For more details and upcoming events visit: https://www.jtrservicesph.com/onsite-training

HOW TO JOIN

1. CLICK the ticket to register and indicate your chosen course.
2. Pay 50% downpayment or the full amount of the chosen course to reserve the slot. Payment is non-refundable. The remaining balance must be paid a week or one (1) day before the scheduled event. Payment details will appear upon registration. OR will be issued upon request.
3. To reserve the slot, please send proof of payment by replying to the email confirmation you receive upon registration or thru this email: [email protected]
4. SLOTS ARE LIMITED. FIRST COME, FIRST SERVE
5. Congrats on completing the steps! You will be receiving a calendar invitation. See you there!

REQUIREMENTS

• Bring your Windows laptop
• Must have MS Excel installed. Version 2016 / 2019 / 2021 / Microsoft 365
• If you don’t have it yet, subscribe and install it from www.office.com
• Must be proficient in spreadsheet

INCLUSIONS

• Light snacks and meal
• Softcopies of Handouts and Excel templates
• Certificate

OBJECTIVES:

• 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 conditions, or do a task if triggered by an action.
• The objective of the course is to build a project with automation using VBA codes

TOPICS

• Macro Recorder And Fundamentals Of Elements
• Procedures, Data Types And Declaration Of Variables, Methods And Properties
• Object Model, Range Objects And Properties
• Worksheet And Workbook Object, Properties And Method
• Deep Dive Methods And Properties Of Range Object
• Other Methods Of Range Object, Formula In Vba And R1c1 Notation
• With Statement, Conditional Statement, Select And Loops Statement
• For Statement And User Defined Function
• Event Procedure, Message Vs Input Box, Debugging, Miscellaneous
• Userforms And Controls

Know what’s Happening Next — before everyone else does.

Get App

Host or Publisher JTR Services PH