I interviewed some job candidates for an accounting position recently, all of the candidates they brought in for interview had " good Excel skills" or "excellent Excel skills on Paper".😁
When we put a computer in front of them and most of them crumbled, admitting they had seen #pivottable , #vlookup , #if and #macros at university and they have not used one since, but they included it in their CV.
So I understand your quandary.
Stating specific functions does make a small difference, but as an Excel Trainer, I usually pay more attention to the actual job the person had to do using Excel.
And then on the interview I'll ask about the functions they used or how would they solve a specific problem.
If I were you, I will update my Excel skills before going for my next job interview.
Advanced functions such as Power Query, Power Pivot, Index and Match, Macro, Solver, What's If Analysis, PivotTables, and Vlookups should be your bread and butter.
Having knowledge of Excel functions would make you stand out.
And using it regularly means you have a good working knowledge.
Kindly join us this Saturday 1st of August 2020 for Advanced Excel Data Analytics Masterclass
Contact us on 08062468296 to register