BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Catapult HR - ECPv6.17.5//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
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:20261029T120000
DTEND;TZID=America/New_York:20261029T160000
DTSTAMP:20260921T180046Z
CREATED:20260921T180046Z
LAST-MODIFIED:20260921T180046Z
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$319\nFacilitatorMonica Lewis\nSeats10 seats7 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
END:VCALENDAR