I will fix excel formulas and vba codes

Pakistan

I speak English, Urdu, Punjabi

13 orders completed

Data Automtion Done

Welcome meet myself Asif Ashiq, working as office assistant in FEDEX. I can help my buyers in services like MsOffice (Word, Excel, Power Point, Outlook), Data Entry, Virtual Assistant and other offici...
About this Gig

With 15+ years in data analysis, I create or fix custom no-code apps for businesses.

Need inventory, CRM, or data entry apps? Ill build user-friendly solutions with automation, charts, and seamless spreadsheet integration.


improving your files so you can focus on your work instead of fighting spreadsheets.

Services I can help you with:

  • Fix Excel errors (#VALUE, #N/A, #REF, #DIV/0, etc.)
  • Repair and create formulas (IF, V LOOKUP, INDEX/MATCH, SUM IF(S), DATE, TEXT, etc.)
  • Data cleaning & formatting
  • Remove duplicates and improve sheet layout
  • Pivot tables (summary reports)
  • Excel data validation
  • Improve speed and file performance
  • Fix broken links and references

My service Areas:

  • Advanced Formulas >> Nested Loop>> VLOOKUP, HLOOKUP, INDEX, MATCH, IF, OR, AND, NOT, IFERROR, Left, Right, Len, Mid, Find, Substitute, Concatenate, Count if, Count ifs, Max, Min, Large, Small, Round, Round Down, Round UP, Sum, SUMIF, SUMIFS, all date function.
  • Pivot Tables >> Automated Dashboard, Pivot Chart, Slicer, Timeline
  • Excel Template
  • Excel Power Query
  • Excel Power Pivot
  • Solve Macros
  • Fix Errors >> #NUM!, #REF!, #VALUE! #DIV/0, #N/A, #NAME?, #NULL! etc.

Solve any excel formula related problem.

Platform:

Excel

Google Sheets

Development technology:

VBA

Google Apps Script

Expertise:

Formatting

Fixing

Forms

Pivot tables

Formulas

My Portfolio

Other Data Processing Services I Offer