I will create custom excel spreadsheets with advanced formulas and automation

Sri Lanka

I speak English

Junior Quantity Surveyor, Accurate BOQ and Takeoff in Excel

I am a 4th year BSc (Hons) Quantity Surveying undergraduate with strong experience in material takeoffs, BOQ preparation, and construction cost estimation for residential and small commercial projects...
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