Jhoel E.

Specializing in Excel Formulas, Power Query/Pivot, and Macro

As an Excel data management professional, I am adept at crafting simple to complex Excel formulas, writing VBA code for task automation, and using Power Query for extracting and transforming large datasets for data migration and analysis. My expertise includes categorizing email content and managing mailing activities for marketing, merging multiple CSV files into a comprehensive dataset, performing data cleaning to eliminate errors, and transforming data into easy-to-read formats for analysis with Power Query. Additionally, I generate reports and visuals using PivotTables and Power Pivot for large and complex data models. Over the years, I have honed the following skills: Programming Languages: - VBA - SQL - M Language Technologies: - Excel - DAX Studio - Google Sheets - Microsoft Access - Power BI - CRM Systems - Databases - SAP for Accounts Payable