I will fix excel formulas, clean messy data, and repair your spreadsheets

Nepal

I speak English

Data Analyzer

Need a data-driven financial expert to manage your books and analyze your numbers? With 7 years of experience, I bridge the gap between accounting and advanced data manipulation to handle complex fin...
About this Gig

My Services Include:

  • Formula Fixing & Creation: VLOOKUP, XLOOKUP, INDEX/MATCH, IF/THEN statements, Nested IFs, SUMIFS, COUNTIF, and dynamic arrays.
  • Error Resolution: Quickly fixing #N/A, #VALUE!, #REF!, #DIV/0!, and circular reference errors.
  • Data Cleaning: Removing duplicates, splitting text into columns, trimming spaces, and standardizing formatting.
  • Spreadsheet Automation: Creating dropdown lists, data validation, conditional formatting, and interactive dashboards.
  • Data Summary: Organizing and summarizing large datasets using Pivot Tables and Charts.


Platform:

Excel

Google Sheets

Development technology:

Excel

Power BI

VLOOKUP

Expertise:

Formatting

Fixing

Pivot tables

Formulas

Cleaning