How to

• choose monthly allocation methods on a line by line basis

• select different inflation rates to apply on a line by line basis

• choose between percentage-based allocations or per unit allocations

• turn inflation rates off and on at the click of a Check Box

• use drop down lists for selecting options

• create a flexible validation system

• use dynamic arrays

• create a custom function

These techniques could also be applied to forecasting and financial modelling.

Course Level: Advanced
Price: AUD25
Duration: 1 hour