Excel Practice Project: Hotel Booking Data CleaningExcel Practice Project: Hotel Booking Data Cleaning
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Self-Created Practice Project
I worked on a practice hotel booking dataset where multiple data fields were combined into a single raw-data column.
Work completed:
Separated unstructured data into individual columns using Text to Columns
Organized Booking ID, Guest Name, City, Check-In Date, Check-Out Date, Number of Pax, Amount and Status
Improved the structure and readability of the spreadsheet
Prepared the dataset for easier filtering and further use
Tool: Microsoft Excel
Skills: Data Entry | Data Cleaning | Text to Columns | Data Organization | Spreadsheet Formatting
This is a self-created practice project and not client work
Post image
Post image
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started