I will create custom excel spreadsheets with advanced formulas and automation
Junior Quantity Surveyor, Accurate BOQ and Takeoff in Excel
About this Gig
Are you struggling with complex data or need a smart Excel tool to automate your daily tasks?
I am an expert in Microsoft Excel with extensive experience in creating specialized formats and complex formulas. Whether you need a simple tracking sheet, a financial model, or a high-level automated dashboard, I can design a solution that is both professional and user-friendly.
What I can do for you:
- Custom Formulas: Advanced VLOOKUP/XLOOKUP, INDEX-MATCH, Nested IFs, and Array formulas.
- Data Automation: Use of VBA/Macros to automate repetitive tasks.
- Interactive Dashboards: Visualizing your data with professional charts and slicers.
- Specialized Formats: Tailor-made templates for QS, Construction, Finance, or Inventories.
- Data Cleaning: Sorting, deduplication, and organizing messy data.
Why choose me?
- Professional Logic: As someone with a technical background, I understand the logic behind data.
- Clean Design: I focus on making sheets that are easy for anyone to use.
- Error-Free Work: I rigorously test every formula before delivery.
Note: If you use Google Sheets, I can provide the same services there as well!
Platform:
Excel
•
Microsoft Office
•
PowerPoint
Development technology:
Excel
Expertise:
Formatting
•
Forms
•
Formulas
•
Functions
•
Charts
FAQ
Do you work with Google Sheets as well?
Yes! Most formulas and functions work similarly in Google Sheets. I can build or fix your sheets in either platform.
Can you automate my existing spreadsheet?
Absolutely. Send me your current file and explain your requirements; I will add the necessary automation or formulas to make it work better.
Is my data safe with you?
Yes, 100%. I treat all client data with strict confidentiality.

