QUOTE(quovadis123 @ Feb 7 2014, 05:39 PM)
Easy:
Anybody can use excel. But nobody uses excel like an accountant with some coding background and common sense.
If you use Excel everyday, chances are you are the "clerk-like" type who uses it like some gigantic notepad.
If you only use Excel once a month, either you don't work in finance, or you are just developer who finish project then dump it on users.
Either way, nobody knows bow to combine vlookup, sumif and pivots at the same time to come up with a robust report that can analyze 60,000 lines of data into an easy to understand and workable sheet. Even if they know that much, they'll pengsan when they see multiple nested if statements. When they look over my shoulder when I do stuff, all they see is my fingers flying around hitting shortcut buttons and copy-pasta formula. Pengsan again.
Combine all of this, you have 2 types of excel users:
1. Office worker.
2. Dev people.
Either way, they can't connect because #1 dun have the logic of #2, and #2 never understand the actual requirements of #1. I can do both (to an extent of course).
It's at this spot that I insert myself. It's a niche I carefully cultivated over my entire career, and this job can never be replaced by a robot.
Hope I dun sound too lansi, but I'm proud of my work