If Excel is completely new to you and you haven’t played with it much – you’re Intro.
Are you not sure how to start a Formula, do you get there but would struggle to get there again – you’re Intro.
Stuck on Functions – you’re Intermediate.
You can do basic formatting, get around ok, but need to work across multiple sheets, summarise and return data from other locations – you’re intermediate.
Is manipulate data or importing data something you need help with, then need to take out extra spaces, use upper case, clean up columns and you do this all the time, you may need a macro to automate your steps – you need Advanced.
Statistical information a big part of what you do – You need Advanced.
Created recorded macros and they just don’t cut it anymore, you need to do loops. Something that can re test, “Does this sheet name exist – go check existing sheets -if no then insert new sheet and name it” – you need Excel VBA
Customise your own message prompts and data validation can’t do it – you need Excel VBA
You want to create prompt boxes (input boxes) or design a form – you need Excel VBA