I have been using Excel personally and professionally every day for more than a decade. In that time, I’ve gained a comfort and familiarity with the program that allows me to quickly find solutions to even the most challenging problems. To that end, I often post solutions on the Q&A Site Stack Overflow to help others who are encountering roadblocks with the software.
You can find examples of common themes that I encounter in Excel below, or use the navigation in the drop-down menu above (hover over “Programming” then “Excel” without clicking).
Conditional Logic
Working With Strings
Working With Dates
Dynamic Ranges
LAMBDA Functions
Screenshots below showcase some problems that I’m especially happy with.
