One of the biggest pathways to learning that I have found is what some call "Rote" learning. Some call it learning by example, others call it "Monkey see, Monkey do".
In the first stage, it really is a case of Mimicing. It's where you take the mimic that makes the difference.
As a PC Tech, from 1994 to about 2 years ago... I had to basically find things myself, copy others, until I knew what the basic Syntax was. In some cases, such as Getting a Program to talk with another program, I needed Vendor provided API files that Allowed the program to send on Banyan Vines and not on the default MS-MAIL program.
Specifically, in Programming Ericsson MD-110 PABXs, I copied commands from my Supervisor, and asked key questions. I devloped my knowledge by using the Twenty volume Manual ( believe me, that is not easy, but I did it ). I made the moves from release BC6.7 up to BC9 purely on my own, and by using a interface that programmed in such a way that the easy commands were abbreviated. But for each short cut on the Interface, the log file showed the long form way, so that when I got stuck on more complex commands, I could at least work out what to do.
I started out in HTML programming by again mimicing, and then advancing to editors, and eventually using FrontPage as an editor; once again the mimic process was the way. I still do this when-ever I can't understand a page code... I just look at the Source code... then Parrot the moves, and work out the Syntax.
The Most extreme example of learning by rote is with Sanskrit. It took 6 months to learn the Script, then after learning basic Grammar, it ended up being an event like an Epiphany... I took in so much, I eventually realised that I knew what to do.
I could give plenty more examples, but I am sure my post will be deleted if I did.
About all I can say, is that thus far, I am glad I Discovered Guerilla Data Analysis, I am EXTREMELY grateful for the people that help me on mrexcel.com , and I totally Love the Holy Macro 1,600 VBA example disc, as well as MR Excell on Excell.
And I am telling as many people as I know about Mrexcel.com ... this place is a major resource, and most of the people I know are academics who are self taught in various fields.
I don't pretend to be good at learning programming of any sort, but my tenacious approach usually compensates. My attitude is that I'll learn come hell or high water, and my hope is to be able to do it by myself, but since I KNOW I don't know a lot, I always ask. This process seems to work.
Well thats my view as brief as Someone with an Arts and Law background can write, but I think it works.