BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Catapult HR - ECPv6.17.3//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:20260908T120000
DTEND;TZID=America/New_York:20261119T133000
DTSTAMP:20260825T161137Z
CREATED:20260814T160104Z
LAST-MODIFIED:20260825T161137Z
UID:41841-1788868800-1795095000@letscatapult.org
SUMMARY:PHR/SPHR/SHRM-CP/SHRM-SC Certification Prep Study Course
DESCRIPTION:HRCI & SHRM Certification \nSeptember 8 – November 19\, 2026 · Virtual Live \n\nRegister Now → \n\n\nCourse Details \n\nFormatVirtual Live\nLocationVirtual Live (Online)\nDate & TimeSeptember 8 – November 19\, 202612:00 PM ET start\nPriceSee registration\nFacilitatorDavid Siler\nSeats900 seats897 available\n\n\n\nWould you like to take a live\, high-quality study prep course to prepare for the newest HR certification exams but really need scheduling flexibility? Now\, from the comfort of your own home or office\, you can participate in one of the most comprehensive HR cert-prep (certification preparatory) programs to be found anywhere. \n \nGetting a PHR® (Professional in Human Resources®)\, SHRM-CP (Certified Professional)\, SHRM-SCP (Senior Certified Professional) or SPHR (Senior Professional in Human Resources®) certification will distinguish you from your peers\, build your self-confidence\, and earn you greater respect within the HR profession. \n \nDistinctive Human Resources has a reputation for being the top-quality certification prep provider with over 25 years of experience helping thousands of people pass their PHR or SPHR certification. Developed by David Siler\, SPHR\, GPHR\, SHRM-SCP\, who is a leader both in certification prep and in the HR field\, our program targets the high-probability items on the exam so you have the best chance of passing on the first try. This program will eliminate unnecessary study time and provide a step-by-step preparation process led by world-class instructors\, including the author and creator of the program. This program enjoys a 90%+ pass rate! \n \nRather than rely solely on book learning\, we focus on the types of learning materials adults prefer: audio files\, lecture\, test taking skills\, quizzes (over 1500 questions)\, virtual flashcards\, and videos. Plus\, participants will have access to a live weekly Q&A hour-of-power (as it is fondly known) with David Siler leading this informative and powerful study session. \n \nWhile our singular study guide provides a good understanding of topics\, it is the lecture from our distinguished instructors that nail the points home. Additionally\, we are the ONLY provider to offer The Seven Princes\, which detail the seven main principles of HRM that show up all over the tests. Ask around\, the Seven Princes\, written by David Siler\, is your secret weapon that no one else can offer! Materials will ship approximately two weeks prior to the start of class. \n \nTools and Resources \nIn addition to exceptional instruction and interaction\, you will receive many tools to prepare yourself for the exam\, including: \n\nStudy Manual\nPowerPoint Booklet of Slides\nDavid Siler's "Seven Princes" book\nFlashcards available virtually\nDownloadable/streaming audio files\nOn-line access to hundreds of practice exam questions\nOn-line access to testing games and videos on tough topics\nOn-line access to Learning Management System (LMS)\nTalk directly with the Instructor during “Online Office Hours”\nBest Practices on how to take standardized tests\nComprehensive Final Practice Exam\n\n \nNot sure if you're ready? Register to attend the FREE 60-minute LIVE preview webinar of the HR Certification Preparation Study Course: What’s It All About? to learn more! \n \nImportant Things to Know \n\nMaterials Shipping fee will be added at checkout.\nAll classes are virtual with live instruction.\nThe times for the study courses are Eastern Standard Time. \nFor a listing of specific class dates within a session\, click the blue dates button.\nIn order to receive course materials\, all registrants must pay for the course on or before the first day of the class.\nTo ensure payment is received on our before the first day of class\, it is recommended that you pay using a credit card. If paying by check\, please mail a minimum of two weeks prior to the start of class to ensure receipt and posting of payment\nMaterials will arrive on or around the start date of your session.\nIf you cancel after receiving the course materials\, a nonrefundable materials fee of $500 will be charged.\nWebinar log-in instructions will be sent out 24 hours prior to the session\, and again 1 hour before the class begins.\nYou will be given access to the LMS online resource the first day of your class. \n\n \nLate Registrations \n\nOnce a class is no longer available on our website (closed)\, please choose a future class date. \nIf you need to register for a closed class\, you may contact Learning@letscatapult.org for registration. \nThe only form of payment accepted for a closed class is a credit card.\nA $150 late fee will be added to the cost of the class to process a late registration. \nWe cannot guarantee that your materials will arrive in time for the first night of class.  \n\nFor more information regarding the online exam scheduling and delivery go to www.hrci.org and www.shrm.org. \n \nAbout the Instructors \nDavid Siler is the founder and Managing Partner of Distinctive HR\, Inc. He is the author and creator of the DHR learning system for HR certification. He has 40 years’ experience as a senior level HR practitioner and 30 years' experience guiding candidates through the HR cert-prep process. He currently holds all the major certifications from both HRCI and SHRM. David is considered a thought leader in the field of HR and is an award-winning lecturer on the subject. He was an HR executive with a Fortune 100 organization prior to dedicating his career to HR certification. He has a Master’s degree in Psychology. \n  \nSince 2012\, Ken Defeo has been with Distinctive HR\, Inc. as an instructor teaching exam preparation programs. Holding both the SPHR and the SHRM-SCP\, Ken has also been working in compensation and benefits for over 27 years. He is currently the Vice President for APAC Compensation with GXO Logistics\, Inc. Some examples of his functional areas of expertise include: Strategic Planning • Compensation and Benefits • Affirmative Action • Compliance • Employment Law • Talent Acquisition • Employee Relations • Employee Engagement • Talent Management. He has a bachelor’s degree in Business Administration and Economics. \n  \nBrittany Siler has 7+years of experience in all areas of HR certification preparation. As one of the candidates in the first group to take the aPHR exam she has successfully obtained all the HRCI and SHRM core certifications (aPHR\, PHR\, SPHR\, SHRM-CP\, & SHRM-SCP). She is currently SPHR and SHRM-SCP certified. Brittany has participated in the inception of new instructor led programs\, edited quiz and text materials\, as well as created instructional videos. She has experience teaching for a major university and has brought that knowledge to DHR where she is one of our aPHR and HR Certification instructors. She has a BS in animal science and a BA in psychology. \n \nNick Tatarian has 7+ years of HR experience in healthcare\, medical technology\, and retail sectors\, bringing a strategic approach to aligning HR initiatives with business goals. He holds SPHR and SHRM-SCP certifications and a degree in Psychology. He is currently the HR Manager for US operations at XVIVO\, a global leader in medical technology\, overseeing all facets of human resources\, including payroll\, benefits\, employee relations\, talent acquisition\, performance management\, policy development\, learning and development\, and compensation. \n \nTestimonials \n "From start to finish\, this course was the key to my success. The live instruction made complex topics clear and engaging\, helping me understand how to think like a strategic HR leader rather than just memorize content. David's teaching style made it easy to stay focused and motivated through some very dense material. \n \nThe practice exams were absolutely essential. They didn’t just help me study\, they trained me to think critically\, spot traps\, and approach each question from a strategic perspective. I went into the exam confident and prepared because I had already practiced at that level. \n \nAnd of course\, David’s Seven Princes framework tied everything together. That model helped me truly grasp the mindset and competencies the SPHR exam is built around. It’s not about being tactical\, it’s about thinking like a strategy driven HR Pro. The Seven Princes kept me grounded in that mindset throughout my studies and during the exam itself. \n \nIf you're serious about passing the SPHR\, I cannot recommend this course highly enough. It's more than just prep; it's a full reframe of how you approach HR leadership." \nHannah Royal\, SPHR\, CPSP – HR Generalist  \n \n“I absolutely LOVED this web-based PHR/SPHR Certification Study Course. It was so convenient for my busy work schedule\, I could attend class at work or home. I have taken the “traditional” SHRM 12 week course years ago and talk about boring lectures. David’s prep course is hands down the best. I have recommended his prep material and now his web-based study course to all HR professionals seeking to slay the beast! Thanks again for your passion in helping the HR profession!” \nTammy Schmitt – HR Manager – CertainTeed Corp \n \n"It didn’t take long for me to realize that the benefits of your program extend far beyond simply being ready for the test. The variety of learning methods – audio CDs\, on-line sample tests and games\, flash cards\, and study manual – was a tremendous help in absorbing an overwhelming amount of information. I especially appreciate the test taking tips! And our classroom lectures not only prepared me for the exam\, but truly got me engaged in all aspects of Human Resources. I’ll miss the weekly opportunities to get your professional input and to discuss current HR topics with colleagues." \nLaura Tomanelli\, SPHR – Human Resources Generalist – Village of Pinehurst \n \n"I cannot say enough about the comprehensive PHR prep course presented by Distinctive HR through CAI. David Siler’s exceptionally prepared lectures and materials covered every base in my exam prep and increased my confidence ten-fold. The study materials\, in addition to the classes\, enabled an ‘old’ student\, to successfully complete a very intimidating exam. I would highly recommend this course as the best preparation around!" \nNancy M. Rodgers\, PHR – HR Manager – Rural Health Group\, Inc. \n \n————————————————- \nThe HR Certification Institute® (HRCI®) does not endorse any particular preparation program or offering. We encourage prospective certification holders to use a variety of resources that reflect their learning styles and needs. Purchasing a certification product is NOT required and HRCI does not guarantee that an individual will pass based on the purchase of a certification preparation product. \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/phr-sphr-shrm-cp-shrm-sc-certification-prep-study-course-2026-09-08/
LOCATION:Virtual Live (Online)
CATEGORIES:HR & Compliance
ATTACH;FMTTYPE=image/png:https://letscatapult.org/wp-content/uploads/2026/08/HR_Thumbnail-XrwoqZ.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20261005T190000
DTEND;TZID=America/New_York:20261207T210000
DTSTAMP:20260820T190052Z
CREATED:20260820T190052Z
LAST-MODIFIED:20260820T190052Z
UID:41859-1791226800-1796677200@letscatapult.org
SUMMARY:PHR/SPHR/SHRM-CP/SHRM-SC Certification Prep Study Course
DESCRIPTION:HRCI & SHRM Certification \nOctober 5 – December 7\, 2026 · Virtual Live \n\nRegister Now → \n\n\nCourse Details \n\nFormatVirtual Live\nLocationVirtual Live (Online)\nDate & TimeOctober 5 – December 7\, 20267:00 PM ET start\nPriceSee registration\nFacilitatorBrittany Siler\nSeats900 seats897 available\n\n\n\nWould you like to take a live\, high-quality study prep course to prepare for the newest HR certification exams but really need scheduling flexibility? Now\, from the comfort of your own home or office\, you can participate in one of the most comprehensive HR cert-prep (certification preparatory) programs to be found anywhere. \n \nGetting a PHR® (Professional in Human Resources®)\, SHRM-CP (Certified Professional)\, SHRM-SCP (Senior Certified Professional) or SPHR (Senior Professional in Human Resources®) certification will distinguish you from your peers\, build your self-confidence\, and earn you greater respect within the HR profession. \n \nDistinctive Human Resources has a reputation for being the top-quality certification prep provider with over 25 years of experience helping thousands of people pass their PHR or SPHR certification. Developed by David Siler\, SPHR\, GPHR\, SHRM-SCP\, who is a leader both in certification prep and in the HR field\, our program targets the high-probability items on the exam so you have the best chance of passing on the first try. This program will eliminate unnecessary study time and provide a step-by-step preparation process led by world-class instructors\, including the author and creator of the program. This program enjoys a 90%+ pass rate! \n \nRather than rely solely on book learning\, we focus on the types of learning materials adults prefer: audio files\, lecture\, test taking skills\, quizzes (over 1500 questions)\, virtual flashcards\, and videos. Plus\, participants will have access to a live weekly Q&A hour-of-power (as it is fondly known) with David Siler leading this informative and powerful study session. \n \nWhile our singular study guide provides a good understanding of topics\, it is the lecture from our distinguished instructors that nail the points home. Additionally\, we are the ONLY provider to offer The Seven Princes\, which detail the seven main principles of HRM that show up all over the tests. Ask around\, the Seven Princes\, written by David Siler\, is your secret weapon that no one else can offer! Materials will ship approximately two weeks prior to the start of class. \n \nTools and Resources \nIn addition to exceptional instruction and interaction\, you will receive many tools to prepare yourself for the exam\, including: \n\nStudy Manual\nPowerPoint Booklet of Slides\nDavid Siler's "Seven Princes" book\nFlashcards available virtually\nDownloadable/streaming audio files\nOn-line access to hundreds of practice exam questions\nOn-line access to testing games and videos on tough topics\nOn-line access to Learning Management System (LMS)\nTalk directly with the Instructor during “Online Office Hours”\nBest Practices on how to take standardized tests\nComprehensive Final Practice Exam\n\n \nNot sure if you're ready? Register to attend the FREE 60-minute LIVE preview webinar of the HR Certification Preparation Study Course: What’s It All About? to learn more! \n \nImportant Things to Know \n\nMaterials Shipping fee will be added at checkout.\nAll classes are virtual with live instruction.\nThe times for the study courses are Eastern Standard Time. \nFor a listing of specific class dates within a session\, click the blue dates button.\nIn order to receive course materials\, all registrants must pay for the course on or before the first day of the class.\nTo ensure payment is received on our before the first day of class\, it is recommended that you pay using a credit card. If paying by check\, please mail a minimum of two weeks prior to the start of class to ensure receipt and posting of payment\nMaterials will arrive on or around the start date of your session.\nIf you cancel after receiving the course materials\, a nonrefundable materials fee of $500 will be charged.\nWebinar log-in instructions will be sent out 24 hours prior to the session\, and again 1 hour before the class begins.\nYou will be given access to the LMS online resource the first day of your class. \n\n \nLate Registrations \n\nOnce a class is no longer available on our website (closed)\, please choose a future class date. \nIf you need to register for a closed class\, you may contact Learning@letscatapult.org for registration. \nThe only form of payment accepted for a closed class is a credit card.\nA $150 late fee will be added to the cost of the class to process a late registration. \nWe cannot guarantee that your materials will arrive in time for the first night of class.  \n\nFor more information regarding the online exam scheduling and delivery go to www.hrci.org and www.shrm.org. \n \nAbout the Instructors \nDavid Siler is the founder and Managing Partner of Distinctive HR\, Inc. He is the author and creator of the DHR learning system for HR certification. He has 40 years’ experience as a senior level HR practitioner and 30 years' experience guiding candidates through the HR cert-prep process. He currently holds all the major certifications from both HRCI and SHRM. David is considered a thought leader in the field of HR and is an award-winning lecturer on the subject. He was an HR executive with a Fortune 100 organization prior to dedicating his career to HR certification. He has a Master’s degree in Psychology. \n  \nSince 2012\, Ken Defeo has been with Distinctive HR\, Inc. as an instructor teaching exam preparation programs. Holding both the SPHR and the SHRM-SCP\, Ken has also been working in compensation and benefits for over 27 years. He is currently the Vice President for APAC Compensation with GXO Logistics\, Inc. Some examples of his functional areas of expertise include: Strategic Planning • Compensation and Benefits • Affirmative Action • Compliance • Employment Law • Talent Acquisition • Employee Relations • Employee Engagement • Talent Management. He has a bachelor’s degree in Business Administration and Economics. \n  \nBrittany Siler has 7+years of experience in all areas of HR certification preparation. As one of the candidates in the first group to take the aPHR exam she has successfully obtained all the HRCI and SHRM core certifications (aPHR\, PHR\, SPHR\, SHRM-CP\, & SHRM-SCP). She is currently SPHR and SHRM-SCP certified. Brittany has participated in the inception of new instructor led programs\, edited quiz and text materials\, as well as created instructional videos. She has experience teaching for a major university and has brought that knowledge to DHR where she is one of our aPHR and HR Certification instructors. She has a BS in animal science and a BA in psychology. \n \nNick Tatarian has 7+ years of HR experience in healthcare\, medical technology\, and retail sectors\, bringing a strategic approach to aligning HR initiatives with business goals. He holds SPHR and SHRM-SCP certifications and a degree in Psychology. He is currently the HR Manager for US operations at XVIVO\, a global leader in medical technology\, overseeing all facets of human resources\, including payroll\, benefits\, employee relations\, talent acquisition\, performance management\, policy development\, learning and development\, and compensation. \n \nTestimonials \n "From start to finish\, this course was the key to my success. The live instruction made complex topics clear and engaging\, helping me understand how to think like a strategic HR leader rather than just memorize content. David's teaching style made it easy to stay focused and motivated through some very dense material. \n \nThe practice exams were absolutely essential. They didn’t just help me study\, they trained me to think critically\, spot traps\, and approach each question from a strategic perspective. I went into the exam confident and prepared because I had already practiced at that level. \n \nAnd of course\, David’s Seven Princes framework tied everything together. That model helped me truly grasp the mindset and competencies the SPHR exam is built around. It’s not about being tactical\, it’s about thinking like a strategy driven HR Pro. The Seven Princes kept me grounded in that mindset throughout my studies and during the exam itself. \n \nIf you're serious about passing the SPHR\, I cannot recommend this course highly enough. It's more than just prep; it's a full reframe of how you approach HR leadership." \nHannah Royal\, SPHR\, CPSP – HR Generalist  \n \n“I absolutely LOVED this web-based PHR/SPHR Certification Study Course. It was so convenient for my busy work schedule\, I could attend class at work or home. I have taken the “traditional” SHRM 12 week course years ago and talk about boring lectures. David’s prep course is hands down the best. I have recommended his prep material and now his web-based study course to all HR professionals seeking to slay the beast! Thanks again for your passion in helping the HR profession!” \nTammy Schmitt – HR Manager – CertainTeed Corp \n \n"It didn’t take long for me to realize that the benefits of your program extend far beyond simply being ready for the test. The variety of learning methods – audio CDs\, on-line sample tests and games\, flash cards\, and study manual – was a tremendous help in absorbing an overwhelming amount of information. I especially appreciate the test taking tips! And our classroom lectures not only prepared me for the exam\, but truly got me engaged in all aspects of Human Resources. I’ll miss the weekly opportunities to get your professional input and to discuss current HR topics with colleagues." \nLaura Tomanelli\, SPHR – Human Resources Generalist – Village of Pinehurst \n \n"I cannot say enough about the comprehensive PHR prep course presented by Distinctive HR through CAI. David Siler’s exceptionally prepared lectures and materials covered every base in my exam prep and increased my confidence ten-fold. The study materials\, in addition to the classes\, enabled an ‘old’ student\, to successfully complete a very intimidating exam. I would highly recommend this course as the best preparation around!" \nNancy M. Rodgers\, PHR – HR Manager – Rural Health Group\, Inc. \n \n————————————————- \nThe HR Certification Institute® (HRCI®) does not endorse any particular preparation program or offering. We encourage prospective certification holders to use a variety of resources that reflect their learning styles and needs. Purchasing a certification product is NOT required and HRCI does not guarantee that an individual will pass based on the purchase of a certification preparation product. \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/phr-sphr-shrm-cp-shrm-sc-certification-prep-study-course-2026-10-05/
LOCATION:Virtual Live (Online)
CATEGORIES:HR & Compliance
ATTACH;FMTTYPE=image/png:https://letscatapult.org/wp-content/uploads/2026/08/HR_Thumbnail-XrwoqZ.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20261029T090000
DTEND;TZID=America/New_York:20261029T123000
DTSTAMP:20260824T150053Z
CREATED:20260824T150053Z
LAST-MODIFIED:20260824T150053Z
UID:41866-1793264400-1793277000@letscatapult.org
SUMMARY:The 1-Page HR Business Case
DESCRIPTION:HR & Compliance \nThursday\, October 29\, 2026 · Virtual Live · Almost full — only 2 seats left \n\nRegister Now → \n\n\nCourse Details \n\nFormatVirtual Live\nLocationVirtual Live (Online)\nDate & TimeThursday\, October 29\, 20269:00 AM – 12:30 PM ET\nPrice$0Member · Non-member: $99\nFacilitatorAshley Wood\nSeats15 seats2 available\n\n\n\nHow to build a one-page HR business case a CFO will actually read and act on. \nThe course covers speaking the executive's language\, putting a defensible dollar figure on a problem like turnover or a manager-development investment\, and pressure-testing the case so finance engages with it. Participants may submit a finished case to a Catapult HR Advisor for feedback after the course.  \n \nWho should attend:  \nHR practitioners and managers who need to secure budget or buy-in in the executive's language. \n \nParticipants leave ready to:  \n\nWalk into a CFO's office with a one-page case the CFO will read \nCatch the impulse to argue HR-to-HR and reframe it in leadership's language \nPut a defensible dollar number on a turnover or manager-development problem \nHear "there's no budget for that" as a prompt to come back restructured \nSubmit a real business case to a Catapult HR Advisor for review and calibration\n\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/the-1-page-hr-business-case-2026-10-29/
LOCATION:Virtual Live (Online)
CATEGORIES:HR & Compliance
ATTACH;FMTTYPE=image/png:https://letscatapult.org/wp-content/uploads/2026/08/HR_Thumbnail-XrwoqZ.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20261029T120000
DTEND;TZID=America/New_York:20261029T160000
DTSTAMP:20260811T220203Z
CREATED:20260811T220203Z
LAST-MODIFIED:20260811T220203Z
UID:1983-1793275200-1793289600@letscatapult.org
SUMMARY:MS Excel Data Cleaning Essentials
DESCRIPTION:Technology & Digital Skills \nThursday\, October 29\, 2026 · In Person · Charlotte \n\nRegister Now → \n\n\nCourse Details \n\nFormatIn Person\nLocationCharlotte\nDate & TimeThursday\, October 29\, 202612:00 PM – 4:00 PM ET\nPrice$289\nFacilitatorCatapult HR Specialists\nSeats10 seats10 available\n\n\n\nBefore diving into data analysis\, it’s critical to ensure your data is both accurate and usable. In this course\, you’ll learn key techniques to clean and manage "dirty data" that can hinder the analysis process. While preventing messy data is ideal\, this course will equip you with practical\, proven methods to transform inconsistent and inaccurate data into clean\, reliable datasets. \n \nThis course will help you establish best practices for data cleaning\, ensuring accuracy and consistency in your datasets for effective analysis. \n \nPrerequisites: The course requires that you have successfully completed Excel I and II. \n \nContents: \nRemove Unnecessary Data \n\nSave a copy of your data in a new tab or separate workbook\nUnhide all hidden rows\, columns\, and sheets\nRemove irrelevant or unnecessary columns\nDelete blank rows\nRun a spell check\nRemove extra spaces\nEliminate labels or unnecessary prefixes/suffixes\nIdentify and remove duplicate entries\n\n \nCorrect Data Inaccuracies \n\nUse Find and Replace to update incorrect values\nParse (separate) data into multiple columns\nCombine data when necessary\nManage missing values or blank cells effectively\nStandardize Data Formatting\nApply consistent capitalization\nConvert data to the correct types (e.g.\, date\, number\, text)\nRemove unnecessary formatting\nFormat data to enhance readability and usability\nCopy and Paste as Values to preserve clean data\n\n \nIdentify and Fix Errors \n\nHighlight and resolve errors in your dataset\nUse IFERROR to manage formulas and avoid calculation errors\n\n \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/ms-excel-data-cleaning-essentials-october-2026/
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:20261029T120000
DTEND;TZID=America/New_York:20261029T160000
DTSTAMP:20260811T220204Z
CREATED:20260811T220204Z
LAST-MODIFIED:20260811T220204Z
UID:1984-1793275200-1793289600@letscatapult.org
SUMMARY:MS Excel Data Cleaning Essentials
DESCRIPTION:Technology & Digital Skills \nThursday\, October 29\, 2026 · Virtual Live \n\nRegister Now → \n\n\nCourse Details \n\nFormatVirtual Live\nLocationVirtual Live (Online)\nDate & TimeThursday\, October 29\, 202612:00 PM – 4:00 PM ET\nPrice$289\nFacilitatorCatapult HR Specialists\nSeats10 seats10 available\n\n\n\nBefore diving into data analysis\, it’s critical to ensure your data is both accurate and usable. In this course\, you’ll learn key techniques to clean and manage "dirty data" that can hinder the analysis process. While preventing messy data is ideal\, this course will equip you with practical\, proven methods to transform inconsistent and inaccurate data into clean\, reliable datasets. \n \nThis course will help you establish best practices for data cleaning\, ensuring accuracy and consistency in your datasets for effective analysis. \n \nPrerequisites: The course requires that you have successfully completed Excel I and II. \n \nContents: \nRemove Unnecessary Data \n\nSave a copy of your data in a new tab or separate workbook\nUnhide all hidden rows\, columns\, and sheets\nRemove irrelevant or unnecessary columns\nDelete blank rows\nRun a spell check\nRemove extra spaces\nEliminate labels or unnecessary prefixes/suffixes\nIdentify and remove duplicate entries\n\n \nCorrect Data Inaccuracies \n\nUse Find and Replace to update incorrect values\nParse (separate) data into multiple columns\nCombine data when necessary\nManage missing values or blank cells effectively\nStandardize Data Formatting\nApply consistent capitalization\nConvert data to the correct types (e.g.\, date\, number\, text)\nRemove unnecessary formatting\nFormat data to enhance readability and usability\nCopy and Paste as Values to preserve clean data\n\n \nIdentify and Fix Errors \n\nHighlight and resolve errors in your dataset\nUse IFERROR to manage formulas and avoid calculation errors\n\n \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/ms-excel-data-cleaning-essentials-october-29-2026/
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