
Muhammad Abbas
Excel Data Cleaning and Spreadsheet Specialist

See my services

Portfolio
Work experience
Excel Data Specialist
Freelance Projects • Self-employed
Aug 2024 - Present • 1 yr 9 mos
Providing Excel data cleaning, formatting, and organization services for various projects and learning assignments. KEY SKILLS DEVELOPED: Data Cleaning & Standardization - Removed duplicates from customer and product databases (500+ row datasets) - Standardized name formatting (Proper Case), email addresses (lowercase), phone numbers (consistent format) - Fixed date inconsistencies across multiple formats - Handled missing values and blank cells professionally Excel Formulas & Functions - VLOOKUP for product pricing and data matching - SUMIFS, COUNTIFS, AVERAGEIFS for conditional calculations - IF statements for logic and validation - Text functions (TRIM, PROPER, CONCATENATE) for data cleanup - Error handling with IFERROR Template Design & Automation - Created invoice templates with automatic calculations - Built expense tracking sheets with category summaries - Designed attendance systems with percentage calculations - Developed inventory trackers with stock alerts Data Validation & Quality Control - Implemented dropdown lists for consistent data entry - Set up conditional formatting to highlight errors and alerts - Created data validation rules to prevent future mistakes - Quality-checked every project for accuracy before completion TECHNICAL PROFICIENCY: - Microsoft Excel (formulas, formatting, data tools) - Data cleaning techniques and best practices - Template design with user-friendly layouts - Attention to detail and accuracy standards