I work in the HR department of the UK office of a global company, and it's my job to turn sheets of boring figures into something more exciting and user friendly !!!
For example - our payroll department run some spreadsheets that would make your eyes bleed and go through the most complex process to update formulas that haven't worked since the late nineties. It's my job to stop them spending half a day copying and pasting stuff from one sheet to another... for a start !
It's great in many ways because
a) no one knows how I do what I do (it's just magic)
b) I get given mini projects/problems to solve and therefore learn a bit more VBA in the process !
c) I can justify my mrexcel time as work research !
If I could only get my manager to realise the complexity of what I do then I'd be truely happy !
For example - our payroll department run some spreadsheets that would make your eyes bleed and go through the most complex process to update formulas that haven't worked since the late nineties. It's my job to stop them spending half a day copying and pasting stuff from one sheet to another... for a start !
It's great in many ways because
a) no one knows how I do what I do (it's just magic)
b) I get given mini projects/problems to solve and therefore learn a bit more VBA in the process !
c) I can justify my mrexcel time as work research !
If I could only get my manager to realise the complexity of what I do then I'd be truely happy !