I’m interested in learning about a variety of types of software and programs that would be considere

LearnIt.ucla.edu is exactly what you are looking for. There are many links to all the IT resource options such as www.Lynda.com, Safari Books Online, Microsoft IT Academy, UCLA on iTunes, and the UCLA Knowledgebase. All of these resources offer basic and general knowledge for the basic software and programs that every individual should be proficient with. LearnIt.ucla.edu has also prepared “bundles,” or lists of training resources to bring you up to speed on certain technology topics.

see also, Technical Training and Development