BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Catapult HR - ECPv6.17.1//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Catapult HR
X-ORIGINAL-URL:https://letscatapult.org
X-WR-CALDESC:Events for Catapult HR
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/New_York
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20250309T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20251102T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20260308T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20261101T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20270314T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20271107T060000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20261209T090000
DTEND;TZID=America/New_York:20261209T160000
DTSTAMP:20260804T185420Z
CREATED:20260804T185420Z
LAST-MODIFIED:20260804T185420Z
UID:41879-1796806800-1796832000@letscatapult.org
SUMMARY:Excel Macros & Intro to VBA: Building Tools & Eliminating Repetition
DESCRIPTION:Technology & Digital Skills \nWednesday\, December 9\, 2026 · In Person · Charlotte \n\nRegister Now → \n\n\nCourse Details \n\nFormatIn Person\nLocationCharlotte\nDate & TimeWednesday\, December 9\, 20269:00 AM – 4:00 PM ET\nPrice$309Member · Non-member: $369\nFacilitatorCatapult HR Specialists\nSeats10 seats10 available\n\n\n\nExcel macros and VBA are utilized to automate repetitive tasks\, customize Excel's functions\, and streamline data processing. With VBA\, custom functions and procedures can be created\, making complex calculations and data manipulation possible\, extending Excel's capabilities\, and making it a more powerful and efficient tool for data analysis and reporting. \n \nProgram Level: Intermediate \nPrerequisites: The student must be a current Excel user and have taken at least Excel I and II or have equivalent experience. \n \nContents: \n\nUnderstanding Macros \n\nWhat is a Macro?  \n\nWhat is VBA  \n\nDisplaying the Developer Ribbon Tab  \nMacro Security \nRecording a Macro  \n\n\nStoring Macros  \n\nThe Personal Macro Workbook  \nUsing Macro-Enabled Workbooks  \n\n\nRunning Macros  \n\n\nCreating a Macro Icon for the Toolbar   \n\n\nCreating Macros 3 ways \n\nAbsolute Macros \n\nCreate a macro for a report or repetitive data set \n\n\nRelative reference macros \n\nCreate a macro that will work on any column \n\n\nRelative reference macro starting from a selection  \n\nCreate a macro that will format any selection \n\n\n\n\nCreate Functional tools \n\nCreate a macro to clean and trim a column \nCreate a macro to add leading zeros to a column \n\n\nIntroduction to the VBA interface \n\nVisual Basic button / Developer Ribbon \nSetting up and understanding the VBA Editor \nUsing the Project Window / Hiding the Properties Window \nOpening / closing and saving your work \n\n\nUsing pre-built code to do what excel does not \n\nSaving a workbook before closing \nCreate a backup copy with today’s date in the title \nCreate a new workbook for each worksheet \nCreate a Table of Contents for you worksheets in a workbook \nMoving data from multiple sheets to a single sheet \nText to columns on all columns to apply number format \nCreate a new sheet for each item in an Autofilter \nCopy all Charts to PowerPoint \n\n\nVisual Basic Forms  \n\nWhat is a VB Form?  \nBuilding a Basic Form \nWorking with Modules \nRenaming Modules  \nChanging Form Properties  \nForm Controls  \n\nText Boxes  \nLabels  \nCombo Boxes  \nCheck Boxes  \n\n\nDisplaying the forms \n\nMake your form appear \nClosing the form \nAdding VB Code to your Form  \n\n\n\n\n\nNote: This course will be taught using the windows operating system environment \n\n\nReady to Advance Your Career?\nJoin professionals across the Carolinas who trust Catapult for professional development. \nRegister Now →\n​
URL:https://letscatapult.org/event/excel-macros-and-intro-to-vba-building-tools-and-eliminating-repetition-2026-12-09/
LOCATION:Catapult – Charlotte\, 9140 Arrowpoint Blvd.\, Suite 140\, Charlotte\, NC\, 28273\, United States
CATEGORIES:Technology & Digital Skills
ATTACH;FMTTYPE=image/png:https://letscatapult.org/wp-content/uploads/2026/08/TS_Thumbnail_new-7nv3l8.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20261209T090000
DTEND;TZID=America/New_York:20261209T160000
DTSTAMP:20260804T185422Z
CREATED:20260804T185422Z
LAST-MODIFIED:20260804T185422Z
UID:40956-1796806800-1796832000@letscatapult.org
SUMMARY:Excel Macros & Intro to VBA: Building Tools & Eliminating Repetition
DESCRIPTION:Technology & Digital Skills \nWednesday\, December 9\, 2026 · Virtual Live \n\nRegister Now → \n\n\nCourse Details \n\nFormatVirtual Live\nLocationVirtual Live (Online)\nDate & TimeWednesday\, December 9\, 20269:00 AM – 4:00 PM ET\nPrice$309Member · Non-member: $369\nFacilitatorCatapult HR Specialists\nSeats10 seats9 available\n\n\n\nExcel macros and VBA are utilized to automate repetitive tasks\, customize Excel's functions\, and streamline data processing. With VBA\, custom functions and procedures can be created\, making complex calculations and data manipulation possible\, extending Excel's capabilities\, and making it a more powerful and efficient tool for data analysis and reporting. \n \nProgram Level: Intermediate \nPrerequisites: The student must be a current Excel user and have taken at least Excel I and II or have equivalent experience. \n \nContents: \n\nUnderstanding Macros \n\nWhat is a Macro?  \n\nWhat is VBA  \n\nDisplaying the Developer Ribbon Tab  \nMacro Security \nRecording a Macro  \n\n\nStoring Macros  \n\nThe Personal Macro Workbook  \nUsing Macro-Enabled Workbooks  \n\n\nRunning Macros  \n\n\nCreating a Macro Icon for the Toolbar   \n\n\nCreating Macros 3 ways \n\nAbsolute Macros \n\nCreate a macro for a report or repetitive data set \n\n\nRelative reference macros \n\nCreate a macro that will work on any column \n\n\nRelative reference macro starting from a selection  \n\nCreate a macro that will format any selection \n\n\n\n\nCreate Functional tools \n\nCreate a macro to clean and trim a column \nCreate a macro to add leading zeros to a column \n\n\nIntroduction to the VBA interface \n\nVisual Basic button / Developer Ribbon \nSetting up and understanding the VBA Editor \nUsing the Project Window / Hiding the Properties Window \nOpening / closing and saving your work \n\n\nUsing pre-built code to do what excel does not \n\nSaving a workbook before closing \nCreate a backup copy with today’s date in the title \nCreate a new workbook for each worksheet \nCreate a Table of Contents for you worksheets in a workbook \nMoving data from multiple sheets to a single sheet \nText to columns on all columns to apply number format \nCreate a new sheet for each item in an Autofilter \nCopy all Charts to PowerPoint \n\n\nVisual Basic Forms  \n\nWhat is a VB Form?  \nBuilding a Basic Form \nWorking with Modules \nRenaming Modules  \nChanging Form Properties  \nForm Controls  \n\nText Boxes  \nLabels  \nCombo Boxes  \nCheck Boxes  \n\n\nDisplaying the forms \n\nMake your form appear \nClosing the form \nAdding VB Code to your Form  \n\n\n\n\n\nNote: This course will be taught using the windows operating system environment \n\n\nReady to Advance Your Career?\nJoin professionals across the Carolinas who trust Catapult for professional development. \nRegister Now →\n​
URL:https://letscatapult.org/event/excel-macros-intro-to-vba-building-tools-eliminating-repetition-2/
LOCATION:Virtual Live (Online)
CATEGORIES:Technology & Digital Skills
ATTACH;FMTTYPE=image/png:https://letscatapult.org/wp-content/uploads/2026/08/TS_Thumbnail_new-7nv3l8.png
END:VEVENT
END:VCALENDAR