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 (operating under the username “EDS”) 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
Reshaping And Appending Data