Why Learn Excel Macros?
If you are reading this, you are probably one of the 400 million users of Microsoft’s flagship spreadsheet program, Microsoft Excel. You may well have developed your own files to track the movement of cash or inventory around your own organization. Some of these sheets may be quite extensive but, if you’ve never come across macros, then you’ve only scratched the surface of Excel’s capabilities. At an intermediate level, a spreadsheet tends to contain a lot of raw data that you can analyze using various logical and arithmetic functions. It can get very complicated. At an expert level, a lot of these formulas start to disappear from the sheet. Some get rationalized, but many get replaced by background code. Background code written in Excel gets called a macro. Macros are pieces of Visual Basic (VBA) programming that can interact with the spreadsheet as you see it. This means the code can read numbers from your spreadsheet, do some math, and put an output elsewhere in your spreadsheet. Ul
