(Select the application icon to see course outlines). Any Microsoft Office Training session can be delivered at your premises in Sydney. We also offer tailored Excel Training Courses where you get to pick the topics most relevant to your job. Excel is used for many different types of business and across many industries.Įxcel Courses are generally broken up into levels: Introduction, Intermediate and Advanced which you can cover in a one-day training session. It’s not only used to crunch numbers but great for creating lists, getting statistical information, generate reports using dashboards, cross-check data through the use of functions and formulas. You want to create prompt boxes (input boxes) or design a form – you need Excel VBAĮxcel spreadsheets are the most popular because it’s so versatile. 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Ĭustomise your own message prompts and data validation can’t do it – you need Excel VBA Excel VBAĬreated recorded macros and they just don’t cut it anymore, you need to do loops. Statistical information a big part of what you do – You need Advanced. 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. 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. Stuck on Functions – you’re Intermediate. If Excel is completely new to you and you haven’t played with it much – you’re Intro.Īre you not sure how to start a Formula, do you get there but would struggle to get there again – you’re Intro.
0 kommentar(er)
