Wednesday, December 10, 2014

Software training

I went to the class Excel 3 where they talked about Macros and VBA. I chose this class for two reasons, one being that it was one of less than around ten classes that were available when I looked, and another being that I had no clue what Macros were so I figured might as well learn something completely new.

The class was fairly interesting since I learned new concepts and how to create a Macro. Basically, a Macro is a keyboard shortcut that you make yourself. So you press "control g" (it can be any letter) and then something happens on excel with the formatting or whatever else (just like when you press control z it undos your previous action). So I learned how to make a keyboard shortcut myself, and to do that you need to write code because you need to tell the computer what to do. I've never written or really seen/tried-to-comprehend code before so it was interesting to do it for the first time. I more just typed the code on the power point then actually figured out the code for myself (actually it was 100% on the power point), but I still learned what the code means and what it's saying to the computer (it's like learning a language, the programing language).

Overall the class was solid and I got to be exposed to new things. I will most likely never actually make a macro myself unless I get some help from someone or a resource like online (so it's not like the class left me fluent in code) but it was a good two hour intro into the concept.

No comments:

Post a Comment