I will fix excel formulas, errors, and clean up your messy data

Zimbabwe

I speak English, Shona, North Ndebele

Excel and Google Sheets Expert, Dashboards and Automation

I’m an IT Administrator and lecturer with a Master’s in Information Systems Management, and I build Excel and Google Sheets solutions that save businesses hours every week. I create: • Interactive da...
About this Gig

Is your spreadsheet full of #REF!, #N/A or #VALUE! errors? Are your formulas giving wrong totals, or is your data too messy to use?


I'm an IT Administrator and lecturer with an MSc in Information Systems Management. I fix broken Excel and Google Sheets files so they work properly and give you numbers you can trust.


What I can do for you:

- Fix broken or wrong formulas (VLOOKUP, XLOOKUP, INDEX/MATCH, SUMIFS, IF and more)

- Find and correct #REF!, #N/A, #VALUE!, #DIV/0! and circular reference errors

- Remove duplicates, extra spaces and blank rows

- Fix dates, numbers stored as text and inconsistent formats

- Split or merge columns (names, addresses, codes)

- Add dropdowns and data validation so errors don't come back


What you get:

- Your corrected file, ready to use

- A short note explaining every fix

- Fast, friendly communication


Works with Microsoft Excel and Google Sheets.


Please message me before ordering with a short description of the problem (or a sample file with private data removed) so I can confirm the right package.


Platform:

Excel

•

Google Sheets

•

Power BI

Development technology:

Google Apps Script

•

Excel

•

Power BI

Expertise:

Formatting

•

Formulas

•

Dashboard

•

Cleaning

•

Data validation

My Portfolio