I will write excel formulas, fix errors and pivot tables
About this Gig
Struggling with Excel formulas that just won't work? I will write, fix, and optimize your Excel formulas XLOOKUP, VLOOKUP, INDEX+MATCH, SUMIFS, IFERROR, and more. I also build clean, interactive PivotTables that turn raw data into clear summaries. What you get: - Custom formulas written for your exact need - Broken formulas debugged and fixed (#N/A, #VALUE!, #REF! etc.) - PivotTables with slicers for easy filtering - Clean, documented workbook that's easy to reuse I work fast, communicate clearly, and explain what I changed so you understand your own file. Send your workbook and tell me what you need let's get your Excel working for you, not against you.
Platform:
Excel
•
Google Sheets
•
Microsoft Office
Development technology:
VBA
•
Power Query
•
Excel
Expertise:
Fixing
•
Pivot tables
•
Formulas
•
Functions
•
Macros
FAQ
What do you need from me to start?
Your Excel file (.xlsx) and a short description of what you want the formula or report to do. Screenshots of any errors help too.
Which Excel versions do you support?
I work with Excel 2016, 2019, 2021 and Microsoft 365, including XLOOKUP and dynamic array formulas.
Can you fix a formula someone else wrote?
Yes. Send the file, tell me what it should do versus what it does now, and I will debug it.
