Deciding which course level to book into can be daunting. Think of it this way.
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.
If you’ve played with it and you’re stuck on Functions – you’re Intermediate.
You can do basic formatting, get around ok, but need to work across multiple sheets, summarize and return data from other locations – you’re intermediate.
If you need to manipulate data, you import data 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.
If you need statistical information. You need Advanced.
If you have design 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
If you want to customize 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