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
Screenshots below showcase some problems that I’m especially happy with.
