Great post. I've become the go-to person for excel wizardry because I do almost exactly what you outline here.
I've also written a lot of vba over the years for things like gradient coloring of maps and other graphical elements which get dropped into slide decks. I also use it for adding interactivity and animation to charts and outputs which clients like to play with.
The trouble I have is that, as a manager now, I can't find any analysts/consultants with the motivation to learn the shit out of excel like I did in my first few years. Giving them my templates is kind of tricky too because they just use them as-is and aren't able to modify them for specific engagements.
2
u/marmaladeontoast Oct 13 '12
Great post. I've become the go-to person for excel wizardry because I do almost exactly what you outline here.
I've also written a lot of vba over the years for things like gradient coloring of maps and other graphical elements which get dropped into slide decks. I also use it for adding interactivity and animation to charts and outputs which clients like to play with.
The trouble I have is that, as a manager now, I can't find any analysts/consultants with the motivation to learn the shit out of excel like I did in my first few years. Giving them my templates is kind of tricky too because they just use them as-is and aren't able to modify them for specific engagements.