Excel Data Cleaning & Quality Assurance by Kenan Cengiz GülerExcel Data Cleaning & Quality Assurance by Kenan Cengiz Güler

Excel Data Cleaning & Quality Assurance

Portfolio project
Kenan Cengiz Güler

Overview

An independent sample project showing how I clean a messy spreadsheet without losing track of what changed. The dataset is synthetic; no client data is used.

Objective

Turn 60 inconsistent raw records into a dataset that can be used with confidence, and document every exclusion.

My role

I defined the scope and the cleaning rules, built the workbook with AI-assisted tooling, and reviewed and tested the result.

Approach

The raw data stays untouched on its own sheet. A clean sheet applies formulas that standardize formats and classify each record as accepted, duplicate, missing company or invalid amount. A QA summary reconciles the counts back to the input.

Tools

Microsoft Excel (formulas, data validation); AI-assisted build and checks.

Deliverables

One workbook with three sheets: QA Summary, Raw Data and Clean Data.

Results

60 input records: 50 accepted, 5 duplicates, 3 missing company names, 2 invalid amounts, 0 unreconciled. Changing an input updates the summary; this was tested and the inputs restored. This is an independent sample, not a paid client project.

0 likes · 1 view · Oct 11, 2026

Independent sample: 60 raw records cleaned into a validated dataset with a documented QA summary. Synthetic data.

Tags