DEV Community

Discussion on: 10 Things Every Software Developer Should Know

Collapse
 
aarone4 profile image
Aaron Reese • Edited

Excel is ubiquitous on the office desktop and is often the only programming option to non it staff in an enterprise security model. It gets used as data entry, database and report generator so learning VBA is one if the most pragmatic solutions in my software arsenal. With the integration of power query and the DAX engine for manipulation and presentation of data on desktops with 8+ GB of RAM. Underestimate Excel at the detriment of your career.
Automation of tasks using Excel has one of the biggest ROI for most organisations and is really low hanging fruit
If you can program in any modern OO language then VBA is a sinch and a cheap win for everyone