[242126]

What is considered an intermediate level of Excel knowledge? Is it being able to do pivot tables, vlookups, basic formulas etc… or would that be considered advanced?

[marqzho]

From my understanding

Beginner: know how to print, sum, format, table..
intermediate: know how solve problem in excel by its function or play with it formula, pivot table, vlookup, If, sumif, generate report
Advance: VBA, some complicated function, index, array, etc

REG 90
FAR 95
AUD 98
BEC 84

[Anonymous]

yea awesome answer couldntve said it better myself.

all accountants/CPA's at a MINIMUM must be an intermediate excel user

[Anonymous]

Those are pretty good definitions…but I would also add that they may vary. They're probably more standard within the big accounting firms, but if you were applying to a small accounting firm or an industry job that required intermediate accounting skills, they might consider “sumif” (or maybe even “sum” or “if”, not even “sumif” lol) to be intermediate. and “vloookup” to be advanced, or something like that. I think in a smaller firm or in industry (where accounting is often a smaller department), the tiers are based on who is the most experience person in the office. As an example, before I started at my current employer, the most complicated spreadsheets on our drives had “sum” in them. So, when I added a “sumif”, I was seen as an Excel goddess. If my boss had asked for “Advanced Excel Skills” in a job posting, then mine would have qualified just because I could use “sumif” and “vlookup”, even though I'm pretty green with “index” and “array” (I use them, but usually Google for an example – quicker than figuring it out myself 🙂 – so wouldn't say I really know how they work). I was more advanced than anyone they'd had in the office, so I was “Advanced”, even though in a B4 office full of Excel experts, I'd probably be seen as “Intermediate” at best.

[Author]

Replies