People ask me all the time if I can teach them how to do what I do. Here are my free resources for the adventurous among you.
Thinking Like a Programmer is a book I wrote that teaches you the concepts to get the programmer's mindset without any of the coding. Available for free online. In text and audio.

Lessons
What you need to know about how computers work. Not specific languages, but the basic concepts of what computers do.

Scenarios
We go through basic scenarios at work and we map them out into steps using the concepts we learned in the previous section. For most people, this is good enough. Now that you have your worked mapped out according to how computers work, you can take this to your IT department and ask them to provide you with the solution.

Solutions
For those feeling extra adventurous, here I show you how to implement the solution into a set of tools and languages, usually Office 365.