I am seeking to increase my knowledge in the quantitative finance field. I would be grateful if someone could point me to useful resource online, where I can find working examples of they types of applications built in Excel or Access, one can expect to find on a trading desk or in the middle office of a bank.
I already know how to program (C, C++, Python etc), but I want to familiarize myself with working applications - in preparation for interviews.
In the event that no resources are forthcoming, I would be interested in hearing from practitioners, what types of applications (or tools), they construct using Excel, VBA, and/or access. It would be useful in terms of the required functionality of the tools, so that in the event that there are no suitable resources online, I can try to build the tools myself.