DEV Community

Discussion on: 10 Things Every Software Developer Should Know

Collapse
 
kian1991 profile image
Kian Lütke

I think he is totally right. Most companies are somehow using Excel and you will get confronted with it somehow. So having a good knowledge in this would be very helpful

Collapse
 
javinpaul profile image
javinpaul

Thanks, happy to find somoen who concur my thoughts with Excel :-)

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