Welcome to my Microsoft Excel Projects Portfolio, where I showcase a variety of business-focused Excel projects involving data cleaning, automation with macros, and interactive applications. These projects demonstrate my ability to solve practical problems using the full capabilities of Excel—from formulas and pivot tables to VBA and dashboards.
- Excel Features: Pivot Tables, Conditional Formatting, Data Validation, Power Query
- Automation: Excel Macros, VBA (Visual Basic for Applications)
- File Types:
.xlsm,.csv - Skills Demonstrated: Data Cleaning, Workflow Automation, Game Logic Design, Sales Reporting
Clean and organize messy player statistics from FIFA 21 to enable insightful analysis.
Skills: Power Query, text-to-columns, removing duplicates, structured referencing, macro-driven data refinement.
An interactive memory game built using Excel VBA. Players must match numbers hidden in cells within a time limit.
Skills: VBA programming, game logic, interactive UI, conditional formatting.
Automated invoice generator for a car dealership. Allows sales tracking and printed receipts with macro buttons.
Skills: Macros for form automation, data entry simplification, printable reports, visual formatting.
- Showcase ability to automate repetitive tasks and create user-friendly interfaces
- Demonstrate a strong grasp of data cleaning and organization—vital for business reporting
- Blend technical and creative problem solving (e.g., turning Excel into a game engine!)
I'm always open to new opportunities involving Excel, data analytics, and automation. Feel free to reach out if you're hiring or interested in collaboration!