The gaps that you are describing are real, especially in smaller workplaces that may not have any kind of training "department." I've been thinking about this for awhile, and I realized that there's a disconnect between social and informal learning and most workplaces. Even in my last stint in a company that actually did have a training department, I was identified as the person to ask if you had something you needed to do in Excel, Word, PowerPoint, etc. People need someone to call when they are in the moment of working on their project. How to manage this?