I have fairly strong knowledge of the VBA language. This includes object-oriented programming with VBA using class modules. My largest portfolio project, which is also my most complex project, is a project called Fluent VBA. This project is a unit testing library for VBA. I estimate that I've put over 2,000 hours in this project over a period of nearly five years.
I've deployed an office.js add-in that uses custom functions to return entity types. These entity types are capable of displaying movie and television data using entities in Excel. Currently the add-in uses data from JustWatch.com. But it may (and likely will) be extended to other APIs in the future. You can see a demo of my add-in from my YouTube channel below:
Video demonstration showing my Office.js Excel add-in displaying movie and television data inside Excel.
I've created issues on a number of bugs related to Excel programming that Microsoft has acknowledged as bugs and has either fixed or at least flagged. You can see some of these bugs below:
Bugs are typically most prevalent in the most cutting-edge work. So I think that identifying these bugs is reflective of my skill and the level I tend to operate on.
My movie_prices_db uses a Python library to pull data from an API, manipulates this data in a DataFrame (Pandas), and stores this data in a database (SQLite).
I built this website using the web development skills I needed to learn to build Office.Js Add-ins. So this website is also one of my portfolio projects.