How to decide which course level of Excel to book into – Intro, Interm or advance

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

Book into a course or have one customized to your needs.               email           m: 0414417059
Excel courses Sydney – Sutherland Shire


About Customised Computer Courses Sydney - Sutherland Shire M 0414 417 059

On-Site customised computer training courses Sydney - Sutherland Shire. Excel, Word,Power Point, Access, Outlook, Visio, Publisher, Excel VBA e: m: 0414 417 059
This entry was posted in Excel and tagged , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s