Automating repetitive tasks using Google Apps Script (e.g., sending emails, updating sheets, generating PDFs).
Creating custom functions and add-ons in Google Sheets.
Advanced Data Analysis & Reporting
Using Advanced Excel features like PivotTables, Power Query, VLOOKUP/XLOOKUP, macros, conditional formatting, etc.
Performing in-depth data analysis, modeling, and forecasting.
Creating dashboards and data visualizations.
Data Management
Managing and maintaining databases/spreadsheets in Google Sheets and Excel.
Importing/exporting data between systems (e.g., CRM, ERP, APIs).
Collaboration & Documentation
Working with teams using Google Workspace tools like Docs, Sheets, Slides, Forms, and Drive.
Creating and managing documentation and shared folders.
Custom Tool Development
Building small web apps or custom tools with Google Apps Script to solve business problems.
Writing scripts to interact with APIs and external services (e.g., Slack, Gmail, Calendar).
Process Improvement
Identifying inefficiencies in workflows and proposing digital solutions.
Documenting SOPs and creating process maps.
Proficiency in Google Workspace (Sheets, Docs, Drive, Forms, etc.)
Strong knowledge of Google Apps Script (JavaScript-based scripting)
Advanced Excel skills (including formulas, VBA, automation)