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 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.

Your trainer, Ivor, is one of the most Senior Excel Trainers in Australia.