This live, facilitator led MS Excel Formulas & Functions training course is delivered to you online at your computer. You still have all the benefits of interacting with our facilitators in real time, just at your office or home desk. You can ask questions both during the training and afterwards with our free post course help desk.
9am to 4pm
Working with Multiple Sheets
Grouping sheets for editing & linking data from multiple sheets
Create 3-dimensional formulae
Manage multiple sheets with data consolidation
Excel Formula & Functions
Scoping a formula
Working with specific function groups including –
Lookup & reference
Nesting & combining functions
Working with labels and names
On completion of this course participants will be able to use multiple files, link these with formulae and work with three-dimensional ranges.
They will have an understanding of a wide range of functions and their application and how to build complex formulae and functions.
Completion of Microsoft Excel Introduction and Intermediate course or equivalent knowledge is required.
“I feel like I have learned a lot and I think that everyone in the Payroll team should attend this course at some point as it was very helpful and interesting.” Jasmine from the Dept Training & Workforce Development
” Great first time at ATI, good course & content” Tania from Venues West
” Really happy with the content & trainer. Glad I attended!” Leanne from REIWA
” Great training, very useful & great presenter” Christine from Landgate