I'm not sure if we're allowed general chat and opinions on this forum but I have a burning question so I thought I would give it a shot, I'm sorry if it's not allowed.
At what point would you consider somebody an advanced user of Excel?
I can happily use the following:
- formulas including sumifs, countifs etc.
- nested formulas
- if statements
- vlookups, hlookups, index/match
- filter and sort
- conditional formatting
- charting tools, including creating dynamic charts
- I have written, not just recorded, some very complex macros
but, so far in my line of work (research scientist) I have limited experience with:
- pivot tables
- powerpivot
- array formulas
I think my experience should classify me as advanced, but when I've gone for job interviews in the past they always seem to associate advanced with pivot tables. In fact the tests I've been given at interviews have always been pivot tables.
I can use them, but it takes a bit of time to get what I'm looking for. In fact the biggest challenge I have is figuring out what I'm looking for, or what information I can get from the data.
So my question is two fold:
- What level should I put on my resume with the experience I have now?
- How can I get better at delving into data and using pivot tables?
Again, sorry if this post isn't appropriate here
Many thanks
Bookmarks