I will write or fix excel formulas, xlookup, and pivot tables
Excel and Google Sheets Data Specialist
About this Gig
Need a formula written, fixed or explained? I will build it in your workbook so it calculates correctly and is easy to update later.
I work in Excel and Google Sheets. Typical requests include XLOOKUP and VLOOKUP, IF and nested IF, SUMIFS and COUNTIFS, INDEX/MATCH, text and date formulas, named ranges, data validation, conditional formatting and pivot tables.
How I work:
You send the file and tell me what the result should be
I write or repair the formulas and check them against your numbers
I leave short notes on how each formula works, so you can maintain the sheet
I will not replace a formula with a typed number. If something is broken, I will find the cause and fix it, and I will only rebuild the sheet if that is the better option.
Tell me how many formulas you need and whether you use Excel or Google Sheets, and I will recommend a package.
Platform:
Excel
•
Google Sheets
Development technology:
Excel
Expertise:
Fixing
•
Pivot tables
•
Formulas
•
Functions
FAQ
Do you work in both Excel and Google Sheets?
Yes. Tell me which one you use when you order, and I will build the formulas in that file.
What do you need from me to start?
The workbook, or a Google Sheets link, and a short note on what the formula should return. A before-and-after example in two cells is ideal if you have one.
Will you explain how the formulas work?
Yes. I leave brief notes in the file so you can maintain or extend the work later.
What if I need more formulas than the package allows?
Message me with the count and I will recommend an upgrade, or we can add an extra before I start.

