# Event Details - **Event Name**: MS Excel Macros and VBA Programming - **Event Start and End Date**: Mon, 19 Oct, 2026 at 08:00 am – Tue, 20 Oct, 2026 at 05:00 pm (+08:00) - **Event Description**: This training covers the fundamentals of using macros and VBA programming to automate MS Excel.About this EventThis training provides a solid foundation in Excel automation using Macros and Visual Basic for Applications (VBA). It equips participants with the essential knowledge and hands-on skills needed to streamline repetitive tasks, improve accuracy, and build sustainable processes within their teams.Through guided exercises in every module, participants will progressively develop working automation solutions. By the end of the program, they will be able to automate reports, reduce manual intervention, minimize errors, and lessen operational risks caused by dependency on specific individuals.ObjectivesUnderstand how macros and VBA improve efficiency and reduce manual errorsRecord, modify, and execute macros for common Excel tasksNavigate and use the VBA environment confidentlyWrite basic VBA code to manipulate data, cells, and worksheetsApply logical and looping structures to automate repetitive processesCreate user-defined functions and interactive userformsImplement error handling to ensure stable automationDevelop end-to-end automation solutions for real workplace scenariosWho This Is ForExcel users handling repetitive reports and manual processesOperations, finance, and administrative professionals working with structured dataAnalysts and supervisors aiming to standardize workflowsTeams looking to reduce dependency on specific individuals for report generationAnyone with basic Excel knowledge who wants to move into automationMethodologies1. Guided Build ApproachParticipants will learn by doing—each concept is immediately followed by structured exercises where they create actual macros, write code, and test outputs. The progression ensures that learners move from simple recordings to fully functional automation tools.2. Scenario-Based ApplicationRealistic business scenarios (e.g., report generation, data cleaning, automated formatting, simple input systems) are used to simulate workplace challenges. Participants will apply VBA techniques to solve these scenarios, reinforcing both technical skill and practical judgment.INCLUSIONS (if joining in Cubao)2 snacks per day1 lunch per dayhandoutscertificateunlimited coffeecandies and snacksINCLUSIONS (if joining via Zoom)PDF certificatePDF handoutWhere:Mpower Learning Manila222 Vivaldi Residences, 628 EDSA cor Aurora Blvd., Cubao, Quezon CityOutlineOutlinePart 1. Macro RecordingCreating MacrosExploring Macro SecurityRecording and Running a MacroUsing Relative ReferenceAssigning a Macro to ButtonsUsing Macro Recording to Create VBA CodesPart 2. Introduction to VBAExploring the VBA Interface (Overview)VBA TerminologiesExploring the Properties WindowExploring the Code WindowPart 3. Programming BasicsEssential VBA CodesDifferent Ways of Calling CellsCreating Basic ModulesObjects, Properties, and ActionsModifying Objects with Properties (e.g. OFFSET)Common Mistakes when CodingDealing with Rows, Columns, and SheetsCoding Common Tasks in ExcelPart 4. Logical and Loop Control StructuresApplying Decision StructuresIf, Then, Else StatementIf, Then, ElseIf StatementSolving Repetitive Tasks with Loop StructuresFor, Next LoopFor Each, Next LoopDo Until, LoopApplying Control Structures in Excel ProgramsPart 5. More VBA FunctionsUsing IF to Create FunctionsUser-Defined FunctionsUsing MS Excel Functions in VBAPart 6. Creating Userforms and Userform EventsAdding UserFormsAdding Form ElementsCoding Common Tasks Involving Forms (e.g. Search, Add Data, etc.)Part 7. Designating Actions When Errors are EncounteredIdentifying common runtime errorsImplementing error-handling techniquesDesigning stable and reliable VBA proceduresPart 8. Creative Automation Exercises in VBAApplying all learned concepts in practical scenariosBuilding complete automation solutionsEnhancing efficiency through end-to-end VBA workflows - **Event URL**: https://allevents.in/mandaluyong-city/ms-excel-macros-and-vba-programming/100001994128246265 - **Event Categories**: it, workshops, art - **Interested Audience**: - total_interested_count: 0 - **Event Highlights**: - Duration: 9 hours - Location: Mpower Learning Manila - Languages: English ## Ticket Details - **Ticket Price Range**: min: 4408.53, max: 11022.9, currency: PHP ## Event venue details - **city**: Mandaluyong City - **state**: MM - **country**: Philippines - **location**: Mpower Learning Manila - **lat**: 14.6210878 - **long**: 121.0505905 - **full address**: Mpower Learning Manila, 222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd, Mandaluyong City, Philippines ## Event gallery - **Alt text**: MS Excel Macros and VBA Programming - **Image URL**: https://cdn-az.allevents.in/events3/banners/1cfa38bd4d776959869ff3d013d85b11f29b8ee5a3964694cabec30b232d2f3a-rimg-w1200-h628-dc127bbc-gmir.jpg?v=1784216008 ## FAQs - **Q**: When and where is MS Excel Macros and VBA Programming being held? - **A:** MS Excel Macros and VBA Programming takes place on Mon, 19 Oct, 2026 at 08:00 am to Tue, 20 Oct, 2026 at 05:00 pm at Mpower Learning Manila, 222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd, Mandaluyong City, Philippines. - **Q**: Who is organizing MS Excel Macros and VBA Programming? - **A:** MS Excel Macros and VBA Programming is organized by Insights Training. - **Q**: Who is this event for? Is it right for me? - **A:** MS Excel Macros and VBA Programming is ideal for curious learners, students, and skill-builders looking to gain hands-on knowledge and practical expertise in a focused, interactive setting. Whether you're a first-time attendee or a longtime enthusiast in Mandaluyong City, this event is thoughtfully curated to deliver a standout experience worth every moment. If MS Excel Macros and VBA Programming sounds like your kind of event, don't wait - spots fill up fast. ## Structured Data (JSON-LD) ```json [ { "@context": "https://schema.org", "@type": "Event", "name": "MS Excel Macros and VBA Programming", "image": "https://cdn-az.allevents.in/events3/banners/1cfa38bd4d776959869ff3d013d85b11f29b8ee5a3964694cabec30b232d2f3a-rimg-w1200-h628-dc127bbc-gmir.jpg?v=1784216008", "startDate": "2026-10-19T08:00:00+08:00", "endDate": "2026-10-20T17:00:00+08:00", "url": "https://allevents.in/mandaluyong-city/ms-excel-macros-and-vba-programming/100001994128246265", "eventStatus": "https://schema.org/EventScheduled", "location": { "@type": "Place", "name": "Mpower Learning Manila", "address": { "@type": "PostalAddress", "streetAddress": "222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd", "postalCode": "1109", "addressLocality": "Mandaluyong City", "addressRegion": "MM", "addressCountry": "PH" }, "geo": { "@type": "GeoCoordinates", "latitude": "14.6210878", "longitude": "121.0505905" } }, "eventAttendanceMode": "https://schema.org/OfflineEventAttendanceMode", "description": "This training covers the fundamentals of using macros and VBA programming to automate MS Excel.", "offers": [ { "@type": "AggregateOffer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-07-16", "availabilityEnds": "2026-10-20T17:00:00+08:00", "validFrom": "2026-07-16", "lowPrice": "4408.53", "highPrice": "11022.90", "price": "4408.53", "url": "https://allevents.in/mandaluyong-city/ms-excel-macros-and-vba-programming/100001994128246265" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-07-16", "availabilityEnds": "", "validFrom": "2026-07-16", "url": "https://allevents.in/mandaluyong-city/ms-excel-macros-and-vba-programming/100001994128246265", "price": "5699.00", "name": "Join in Cubao" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-07-16", "availabilityEnds": "", "validFrom": "2026-07-16", "url": "https://allevents.in/mandaluyong-city/ms-excel-macros-and-vba-programming/100001994128246265", "price": "5458.43", "name": "Early Bird (Cubao)" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-07-16", "availabilityEnds": "", "validFrom": "2026-07-16", "url": "https://allevents.in/mandaluyong-city/ms-excel-macros-and-vba-programming/100001994128246265", "price": "4933.48", "name": "Join via Zoom" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-07-16", "availabilityEnds": "", "validFrom": "2026-07-16", "url": "https://allevents.in/mandaluyong-city/ms-excel-macros-and-vba-programming/100001994128246265", "price": "4408.53", "name": "Early Bird (via Zoom)" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-07-16", "availabilityEnds": "", "validFrom": "2026-07-16", "url": "https://allevents.in/mandaluyong-city/ms-excel-macros-and-vba-programming/100001994128246265", "price": "11022.90", "name": "Bundle for 2 (Join in Cubao)" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-07-16", "availabilityEnds": "", "validFrom": "2026-07-16", "url": "https://allevents.in/mandaluyong-city/ms-excel-macros-and-vba-programming/100001994128246265", "price": "9448.05", "name": "Bundle for 2 (Join via Zoom)" } ], "organizer": [ { "@type": "Organization", "name": "Insights Training", "url": "https://allevents.in/org/insights-training/22581225", "description": "Insights Training is a pool of traning consultants offering their courses at an affordable investment.  We believe that training must be affordable but effective (and fun!) at the same time.Visit our website at www.insightsmanila.com for more details.Our office is located at 7F Finman Bldg., 131 Tordesillas St., Salcedo Village, Makati.  You may reach us at info@insightsmanila.com, 0977.103.1800." } ] } ] ```