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
Earnings and projects
Last 6 months ÷ 6
Last 6 months: $14k
Billed in all: $53,813$54k
$14k in the last 6 months
Across 14 contracts
Earnings, last 30 days
Skill rankings: Top 2% in Microsoft Word
Ranked by MRR among everyone on Upwork with the skill.
- #13SAP ERP324 freelancers · 🇵🇭 #3Top 4%🇵🇭#3 of 83
- #15Microsoft Access Programming321 freelancers · 🇵🇭 #1Top 5%🇵🇭#1 of 31
- #43Excel Macros900 freelancers · 🇵🇭 #9Top 5%🇵🇭#9 of 91
- #60Power Query958 freelancers · 🇵🇭 #5Top 6%🇵🇭#5 of 61
- #69Visual Basic for Applications1,453 freelancers · 🇵🇭 #7Top 5%🇵🇭#7 of 209
- #82Microsoft Outlook1,954 freelancers · 🇵🇭 #23Top 4%🇵🇭#23 of 637
- #152Tableau2,183 freelancers · 🇵🇭 #3Top 7%🇵🇭#3 of 80
- #288Microsoft Word12,572 freelancers · 🇵🇭 #82Top 2%🇵🇭#82 of 3,810