CEBU Fundamentals of Macros and VBA Programming

• Cebu Philippines
• Start: Jul 19 2022 00:00
• Finish: Dec 01 2024 00:00
• Time zone: Asia/Manila

NO PAYPAL? NO problem.  Send us a text at 09771031800 about other payment options.  Or email at inquire@insightsmanila.com.
____
Bring own laptop.  Handouts, certificate, snacks provided. LUNCH NOT INCLUDED-- there will be a 45-minute lunch time where participants can take their lunch from food establishments nearby (e.g. McDonalds and Jollibee.)
___
Description
Knowledge of Macros and VBA Programming allows you to automate reports in MS Excel. Generate reports in one click, create tools that will eliminate the manual tasks in your workplace. Know how to record macros, and create modules with Logical, Loop, and Userform structures!The course requires just at least a basic understanding of MS Excel in order to be appreciated.
IMPORTANT DETAILS:
Certificates will be provided.
Handouts and workfiles included.
Bring your own laptop. Practice files will be emailed before the training. (You can ask us about our laptop rental service if you cannot bring a laptop.)
Coffee, PM snacks, and candies included.
Tax included. Official Receipt can only be given on the day itself.
Email: inquire@insightsmanila.com
SMS: 0977.103.1800
Facebook: www.facebook.com/InsightsManila
Topics:
1. Macros
Recording Macros
Assigning Macros to Objects
Relative References
Making Macros Permanent
2. Introduction to Visual Basic for Applications
The Visual Basic Editor
Essential Codes: ACTIVECELL, SELECTION, MSGBOX, RANGE, SHEETS
Essential Actions: ACTIVATE, CLEAR, VALUE, COPY, PASTE, INSERT, DELETE
3. Decision Structures
IF
ELSEIF
AND and OR
Resolving Case Sensitivity of Codes
Using IF Structures in resolving different scenarios
4. Loop Structures
Creating Conditional Stops with DO UNTIL
Creating Absolute Loops with FOR NEXT
Looping Objects with FOR EACH NEXT
Combining Loop Structures
5. Userforms
Creating basic userforms
Automating userform actions
UNLOAD, TEXTBOX, CHECKBOX, USERFORM SHOW