Excel Macros For Dummies
November 30, 2011 2:23 PM Subscribe
Explain to me Excel macros and how I can learn to program them (assume that I know absolutely nothing, because that would be correct).
posted by so much modern time to Computers & Internet (8 answers total) 20 users marked this as a favorite
A few years ago, I had a boss that was an Excel macro genius. I did photo keyword tagging for him, which was very data entry heavy. He was able to program information that had been inputted into one part of a spreadsheet to automatically repeat in other parts of the spreadsheet; it was also color-coded.
This was the first time that I'd ever seen Excel macros used, and I thought it was amazing. However, I haven't been in an environment since where I've had the opportunity to see this in action again, or even known other people who were able to program Excel macros.
Still, it's dawned on me that this is a very useful skill. However, it looks quite intimidating, and I'm not even sure about what you would use them for beyond data entry. Hive mind, could you please explain to me what Excel macros might be used for, and perhaps good tutorials so that I can try my hand at it?