I will automate google sheets or excel with custom formulas and apps script

Bangladesh

I speak Bengali, English, Hindi

5 orders completed

Hello! I'm a Mechanical Engineer passionate about programming and automation. I've crafted user-friendly systems using Google Sheets, Python, and Excel for local businesses and engineering firms. My ...
About this Gig

If you need a solution for your business or any task that might be done using spreadsheets, scripts, API, Google Cloud, cloud functions, or simple web apps, I can assist you with that. With my 10 years of experience in programming and tech, I will try to provide you with the simplest solution that might make your work more efficient.

What Solutions to expect from me:

  • Formulas & Optimization (Excel & Google Sheets): Crafting/debugging complex formulas (VLOOKUP, XLOOKUP, ARRAYFORMULA, etc.); conditional formatting.
  • Automation & Scripting (Excel & Google Sheets): Implementing basic Excel Macros/VBA; developing Google Apps Script solutions (custom functions, triggered events, Gmail integration); automating data cleaning/transformation.
  • API Integration (Google Sheets Focus): Pulling/sending data between Google Sheets and online platforms via APIs.
  • Custom Spreadsheet: Designing/optimizing spreadsheets for specific tasks (inventory, budget, project management); building interactive dashboards/reports.

Platform:

Excel

Google Sheets

OpenOffice

Development technology:

VBA

Google Apps Script

Python

Expertise:

Fixing

Forms

Formulas

Functions

Macros