Data Analyst | Bookkeeper | Quality Assurance | Zapier Exp

✦ Data Cleaning ✦ Complex Excel & Google Sheet Formula ✦ VBA & Google AppsScript Automation ✦ Advanced formulas (VLOOKUP, HLOOKUP, INDEX-MATCH) ✦ Nested functions ✦ Array formulas ✦ Goal Seek and Solver✦ Text-to-columns ✦ Conditional formatting ✦ Data cleaning techniques ✦ Merging and splitting cells ✦ Business Process Automation ✦ VBA (Visual Basic for Applications) ✦ Macro recording and editing ✦ Automation of repetitive tasks ✦ Zapier ✦ Bardeen AI ✦ Sharing and permissions in Google Sheets ✦ Collaboration tools (Comments, Suggestions) ✦ Version history and tracking changes ✦ Building interactive dashboards ✦ Google sheet and Excel Dynamic charts and graphs ✦ Conditional formatting for visual impact ✦ Looker Studio ✦ Importing data from external sources ✦ Exporting data to different formats ✦ Web scraping and data connections ✦ Gantt charts and project tracking ✦ Resource planning using spreadsheets ✦ Task automation for project workflows ✦ Budgeting and forecasting ✦ Financial analysis and modeling ✦ Scenario analysis and sensitivity tables ✦ Identifying and fixing errors in formulas ✦ Debugging macros and scripts ✦ Finding optimal solutions for data challenges

✦ Efficiently organize, visualize, and validate data for meaningful insights. ✦ Utilize advanced formulas, nesting, arrays, and optimization tools for complex calculations. ✦ Cleanse and restructure data through text manipulation, conditional formatting, and merging techniques. ✦ Automate tasks, extend functionality, and enhance productivity through VBA scripting and macro recording. ✦ Facilitate seamless collaboration, control access, and track changes in shared spreadsheets. ✦ Build interactive dashboards with dynamic charts and formatting for impactful data visualization. ✦ Import data from external sources, export in various formats, and establish web connections for data retrieval. ✦ Plan, track, and automate project workflows, resource allocation, and task scheduling. ✦ Forecast budgets, analyze financial data, and conduct scenario analysis to support decision-making. ✦ Identify and resolve errors in formulas, macros, and data challenges for accurate analysis

Dashboard Creation: Proficient in crafting dashboards using Excel and Looker Studio. Automation of Reports: Skilled in automating report generation processes. Error Formula Resolution: Experienced in identifying and resolving formula errors. Complex Excel and Google Sheet Formulas: Adept at creating intricate formulas in both Excel and Google Sheets. Macro VBA and Google Appscript: Well-versed in developing macros using VBA in Excel and utilizing Google Appscript for automation in Google Sheets.

This is my way to communicate for professional discussions

Working with International Partners