Excel Intermediate to Advanced Course
This course has a prerequisite
Attendees must have beginner Excel skills equivalent to our Excel Fundamentals course, including basic functions and formulas, printing, formatting, sorting and filtering, flashfill, knowledge to build a useful spreadsheet.
Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP and XLOOKUP, and learn techniques to expedite your workflow. Split and join text, create dropdown menus (data validation). Use statistical formulas like COUNTIFS and SUMIFS to learn more about your data. Learn how to use Use of Tables and Slicers. At the end of this class, you’ll unlock powerful techniques that will help you complete tasks more quickly, more efficiently and securely.
Click on the Orange button, top right, to book or for more info. This flexible course is 1-on-1 face-to-face, or your Group, in 2 or 3 Hour units, to suit your schedule. We can work on your spreadsheets, and conduct the training via Teams, Zoom, etc. For more details, you can check out our Microsoft Project Training Perth.
Your trainer, Ivor, is one of the most Senior Excel Trainers in Australia.
- Best Practice
- Named Ranges
- Sorting and Filtering by colour
- Multilevel sort
- Cross Checks
- Statisitical formulas – Avg, Count, Max, Min
- Rounding, Ceiling, Floor
- Flashfill
- Conditional Formating
- Data Validation
- V and H Lookup
- Tables
- Pivot Tables
- Charts and Graphs
- Specialized Formula – Sumif, Countif, Filter, Unique, Sort
- Introduction to Power Query
- Introduction to Macros
- Any special requests