I'm Barshon, an Excel data analyst and B.Sc. Mathematics student in Jashore, Bangladesh. I clean duplicate rows, fix inconsistent names and text-stored numbers, organise data into tidy Excel Tables, and build summaries with SUMIFS and PivotTables — including a 10,000-row sales file cleaned with a repeatable Power Query workflow. Every total is checked before I deliver.
My mathematics degree is built on logic and careful checking — and that's exactly how I work in Excel. A total is only useful if it's right, so I verify every summary against the source data before calling a file finished.
Right now I take on data cleaning and reporting work: removing duplicates, fixing inconsistent region and product names, converting text-stored prices back to numbers, formatting data as proper Excel Tables, and building region- and product-level summaries with SUMIFS and PivotTables. My largest finished sample cleaned 10,150 messy sales rows down to 8,130 — with an XLOOKUP price check that flagged 104 mismatched prices instead of hiding them.
For repeat files I clean with Power Query — Trim, Capitalize Each Word, proper number types, Remove Duplicates — so the next messy file is cleaned with one Refresh instead of hours of manual work, no macros needed. I also experiment with my own VBA toolbox for one-click automation, and I'm honest about what's client-ready and what's still practice.
I'm following a structured Advanced Excel roadmap — foundations and a 1-week intensive plan done, then advanced formulas, Power Query ETL, BI dashboards, and automation — building one portfolio project per stage. This site grows as each project lands: nothing here claims a skill before the work exists to show it.
I learn and build with free resources — Kaggle datasets and teachers like Leila Gharani and Kevin Stratvert — and I explain what I changed in every delivery, so you can trust the numbers.
Cleaning, summaries and Power Query refresh workflows are services I deliver today. Full dashboards and client-ready VBA automation are the pillars I'm building through my roadmap — available as each portfolio project is finished, never oversold before then.
Dynamic dashboards and KPI trackers built on complex PivotTables, so executives see the numbers that matter at a glance.
Messy files turned into tidy, analysis-ready tables — duplicates out, names and dates consistent, every total re-checked. Proven at 10,000-row scale.
One-click routines that take repetitive spreadsheet work off your plate. My reliable one-click method today is Power Query Refresh; VBA is the pillar I'm building next.
Two finished practice samples, shown in full — what came in, what changed, and the checked results. The 10K project is the flagship; the smaller sample below it is where the process started. New projects join this section as each roadmap stage is completed.
A 10,150-row messy sales file — duplicates, casing and extra-space mess, prices stored as text — cleaned into an 8,130-row Excel Table named Sales_Data, with live formulas, a formula-only Summary, a PivotTable summary and an XLOOKUP price check.
| Region | Revenue | Product | Revenue |
|---|---|---|---|
| Chattogram | 28,091,760 | Backpack | 52,136,380 |
| Khulna | 27,737,630 | Water Bottle | 20,264,325 |
| Dhaka | 27,689,545 | Notebook | 9,276,995 |
| Khulna units | 83,866 units | Pen | 1,841,235 |
One method, repeatable: the same cleaning runs in Power Query — Trim, Capitalize Each Word, number types, Remove Duplicates — so the next file like this is cleaned with one Refresh, and the 5-step process (Clean → Formulas → Summary → Pivot → Price check) stays identical every time.
A 14-row sales file with duplicates and inconsistencies, cleaned into a 12-row Excel Table ready for PivotTable analysis — with a written log of every change.
| Date | Product | Region | Units | Unit Price | Problem |
|---|---|---|---|---|---|
| 2026-01-05 | Notebook | Khulna | 12 | 150 | — |
| 05/01/2026 | notebook | khulna | 12 | 150 | Mixed date format, inconsistent names |
| 2026-01-05 | Notebook | Khulna | 12 | 150 | Exact duplicate row |
| 2026/01/07 | Pen | Chattogram | 40 | 25 | Third date format in one file |
| 07-01-2026 | Pen | Chattogram | 40 | 25 | Duplicate, disguised by date format |
| Date | Product | Region | Units | Unit Price | Total |
|---|---|---|---|---|---|
| 2026-01-05 | Notebook | Khulna | 12 | 150 | 1,800 |
| 2026-01-07 | Pen | Chattogram | 40 | 25 | 1,000 |
| 2026-01-09 | Backpack | Khulna | 8 | 850 | 6,800 |
| 2026-01-11 | Water Bottle | Khulna | 20 | 320 | 6,400 |
Honest label: this is a practice sample built from my own training data to demonstrate my cleaning process — it is not paid client work, and it isn't presented as such anywhere, including on Fiverr.
Ten of these are the skills on my Fiverr profile, at exactly the levels listed there — no skill is shown higher here than it is there. The two remaining rows are formula topics from my current daily practice, labelled “In daily practice” rather than given a level. Beginner means learned and practised in training files; intermediate means used confidently on real tasks.
Skills I use on deliverable work right now.
On my Fiverr profile at beginner level — each one gets a portfolio project on the roadmap.
Each stage ends with a portfolio project. When a project is finished, it appears in the Work section above and the matching service switches from “roadmap” to “available”.
Excel Tables, core calculations, logic formulas (IF / AND / OR), SUMIFS / COUNTIFS, XLOOKUP, data cleaning and PivotTables — finished with a 10,150-row portfolio project cleaned to 8,130 verified rows.
Dynamic arrays, advanced XLOOKUP and conditional logic for reporting models that update themselves. Alongside it: Power Query refresh cleaning for repeat files.
Extract, transform and merge messy multi-file datasets into refreshable pipelines.
Executive dashboards and KPI trackers built for decision-makers.
Custom macros that automate repetitive reporting work in one click. A personal VBA toolbox (clean, formulas, summary, pivot buttons) is already built and being tested; Power Query Refresh carries the one-click work until this lands.
I'll return it clean, checked, and ready to use — with a short log of everything that changed. Files from a few rows to 10,000+ are welcome; repeat files can be set up as a one-click Power Query refresh. The fastest way to reach me is through my Fiverr gig for data entry and Excel data cleaning.