Excel macros. Everybody wants to learn them. You're not a programmer though. How is a non technical user going to learn how to program? You do want to use macros to make your work easier but are you really going to sit down with a huge programming textbook and work your way through every. single. boring. page? Like most people, you'll start with great enthusiasm and vigor but after a few chapters, the novelty wears off. It gets boring.
I'm going to try and change that and make learning macro programming entertaining and accessible to non-techies. First of all, programming Excel macros is a huge topic. Let's eat the elephant one bite at a time. Instead of sitting down with a dry, heavy text, you will read very focused, to the point topics. You can then immediately use what you learned in the real world.
This is the first lesson in the series. You will learn what macros are, how to access them, a tiny bit of programming theory (just so you have a clue as to what's going on) and how to record macros. As with all my other lessons, this one has a follow along workbook that you can use to work through the exercises.
The images in the lessons are based on Excel 2013 for Windows.
The intro to the intro
It’s a very short read, which is good and bad.
If your asking yourself “what is macro” and want a very simple, very dumbed down version of an explanation without any usage of terminology and extremely simple examples, then this is the book for you.
If you want to learn about macros you’ll be better of getting a macros for dummies book or read into the version that comes back after this. You will most likely not find any serious content in here.
A quick comparison: if it were a book how to create a document in word, you would learn how to copy, past, change font, size, margins and alignment.
A quick run through: you will type a name in a cell and see how excel interprets that name. You will be asked to download a worksheet online just so that you can see how excel “sees” editing of text and formulas. You will be given very simple explanation of a very complex subject.
Not a bad read but it’s more of an introduction to the introduction of an introduction to macro for applications.