I will create and fix excel formulas and xlookup

Singapore

I speak Chinese, English

Excel Formula, Data Specialist

Hi! I'm an administrative professional with hands-on experience in Microsoft Excel and data management. I can help with Excel formulas, VLOOKUP, XLOOKUP, SUMIF, data matching, conditional formatting,...
About this Gig

Need help with Excel formulas or data matching?

I can help you create, fix, and optimize Excel formulas to make your spreadsheet work automated, clean, and accurate.

My Services Include:

  • Formula Creation & Fixing: SUM, SUMIF, COUNTIF, IF, IFERROR, Nested IFs
  • Data Lookup & Matching: VLOOKUP, XLOOKUP, INDEX/MATCH
  • Data Organization: Sorting, filtering, removing duplicates, and data cleaning
  • Data Validation: Dropdown lists, input restrictions
  • Conditional Formatting: Highlighting rules, status tracking

Why Choose Me?

  • Accurate and double-checked formula results
  • Clear and fast communication
  • Neat and well-structured Excel spreadsheets
  • On-time delivery

Important Notes Before Ordering:

  • Scope: Each Additional Formula ($5) covers 1 extra formula task.
  • Custom Requests: Please message me with a brief explanation and sample file before placing an order. I will review your requirements to ensure a perfect fit!

I look forward to helping you make your Excel tasks easier and faster!

Platform:

Excel

•

Google Sheets

Development technology:

Excel

•

VLOOKUP

Expertise:

Formatting

•

Fixing

•

Formulas

•

Functions

•

Cleaning