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