This is a one-day training course tailored to give experienced Excel users the skills required to use Excel’s most commonly used formulas. Lead by dedicated instructors who are experts in the Microsoft Office package, you’ll learn real world tips and tricks for creating and using advanced Excel formulas and functions. We’ll teach you how to enter common formulae using name ranges, sums and dates, utilise helpful functions including database functions, rounding functions, logical functions, financial functions, nesting functions and working up to array formulas and more.
Our courses are taught face-to-face using simple instructions, clear demonstrations and hands on activities. Class sizes are kept small to ensure students receive personalised support and achieve the highest learning outcomes possible. Training with Raising the Bar will provide you with brand new skills and knowledge of Excel, allowing you to create efficient spreadsheets using advanced formulas. We supply all the equipment so all you need to do is show up.
Upon completion of the Excel Advanced Formulas course, you’ll have the proficiency required to use Excel’s common formula functions. You'll also leave with a certificate of completion and a comprehensive course manual to work through at your leisure so you can further develop your skills at your own pace.
Who Should Attend This Course
The Excel Advanced Formulas Training Course is designed especially for students who already have an advanced knowledge of Excel and want to expand their skills to utilise more complex formula functions. This course is perfect for users who want to gain confidence to create, edit and troubleshoot the Excel formulas and functions that they currently utilise in their Excel spreadsheets and workflows.
Most students who attend this course are already comfortable with Excel and know how to use its more complex and technical features to create professional, productive spreadsheets. This course is right for you if you’re an experienced Excel user who wants to learn how to use nesting, name ranges, sum functions, count functions, date and time formulas, various database functions, audit formulas, arrays, concatenation and more.
Our public training courses are delivered throughout the year in the Raising the Bar training centre in the Sydney CBD. Alternatively, private training sessions are available by appointment for organisations in Sydney, Melbourne, Adelaide, Canberra, Brisbane and Perth.