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

Einige Informationen werden in englischer Sprache angezeigt.

Bangladesch

Ich spreche Bengalisch, Englisch, Hindi

5 Aufträge abgeschlossen

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 ...
Über diesen Service

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.

Plattform:

Excel

Google Sheets

OpenOffice

Entwicklungstechnologie:

vba

google apps-Skript

Python

Expertise:

Fixing

Formulare

Formeln

Funktionen

Makros