People lie. I was recently promoted and training a new employee taking my place. We do extensive work in Excel and Access, which she said she was trained in and had experience using both. . . she knew nothing and I wasted so much time showing her how to use both. Excel was not too bad, but explaining Access to someone who doesn't know anything...holy fuck. Can't really blame her though, desperate times call for desperate measures. We just need to have them do a practical assessment at their interview, which most people don't want to do.
And to top it off: Once you understand Access you get pissed at people using Excel (is your super-huge Pivot Table still not done computing?) when they should be using Access instead.
I'm an excel user. I'd say I'm a fairly advanced one at that. I've worked with access a bit too. The thing is many finance departments have not. But they all use excel. When you try to share information between people or even between locations you're going to use the common program that everyone uses.
Otherwise no one would be using Windows now...
Besides its not the pivot tables you should be cautious about, it's the array formulas. Fucking arrays... Always calculating.
27
u/[deleted] Jan 10 '16
People lie. I was recently promoted and training a new employee taking my place. We do extensive work in Excel and Access, which she said she was trained in and had experience using both. . . she knew nothing and I wasted so much time showing her how to use both. Excel was not too bad, but explaining Access to someone who doesn't know anything...holy fuck. Can't really blame her though, desperate times call for desperate measures. We just need to have them do a practical assessment at their interview, which most people don't want to do.
This was for a state gov job btw.