Mudassar Hameed

Freelance Excel & Data Solutions Specialist

Freelance Academy • Selbstständig

Oct 2020 - Present • 6 yrs 1 mo

Excel data specialist handling the full data workflow end to end: from raw, messy files to clean datasets, verified results and a clear report summary that decision-makers could act on. END-TO-END SCOPE • Data audit: reviewed files to identify duplicates, inconsistent formats, blank or invalid values, broken formulas and mismatched totals • Data cleaning: removed duplicates, standardised dates, currency, names and text, and applied validation rules so errors did not return • Accuracy and verification: rebuilt totals with formulas, cross-checked results and confirmed figures before sharing • Analysis: built pivot tables and charts to reveal totals, trends, top performers and exceptions • Reporting: delivered a clear summary of key findings, ready for managers, owners and clients • Automation: used Power Query to clean recurring files consistently and cut repeat work • Consolidation: combined files from multiple sources into one reliable dataset STANDARDS I WORKED TO • Original data never altered: all work done on a copy • Every change documented in a Changes List with counts • Rules agreed upfront: what to delete, what to flag, how to treat blanks • Formats matched to the requirement (DD/MM/YYYY or MM/DD/YYYY, £, $, A$) • Strict confidentiality and clear, timely communication Tools: Microsoft Excel, Power Query, Pivot Tables, advanced formulas, data validation.