Question: what is the difference between intermediate and advanced excel skills?
Answer: Intermediate: Can type out formulas, have dynamic fields and complex calculations. Advanced: Can use more logical excel formulas, chiefly vlookup, if, concatenate, and left/right/mid. Expert: Know what VBA is and be able to identify a problem that can only be solved with it (even if you cant actually solve the issue).