Microsoft Excel

Proficiency Level: Intermediate

I have intermediate proficiency in Microsoft Excel, with skills including:

• Creating and managing complex spreadsheets for data analysis and reporting
• Using advanced functions such as VLOOKUP, INDEX/MATCH, and array formulas for data manipulation
• Building interactive dashboards and reports with PivotTables and PivotCharts
• Automating repetitive tasks and workflows using Excel macros (VBA)
• Designing user-friendly GUIs in Excel using VBA for data entry and process automation
• Integrating Excel with external data sources and databases for seamless data handling
• Collaborating on workbooks and managing version control for team projects

I have applied these skills in various projects to streamline data analysis processes and enhance reporting capabilities, contributing to efficient decision-making and business insights.