This video reveals two powerful Excel data cleanup tricks to format and validate your data, to fix data upload errors and save you time. You'll learn how to quickly set up sequential numbering that dynamically restarts for each unique record on your Excel spreadsheet. Then, I'll show you how to check for duplicate entries before you upload to your database.

First, learn how to create a simple Excel IF formula to add repeating sequential numbers that restart for each unique record. Using our HRIS example, you'll see how to automatically number an employee's skills (1, 2, 3...) and have the count reset for the next employee. This is a game-changer for data that requires a unique, sequential ID for each related entry.

Next, we'll dive into PivotTables to perform a quick and easy duplicate check. This is a crucial step for maintaining data integrity. I'll show you how to:

- Set up a PivotTable to count your records.
- Use conditional formatting to instantly flag duplicate entries.
- Pinpoint and fix the exact rows that need to be cleaned up before you upload.

Whether you work with HR, finance, sales, or supply chain data, these essential tips will help you prepare your spreadsheets for a clean upload into any system.

What you'll learn in this video:

- How to add dynamic sequential numbers that restart for each unique record.
- A powerful PivotTable method to find and flag duplicate records.
- The essential steps to clean and validate your data for a successful database upload.

Free Download: Get the exact sample file used in this tutorial to follow along: https://docs.google.com/spreadsheets/d/1nLHCsYOzKtdmP10KWVPOwTFE4yTFVeor/edit?usp=sharing&ouid=105753634361526165736&rtpof=true&sd=true
To download the file: Click the link, then go to File - Download - Microsoft Excel (.xlsx).

#ExcelTips #DataValidation #HRData #HRTech #HRConsultant #PivotTable #DataAudit #HumanResources #HRIS #ExcelTutorial, #DataAnalytics, #DatabaseManagement #DataIntegrity

TIMESTAMPS
00:00 Introduction to Dynamic Numbering & Data Validation
00:42 How to Sort Your Data for Sequential Numbering
01:13 Creating the IF Formula for Sequential Numbers
02:20 Pasting Values to Lock Your Numbering
02:49 How to Use a PivotTable to Check for Duplicates
04:08 Using Conditional Formatting to Flag Duplicates
04:33 Finding and Deleting Duplicate Entries in Your Spreadsheet

FREE COURSE: How To Create Fillable Forms in Microsoft Word - A Step-by-Step Guide
Create Fillable Forms, Surveys & Questionnaires in Microsoft Word like a Pro!
https://youtu.be/438pCPCSuG4

WATCH NEXT Convert Columns to Rows with Power Query: https://youtu.be/0kA114-Ts24

TEMPLATES
Check out my helpful list of templates available for purchase: https://creatoriq.cc/43c51cv
Thank you for supporting my channel!

FREE DOWNLOADS
Visit https://mailchi.mp/6a0859ea0844/sharonsmithhrformulasdownload to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.

CONNECT WITH ME
Visit my website: https://www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: https://www.linkedin.com/in/sharonsmithhr
Twitter: https://twitter.com/SharonSmithHR
Instagram: https://www.instagram.com/sharonsmithlearning/
Facebook: https://www.facebook.com/SharonSmithLearning

GEAR
Blue Yeti USB Microphone: https://amzn.to/2W4SbzV (Great for recording professional sounding audio for your videos!)
Silent Mouse: https://amzn.to/3pxpc25 (This is a really cool mouse!)
Screen Recording Software: https://techsmith.z6rjha.net/NZG5b
Green Screen: https://amzn.to/2DnHsY2
Camera: https://amzn.to/39KvpQA
Live Stream Tool: https://amzn.to/2VFJyID (Turns your DSLR into a top notch webcam)

RESOURCES
JotForm: https://www.jotform.com/pricing/?utm_source=sharon-smith&utm_campaign=jf1&utm_medium=blog
TechSmith Camtasia Screen Recording: https://techsmith.z6rjha.net/SharonSmithHR

Links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!

SUPPORT THIS CHANNEL
- Hit the "$Thanks" button on any video, or
- Donate through my PayPal link: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=AJJ6SXERNDMYA&source=url

If you found this content helpful, please consider donating to my channel. Your donation, no matter what amount, is greatly appreciated and goes towards producing more content that enhances your productivity and elevates your skills.
You can also support my channel just by watching, liking, and sharing all my videos! Thank you so much!

PLAYLISTS
Excel Tutorials: https://www.youtube.com/playlist?list=PLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90

Excel Tips & Tricks: https://www.youtube.com/playlist?list=PLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW